CDC Tables Copied Over from OpenText PPM Database

This section lists the CDC tables that contain the changes made to OpenText PPM 9.12 Content Pack 1 since the last ETL cycle. Data from the CDC tables in OpenText 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 OpenText 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