|
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. |
|
trans_id |
VARCHAR |
36 |
Y |
ID used to identify the transaction in the source system. |
|
visit_id |
VARCHAR |
40 |
Y |
|
|
cpt_code |
VARCHAR |
13 |
|
|
|
payer |
CHAR |
1 |
|
Expecting: 1, 2, 3 or P (1 = Primary, 2 = Secondary, 3 = Tertiary and P = Patient Paid) |
|
type |
CHAR |
1 |
|
Expecting: A, C or R (A = Adjustment, C = Payment, R = Refund) |
|
paid_amt |
NUMERIC |
19,2 |
|
|
|
adjustment_amt |
NUMERIC |
19,2 |
|
|
|
post_date |
VARCHAR |
8 |
|
Format: YYYYMMDD |
|
trans_description |
VARCHAR |
50 |
|
|
|
hj_create_timestamp |
TIMESTAMP |
|
|
For internal Datavant Site Connect use and reference. |
|
hj_modify_timestamp |
TIMESTAMP |
|
|
For internal Datavant Site Connect use and reference. |
|
delete_ind |
CHAR |
1 |
|
|
|
row_hash |
CHAR |
32 |
|
For internal Datavant Site Connect use and reference. |
Transaction
