request gpbuild.sqlThe presentation Configuring Global Payroll for Optimal Performance recommends physically partitioning Global Payroll result tables to match the logical streaming, and converting working storage tables to Oracle Global Temporary tables. Application Designer cannot generate the DDL for partitioned tables. This script will generate scripts that will rebuild payroll result tables with partitioning.

This concept is explained in more detail in the document Configuring and Operating Streamed Processing in PeopleSoft Global Payroll, including a step-by-step guide on implementation.

latest updates:
7. 6.2004 - addition partitioned tables for GP_PMT_PREP and UK payslip
27. 9.2004 - suppress disabled index build, but force disabled index to drop
18.10.2004 - additional Swiss working storage tables

© Go-Faster Consultancy Ltd. 2006