OR_LOG_PNDS_OUT

Description: |
The OR_LOG_PNDS_OUT table contains OR management system log PNDS outcome 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 outcomes refer to.
2 | LINE | INTEGER | No |
The line number of the PNDS outcome in the log.
3 | PNDS_OUTCOME_ID | VARCHAR | No |
The unique ID of the PNDS outcome.
4 | PNDS_OUTCOME_ID_ELEMENT_NAME | VARCHAR | No |
The name of the PNDS record.
5 | PNDS_OUT_ACHVD_YN | VARCHAR | No |
Yes/no flag indicating whether or not this outcome was achieved.
May contain organization-specific values: No
Category Entries:
Yes
No
6 | PNDS_OUT_NOTES | VARCHAR | No |
Free text comments about the outcome.
7 | PNDS_OUT_ADDED_YN | VARCHAR | No |
Yes/no flag indicating whether or not this outcome was added by a user.
The category values for this column were already listed for column: PNDS_OUT_ACHVD_YN