INF_EXPIRATION_CHANGE_HX

Description:

This table stores changes to the infection expiration date.

Primary Key

Column Name	Ordinal Position
INFECTION_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	INFECTION_ID	NUMERIC	No
	The unique identifier (.1 item) for the infection 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	EXP_CHANGE_INST_UTC_DTTM	DATETIME (UTC)	No
	The UTC instant that a change was made to the infection expiration date.
4	EXP_CHANGE_NEW_DATE	DATETIME	No
	The new expiration date set by an expiration date change.
5	EXP_CHANGE_TYPE_C_NAME	VARCHAR	No
	The change type category ID for the expiration date change. May contain organization-specific values: No Category Entries: User Import Infection Indicator Expiration Exception Expired Resolved User - Never Expire Import - Never Expire User - From External
6	EXP_CHANGE_USER_ID	VARCHAR	No
	The unique ID of the user who changed the expiration date.
7	EXP_CHANGE_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
8	EXP_CHANGE_ORDER_ID	NUMERIC	No
	The unique ID of the order that changed the expiration date.
9	EXP_CHANGE_RULE_ID	VARCHAR	No
	The unique ID of the rule that was evaluated for expiration exceptions that resulted in a change to the expiration date.
10	EXP_CHANGE_RULE_ID_RULE_NAME	VARCHAR	No
	The name of the rule.
11	EXP_CHNG_ALERT_CSN_ID	NUMERIC	No
	The unique alert CSN for the advisory that changed the expiration date.
12	EXP_CHANGE_INST_DTTM	DATETIME (Attached)	No
	The local instant that a change was made to the infection expiration date.