FUNDS REPORTING CC HISTORY Table
View exposing historical fund reporting records by cost collector used for financial reporting and trend analysis.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDRESSEE |
Addressee associated with the record. |
VARCHAR2 |
30 |
ADMIN_FLAG |
Admin flag associated with the record. |
VARCHAR2 |
2 |
COST_COLLECTOR_CATEGORY_CODE |
Code identifying cost collector category. |
VARCHAR2 |
5 |
COST_COLLECTOR_CATEGORY_DESC |
Description of cost collector category. |
VARCHAR2 |
30 |
COST_COLLECTOR_FP_KEY |
Surrogate key identifying the cost collector fp. |
VARCHAR2 |
12 |
COST_COLLECTOR_ID |
Business identifier for the cost collector. |
VARCHAR2 |
7 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
COST_COLLECTOR_NAME |
Cost collector name associated with the record. |
VARCHAR2 |
60 |
COST_COLLECTOR_TYPE_CODE |
Code identifying cost collector type. |
VARCHAR2 |
5 |
PC_LEVEL1_CATEGORY |
Pc level1 category associated with the record. |
VARCHAR2 |
40 |
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_SORT |
Pc level2 sort associated with the record. |
NUMBER |
6 |
PC_LEVEL3_CATEGORY |
Pc level3 category associated with the record. |
VARCHAR2 |
40 |
PC_LEVEL3_SORT |
Pc level3 sort associated with the record. |
NUMBER |
6 |
POOL_CODE |
Code identifying pool. |
VARCHAR2 |
1 |
PROFIT_CENTER_ID |
Business identifier for the profit center. |
VARCHAR2 |
7 |
PROFIT_CENTER_NAME |
Profit center name associated with the record. |
VARCHAR2 |
40 |
SUPERVISOR |
Supervisor associated with the record. |
VARCHAR2 |
30 |
TERM_CODE |
Code identifying term. |
VARCHAR2 |
1 |
TIME_MONTH_KEY |
Surrogate key identifying the time month. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |