HSP_PMT_REMIT_DETAIL
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 extracts the information that displays in the remittance grid in payment posting as the end user sees it.

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 DTL_GRP_CODE_C_NAME VARCHAR No
This column stores the group code for the reason code that is entered in the remittance grid when this batch is opened in payment posting.
May contain organization-specific values: Yes
Category Entries:
Patient Responsibility
Contractual Obligation
Payor Initiated
Correction and Reversal
Other Adjustment
4 DTL_REMIT_CODE_ID VARCHAR No
This column stores the remit code that is entered in the remittance grid when this batch is opened in payment posting.
5 DTL_REMIT_CODE_ID_REMIT_CODE_NAME VARCHAR No
The name of each remittance code.
6 DTL_RSN_CODE_EXTL VARCHAR No
This column stores the external reason code that is entered in the remittance grid when this batch is opened in payment posting.
7 DTL_REMIT_AMT NUMERIC No
This column stores the amount associated with the reason code that is entered in the remittance grid when this batch is opened in payment posting.
8 DTL_ACTION_STRING VARCHAR No
This column stores the actions associated with the reason code that is entered in the remittance grid when this batch is opened in payment posting. This is a comma delimited string of actions for reason codes with multiple actions associated with them.
9 DTL_CREATE_BDC_YN VARCHAR No
This column stores whether a denial or remark record should be created with the reason code. If any action on the reason code creates a denial or remark, this column will be set to Yes, otherwise this column will be set to No.
10 DTL_SERVICE_LINE INTEGER No
This column stores the service line this reason code was entered in on the remittance grid when this batch was opened in payment posting. If any reason code was entered at the claim level this row will be set to -1.
11 DTL_DFLTCD_MAPCOL_C_NAME VARCHAR No
This column contains the mapped column of the defaulted remit code.
May contain organization-specific values: No
Category Entries:
None
Deductible
Copay
Coinsurance
Coordination of Benefits
Non-covered
Not Allowed
Denied
Insurance Write-off
12 DTL_AUTO_CLOSE_YN VARCHAR No
This field contains whether the follow-up record should be auto-closed after being created.
May contain organization-specific values: No
Category Entries:
No
Yes