ORD_LDA_LINK_AUDIT

Description: |
Audit table for links between the Order and LDAs.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ORDER_ID | NUMERIC | No |
The order ID. KB SQL Table: AUDIT_LDA_LINK KB SQL Column: ORDER_ID
2 | LINE | INTEGER | No |
The line in the chronicles item. This is extracted from the LINE_COUNT column.
3 | AUDIT_LDA_ID | VARCHAR | No |
Audit trail for Line/Drain/Airway (LDA) ID. KB SQL Table: AUDIT_LDA_LINK KB SQL Column: AUDIT_LDA_ID
4 | AUDIT_LDA_PORT_C_NAME | VARCHAR | No |
Audit trail for Line/Drain/Airway (LDA) Port. KB SQL Table: AUDIT_LDA_LINK KB SQL Column: AUDIT_LDA_PORT_C
May contain organization-specific values: Yes
5 | AUDIT_LDA_INSTLK_TM | DATETIME (Local) | No |
Audit trail for the line linkage instant. KB SQL Table: AUDIT_LDA_LINK KB SQL Column: AUDIT_LDA_INST_LINK
6 | AUDIT_LDA_COMMENT | VARCHAR | No |
Audit trail of the comment for the line linkage. KB SQL Table: AUDIT_LDA_LINK KB SQL Column: AUDIT_LDA_COMMENT
7 | AUDIT_LDA_INSTRC_TM | DATETIME (Local) | No |
Audit trail for the instant the line link was recorded. KB SQL Table: AUDIT_LDA_LINK KB SQL Column: AUDIT_LDA_INST_REC
8 | AUDIT_LDA_USER_ID | VARCHAR | No |
Audit trail of the user that recorded the line linkage. KB SQL Table: AUDIT_LDA_LINK KB SQL Column: AUDIT_LDA_USER_ID
9 | AUDIT_LDA_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
10 | AUDIT_LDA_EDITED | INTEGER | No |
The line that was edited to create this entry in the audit trail. KB SQL Table: AUDIT_LDA_LINK KB SQL Column: AUDIT_LDA_EDITED
11 | AUDIT_ENC_CSN | NUMERIC | No |
The audit trail of the encounter identifier that the Line/Drain/Airway (LDA) link was documented from.