TYPE |
LEN |
REQ |
VALUE |
NOTES |
PK |
Y |
Encounter Primary Key |
||
VARCHAR |
100 |
Y |
Client ID |
Healthjump's client identifier. |
VARCHAR |
40 |
Y |
Visit ID |
When available, this should be an alternate human readable encounter id (e.g. encounter number (enc_nbr)). When not available, this should be the same as the unique encounter id. |
VARCHAR |
50 |
Y |
Patient ID |
|
VARCHAR |
200 |
Encounter Type |
||
VARCHAR |
8 |
Y |
Encounter Date |
Format: YYYYMMDD |
VARCHAR |
6 |
Encounter Time |
Format: HHMMSS |
|
VARCHAR |
200 |
Location |
||
VARCHAR |
1000 |
Comment |
||
VARCHAR |
40 |
Encounter Unique ID |
Encounter ID from the source system. Related in other tables by client_encounter_ID. |
|
VARCHAR |
1000 |
Reason for Visit – ICD9 |
ICD-9 describing the patient’s stated reason for seeking care. |
|
VARCHAR |
200 |
Clinician |
The name of the rendering provider |
|
VARCHAR |
1000 |
Reason for Visit – ICD10 |
ICD-10 describing the patient’s stated reason for seeking care. |
|
VARCHAR |
1000 |
Reason for Visit – LOINC |
LINC describing the patient’s stated reason for seeking care. |
|
VARCHAR |
1000 |
Reason for Visit – SNOMED |
SNOMED describing the patient’s stated reason for seeking care. |
|
VARCHAR |
100 |
Member / Subscriber ID |
Identifier assigned to patient by health plan. |
|
VARCHAR |
100 |
Insurance Type |
|
|
DATE (Time) |
|
HJ Create Timestamp |
For internal Healthjump use and reference. |
|
DATE (Time) |
|
HJ Modify Timestamp |
For internal Healthjump use and reference. |
|
VARCHAR |
100 |
Status |
Ex. Filed, Pushed, Signed “Y” = Locked; “N” = Not Locked |
|
CHAR |
32 |
Row Hash |
For internal Healthjump use and reference. |