01Relates to the patient
APPT_ID matches APPOINTMENTS.APPT_ID on a row of APPOINTMENTS that relates to the patient
Single-patient export: the patient's rows.
02References
APPT_ID→APPOINTMENTS.APPT_ID
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | APPT_ID PK | integer | int | no | |
| 2 | LINE_NO PK | integer | int | no | |
| 3 | AUTHORIZATION_NUMBER | string | varchar(40) | yes | |
| 4 | AUTH_LINE_NO | integer | int | yes | |
| 5 | COMPANY_CODE | string | varchar(20) | no | |
| 6 | INSURANCE_ID | string | varchar(25) | no | |
| 7 | FROM_DATE | datetime | smalldatetime | yes | |
| 8 | NUMBER_USED | integer | int | yes | |
| 9 | REFERRAL_NUMBER | string | varchar(15) | yes | |
| 10 | REF_LINE_NO | integer | int | yes | |
| 11 | AUTH_OVERRIDE | string | char(1) | yes | |
| 12 | REF_OVERRIDE | string | char(1) | yes |