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.