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