|
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 |
|
|
cpt4_hcpcs_code |
VARCHAR |
100 |
Y |
|
|
description |
VARCHAR |
1000 |
|
|
|
date |
VARCHAR |
10 |
|
Format: YYYYMMDD |
|
units |
VARCHAR |
20 |
|
|
|
modifier_code1 |
VARCHAR |
20 |
|
CPT-4 or HCPCS modifier code |
|
modifier_code2 |
VARCHAR |
20 |
|
CPT-4 or HCPCS modifier code |
|
modifier_code3 |
VARCHAR |
20 |
|
CPT-4 or HCPCS modifier code |
|
modifier_code4 |
VARCHAR |
20 |
|
CPT-4 or HCPCS modifier code |
|
place_of_service |
VARCHAR |
100 |
|
CMS place of service. Needs to be the actual name of the location. |
|
performed_by_clinician |
VARCHAR |
100 |
|
Must be NPI |
|
ordered_by_clinician |
VARCHAR |
100 |
|
Must be NPI |
|
encounter_id |
VARCHAR |
40 |
|
Identifies the encounter during which this was performed from the source system. |
|
internal_charge_code |
VARCHAR |
20 |
|
|
|
total_charges |
VARCHAR |
20 |
|
|
|
loinc_code |
VARCHAR |
20 |
Y* |
|
|
snomed_code |
VARCHAR |
20 |
Y* |
|
|
result |
VARCHAR |
50 |
|
Any result data associated with the performed procedure such as PHQ9, HCPCS, LOINC, SNOMED (mammogram, colonoscopy, diabetic eye exam results, etc.) |
|
hj_create_timestamp |
TIMESTAMP |
|
|
For internal Datavant Site Connect use and reference. |
|
hj_modify_timestamp |
TIMESTAMP |
|
|
For internal Datavant Site Connect use and reference. |
|
dx1_code |
VARCHAR |
50 |
|
|
|
dx2_code |
VARCHAR |
50 |
|
|
|
dx3_code |
VARCHAR |
50 |
|
|
|
dx4_code |
VARCHAR |
50 |
|
|
|
dx5_code |
VARCHAR |
50 |
|
|
|
dx6_code |
VARCHAR |
50 |
|
|
|
dx7_code |
VARCHAR |
50 |
|
|
|
dx8_code |
VARCHAR |
50 |
|
|
|
client_procedure_id |
VARCHAR |
50 |
|
|
|
row_hash |
CHAR |
32 |
|
For internal Datavant Site Connect use and reference. |
*Y* – One of these values must be specified.