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
Unspecified
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