PROJECT AUTH TOTAL HISTORY Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AUTHORIZED_TOTAL_AMOUNT |
The amount authorized to be expended for a cost collector, usually by a WBS project sponsor. |
NUMBER |
13,2 |
COST_COLLECTOR_FP_KEY |
Key used to join historical Cost Collector tables and a fact table (Balances by Fiscal Period, Summary Statement Detail) when you want to bring up the cost collector data matching the fiscal period on the fact table. For the current fiscal period, the most recent data will be brought in. |
VARCHAR2 |
12 |
COST_COLLECTOR_FY_KEY |
Key used to join historical Cost Collector tables and a fact table (Balances, Balances by Fiscal Period, Summary Statement Detail) when you want to bring in cost collector data as it was at the end of fiscal year of the fact data. For the current fiscal year, the most recent data will be brought in. |
VARCHAR2 |
12 |
FISCAL_YEAR_KEY |
XXX |
VARCHAR2 |
4 |
PROJECT_WBS_ID |
Project work breakdown structure element identifier. |
VARCHAR2 |
7 |
TIME_MONTH_KEY |
Key used only for joining the TIME_MONTH table to other tables, NOT for reporting. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |