Matthew
CS/HR 9.0 provide an archive template
PeopleTools >> Data Archive Manager >> Data Archive Template Archive
ID: GPAURSLT
We have also partitioned some of our tables (including PS_GP_RSLT_ACUM)
to be CAL_RUN_ID based.
This improves performance by creating less fragmentation in the table.
Stuart
--
============================================
Stuart Kendall
PeopleSoft Team Lead
Enterprise Systems, IT Infrastructure
Division of Information
K Block (Building 3k)
The Australian National University
Canberra ACT 0200 Australia
T: +61 2 6125 6781
F: +61 2 6125 0449
M:
stuart.kendall@anu.edu.auW:
http://information.anu.edu.auCRICOS Provider #00120C
============================================