OR_LNLG_CDP

Description:

This table contains the CDP information for the Surgical Log (ORL). CDP stands for Catheter, Drains, and Packings which has been replaced by LDAs (Lines, Drains, and Airways) post Summer 2009.

Primary Key

Column Name	Ordinal Position
RECORD_ID	1

Column Information

	Name	Type	Discontinued?
1	RECORD_ID	VARCHAR	No
	The unique ID of the line record.
2	CDP_TYPE_C_NAME	VARCHAR	No
	The category ID for the type of CDP for the surgical log. May contain organization-specific values: Yes
3	CDP_ACTION_C_NAME	VARCHAR	No
	The action taken on the catheter, drain, or packing (CDP). May contain organization-specific values: Yes
4	CDP_AREA_C_NAME	VARCHAR	No
	The category ID for the area in which the CDP was applied. May contain organization-specific values: Yes
5	CDP_SIZE	NUMERIC	No
	The size of the catheter, drain, or packing (CDP).
6	CDP_REMOVAL_DATE	DATETIME	No
	The date the CDP was removed.
7	CDP_NUM_USED	INTEGER	No
	The number of CDPs used.
8	CDP_LATERALITY_C_NAME	VARCHAR	No
	The laterality of the CDP. May contain organization-specific values: Yes Category Entries: Left Right Bilateral N/A Default
9	CDP_AMOUNT	NUMERIC	No
	This column is a numeric value that stores the amount of CDPs. CDPs have been replaced by Lines, Drains, and Airways (LDAs) as of 2009.
10	CDP_UNITS_C_NAME	VARCHAR	No
	The units of measure category number for the CDP. May contain organization-specific values: Yes
11	CDP_INV_LOC_ID	NUMERIC	No
	This item will store inventory location for the CDPs.
12	CDP_CC_INFLATION	NUMERIC	No
	Stores the amount, in CCs, needed for inflation.
13	CDP_DIFF_INSRT_YN	VARCHAR	No
	Stores whether insertion was difficult. May contain organization-specific values: No Category Entries: No Yes
14	CDP_URINE_RET_C_NAME	VARCHAR	No
	The category number for the urine returned. May contain organization-specific values: Yes Category Entries: No Yes