ORD_LDA_LINK

Description: |
Links between Orders (ORD) 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: CURRENT_LDA_LINK KB SQL Column: ORDER_ID
2 | LINE | INTEGER | No |
The chronicles item line. This does not actually have a KB SQL column. Extracted from LINE_COUNT
3 | LDA_ID | VARCHAR | No |
The ID of the currently linked Line/Drain/Airway (LDA) KB SQL Table: CURRENT_LDA_LINK KB SQL Column: LDA_ID
4 | LDA_PORT_C_NAME | VARCHAR | No |
Currently linked Line/Drain/Airway (LDA) port. KB SQL Table: CURRENT_LDA_LINK KB SQL Column: LDA_PORT_C
May contain organization-specific values: Yes
5 | LDA_INST_LINKED_TM | DATETIME (Local) | No |
The instant when the current line linkage occurred.
6 | LDA_COMMENT | VARCHAR | No |
A comment for the current Line/Drain/Airway (LDA) link. KB SQL Table: CURRENT_LDA_LINK KB SQL Column: LDA_COMMENT
7 | LDA_INST_RECORD_TM | DATETIME (Local) | No |
The instant that the current linkage was recorded. KB SQL Table: CURRENT_LDA_LINK KB SQL Column: LDA_INST_RECORDED
8 | LDA_USER_ID | VARCHAR | No |
The user that recorded the current Line/Drain/Airway (LDA) link. KB SQL Table: CURRENT_LDA_LINK KB SQL Column: LDA_USER_ID
9 | LDA_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
10 | LDA_EDITED | INTEGER | No |
Points to a line in the audit trail if the LDA linked to the order is edited.
11 | ENC_CSN | NUMERIC | No |
The encounter identifier that the Line/Drain/Airway (LDA) link was documented from.