CDC Tables Copied Over from PPM Database

This section lists the CDC tables that contain the changes made to PPM 9.12 Content Pack 1 since the last ETL cycle. Data from the CDC tables in PPM are extracted and copied into these tables.

Data from these tables are used to process the changes on the reporting database during the ETL cycle.

Note: We strongly recommend you not to alter any of these tables.

The CDC tables that are copied over from the PPM database include:

  • FG_MASTER_PROJ_REF_CDC_PM_W

  • FG_PROJ_SCOPE_CHANGE_CDC_PM_W

  • FM_APPROVED_BUDGETS_CDC_FM_W

  • FM_FAL_CDC_FM_W

  • FM_FINANCIAL_SUMMARY_CDC_CM_W

  • FM_FINANCIAL_SUMMARY_CDC_FM_W

  • FM_FLC_CDC_FM_W

  • FM_FORECAST_ACTUALS_CDC_FM_W

  • FM_USER_DATA_CDC_FM_W

  • ITG_ACTIVITIES_NLS_CDC_TM_W

  • ITG_AUDIT_EVENTS_CDC_TM_W

  • ITG_SA_CDC_FM_W

  • ITG_SC_CDC_FM_W

  • ITG_SCA_CDC_FM_W

  • ITG_SCC_CDC_FM_W

  • KCRT_CONTACTS_CDC_CM_W

  • KCRT_FG_PFM_ASSET_CDC_CM_W

  • KCRT_FG_PFM_ASSET_CDC_FM_W

  • KCRT_FG_PFM_PROJECT_CDC_CM_W

  • KCRT_FG_PFM_PROJECT_CDC_FM_W

  • KCRT_FG_PFM_PROJECT_CDC_PM_W

  • KCRT_FG_PFM_PROPOSAL_CDC_CM_W

  • KCRT_FG_PFM_PROPOSAL_CDC_FM_W

  • KCRT_FG_PROJ_ISSUE_CDC_PM_W

  • KCRT_FG_PROJ_RISK_CDC_PM_W

  • KCRT_REQUESTS_CDC_CM_W

  • KCRT_RTN_CDC_CM_W

  • KCRT_STATUSES_NLS_CDC_CM_W

  • KCST_CURRENCIES_NLS_CDC_CM_W

  • KCST_CURRENCIES_NLS_CDC_FM_W

  • KDLV_PACKAGES_CDC_TM_W

  • KDRV_CAL_EXECP_CDC_RM_W

  • KDRV_CALENDAR_SETUPS_CDC_CM_W

  • KDRV_CALENDAR_SETUPS_CDC_RM_W

  • KDRV_CALENDARS_CDC_CM_W

  • KDRV_WORKING_DAYS_CDC_CM_W

  • KDRV_WORKING_DAYS_CDC_RM_W

  • KNTA_LOOKUPS_NLS_CDC_CM_W

  • KNTA_LOOKUPS_NLS_CDC_PM_W

  • KNTA_REGIONS_NLS_CDC_CM_W

  • KNTA_REGIONS_NLS_CDC_RM_W

  • KNTA_SEC_GROUPS_NLS_CDC_RM_W

  • KNTA_USERS_CDC_CM_W

  • KNTA_USERS_CDC_PM_W

  • KNTA_USERS_CDC_RM_W

  • KPMO\KPMO_BO_NLS_CDC_CM_W

  • KPMO\KPMO_BO_NLS_CDC_FM_W

  • KKRSC_ORG_UNIT_MEMBERS_CDC_CM_W

  • KKRSC_ORG_UNITS_NLS_CDC_CM_W

  • KKRSC_ORG_UNITS_NLS_CDC_FM_W

  • KTMG_CHARGE_CODES_NLS_CDC_TM_W

  • KTMG_PERIOD_TYPES_NLS_CDC_TM_W

  • KTMG_PERIODS_CDC_TM_W

  • KTMG_POLICIES_CDC_TM_W

  • KWFL_WI_CDC_CM_W

  • KWFL_WIS_CDC_CM_W

  • KWFL_WORKFLOWS_NLS_CDC_CM_W

  • KWFL_WSN_CDC_CM_W

  • PPFM_LPE_CDC_CM_W

  • PPFM_LPE_CDC_FM_W

  • PGM_PROGRAM_CONTENT_CDC_CM_W

  • PGM_PROGRAM_CONTENT_CDC_FM_W

  • PGM_PROGRAMS_CDC_CM_W

  • PGM_PROGRAMS_CDC_FM_W

  • PM_PROG_BO_CDC_CM_W

  • PM_PROG_BO_CDC_FM_W

  • PM_PROJECT_ROLLUP_CDC_CM_W

  • PM_PROJECT_TYPES_CDC_CM_W

  • PM_PROJECTS_CDC_CM_W

  • PM_PROJECTS_CDC_FM_W

  • PM_PROJECTS_CDC_PM_W

  • PM_WORK_PLANS_CDC_CM_W

  • PM_WORK_PLANS_CDC_PM_W

  • PPPM_FIS_PERIODS_NLS_CDC_CM_W

  • REQ\REQ_DETLS_CDC_CM_W

  • REQ\REQ_DETLS_CDC_PM_W

  • REQ\REQ_HDR_DETLS_CDC_CM_W

  • REQ\REQ_HDR_DETLS_CDC_PM_W

  • RSC_POSITION_FORECAST_CDC_RM_W

  • RSC_POSITIONS_CDC_RM_W

  • RSC_RES_ASSGN_CDC_RM_W

  • RSC_RESOURCE_POOL_MGR_CDC_CM_W

  • RSC_RESOURCE_POOLS_CDC_CM_W

  • RSC_RESOURCE_POOLS_CDC_RM_W

  • RSC_RESOURCES_CDC_CM_W

  • RSC_RESOURCES_CDC_PM_W

  • RSC_RESOURCES_CDC_RM_W

  • RSC_ROLES_NLS_CDC_CM_W

  • RSC_RPDE_CDC_CM_W

  • RSC_RPDE_CDC_RM_W

  • RSC_SPA_CDC_RM_W

  • RSC_STAFFING_PROFILES_CDC_CM_W

  • RSC_STAFFING_PROFILES_CDC_RM_W

  • TM_ACTUALS_CDC_TM_W

  • TM_ACTUALS_EFFORT_CDC_TM_W

  • TM_LINE_CHARGE_CODES_CDC_TM_W

  • TM_TIME_SHEET_LINES_CDC_CM_W

  • TM_TIME_SHEET_LINES_CDC_TM_W

  • TM_TIME_SHEETS_CDC_CM_W

  • TM_TIME_SHEETS_CDC_TM_W

  • WP_MILESTONES_CDC_PM_W

  • WP_TASK_ACTUALS_CDC_CM_W

  • WP_TASK_ACTUALS_CDC_PM_W

  • WP_TASK_COSTS_CDC_PM_W

  • WP_TASK_INFO_CDC_PM_W

  • WP_TASK_INFO_CDC_TM_W

  • WP_TASK_SCHEDULE_CDC_PM_W

  • WP_TASKS_CDC_CM_W

  • WP_TASKS_CDC_PM_W

  • WP_TASKS_CDC_TM_W

  • WP_USER_DATA_CDC_PM_W

  • WP_WORK_UNITS_CDC_PM_W