CL_REMIT

Description: |
This table stores information for each Image Database (IMD) record. This can be check-level or claim-level, and is indicated in column IMD_TYPE_C.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
IMAGE_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | IMAGE_ID | VARCHAR | No |
This is the ID for the remittance image record. A separate remittance image record is created for each invoice payment.
2 | CREATION_DATE | DATETIME | No |
The date when the remittance image record was created (i.e., when the electronic file was loaded and created).
3 | SERVICE_AREA_ID_LOC_NAME | VARCHAR | No |
The name of the revenue location.
4 | PAYMENT_METHOD_C_NAME | VARCHAR | No |
The posting method by which this remittance record was created (manual or through electronic remittance).
May contain organization-specific values: No
Category Entries:
Remittance
Manual payment posting
5 | PAYMENT_TYPE_C_NAME | VARCHAR | No |
The payment type for this remittance record (self-pay or insurance).
May contain organization-specific values: No
Category Entries:
Insurance payment
Self-Pay
6 | PAYMENT_AMOUNT | NUMERIC | No |
Total amount paid by the payer in the remittance file.
7 | CREDIT_DEBIT_C_NAME | VARCHAR | No |
Code indicating whether payment amount is a credit or debit.
May contain organization-specific values: No
Category Entries:
Credit
Debit
8 | PAYMENT_MTD_CODE_C_NAME | VARCHAR | No |
Code identifying the method for the movement of payment instructions.
May contain organization-specific values: No
Category Entries:
Automated Clearing House
Financial Institution Option
Check
Federal Reserve Funds or Wire Transfer
Non-Payment Data
9 | PAYMENT_FMT_CD_C_NAME | VARCHAR | No |
Code identifying the payment format used.
May contain organization-specific values: No
Category Entries:
Cash Concentration/Disbursement plus Addenda (CCD+) (ACH)
Corporate Trade Exchange (CTX) (ACH)
10 | SENDER_ID_QUAL_C_NAME | VARCHAR | No |
Sender ID qualifier. Code identifying the type of identification number of Depository Financial Institution (DFI).
May contain organization-specific values: No
Category Entries:
ABA Transit Routing Number with check digits
Canadian Bank Branch and Institution Number
11 | SENDER_IDN_NUM | VARCHAR | No |
Sender Depository Financial Institution (DFI) identification number from the remittance file.
12 | ISSUE_DATE | DATETIME | No |
Check issue date or Effective Entry Date for electronic fund transfers.
13 | TRACE_TYP_CD_C_NAME | VARCHAR | No |
Code identifying which transaction is being referenced.
May contain organization-specific values: No
Category Entries:
Current Transaction Trace Numbers
14 | REF_IMG_ID | VARCHAR | No |
Reference remittance record for general remittance file information. A separate remittance image record is created for each invoice payment in the remittance file. The general check level information is stored in the first remittance image record and subsequent image records hold the image ID of that record in this item.
15 | GRP_REF_ID | VARCHAR | No |
Reference remittance image record for Provider Summary Information and Provider Supplemental Summary Information. A separate remittance image record is created for each invoice payment in the remittance file. Multiple invoice payments can share the same Provider Summary Information and Provider Supplemental Summary Information. This information is stored in the first remittance image record. Subsequent image records hold the image ID of the original remittance image in this item.
16 | PAT_ID | VARCHAR | No |
The patient from the invoice to which the payment in the remittance image record is posted.
17 | CLM_START_DATE | DATETIME | No |
The starting date of the claim that was sent out to the payer.
18 | CLM_END_DATE | DATETIME | No |
The ending date of the claim that was sent out to the payer.
19 | CLP_ID | NUMERIC | No |
Internal ID of the claim record (for Hospital Billing only).
20 | IMD_TYPE_C_NAME | VARCHAR | No |
Specifies the type of Remittance Image. 1 is Check Level and 2 is File Level.
May contain organization-specific values: No
Category Entries:
Check Level IMD
Invoice IMD
21 | INTER_CTRL_NUM | VARCHAR | No |
Holds the Interchange Control Number from the electronic remittance file.
22 | GROUP_CTRL_NUM | VARCHAR | No |
Holds the Group Control Number from the electronic remittance file.
23 | EXPRESS_TYPE_C_NAME | VARCHAR | No |
This item identifies records created from incoming payer interface messages in response to Express claims. Records with this item set are not linked to transactions, but can be viewed from the Claim Status section in Inquiry or WQ.
May contain organization-specific values: No
Category Entries:
Predetermination raw data
Payment raw data