AN_HSB_LINK_AUDIT

Description: |
The AN_HSB_LINK_AUDIT table contains an audit trail of anesthesia linking operations. This table applies to episode (HSB) records of the type specified for anesthesia episodes in clinical system definitions.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
SUMMARY_BLOCK_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | SUMMARY_BLOCK_ID | NUMERIC | No |
The unique ID for the Episode record for this row. This column is frequently used to link to the EPISODE table.
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 | AN_AUDIT_TYPE_C_NAME | VARCHAR | No |
Anesthesia linking audit trail item representing the type of link being done.
May contain organization-specific values: No
Category Entries:
Encounter
Order
Ad-hoc
4 | AN_AUDIT_VALUE | VARCHAR | No |
Anesthesia linking audit trail item representing the value of the link. If the linking type is 1-Encounter, this will be the unique patient contact serial number (EPT CSN) of the linked procedure contact. If the linking type is 2-Order, this will be the unique order (ORD) ID of the linked order. If the linking type is 3-Unlinked, this will be the user-entered episode description.
5 | AN_AUDIT_INST_TM | DATETIME (UTC) | No |
Anesthesia linking audit trail item representing the instant the link was changed.
6 | AN_AUDIT_USER_ID | VARCHAR | No |
Anesthesia linking audit trail item representing the user doing the linking.
7 | AN_AUDIT_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.