OR_LOG_PNDS_INT

Description: |
The OR_LOG_PNDS_INT table contains OR management system log PNDS intervention information.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | LOG_ID | VARCHAR | No |
The unique ID of the surgical log that the PNDS interventions refer to.
2 | LINE | INTEGER | No |
The line number of the PNDS interventions in the log.
3 | PNDS_INTERVENT_ID | VARCHAR | No |
The unique ID of the PNDS intervention.
4 | PNDS_INTERVENT_ID_ELEMENT_NAME | VARCHAR | No |
The name of the PNDS record.
5 | PNDS_INT_USED_YN | VARCHAR | No |
Yes/no flag indicating whether or not this intervention was used.
May contain organization-specific values: No
Category Entries:
Yes
No
6 | PNDS_INT_NOTES | VARCHAR | No |
Free text comments about the intervention.
7 | PNDS_INT_ADDED_YN | VARCHAR | No |
Yes/no flag indicating whether or not this intervention was added by a user.
The category values for this column were already listed for column: PNDS_INT_USED_YN
8 | PNDS_INT_OUT_ID | VARCHAR | No |
The unique ID of the PNDS outcome associated with this intervention.
9 | PNDS_INT_OUT_ID_ELEMENT_NAME | VARCHAR | No |
The name of the PNDS record.