| NAME | TYPE | LENGTH | REQUIRED | NOTES |
| hj_import_int | INT | Y | ||
| client_id | VARCHAR | 100 | Y | Datavant Site Connect’s client identifier. |
| patient_id | VARCHAR | 40 | Y | Related to demographic.patient_id = demographic.patient_id |
| encounter_id | VARCHAR | 40 | N | Unique encounter ID obtained from the source system. |
| order_number | VARCHAR | 50 | Y | Unique ID for the order obtained from the source system. |
| order_date | VARCHAR | 10 | Y | Format: YYYYMMDD |
| status | VARCHAR | 50 | Y | Status of order accepted, expired, pending rejected |
| type | VARCHAR | 50 | N | type of order, referral, labs, radiology, etc... |
| category | VARCHAR | 50 | N | ambulatory, emergency, inpatient, outpatient |
| priority | VARCHAR | 50 | N | such as asap, routine, stat |
| code | VARCHAR | 50 | Y | procedure code of order |
| code_type | VARCHAR | 40 | Y | code nomenclature CPT2, CPT4, HCPS |
| appointment_date | VARCHAR | 10 | N | Format: YYYYMMDD |
| ordering_provider_id | VARCHAR | 50 | Y | NPI |
| ordering_provider_name | VARCHAR | 200 | Y | Ordering provider name |
| receiving_provider_id | VARCHAR | 50 | N | NPI |
| receiving_provider_name | VARCHAR | 200 | Y | Recieving provider name |
| order_service_location | VARCHAR | 200 | N | location order was sent to |
| referral_reason | VARCHAR | 200 | N | provider ordered, patient pref, workload, second opinion |
| referral_diagnosis | VARCHAR | 200 | N | diagnosis code |
| referral_notes | VARCHAR | 200 | N | free text comments |
| hj_create_timestamp | TIMESTAMP | For internal Datavant Site Connect use and reference. | ||
| hj_modify_timestamp | TIMESTAMP | For internal Datavant Site Connect use and reference. | ||
| row_hash | CHAR | 32 | For internal Datavant Site Connect use and reference. |