PROFIT CENTER GROUP Table
View exposing hierarchical groupings of profit centers including multi-level sort order and category attributes used for financial reporting and organizational rollups.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DLC_KEY |
Identifier for the DLC (department, lab, or center) associated with the profit center. |
VARCHAR2 |
180 |
DLC_NAME |
Name of the DLC associated with the profit center. |
VARCHAR2 |
840 |
PC_LEVEL1_CATEGORY |
Level 1 reporting category used for profit center grouping. |
VARCHAR2 |
40 |
PC_LEVEL1_SORT |
Sort order for hierarchy level 1 reporting category. |
NUMBER |
6 |
PC_LEVEL2_CATEGORY |
Level 2 reporting category used for profit center grouping. |
VARCHAR2 |
40 |
PC_LEVEL2_SORT |
Sort order for hierarchy level 2 reporting category. |
NUMBER |
6 |
PC_LEVEL3_CATEGORY |
Level 3 reporting category used for profit center grouping. |
VARCHAR2 |
40 |
PC_LEVEL3_SORT |
Sort order for hierarchy level 3 reporting category. |
NUMBER |
|
PC_LEVEL4_CATEGORY |
Level 4 reporting category used for profit center grouping. |
VARCHAR2 |
40 |
PC_LEVEL4_SORT |
Sort order for hierarchy level 4 reporting category. |
NUMBER |
6 |
PC_LEVEL5_CATEGORY |
Level 5 reporting category used for profit center grouping. |
VARCHAR2 |
40 |
PC_LEVEL5_SORT |
Sort order for hierarchy level 5 reporting category. |
NUMBER |
6 |
PC_LEVEL6_CATEGORY |
Level 6 reporting category used for profit center grouping. |
VARCHAR2 |
40 |
PC_LEVEL6_SORT |
Sort order for hierarchy level 6 reporting category. |
NUMBER |
6 |
PC_LEVEL7_CATEGORY |
Level 7 reporting category used for profit center grouping. |
VARCHAR2 |
40 |
PC_LEVEL7_SORT |
Sort order for hierarchy level 7 reporting category. |
NUMBER |
6 |
PC_LEVEL8_CATEGORY |
Level 8 reporting category used for profit center grouping. |
VARCHAR2 |
40 |
PC_LEVEL8_SORT |
Sort order for hierarchy level 8 reporting category. |
NUMBER |
6 |
PROFIT_CENTER_GROUP_CODE |
Code identifying the profit center reporting group. |
VARCHAR2 |
12 |
PROFIT_CENTER_GROUP_NAME |
Descriptive name of the profit center reporting group. |
VARCHAR2 |
40 |
PROFIT_CENTER_ID |
Business identifier for the profit center defined in the source financial system. |
VARCHAR2 |
7 |
PROFIT_CENTER_KEY |
Surrogate identifier for the profit center. |
VARCHAR2 |
11 |
PROFIT_CENTER_NAME |
Descriptive name of the profit center. |
VARCHAR2 |
50 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |