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