Datavant Site Connect Charge Version 2.0 for Ambulatory includes expansion to support 4 modifiers on a charge, claim level diagnosis 1-12, and diagnosis coding system type. The original cpt_code_modifier column was removed 7/25/2022.
|
NAME |
TYPE |
LENGTH |
REQUIRED |
NOTES |
|
hj_import_int |
INT |
|
Y |
|
|
client_id |
VARCHAR |
100 |
Y |
Datavant Site Connect’s client identifier. |
|
client_charge_id |
VARCHAR |
36 |
|
Charge ID obtained from the source system. |
|
encounter_id |
VARCHAR |
40 |
|
|
|
patient_id |
VARCHAR |
40 |
|
|
|
primary_payer_id |
VARCHAR |
36 |
|
|
|
primary_financial_class |
VARCHAR |
500 |
|
Name of primary financial class. |
|
primary_insurance_payer |
VARCHAR |
50 |
|
Name of primary insurance payer. |
|
secondary_payer_id |
VARCHAR |
50 |
|
|
|
secondary_financial_class |
VARCHAR |
500 |
|
Name of primary financial class. |
|
secondary_insurance_payer |
VARCHAR |
50 |
|
Name of secondary insurance payer. |
|
tertiary_payer_id |
VARCHAR |
36 |
|
Name of tertiary insurance payer. |
|
tertiary_financial_class |
VARCHAR |
500 |
|
Name of tertiary financial class. |
|
tertiary_insurance_payer |
VARCHAR |
50 |
|
Name of the tertiary insurance payer. |
|
cpt_code |
VARCHAR |
500 |
|
|
|
cpt_code_modifier1 |
VARCHAR |
100 |
|
|
|
cpt_code_modifier2 |
VARCHAR |
100 |
|
|
|
cpt_code_modifier3 |
VARCHAR |
100 |
|
|
|
cpt_code_modifier4 |
VARCHAR |
100 |
|
|
|
place_of_service |
VARCHAR |
2 |
|
2 digit code required on claims - code set can be found on CMS site here. |
|
location_of_service |
VARCHAR |
50 |
|
|
|
beginning_date_of_service |
VARCHAR |
8 |
|
Format: YYYYMMDD |
|
ending_date_of_service |
VARCHAR |
8 |
|
Format: YYYYMMDD |
|
posting_date_of_charge |
VARCHAR |
8 |
|
Format: YYYYMMDD |
|
entered_date_of_charge |
VARCHAR |
8 |
|
Format: YYYYMMDD |
|
units |
NUMERIC |
19, 2 |
|
|
|
charge_amt |
NUMERIC |
19, 2 |
|
|
|
allowed_amt |
NUMERIC |
19, 2 |
|
|
|
primary_payer_paid_amt |
NUMERIC |
19, 2 |
|
|
|
secondary_payer_paid_amt |
NUMERIC |
19, 2 |
|
|
|
tertiary_payer_paid_amt |
NUMERIC |
19, 2 |
|
|
|
patient_paid_amt |
NUMERIC |
19,2 |
|
|
| primary_payer_adjustment_ |
NUMERIC |
19, 2 |
|
|
| secondary_payer_adjustment_ |
NUMERIC |
19, 2 |
|
|
|
tertiary_payer_adjustment_ |
NUMERIC |
19, 2 |
|
|
|
patient_adjustment_amt |
NUMERIC |
19, 2 |
|
|
|
rendering_id |
VARCHAR |
36 |
|
Rendering provider ID obtained from the source system. |
|
rendering_npi |
VARCHAR |
10 |
|
Rendering providers NPI number. |
|
rendering_name |
VARCHAR |
200 |
|
Rendering providers full name. |
|
coding_system |
VARCHAR |
10 |
|
Type of ICD-9, ICD-10, or Mixed |
|
dx1_code |
VARCHAR |
10 |
|
|
|
dx2_code |
VARCHAR |
10 |
|
|
|
dx3_code |
VARCHAR |
10 |
|
|
|
dx4_code |
VARCHAR |
10 |
|
|
|
dx5_code |
VARCHAR |
10 |
|
|
|
dx6_code |
VARCHAR |
10 |
|
|
|
dx7_code |
VARCHAR |
10 |
|
|
|
dx8_code |
VARCHAR |
10 |
|
|
|
dx9_code |
VARCHAR |
10 |
|
|
|
dx10_code |
VARCHAR |
10 |
|
|
|
dx11_code |
VARCHAR |
10 |
|
|
|
dx12_code |
VARCHAR |
10 |
|
|
|
hj_create_timestamp |
TIMESTAMP |
|
|
For internal Datavant Site Connect use and reference. |
|
hj_modify_timestamp |
TIMESTAMP |
|
|
For internal Datavant Site Connect use and reference. |
|
row_hash |
CHAR |
32 |
|
For internal Datavant Site Connect use and reference. |