HSP_ACCT_COD_ERROR_HX

Description:

This table contains the coding-related error history for external system errors.

Primary Key

Column Name	Ordinal Position
ACCT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	ACCT_ID	NUMERIC	No
	The unique identifier for the hospital account 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	COD_ERROR_TYPE_C_NAME	VARCHAR	No
	Lists the type of error for each error that occurred for the hospital account. May contain organization-specific values: No Category Entries: External System Error Coding Validation Error Coding Validation Warning
4	ERROR_START_UTC_DTTM	DATETIME (UTC)	No
	Lists the UTC instant for when each error first appeared for the hospital account.
5	ERROR_END_UTC_DTTM	DATETIME (UTC)	No
	Lists the UTC instant for when each error was resolved for the hospital account.
6	EXT_ERROR_CODE	VARCHAR	No
	Lists the external error code for each external error that occurred for the hospital account.
7	ERROR_IS_ACTIVE_YN	VARCHAR	No
	Lists whether or not each error is currently applicable for the hospital account. If the error is not active then there will also be an end time for the error. May contain organization-specific values: No Category Entries: No Yes
8	ERROR_MESSAGE	VARCHAR	No
	Lists the error message for each error that occurred for the hospital account.