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. |