PROJECT AUTH TOTAL HISTORY Table
View exposing authorized total amount history for projects and cost collectors by fiscal period and fiscal month to support trend analysis and historical reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AUTHORIZED_TOTAL_AMOUNT |
Authorized total amount associated with the project or cost collector for the period. |
NUMBER |
13,2 |
COST_COLLECTOR_FP_KEY |
Identifier representing the cost collector at the fiscal-period level. |
VARCHAR2 |
12 |
COST_COLLECTOR_FY_KEY |
Identifier representing the cost collector at the fiscal-year level. |
VARCHAR2 |
12 |
FISCAL_YEAR_KEY |
Identifier representing the fiscal year associated with the authorized total history record. |
VARCHAR2 |
4 |
PROJECT_WBS_ID |
Business identifier for the project WBS element. |
VARCHAR2 |
7 |
TIME_MONTH_KEY |
Identifier representing the fiscal month associated with the authorized total history record. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |