|
TYPE |
LEN |
REQ |
VALUE |
NOTES |
|
PK |
Y |
Transaction Primary Key |
||
|
VARCHAR |
100 |
Y |
Client ID |
Healthjump’s client identifier. |
|
VARCHAR |
36 |
Client Charge ID |
Charge ID obtained from the source system. |
|
|
VARCHAR |
36 |
Y |
Trans ID |
ID used to identify the transaction in the source system. |
|
VARCHAR |
40 |
Y |
Visit ID |
|
|
VARCHAR |
13 |
CPT Code |
||
|
CHAR |
1 |
Payer |
Expecting: 1, 2, 3 or P (1 = Primary, 2 = Secondary, 3 = Tertiary and P = Patient Paid) |
|
|
CHAR |
1 |
Type |
Expecting: A, C or R (A = Adjustment, C = Payment, R = Refund) |
|
|
NUMERIC |
19, 2 |
Amount Paid |
||
|
NUMERIC |
19, 2 |
Adjusted Amount |
||
|
VARCHAR |
8 |
Post Date |
Format: YYYYMMDD |
|
|
VARCHAR |
50 |
Trans Description |
||
|
DATE (Time) |
|
HJ Create Timestamp |
For internal Healthjump use and reference. | |
|
DATE (Time) |
|
HJ Modify Timestamp |
For internal Healthjump use and reference. | |
|
CHAR |
1 |
Delete Indicator |
||
|
CHAR |
32 |
Row Hash |
For internal Healthjump use and reference. |