Report 2012-121.2 Data Reliability Assessments
Description of Data | Agency Purpose of Data |
---|---|
The Department of Parks and Recreation's (department) data as maintained in the California State Controller's Office California Leave Accounting System (leave accounting system) |
To perform a variety of functions necessary to accurately track leave system eligibility, state service credits, and leave benefit activity. Magnitude of DataFor the period from July 2009 through March 2013, the leave accounting system contained nearly 1.1 million leave benefit transactions for the department's employees. |
Purpose of Testing | Data Reliability Determination |
For the period from July 2009 through March 2013, determine the total number and dollar amount of potential leave buyback transactions by fiscal year. |
Not Sufficiently Reliable—We performed data-set verification procedures and electronic testing of key data elements and found no significant issues. We did not perform accuracy and completeness testing of the leave accounting data because the department miscoded some of its leave transactions as though the employee was using leave when the employee was actually receiving a payment in exchange for the leave. Further, the department's internal audit report confirmed the miscoding of leave transactions from as early as 2007. As a result, we determined that additional testing of this data was not warranted. |
Corrective Action Recommended | Status of Corrective Action |
We did not recommend corrective action. | N/A |
Description of Data | Agency Purpose of Data |
The Department of Parks and Recreation's data as maintained in the California State Controller's Office (state controller) Position Roster File |
The Position Roster File is a file of authorized positions used by departments to track positions. Magnitude of DataThe Position Roster File contained data specific to nearly 3,900 positions at the department during the period between July 2009 and March 2013. |
Purpose of Testing | Data Reliability Determination |
For the March 2013 pay period, identify all positions for which the full-time equivalent units paid were less than the full-time equivalent units authorized. For the period from July 2009 through March 2013, identify all vacant positions and determine the length of time they remained vacant. For the period from July 2009 through March 2013, identify all instances in which a position was vacant for six or more consecutive months. |
Not Sufficiently Reliable—We performed data-set verification procedures and electronic testing of key data elements and found no significant issues. We were unable to verify the accuracy and completeness of the position roster data because the state controller erroneously destroyed its hard-copy source documents. Specifically, as of fiscal year 2012-13, the state controller's record retention schedule required it to retain the hard-copy documents that support changes to established positions occurring on or after July 1, 2009. However, the state controller prematurely destroyed the documents for the period from July 2009 through April 2010. |
Corrective Action Recommended | Status of Corrective Action |
We did not recommend corrective action. | N/A |
Description of Data | Agency Purpose of Data |
The Department of Parks and Recreation's data as maintained in the California State Controller's Office Uniform State Payroll System (payroll system) |
To process the State's payroll and personnel transaction documents. Magnitude of DataThe payroll system contained more than 26.7 million payroll and personnel transactions for the period between July 2009 and March 2013. |
Purpose of Testing | Data Reliability Determination |
For the period from July 2009 through March 2013, identify all instances in which the Department of Parks and Recreation changed an employee's position number but did not change his or her civil service class or exempt position title. |
Sufficiently Reliable—We performed data-set verification procedures and electronic testing of key data elements and found no significant issues. We relied on the completeness testing performed as part of the State's annual financial audit for payroll transactions between July 2009 and June 2012. Since the State's financial audit for fiscal year 2012-13 is still in progress, we cannot rely on this report to verify completeness for the period from July 2012 through March 2013. However, because we found the payroll data to be complete between July 2009 and June 2012, we have reasonable assurance that the payroll data for the period from July 2012 through March 2013 are also complete. We performed accuracy testing on a random sample of 29 payroll transactions by tracing key data elements to supporting documentation and found no errors. |
For the period from July 2009 through March 2013, determine the total number and dollar amount of potential leave buyback transactions by fiscal year. * A leave buyback occurs when eligible employees receive payment at their regular salary rate in exchange for certain leave benefits. |
Not Sufficiently Reliable—We performed data-set verification procedures and electronic testing of key data elements and found no significant issues. We relied on the completeness testing performed as part of the State's annual financial audit for payroll transactions between July 2009 and June 2012. Since the State's financial audit for fiscal year 2012-13 is still in progress, we cannot rely on this report to verify completeness for the period from July 2012 through March 2013. However, because we found the payroll data to be complete between July 2009 and June 2012, we have reasonable assurance that the payroll data for the period from July 2012 through March 2013 are also complete. We did not perform accuracy testing because the department miscoded some of the buyback transactions. |
Corrective Action Recommended | Status of Corrective Action |
We did not recommend corrective action. | N/A |