HSP_PMT_LINE_REMIT

Description: |
This is a type of summary level of the remittance actions associated with a payment transaction. This table will summarize remittance information from Electronic Remittance and manual payment posting as stored on the transaction. This table is meant to hold a high level summary of line-level reason code information. Data will not be populated if a payment was posted at the invoice-level.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | TX_ID | NUMERIC | No |
The unique identifier for the transaction 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 | LINE_SVCLINE | INTEGER | No |
Stores the service line number for line level payments.
4 | LINE_GRP_CODE_C_NAME | VARCHAR | No |
Stores the group code corresponding to the reason code at the line level.
May contain organization-specific values: Yes
Category Entries:
Patient Responsibility
Contractual Obligation
Payor Initiated
Correction and Reversal
Other Adjustment
5 | LINE_REMIT_CODE_ID | VARCHAR | No |
Stores the reason code or remark code from the service line.
6 | LINE_REMIT_CODE_ID_REMIT_CODE_NAME | VARCHAR | No |
The name of each remittance code.
7 | LINE_RSN_CODE_EXTL | VARCHAR | No |
Stores the external claim level reason code or remark code from the service line.
8 | LINE_RMT_AMT | NUMERIC | No |
Stores the amount associated with the reason code at the line level.
9 | LINE_RMK_CODES | VARCHAR | No |
Stores information about the remark codes that are associated with specific reason codes at the line level. This is a comma delimited list of remark codes. The system will associate all remark codes present at any particular service line to every reason code on the same line.