|
NAME |
TYPE |
LENGTH |
REQUIRED |
NOTES |
|
hj_import_int |
INT |
|
Y |
|
|
client_id |
VARCHAR |
100 |
Y |
Healthjump’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 |
|
|
|
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_modifiers |
VARCHAR |
100 |
|
|
|
place_of_service |
VARCHAR |
2 |
|
|
|
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_amt |
NUMERIC |
19, 2 |
|
|
| secondary_payer_adjustment_amt |
NUMERIC |
19, 2 |
|
|
| tertiary_payer_adjustment_amt |
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_name |
VARCHAR |
77 |
|
Rendering providers full name. |
|
hj_create_timestamp |
TIMESTAMP |
|
|
For internal Healthjump use and reference. |
|
hj_modify_timestamp |
TIMESTAMP |
|
|
For internal Healthjump use and reference. |
|
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 |
|
|
|
row_hash |
CHAR |
32 |
|
For internal Healthjump use and reference. |
Charge
