Oklahoma, www.OK.gov
Home

Skip Nav Skip to Search
Contact  |  Notifications  |  CORE Calendar

HCM


openbooks, oklahoma's finances online

Recovery/Stimulus Information


get adobe reader
Email   |   Print  

Data Archives - Financials


Archiving Schedule for PeopleSoft Financials

The chart below identifies the schedule for archiving PeopleSoft General Ledger, Payables, and Purchasing transactions. The following rules and considerations were incorporated into the archiving schedule:

  • GL data is archived by Fiscal Year - all transactions within a single fiscal year will be processed within the same archive request.
  • 3 full fiscal years of GL data will be retained in the production database. GL transactions from fiscal years 2003, 2004, and 2005 are currently eligible for archiving.
  • AP and PO are archived based on a specific Run Date – all transactions that meet the archiving criteria (i.e. closed POs, paid/posted/deleted vouchers) processed prior to the Run Date will be included within a single archive request.
  • AP and PO transactions will be processed in quarterly increments – due to the volume of data in these transaction table, the data will be archived based on fiscal quarters (not by fiscal year).
  • 39 months of payment information must be retained in the production database. Payables and Purchasing data will be archived simultaneously in order to simplify the archiving schedule. AP and PO transactions through Sept. 30, 2005 are currently eligible for archiving.
  • AP archiving has been delayed until the third quarter of 2009. Once the timeframe has been determined, the following table will be updated to include the AP archiving schedule.

 

Date Application Criteria Comments
4/5/2009 GL FY = 2003 Quarterly maintenance window
PO Through 12/31/2003
5/9/2009 GL FY = 2004 Semi-monthly maintenance window
PO Through 3/31/2004
5/23/2009 PO Through 6/30/2004 Semi-monthly maintenance window
6/13/2009 PO Through 9/30/2004 Semi-monthly maintenance window
8/8/2009 GL FY = 2005 Semi-monthly maintenance window
PO Through 12/31/2004
8/22/2009 PO Through 3/31/2005 Semi-monthly maintenance window
9/12/2009 PO Through 6/30/2005 Semi-monthly maintenance window
9/26/2006 PO Through 9/30/2005 Semi-monthly maintenance window
10/10/2009 PO Through 12/31/2005 Semi-monthly maintenance window
10/24/2009 PO Through 3/31/2006 Semi-monthly maintenance window
11/14/2009 GL FY = 2006 Quarterly maintenance window
PO Through 6/30/2006
1/9/2010 PO Through 9/30/2006 Quarterly maintenance window
4/10/2010 PO Through 12/31/2006 Quarterly maintenance window
7/10/2010 PO Through 3/31/2007 Quarterly maintenance window
10/9/2010 GL FY = 2007 Quarterly maintenance window
PO Through 6/30/2007