HSP_ACCT_CL_AG_HIS

Description:

This table contains collection agency history 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 with associated collection agency information.
2	LINE	INTEGER	No
	The line number in the results of a query. Each collection agency history will have its own line number.
3	AGNCY_HST_DT_OF_CH	DATETIME	No
	Date hospital account was either assigned to or withdrawn from the collection agency.
4	AGNC_HST_CHG_TP_C_NAME	VARCHAR	No
	Change in the collection agency status. 1-Assign to agency 2-Withdraw from agency May contain organization-specific values: No Category Entries: Assign Withdraw
5	AGNCY_HST_AGNCY_ID	NUMERIC	No
	ID of collection agency hospital account has been assigned to.
6	AGNCY_HST_AGNCY_ID_COLL_AGENCY_NAME	VARCHAR	No
	The name of the collection agency.
7	AGN_HST_COL_ACT_C_NAME	VARCHAR	No
	This column stores the type of collection action done on the hospital account: 1-Send Letter, 2-Pre-Collect, 3-Bad Debt, 4-Return to Self-Pay, 5-Write Off, 6-Create Billing Note, 7-Change Notification Date, 8-Add to Queue, 10- Outsource Account, 11- Return from Outsource, 12-Change Agency, 13-Set Billing Indicator, or 14-Send SmartText Letter. May contain organization-specific values: No Category Entries: Send Letter Pre-Collect Send to Bad Debt Return to Self-Pay Write Off Create Billing Note Change Notification Date Add to Queue Account Note Outsource Account Return from Outsource Agency Change Agency Modify Billing Indicator Send SmartText Letter Change Self-Pay Follow-up Date Send to External Agency A/R Return from External Agency A/R Set Tickler Pre-Collect to Bad Debt Outsource to Bad Debt Outsource to External Agency A/R External Agency A/R to Bad Debt Bad Debt to External Agency A/R
8	AGNCY_HST_ACCT_BAL	NUMERIC	No
	Account balance on the hospital account that was sent to collections.
9	AGNCY_HST_CHG_RSN_C_NAME	VARCHAR	No
	This column contains the reason why the account was placed or withdrawn from the agency. Refer to the AGNC_HST_CHG_TP_C to know whether this was related to an assign or withdraw. May contain organization-specific values: Yes No Entries Defined