Operational Reporting Data Tables

The following table summarizes data tables that were created based on core PPM Center data tables for the Operational Reporting schema.

Table 3-6. Changes to Operational Reporting tables
Table	Change
RPT_CALENDAR_DAYS	Added in 9.10
RPT_CM_FACT_CNTL	Added in 9.10
RPT_DIM_PPM_FISCAL_PERIODS	Added in 9.10
RPT_DIM_REQUESTS	Added in 9.10
RPT_DIM_RM_POSITIONS	Added in 9.10
RPT_DIM_RM_RESOURCEPOOLMGRS	Added in 9.10
RPT_DIM_RM_RESOURCEPOOLS	Added in 9.10
RPT_DIM_RM_RESOURCES	Added in 9.10
RPT_DIM_RM_ROLES	Added in 9.10
RPT_DIM_RM_STAFF_PROFILES	Added in 9.10
RPT_DIM_TM_TIME_SHEET_LINES	Added in 9.10
RPT_DIM_TM_TIME_SHEETS	Added in 9.10
RPT_ETL_JOB	Added in 9.10
RPT_EVENT_DEF	Added in 9.10
RPT_EVENT_LOG	Added in 9.10
RPT_EVENT_LOG_DETAIL	Added in 9.10
RPT_FCT_FM_APPROVED_BUDGETS	Added in 9.10
RPT_FCT_FM_FCST_ACTUAL_CELL	Added in 9.10
RPT_FCT_RM_RES_DISTRIBUTION	Added in 9.10
RPT_FCT_RM_RESOURCE_CAPACITY	Added in 9.10
RPT_FCT_RM_RESOURCE_DEMAND	Added in 9.10
RPT_FCT_RM_RESOURCE_DEMAND_STG	Added in 9.10
RPT_FCT_RM_RESOURCE_EFFORT	Added in 9.10
RPT_FCT_RM_RESRCE_CAPACITY_STG	Added in 9.10
RPT_FCT_RM_RSC_CAPACITY_AGGR	Added in 9.10
RPT_FCT_RM_RSC_DEMAND_AGGR	Added in 9.10
RPT_FCT_TM_ACTUAL_EFFORT	Added in 9.10
RPT_FCT_TM_COMPLIANCE	Added in 9.10
RPT_FCT_TM_COST	Added in 9.10
RPT_KNTA_USERS_DELETES	Added in 9.10
RPT_PARAMS	Added in 9.10
RPT_RECREATE_INDEX	Added in 9.10
RPT_RERUN_STATUS	Added in 9.10
RPT_RM_FACT_CNTL	Added in 9.10
RPT_RM_RSC_RP_ENTRIES	Added in 9.10
RPT_RSC_RPDE_DELETES	Added in 9.10
RPT_DEPLOYMENT	Added in 9.12 Content Pack 1
RPT_DIM_PM_TASKS	Added in 9.12 Content Pack 1
RPT_DIM_REQ_DTL_CUSTOM_PARAMS	Added in 9.12 Content Pack 1
RPT_DIM_REQ_HDR_CUSTOM_PARAMS	Added in 9.12 Content Pack 1
RPT_FCT_PM_AGGR_PROJ_EFFORT	Added in 9.12 Content Pack 1
RPT_FCT_PM_AGGR_TASK_EFFORT	Added in 9.12 Content Pack 1
RPT_FCT_PM_TASK_ASSIGNMENTS	Added in 9.12 Content Pack 1
RPT_FCT_PM_TASK_COST	Added in 9.12 Content Pack 1
RPT_FCT_PM_TASK_UNASSGN_EFFORT	Added in 9.12 Content Pack 1
RPT_PM_PROJECT_ENTRIES	Added in 9.12 Content Pack 1
RPT_PM_PROJECT_MANAGERS	Added in 9.12 Content Pack 1
RPT_PM_TASK_ENTRIES	Added in 9.12 Content Pack 1
RPT_UPGRADE_PARAMS	Added in 9.12 Content Pack 1
RPT_TRACE_DETAILS	Added in Content Pack 1.2
RPT_FCT_FM_BENEFIT_ CELLS	Added in Content Pack 2.0
RPT_FCT_REQUEST_ TRANSACTIONS	Added in Content Pack 2.0
RPT_DIM_REQUESTS	Modified in Content Pack 2.0
RPT_FCT_FM_FCST_ ACTUAL_CELL	Modified in Content Pack 2.0
RPT_FCT_FM_APPROVED_ BUDGETS	Modified in Content Pack 2.0