OR_LOG_PNDS_DIA

Description: |
The OR_LOG_PNDS_DIA table contains OR management system log PNDS diagnosis 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 diagnoses refer to.
2 | LINE | INTEGER | No |
The line number of the PNDS diagnosis in the log.
3 | PNDS_DIAGNOSIS_ID | VARCHAR | No |
The unique ID of the PNDS diagnosis.
4 | PNDS_DIAGNOSIS_ID_ELEMENT_NAME | VARCHAR | No |
The name of the PNDS record.
5 | PNDS_DIA_PRES_YN | VARCHAR | No |
Yes/no flag indicating whether or not this diagnosis was present.
May contain organization-specific values: No
Category Entries:
Yes
No
6 | PNDS_DIA_NOTES | VARCHAR | No |
Free text comments about the diagnosis.
7 | PNDS_DIA_ADDED_YN | VARCHAR | No |
Yes/no flag indicating whether or not this diagnosis was added by a user.
The category values for this column were already listed for column: PNDS_DIA_PRES_YN