ENCOUNTERS

91396 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID VARCHAR 255
ALLERGIES.ENCOUNTER SYS_CONSTRAINT_927e5eb0-6c8c-4cc1-a4f2-064676de182aR
CAREPLANS.ENCOUNTER SYS_CONSTRAINT_5276bbad-aa94-4aa1-8fe5-8062df7bbc16R
CONDITIONS.ENCOUNTER SYS_CONSTRAINT_8fab7423-f175-4f84-83ef-9fd273d9fa79R
DEVICES.ENCOUNTER SYS_CONSTRAINT_88977ccd-49e7-4219-90ba-1c9f439b1757R
IMMUNIZATIONS.ENCOUNTER SYS_CONSTRAINT_74e6bc52-318f-4d9b-ae74-12e8776dbee7R
MEDICATIONS.ENCOUNTER SYS_CONSTRAINT_0e092281-2d6e-471c-8475-e76ac484b3e1R
OBSERVATIONS.ENCOUNTER SYS_CONSTRAINT_4b5caadd-24c2-4545-b02a-1941d5acc009R
PROCEDURES.ENCOUNTER SYS_CONSTRAINT_645afbba-0392-4453-845f-456cd9e88c90R
SUPPLIES.ENCOUNTER SYS_CONSTRAINT_c8afb533-359a-4c0f-b21e-08aca4665862R
START DATE 0 √
STOP DATE 0 √
PATIENT VARCHAR 255
PATIENTS.ID SYS_CONSTRAINT_e0684af9-ae3f-499c-a922-c005b4709394R
ORGANIZATION VARCHAR 255 √
PROVIDER VARCHAR 255 √
PROVIDERS.ID SYS_CONSTRAINT_571a191b-05f1-487f-8066-08c10ca615aeR
PAYER VARCHAR 255 √
PAYERS.ID SYS_CONSTRAINT_f49cf6bc-f485-491e-a4e1-bcfde465e348R
ENCOUNTERCLASS VARCHAR 255 √
CODE VARCHAR 255 √
DESCRIPTION VARCHAR 255 √
BASE_ENCOUNTER_COST DOUBLE 0 √
TOTAL_CLAIM_COST DOUBLE 0 √
PAYER_COVERAGE DOUBLE 0 √
REASONCODE VARCHAR 255 √
REASONDESCRIPTION VARCHAR 255 √

Relationships

Close relationships within degrees of separation