OR_LOG_PNDS_IND

Description:

The OR_LOG_PNDS_IND table contains OR management system log PNDS indicator 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 indicators refer to.
2	LINE	INTEGER	No
	The line number of the PNDS indicator in the log.
3	PNDS_INDICATOR_ID	VARCHAR	No
	The unique ID of the PNDS indicator.
4	PNDS_INDICATOR_ID_ELEMENT_NAME	VARCHAR	No
	The name of the PNDS record.
5	PNDS_IND_ACHVD_YN	VARCHAR	No
	Yes/no flag indicating whether or not this indicator was achieved. May contain organization-specific values: No Category Entries: Yes No
6	PNDS_IND_NOTES	VARCHAR	No
	Free text comments about the indicator.
7	PNDS_IND_ADDED_YN	VARCHAR	No
	Yes/no flag indicating whether or not this indicator was added by a user. The category values for this column were already listed for column: PNDS_IND_ACHVD_YN
8	PNDS_IND_OUT_ID	VARCHAR	No
	The unique ID of the PNDS outcome associated with this indicator.
9	PNDS_IND_OUT_ID_ELEMENT_NAME	VARCHAR	No
	The name of the PNDS record.