01Relates to the patient
REMIT_FILENAME matches REMITTANCE_DETAILS.REMIT_FILENAME on a row of REMITTANCE_DETAILS that relates to the patient
Single-patient export: only rows the patient's records refer to.
02References
CLAIM_PROCESSOR→CLAIM_PROCESSORS.CLAIM_PROCESSOR
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | REMIT_FILENAME PK | string | varchar(100) | no | |
| 2 | CLAIM_PROCESSOR | string | varchar(4) | no | |
| 3 | REMIT_RECEIPT_DATE | datetime | datetime | no | |
| 4 | REMIT_POSTING_DATE | datetime | datetime | yes | |
| 5 | CAS_AR | boolean | bit | yes |