Archiving Data for Global Payroll for the United Kingdom
Global Payroll for the UK generates a large amount of result data. To keep the amount of saved data manageable, you should periodically archive it. PeopleSoft PeopleTools delivers an archiving tool called the Data Archive Manager. To aid you in archiving your result data using the Data Archive Manager, Global Payroll for the UK delivers a predefined archive object (GPGB_RSLT_ARCHIVE) and an archive template (GPGBRSLT). The delivered archive template uses queries that select data by calendar group ID (CAL_RUN_ID field).
Note: Please use extreme caution when making changes to delivered archive objects, queries, or templates. Any modifications can result in the loss of important data.
Additional Archiving Considerations
The following Global Payroll for the UK result data is not included in the GPGB_RSLT_ARCHIVE archive object:
|
Result Data Type |
Data Location |
|---|---|
|
Loan Results |
GPGB_LOAN_WA writable array |
The archiving framework delivered with Global Payroll is based on calendar group ID. However, the loan repayment period is variable and can extend across more than one tax year. Loans results data are used by the Loan Review page to view loan history, which means that the data should be available while loans are still active. It is therefore not practical to automatically archive loan results based on the calendar group ID.
If you want to archive this data, you can set up new archive objects, queries, and templates using the Data Archive Manager, or you can use your own archiving solution.
See the product documentation for PeopleTools: Data Management
The following result data are included in the GPGB_RSLT_ARCHIVE archive object, but you should consider whether you want to archive this data:
|
Result Data Type |
Data Location |
|---|---|
|
P11D results |
GPGB_P11DRSLT_L table GPGB_P11DRSLT_M table GPGB_P11DRSLT_S table |
The P11D results data is generated by the P11D data extract tool and is normally loaded into a third-party P11D solution. If you don't want to archive this data, you can remove the tables from the GPGB_RSLT_ARCHIVE archive object.