HSP_ACCT_COD_CHK

Description:

This table stores the information about the coding validation checks.

Primary Key

Column Name	Ordinal Position
ACCT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	ACCT_ID	NUMERIC	No
	The unique ID of the hospital account record.
2	LINE	INTEGER	No
	The line number for the coding validation check. Multiple coding validation checks can occur on one hospital account, so each check has a unique line number.
3	COD_CHK_TEXT	VARCHAR	No
	Coding Validation text
4	COD_VAL_ALT_ITEM_YN	VARCHAR	No
	This item stores the fact that the validation check has been run on the alternate code set items on the diagnosis and procedure tabs on the Coding screen. May contain organization-specific values: No Category Entries: No Yes
5	COD_CHK_RULE_ID	VARCHAR	No
	This item tracks which coding validation rules the account failed.
6	COD_CHK_RULE_ID_RULE_NAME	VARCHAR	No
	The name of the rule.
7	COD_CHK_CER_RULE_ID	VARCHAR	No
	Stores the coding validation check's general filter rule ID.
8	COD_CHK_CER_RULE_ID_RULE_NAME	VARCHAR	No
	The name of the rule.
9	COD_CHK_BWR_RULE_ID	NUMERIC	No
	Stores the coding validation check's billing filter rule ID.
10	COD_CHK_BWR_RULE_ID_RULE_NAME	VARCHAR	No
	This column stores the name of the hospital billing workqueue rule.