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.