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_LOC_NAME VARCHAR No
The name of the revenue location.
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