|
NAME |
TYPE |
LENGTH |
REQUIRED |
NOTES |
|
hj_import_int |
INT |
|
Y |
|
|
client_id |
VARCHAR |
100 |
Y |
Datavant Site Connect’s client identifier. |
|
order_id |
VARCHAR |
50 |
Y |
Charge ID obtained from the source system. |
|
encounter_id |
VARCHAR |
50 |
Y |
Encounter ID obtained from the source system. |
|
patient_id |
VARCHAR |
50 |
Y |
Related to demographic data. patient_id = demographic.patient_id |
|
mrn |
VARCHAR |
50 |
Y |
Patient medical record number obtained from the source system. |
|
patient_first_name |
VARCHAR |
250 |
Y |
|
|
patient_middle_name |
VARCHAR |
250 |
|
|
|
patient_last_name |
VARCHAR |
250 |
Y |
|
|
patient_date_of_birth |
VARCHAR |
20 |
Y |
Format: YYYYMMDD |
|
patient_address_1 |
VARCHAR |
250 |
|
|
|
patient_address_2 |
VARCHAR |
250 |
|
|
|
patient_city |
VARCHAR |
50 |
|
|
|
patient_state |
VARCHAR |
10 |
|
|
|
patient_zip |
VARCHAR |
20 |
|
|
|
cpt_code |
VARCHAR |
50 |
Y |
|
|
cpt_desc |
VARCHAR |
1000 |
|
|
|
diag_code |
VARCHAR |
50 |
Y |
|
|
diag_desc |
VARCHAR |
1000 |
|
|
|
side |
VARCHAR |
50 |
|
The side of the body that the procedure is going to happen on. (left, right, bilateral, etc.) |
|
site |
VARCHAR |
50 |
|
Body part undergoing the procedure. (shoulder, elbow, ankle, etc.) |
|
status |
VARCHAR |
100 |
|
scheduled, ordered, etc. |
|
delete_ind |
VARCHAR |
1 |
Y |
Y = Deleted, N = Not Deleted |
|
location_name |
VARCHAR |
250 |
|
Where procedure was ordered. |
|
notes |
VARCHAR |
1000 |
|
Notes pertaining to the order. (rendering provider name, etc.) |
|
order_date |
VARCHAR |
8 |
|
Order date obtained from the source system. |
|
order_provider |
VARCHAR |
250 |
|
Name of the provider placing the order. |
|
order_provider_id |
VARCHAR |
50 |
|
ID used to identify the provider in the system |
|
scheduled_date |
VARCHAR |
8 |
|
When the order was scheduled to happen from the source system. |
|
create_timestamp |
TIMESTAMP |
|
Y |
When the order was created in the system. |
|
modify_timestamp |
TIMESTAMP |
|
Y |
When the order was last modified in the system. |
|
hj_create_timestamp |
TIMESTAMP |
|
|
For internal Datavant Site Connect use and reference |
|
hj_modify_timestamp |
TIMESTAMP |
|
|
For internal Datavant Site Connect use and reference |
|
order_type |
VARCHAR |
50 |
|
|
|
row_hash |
CHAR |
32 |
|
For internal Datavant Site Connect use and reference |
Order Fact
