Future CAFR for Results Process Overview The following table provides an end-to-end overview of the future CAFR process at the State of Oklahoma. Table 4: To Be CAFR for Results End-to-End Process CAFR Stage Dates Input Tool Output Owner GAAP Packages 1st GAAP PeopleSoft input forms Agencies input Agencies Package due to accounting data created in to forms, July 30th, or Hyperion PSPB attached Excel, data and available for Word, which is 2nd GAAP as appropriate. agencies input saved in Essbase Package August 13th, and 3rd GAAP Package October 8th Combining August 30th PeopleSoft Cash basis data Basis” “Cash Balance (CTB) accounting data exported from data input into Comptroller from PeopleSoft to Essbase via “Actuals” ledger Hyperion PSPB Hyperion PSPB using Hyperion Financial Data Quality Management; Audited Agencies Audit Deadline Audited agency Collected using Agencies to Agencies (mostly November annual financial Hyperion PSPB forms, attached Component Units) 16th for reports in Excel, Forms. Excel, Word, Component Word, and PDF which save in Unit Financial Component Unit Essbase Statements Financial Statements Component Unit State generated using Financial Comptroller Hyperion Statements Financial Reporting Fund Statements Audit Deadline Data stored in Generated Fund November Essbase Hyperion Statements Comptroller – 16th for Fund Financial General Fund, Financials Reporting Proprietary Funds, and Fiduciary Funds Entity-Wide Audit Deadline Data stored in Hyperion Statements State Statements for December Essbase Financial stored in CAFR Comptroller 1st for Reporting repository Statements
Future CAFR for Results Process Overview The following table provides an end-to-end overview of the future CAFR process at the State of Oklahoma. Table 4: To Be CAFR for Results End-to-End Process CAFR Stage Dates Input Tool Output Owner GAAP Packages 1st GAAP Package due to July 30th, 2nd GAAP Package August 13th, and 3rd GAAP Package October 8th PeopleSoft accounting data or data as appropriate. input forms created in Hyperion PSPB and available for agencies input Agencies input to forms, attached Excel, Word, which is saved in Essbase Agencies Combining Balance (CTB) August 30th PeopleSoft accounting data from “Actuals” ledger Cash basis data exported from PeopleSoft to Hyperion PSPB using Hyperion Financial Data Quality Management; “Cash Basis” data input into Essbase via Hyperion PSPB Comptroller Audited Agencies (mostly Component Units) Audit Deadline November 16th for Component Unit Financial Statements Audited agency annual financial reports in Excel, Word, and PDF Collected using Hyperion PSPB Forms. Component Unit Financial Statements generated using Hyperion Financial Reporting Agencies to forms, attached Excel, Word, which save in Essbase Component Unit Financial Statements Agencies State Comptroller Fund Statements Audit Deadline November 16th for Fund Financials Data stored in Essbase Generated Hyperion Financial Reporting Fund Statements – General Fund, Proprietary Funds, and Fiduciary Funds Comptroller Entity-Wide Statements Audit Deadline for December 1st for Statements Data stored in Essbase Hyperion Financial Reporting Statements stored in CAFR repository State Comptroller
Solicitation0900000751AttachmentA.docx