HSP_ACCT_CONS_SP_PMT_ADJ

Description:

The HSP_ACCT_CONS_SP_PMT_ADJ table contains information about the payment & adjustment documentation lines associated with a received self-pay hospital account. As a partial example, this includes common payment & adjustment information like the deposit date, reference number, description, and amount.

Primary Key

Column Name	Ordinal Position
HSP_ACCOUNT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	HSP_ACCOUNT_ID	NUMERIC	No
	The unique identifier (.1 item) for the hosp acct 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	PMT_ADJ_UNIQUE_IDENT	VARCHAR	No
	An identifier unique to this payment/adjustment documentation line related group at the HAR level. No other payment/adjustment documentation lines on the same HAR should share this identifier.
4	PMT_ADJ_DEPOSIT_DATE	DATETIME	No
	The deposit date for a self-pay adjustment or payment. This date is when the adjustment or payment was deposited in the source system.
5	PMT_ADJ_POST_DATE	DATETIME	No
	The original post date for a self-pay adjustment or payment. This date is when the adjustment or payment was posted in the source system.
6	PMT_ADJ_PROC_ID_PROC_NAME	VARCHAR	No
	The name of each procedure.
7	PMT_ADJ_REF_NUM	VARCHAR	No
	The reference number (e.g. check number) for an self-pay adjustment or payment.
8	PMT_ADJ_AMOUNT	NUMERIC	No
	The credit or debit amount for an self-pay adjustment or payment.
9	PMT_ADJ_PAYER_ID_PAYOR_NAME	VARCHAR	No
	The name of the payor.
10	PMT_ADJ_DESCRIPTION	VARCHAR	No
	A description of a self-pay adjustment or payment. Can be supplied by the source system as an override for the procedure description.
11	PMT_ADJ_REVERSAL_DATE	DATETIME	No
	The date that this payment or adjustment documentation line was reversed. This date is set to the day the documentation line was marked as reversed by the source system. If this item is blank, then the charge has not been reversed.
12	PMT_ADJ_ORIG_IDENT	VARCHAR	No
	An identifier for a self-pay adjustment or payment. If this is from another system, this is the ID the source system uses. If this is from the same system, this is the original transaction ID for the source service area (HTR for HB, ETR for PB).
13	PMT_ADJ_UPDATE_DATE	DATETIME	No
	The date that this adjustment or payment documentation line was sent to the consolidated self-pay service area. This date is set to the day the documentation line was first imported from the source system.
14	PMT_ADJ_HTR_ON_BILLING_ACCT_ID	NUMERIC	No
	If this payment/adjustment documentation line corresponds to an HB transaction posted on the insourced hospital account (for example, a patient payment that was posted directly to the target service area hospital account), this item stores a pointer to that transaction.
15	PMT_ADJ_CONS_SP_DOCLN_STS_C_NAME	VARCHAR	No
	The current active status of the documentation line. May contain organization-specific values: No Category Entries: Pending Active Pending Reversal Inactive
16	PMT_EOB_DEDUCTIBLE_AMOUNT	NUMERIC	No
	Deductible amount from related payment transaction.
17	PMT_EOB_COINSURANCE_AMOUNT	NUMERIC	No
	Coinsurance amount from related payment transaction.
18	PMT_EOB_COPAY_AMOUNT	NUMERIC	No
	Copay amount from related payment transaction.
19	PMT_EOB_NON_COVERED_AMOUNT	NUMERIC	No
	Non-covered amount from related payment transaction.
20	PMT_ADJ_PAYER_NAME	VARCHAR	No
	The payer name for an adjustment or payment documentation line. Will fallback on I HAR 3488.