request gfcbuild.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.

The gfcbuild script is a generic scripts that will build record defined in PeopleSoft as partitioned tables.  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.

Please note that the script is only available on a consultancy basis.  Updates are available to existing Go-Faster customers.

latest updates:
22.6.2005 - cloned from GPBUILD.sql
25.7.2006 - applied GPBUILD corrections, and remove chartfield fudge
5.12.2006 - added handling for hash-partitioned only tables
13.12.2006 - remove partitioning column check
6. 9.2007 - enhancement for PeopleTools 8.48, and support for partitioned function based indexes
8.11.2007 - support for range-list composite partitioning
14.2.2008 - selective list partition -v- range build, drop purge, all keys on subrecords

© Go-Faster Consultancy Ltd. 2008