|
TYPE |
LEN |
REQ |
VALUE |
NOTES |
|
PK |
Y |
Med / Surg Primary Key |
||
|
VARCHAR |
100 |
Y |
Client ID |
Healthjumps client identifier. |
|
VARCHAR |
40 |
Y |
Patient ID |
Related to demographic.patient_id = demographic.patient_id |
|
VARCHAR |
8 |
Med/Surg History Date |
Format: YYYYMMDD |
|
|
VARCHAR |
1000 |
Med/Surg History Code |
Type of medical/surgical history observation. (SNOMED, ICD9 or ICD10) |
|
|
VARCHAR |
1000 |
Med/Surg History Description |
Value describing the medical/surgical history. (CABG, AMI, Colectomy, etc.) |
|
|
VARCHAR |
1000 |
Med/Surg History Comments |
||
|
DATE (Time) |
|
HJ Create Timestamp |
For internal Healthjump use and reference. | |
|
DATE (Time) |
|
HJ Modify Timestamp |
For internal Healthjump use and reference. | |
|
VARCHAR |
50 |
Client Med/Surg ID |
||
|
CHAR |
32 |
Row Hash |
For internal Healthjump use and reference. |