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