|
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 |
|
date |
VARCHAR |
8 |
Y |
Date of appointment. Format: YYYYMMDD |
|
begin_time |
VARCHAR |
4 |
Y |
Beginning time of appointment. Format: HHMM |
|
end_time |
VARCHAR |
4 |
|
Ending time of appointment. Format: HHMM |
|
duration |
VARCHAR |
20 |
|
Duration in minutes. |
|
resource |
VARCHAR |
100 |
|
This could be the doctor’s name, room number, equipment, etc. |
|
reason |
VARCHAR |
1000 |
|
Reason for the appointment. |
|
type |
VARCHAR |
100 |
|
Type of appointment. |
|
detail |
VARCHAR |
1000 |
|
Appointment details. |
|
status |
VARCHAR |
20 |
|
Status tied to appointments such as confirmed, checked-in, or no-show. Actual values in the system will be sent. Column added 8/3/2023. |
|
provider_id |
VARCHAR |
10 |
|
Rendering provider’s NPI |
|
provider_clinician_name |
VARCHAR |
100 |
|
Full name of rendering provider. |
|
hj_create_timestamp |
TIMESTAMP |
|
|
For internal Datavant Site Connect use and reference. |
|
hj_modify_timestamp |
TIMESTAMP |
|
|
For internal Datavant Site Connect use and reference. |
|
client_appt_id |
VARCHAR |
100 |
|
This is the appointment ID from the source system |
|
delete_indicator |
CHAR |
1 |
|
Y or N |
|
row_hash |
CHAR |
32 |
|
For Datavant Site Connect internal use and reference. |