Archiving Synchronized Data

The tables that are used to synchronize data are not automatically purged. Use the PeopleTools Data Archive Manager to remove records from the Synchronization log. The tables that hold:

  • Project data are: P6_SYNC_HD_PROJ, P6_SYNC_LN_PROJ, and P6_SYNC_ER_PROJ.

  • Master data are: P6_SYNC_HD_MST, P6_SYNC_LN_MST, and P6_SYNC_ER_MST.

  • Timesheet data are: P6_SYNC_HD_TIME and P6_SYNC_ER_TIME.

You will have to create the archive and history table if you choose to use the Data Archive Manager.