OR_LOG_PNDS_INT

Description:

The OR_LOG_PNDS_INT table contains OR management system log PNDS intervention 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 interventions refer to.
2	LINE	INTEGER	No
	The line number of the PNDS interventions in the log.
3	PNDS_INTERVENT_ID	VARCHAR	No
	The unique ID of the PNDS intervention.
4	PNDS_INTERVENT_ID_ELEMENT_NAME	VARCHAR	No
	The name of the PNDS record.
5	PNDS_INT_USED_YN	VARCHAR	No
	Yes/no flag indicating whether or not this intervention was used. May contain organization-specific values: No Category Entries: Yes No
6	PNDS_INT_NOTES	VARCHAR	No
	Free text comments about the intervention.
7	PNDS_INT_ADDED_YN	VARCHAR	No
	Yes/no flag indicating whether or not this intervention was added by a user. The category values for this column were already listed for column: PNDS_INT_USED_YN
8	PNDS_INT_OUT_ID	VARCHAR	No
	The unique ID of the PNDS outcome associated with this intervention.
9	PNDS_INT_OUT_ID_ELEMENT_NAME	VARCHAR	No
	The name of the PNDS record.