01Relates to the patient
REFERRAL_NUMBER + COMPANY_CODE matches REFERRALS.REFERRAL_NUMBER + REFERRALS.COMPANY_CODE on a row of REFERRALS that relates to the patient
Single-patient export: the patient's rows.
02References
PROC_CODE,CODING_METHOD→PROCEDURES.PROC_CODE,CODING_METHODREFERRAL_NUMBER,COMPANY_CODE→REFERRALS.REFERRAL_NUMBER,COMPANY_CODE
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | REFERRAL_NUMBER PK | string | varchar(15) | no | |
| 2 | COMPANY_CODE PK | string | varchar(20) | no | |
| 3 | LINE_NO PK | integer | int | no | |
| 4 | FROM_DATE | datetime | datetime | yes | |
| 5 | THRU_DATE | datetime | datetime | yes | |
| 6 | VISIT_CLASS | string | varchar(15) | yes | |
| 7 | PROC_CODE | string | varchar(20) | yes | |
| 8 | NUMBER_AUTHORIZED | integer | int | no | |
| 9 | NUMBER_USED | integer | int | no | |
| 10 | CODING_METHOD | string | varchar(5) | yes |