01Relates to the patient
ATTENDANCE_DATE + EPISODE_CARE_ID matches ATTENDANCES.ATTENDANCE_DATE + ATTENDANCES.EPISODE_CARE_ID on a row of ATTENDANCES that relates to the patient
Single-patient export: the patient's rows.
02References
APPT_ID→APPOINTMENTS.APPT_IDATTENDANCE_DATE,EPISODE_CARE_ID→ATTENDANCES.ATTENDANCE_DATE,EPISODE_CARE_IDPROVIDER_CODE→PROVIDERS.PROVIDER_CODESERVICE_NAME→SERVICES.SERVICE_NAMEOFFICE_LOCATION→LOCATIONS.OFFICE_LOCATION
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | ATTENDANCE_DATE PK | datetime | smalldatetime | no | |
| 2 | EPISODE_CARE_ID PK | integer | int | no | |
| 3 | SERVICE_SEQUENCE PK | integer | int | no | |
| 4 | SERVICE_NAME | string | varchar(40) | yes | |
| 5 | DURATION | integer | int | yes | |
| 6 | PROVIDER_CODE | string | varchar(20) | yes | |
| 7 | OFFICE_LOCATION | string | varchar(20) | yes | |
| 8 | INVOICE | integer | int | yes | |
| 9 | APPT_ID | integer | int | yes | |
| 10 | PROCESS_DATE | datetime | datetime | yes | |
| 11 | ENCOUNTER_ID | integer | int | yes |