PR_EST_SVC_LN_RMT_INFO

Description: |
Contains the adjudication information for each service line in a member estimate.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
ESTIMATE_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ESTIMATE_ID | NUMERIC | No |
The unique identifier for the patient estimate record.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | ADDL_LINE_NUM | INTEGER | No |
The line number of related group 1000 that stores additional information about the charge line. It is used to map a line in 2000 related group to a procedure line.
4 | FILE_ORD_NUM | INTEGER | No |
The coverage level associated with the corresponding coverage (I PES 168).
5 | REMIT_CODE_ID | VARCHAR | No |
This stores any Explanation of Benefits/Remittance Advice codes associated with the service line.
6 | REMIT_CODE_ID_REMIT_CODE_NAME | VARCHAR | No |
The name of each remittance code.
7 | REMIT_AMT | NUMERIC | No |
This stores the amount associated with the Explanation of Benefits or remittance advice codes.
8 | REMIT_CATEGORY_C_NAME | VARCHAR | No |
This stores the payment category that the payer has assigned the amount to
May contain organization-specific values: No
Category Entries:
Patient
Not Allowed
Other Adjustment
Denied