HSP_ACCT_PRORATION

Description:

This table contains the Proration related information from the Hospital Accounts Receivable (HAR) master file.

Primary Key

Column Name	Ordinal Position
HSP_ACCOUNT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	HSP_ACCOUNT_ID	NUMERIC	No
	This column stores the unique identifier for the hospital account.
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	COVERAGE_ID	NUMERIC	No
	This column stores the unique identifier for the coverage record on the hospital account.
4	CVG_AUTH_NUM	VARCHAR	No
	The coverage authorization number.
5	EXP_COPAY_AMT	NUMERIC	No
	The expected copay amount.
6	EXP_COINS_PC	NUMERIC	No
	This column stores the expected coinsurance percentage.
7	EXP_COINS_AMT	NUMERIC	No
	This column stores the expected coinsurance amount.
8	EXP_DED_AMT	NUMERIC	No
	This column stores the expected deductible amount.
9	SYS_EXP_COPAY_AMT	NUMERIC	No
	This column stores the copay amount expected by the system.