HSP_ACCT_DNB_SB_HX

Description:

This table holds the history items of adding and removing discharged-not-billed (DNBs), Stop Bills, and Validation Checks to Hospital Accounts. This includes the user that initiated the action, when the action was initiated, and what rule was used to initiate the action.

Primary Key

Column Name	Ordinal Position
HSP_ACCOUNT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	HSP_ACCOUNT_ID	NUMERIC	No
	The hospital account ID with related stop bill/DNB/validation check information.
2	LINE	INTEGER	No
	The line number in the results of a query. Each piece of stop bill/DNB/validation check history will have its own line number.
3	HX_DNBSB_ADD_USR_ID	VARCHAR	No
	This column stores the unique identifier for the user who placed the stop bill/DNB/validation check on the hospital account.
4	HX_DNBSB_ADD_USR_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
5	HX_DNBSB_RMV_USR_ID	VARCHAR	No
	This column stores the unique identifier for the user who removed the stop bill/DNB/validation check from the hospital account.
6	HX_DNBSB_RMV_USR_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
7	HX_BILLING_INDC_C_NAME	VARCHAR	No
	This is the billing indicator category that was added or removed from the account. May contain organization-specific values: Yes
8	HX_FILTER_CER_RULE_ID	VARCHAR	No
	This column stores the unique identifier for the edit check's CER filter rule.
9	HX_FILTER_CER_RULE_ID_RULE_NAME	VARCHAR	No
	The name of the rule.
10	HX_FILTER_BWR_RULE_ID	NUMERIC	No
	This column stores the unique identifier for the edit check's BWR filter rule.
11	HX_FILTER_BWR_RULE_ID_RULE_NAME	VARCHAR	No
	This column stores the name of the hospital billing workqueue rule.