|
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 |
|
service_date |
VARCHAR |
8 |
Y |
Format: YYYYMMDD |
|
service_time |
VARCHAR |
8 |
|
Format: HH:MM:SS |
|
height_cm |
VARCHAR |
20 |
|
Height in centimeters. |
|
height_in |
VARCHAR |
20 |
|
Height in inches. |
|
height_comment |
VARCHAR |
1000 |
|
e.g. SNOMED 50373000 |
|
weight_kg |
VARCHAR |
20 |
|
Weight in kilograms. |
|
weight_lbs |
VARCHAR |
20 |
|
Weight in pounds. |
|
weight_comment |
VARCHAR |
1000 |
|
e.g. SNOMED 27113001 |
|
temperature_c |
VARCHAR |
20 |
|
Temperature in Celsius. |
|
temperature_f |
VARCHAR |
20 |
|
Temperature in Fahrenheit. |
|
temperature_comment |
VARCHAR |
1000 |
|
e.g. Temporal, SNOMED 386725007 Body Temp, SNOMED 276885007 Core Temp |
|
pulse |
VARCHAR |
20 |
|
|
|
pulse_comment |
VARCHAR |
1000 |
|
Regular, SNOMED 78564009 Pulse Rate |
|
respiration |
VARCHAR |
20 |
|
|
|
respiration_comment |
VARCHAR |
1000 |
|
Unlabored, SNOMED 86290005 Respiratory Rate |
|
bp_systolic |
VARCHAR |
20 |
|
|
|
bp_diastolic |
VARCHAR |
20 |
|
|
|
bp_comment |
VARCHAR |
1000 |
|
Patient position, cuff location, cuff size, SNOMED271649006 Systolic, SNOMED 271650006 Diastolic |
|
oxygen_saturation |
VARCHAR |
20 |
|
|
|
oxygen_comment |
VARCHAR |
1000 |
|
SNOWMED 431314004 Peripheral |
|
bmi |
VARCHAR |
20 |
|
LOINC 39256-5 |
|
bmi_comment |
VARCHAR |
1000 |
|
Above Normal Range, Below Normal Range, SNOMED238131007 Overweight, SNOMED 248342006 Underweight |
|
clinician |
VARCHAR |
100 |
|
The name of the provider that took the vital readings |
|
encounter_id |
VARCHAR |
40 |
|
Identifies the encounter during which this was performed obtained by the source system. |
|
comment |
VARCHAR |
2000 |
|
SNOMED 46680005 Vital Signs |
|
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_vitals_id |
VARCHAR |
50 |
|
|
|
row_hash |
CHAR |
32 |
|
For internal Datavant Site Connect use and reference. |