TYPE |
LEN |
REQ |
VALUE |
NOTES |
PK |
Y |
Appointment Primary Key |
||
VARCHAR |
100 |
Y |
Client ID |
Healthjump’s client identifier. |
VARCHAR |
40 |
Y |
Patient ID |
Related to demographic.patient_id = demographic.patient_id |
VARCHAR |
8 |
Y |
Appointment Date |
Date of appointment. Format: YYYYMMDD |
VARCHAR |
4 |
Y |
Begin Time |
Beginning time of appointment. Format: HHMM |
VARCHAR |
4 |
End Time |
Ending time of appointment. Format: HHMM |
|
VARCHAR |
20 |
Appointment Duration |
Duration in minutes. |
|
VARCHAR |
100 |
Resource |
This could be the doctor’s name, room number, equipment, etc. |
|
VARCHAR |
1000 |
Appointment Reason |
Reason for the appointment. |
|
VARCHAR |
100 |
Appointment Type |
Type of appointment. |
|
VARCHAR |
1000 |
Appointment Detail |
Appointment details. |
|
VARCHAR |
10 |
Provider ID |
Rendering provider’s NPI |
|
VARCHAR |
100 |
Provider Name |
Full name of rendering provider. |
|
DATE (Time) |
|
|
HJ Create Timestamp |
For internal Healthjump use and reference. |
DATE (Time) |
HJ Modify Timestamp |
For internal Healthjump use and reference. | ||
VARCHAR |
100 |
Y |
Client Appointment ID |
This is the appointment ID from the source system |
VARCHAR |
1 |
Delete Indicator |
Y or N |
|
CHAR |
32 |
Row Hash |
For internal Healthjump use and reference. |