HSP_ACCT_CONS_SP_STS_HX

Description:

Consolidated balances status history.

Primary Key

Column Name	Ordinal Position
HSP_ACCT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	HSP_ACCT_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	CHANGE_UTC_DTTM	DATETIME (UTC)	No
	Stores the instant the account's consolidated balances status changed.
4	CHANGE_TYPE_C_NAME	VARCHAR	No
	Stores the type of the consolidated balances status change. May contain organization-specific values: No Category Entries: Assign Withdraw
5	USER_ID	VARCHAR	No
	Stores the user behind the consolidated balances status change.
6	USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
7	WITHDRAWAL_REASON_C_NAME	VARCHAR	No
	Stores the reason the account was withdrawn. May contain organization-specific values: Yes Category Entries: Created in Error Account Combine Sent to PB bad debt in non-SBO AR Service Area. Conversion Utility Multi-Instance Inventory