MASTER PROJECT HISTORY Table
View exposing historical master-project reference data by fiscal period including master-project identifiers, names, fiscal period, and fiscal year.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
FISCAL_PERIOD |
Fiscal period associated with the record. |
VARCHAR2 |
6 |
FISCAL_YEAR |
Fiscal year associated with the record. |
VARCHAR2 |
4 |
MASTER_PROJECT_FP_KEY |
Surrogate key identifying the master project fp. |
VARCHAR2 |
12 |
MASTER_PROJECT_NAME |
Master project name associated with the record. |
VARCHAR2 |
160 |
MASTER_PROJECT_NUMBER |
Master project number associated with the record. |
VARCHAR2 |
7 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |