RPT_FCT_FM_APPROVED_BUDGETS
This is a fact table in reporting Star schema that contains the approved budget information of lifecycle entities, programs, org units, and portfolios. The approved budget information is stored at year granularity.
Foreign Keys
This table does not have any foreign keys.
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
FACT_ID |
NOT NULL |
NUMBER |
ID derived from FM_APPROVED_BUDGETS table |
FINANCIAL_SUMMARY_ID |
NOT NULL |
NUMBER |
ID of the financial summary derived from FM_FINANCIAL_SUMMARY table |
DIRECT_PARENT_ID |
NOT NULL |
NUMBER |
ID of proposal, project, asset, program, org unit with which this financial summary is associated. This ID is derived from PFM_LIFECYCLE_PARENT_ENTITY table for currently active entity. |
DIRECT_PARENT_TYPE |
NOT NULL |
VARCHAR2(20) |
Type of parent entity (project, proposal, asset, program, org unit) |
DIRECT_PARENT_NAME |
NOT NULL |
VARCHAR2(500) |
Name of a proposal, project, asset, program, or org unit associated with the financial summary |
REGION_ID |
NULLABLE |
NUMBER |
ID of the region with which the cost is associated with derived from |
PERIOD_ID |
NOT NULL |
NUMBER |
ID of the period with which the cost is associated with derived from FM_APPROVED_BUDGETS table |
AMOUNT_BASE |
NULLABLE |
NUMBER |
Approved cost aggregated for a given year, displayed in base currency |
AMOUNT_LOCAL |
NULLABLE |
NUMBER |
Approved cost aggregated for a given year, displayed in local currency |
EXPENSE_TYPE_CODE |
NULLABLE |
VARCHAR2(40) |
Indicates the expense type (capital or operating) |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
SYS_C003624083 |
UNIQUE |
1 |
FACT_ID |
Sequences
This table uses no sequences.