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.