PROFIT CENTER GROUP WITH ID Table
View exposing profit center group reference records including identifiers and hierarchy attributes used in financial reporting and analysis.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DLC_KEY |
Surrogate key identifying the dlc. |
VARCHAR2 |
180 |
DLC_NAME |
Dlc name associated with the record. |
VARCHAR2 |
840 |
PC_LEVEL1_CATEGORY |
Pc level1 category associated with the record. |
VARCHAR2 |
40 |
PC_LEVEL1_ID |
Business identifier for the pc level1. |
VARCHAR2 |
10 |
PC_LEVEL1_SORT |
Pc level1 sort associated with the record. |
NUMBER |
6 |
PC_LEVEL2_CATEGORY |
Pc level2 category associated with the record. |
VARCHAR2 |
40 |
PC_LEVEL2_ID |
Business identifier for the pc level2. |
VARCHAR2 |
10 |
PC_LEVEL2_SORT |
Pc level2 sort associated with the record. |
NUMBER |
6 |
PC_LEVEL3_CATEGORY |
Pc level3 category associated with the record. |
VARCHAR2 |
40 |
PC_LEVEL3_ID |
Business identifier for the pc level3. |
VARCHAR2 |
10 |
PC_LEVEL3_SORT |
Pc level3 sort associated with the record. |
NUMBER |
6 |
PC_LEVEL4_CATEGORY |
Pc level4 category associated with the record. |
VARCHAR2 |
40 |
PC_LEVEL4_ID |
Business identifier for the pc level4. |
VARCHAR2 |
10 |
PC_LEVEL4_SORT |
Pc level4 sort associated with the record. |
NUMBER |
6 |
PC_LEVEL5_CATEGORY |
Pc level5 category associated with the record. |
VARCHAR2 |
40 |
PC_LEVEL5_ID |
Business identifier for the pc level5. |
VARCHAR2 |
10 |
PC_LEVEL5_SORT |
Pc level5 sort associated with the record. |
NUMBER |
6 |
PC_LEVEL6_CATEGORY |
Pc level6 category associated with the record. |
VARCHAR2 |
40 |
PC_LEVEL6_ID |
Business identifier for the pc level6. |
VARCHAR2 |
10 |
PC_LEVEL6_SORT |
Pc level6 sort associated with the record. |
NUMBER |
6 |
PC_LEVEL7_CATEGORY |
Pc level7 category associated with the record. |
VARCHAR2 |
40 |
PC_LEVEL7_ID |
Business identifier for the pc level7. |
VARCHAR2 |
10 |
PC_LEVEL7_SORT |
Pc level7 sort associated with the record. |
NUMBER |
6 |
PC_LEVEL8_CATEGORY |
Pc level8 category associated with the record. |
VARCHAR2 |
40 |
PC_LEVEL8_ID |
Business identifier for the pc level8. |
VARCHAR2 |
10 |
PC_LEVEL8_SORT |
Pc level8 sort associated with the record. |
NUMBER |
6 |
PROFIT_CENTER_GROUP_CODE |
Code identifying profit center group. |
VARCHAR2 |
12 |
PROFIT_CENTER_GROUP_NAME |
Profit center group name associated with the record. |
VARCHAR2 |
40 |
PROFIT_CENTER_ID |
Business identifier for the profit center. |
VARCHAR2 |
7 |
PROFIT_CENTER_KEY |
Surrogate key identifying the profit center. |
VARCHAR2 |
11 |
PROFIT_CENTER_NAME |
Profit center name associated with the record. |
VARCHAR2 |
50 |
SCHOOL_AREA |
School area associated with the record. |
VARCHAR2 |
840 |