OSCAR - OSC Activity Report

Office of the State Controller
   Robert L. Powell, State Controller
Autumn Quarter 2006

BEACON progresses on schedule, on budget

North Carolina 's efforts to modernize and standardize its key business processes took a step forward in October when the BEACON HR/Payroll project's steering committee finalized the deployment schedule and scope for the State's new business software solution. The steering committee's approval comes as the project team strives to complete the blueprint phase of the project by Dec. 22.

Finalizing the blueprinting, scope and roll-out schedule keeps the project on track and within budget projections to be fully implemented in 2008. The HR/Payroll project will provide not only a centralized common computer system for handling personnel and payroll services, but also will standardize many of the business practices across state agencies and institutions.

The first deployment will take place in January 2008 with the following agencies:

•  Department of Administration/Lt. Governor's Office; Department of Correction; Department of Transportation; Information Technology Services; Governor's Office/Office of State Budget & Management; Office of State Controller; Department of Revenue; and Office of State Personnel.

The second deployment will occur in April 2008 with the following agencies:

•  Administrative Office of the Courts; Department of Agriculture; Department of Commerce; Department of Crime Control & Public Safety; Department of Cultural Resources; Department of Environment & Natural Resources; Department of Insurance; Department of Justice; Department of Juvenile Justice; Department of Labor; Department of Public Instruction; Office of Secretary of State; Department of State Treasurer; Department of Health & Human Services; Employment Security Commission; General Assembly/Fiscal Research; NC Education Lottery Commission; NC Housing Finance; NC Community College System; Office of Administrative Hearings; Office of State Auditor; State Board of Elections; State Health Plan; and Wildlife Resources Commission.

Following is an outline and overview of the HR/Payroll functions that the new system will be built around as the project moves into the realization phase early next year:

Personnel Administration

Within Personnel Administration, capabilities include the creation of a combined repository for employee master data maintenance and reporting, a standardized process for employee life-cycle events, a unique employee identifier, and a streamlined process for validating HR/payroll data elements.

Organizational Management

The Organizational Management function provides organizational diagrams that aid in creating reports and identifying security issues, assists in maintaining consistency in state positions and supports internal workflow processes.

Time Management

The Time Management function of the system will feature Cross Application Timesheets (CATS) for bi-weekly, monthly and DOT payrolls; positive and negative time capture capability; and the ability to interface with agency-specific time capture systems.

Benefits Administration

The Benefits Administration function offers centralized maintenance of statewide benefit plans, including the State Health Plan, NC Flex, retirement savings and others. Annual employee enrollment and event processing for employee life-cycle events will also be supported through the Benefits Administration function.

Payroll

The new Payroll function will create a single centralized payroll service and allow for monthly and bi-weekly pay cycles and retroactive payroll accounting.

SAP Portal

Through the SAP Portal, employees across the State will be able to update personal data, including banking information, addresses, and number of dependents. They will also be able to view and print electronic W-2 forms and payroll remittances. Their managers will have the added capability of being able to view key employee information as well.

Finance/Controls

The organizational setup function within Finance/Controls will allow for integration with the existing NCAS system and offer support for future SAP financials implementation.

Reporting

Standard SAP reports and Business Intelligence will be used to support statewide reporting requirements. Ad hoc reporting and use of Crystal reports provide additional reporting capabilities. Integration with SAP and legacy systems, as well as with third-party tools such as Microsoft Excel and Word will also be featured.

Additional functions are expected to be added in 2008-09, including Training and Events Management, and E-recruitment. Other functions that may be added after the initial rollout include Personnel Development, Personnel Cost Planning, Compensation Management, and Employee Health and Safety.

State ends year with positive fund balance, preliminary figures indicate

Preliminary figures indicate that North Carolina ended the 2005-06 fiscal year with a positive fund balance on a generally accepted accounting principles (GAAP) basis for the first time in five years. The preliminary balances, which have not yet been audited, are based in part on estimates by the Office of the State Controller and could change as OSC completes the Comprehensive Annual Financial Report for the State.

The positive fund balance, in part, is due to the improved economy and revenues for the fiscal year, as well as two significant accounting changes affecting individual income taxes. One change, which is used by 11 other states, adjusted the availability period to recognize revenue. The other changed the method used to estimate tax refunds payable and deferred revenue. The accounting changes represent roughly half of the fund balance.

State officials hope the return of a positive fund balance will lead to the full restoration of North Carolina's AAA bond rating. The bond rating firm Moody's lowered the State's rating slightly as it struggled with budget shortfalls over the last five years, while other rating agencies continued to rate North Carolina at the highest level.

The financial statements will be presented to the bond rating agencies in New York later this year.

SEANC delegates learn of payroll/HR project benefits for employees

BEACON has started expanding its outreach to move awareness of the payroll/human resources project beyond agency business offices and senior managers.

Staff from the Office of the State Controller and the BEACON communication team set up an information booth in early September at the annual convention of the State Employees Association of North Carolina in Greensboro. The group, which represents more than 55,000 state employees, provided the booth space at no cost.

The communication team handed out information on the payroll/human resources project, and brochures outlining the benefits to rank-and-file state employees once the new integrated system goes live in 2008. Those benefits include on-line access to pay stubs and other payroll information, as well as the ability to update benefit information quickly and efficiently on-line.

BEACON staff also have started meeting with communication contacts in state agencies as the blueprinting process continues for the system. Those contacts will be instrumental in keeping state employees informed about the system and how it will work once blueprinting is completed.

Controller's Message: Standards clarification, hard work help balance

For the first time in four years it looks like the Comprehensive Annual Financial Report (CAFR) for North Carolina will reflect a positive fund balance. This is a major milestone given the severe nature of the fiscal problems thaState Controller Robert Powellt have plagued not just North Carolina but the entire nation.

As you all know, elected officials had teamed with state government leadership to make the necessary adjustments in our operations to insure a balanced budget while working toward restoring the reserves depleted during the shortfall years. This has contributed much of the positive reserve that will be reflected upon final audit.

But I want to take a moment of personal privilege to compliment my staff and the staff at the Department of Revenue (DOR) for the outstanding effort put forth in the review and improvement of methods to report individual income tax revenues.

For years OSC and DOR have recognized accrued liabilities in the CAFR for overpayments of individual income taxes, but due to Government Accounting Standards Board (GASB) restrictions have been less able to accrue revenue for underpayments of individual income taxes. With the practice of other states as examples, OSC in collaboration with DOR has been able to revisit the accrued revenue issue and analyze the varying components of the past methodology while incorporating recent GASB standards into the assessment.

Not to go into great detail, but this activity was conducted over the course of a year with input from all fiscal players in the CAFR development process. It was tedious, laborious, sometimes contentious, but always conducted with a spirit of identifying the correct GASB interpretation for our CAFR.

The result of this effort is a more comprehensive reflection of our overall fiscal status and, at least for this year, a stronger representation of the State's bottom line. More importantly, it establishes the methodology that will be in place for years to come consistent with GASB standards and the high fiscal standards established by the financial managers in North Carolina.

I want to express my appreciation to the OSC and DOR staffs, which have spent countless hours working on this effort. I feel extremely good about the results and I am proud of the way they have conducted the analysis.

David Reavis, OSC E-Commerce OperationsMost agencies meet security rules for new credit card contract

The three-month transition period for agencies to migrate to the new merchant card services contract with SunTrust Merchant Services ended October 31, which was the expiration date of the old contract. The transition allowed participants to begin taking advantage of the enhanced pricing structure. The primary "per transaction" fee under the old contract was $.108, while the new per transaction fee is now $.04, representing a 63% decrease.  This is a significant savings to the State, as during FY 2005-2006 there were 3.6 million merchant card transactions, totaling $435 million.

With many of the participants waiting until the last minute to complete the transition process, the staffs of the Statewide E-Commerce Program and the Support Services Center had to devote extra effort during the latter part of October to ensure that agencies did not experience any uninterrupted operations.  The last-minute activity was due primarily to the agencies vigorously working toward the deadline to become compliant with the PCI Data Security Standard for protecting cardholder information. 

A goal had been established for all agencies to be compliant by the time they transitioned to the new contract. A total of 82 participants were transitioned to the new contract, with the participants being comprised of 20 state agencies, 15 universities, 23 community colleges, and 24 local units of government. 

Although all merchant accounts are required to be PCI compliant, any merchant account that "transmits, stores, accesses, or processes" cardholder information via a publicly available Internet address has to adhere to additional mandates. These merchant accounts must also complete an annual self-assessment questionnaire and have their networks scanned for potential vulnerabilities that may result in a breach of sensitive cardholder information.  Merchants have been working to achieve that compliance level since July 2005. As of October 31, about 82% of these accounts were deemed to be compliant with the PCI data security requirements.  The remaining 18% are continuing with their compliance efforts.



OSC task force developing better internal controls

The Office of the State Controller has formed a statewide task force to help develop a more structured internal control framework for North Carolina 's accounting processes.

The Statewide Internal Control Task Force consists of representatives from a number of state agencies and groups, including those with central management authority and oversight. Its mission is to help OSC fulfill its statutory obligations to develop and implement a strong internal control program and improve overall fiscal management.

Creation of the task force and increased scrutiny of internal control compliance by OSC grew out of recent corporate and accounting scandals in the private sector. Congress responded to these scandals with sweeping reform legislation, referred to as the Sarbanes-Oxley Act of 2002. Section 404 of this Act requires management to assess and make representations about the effectiveness of their organization's internal control structure.

Although the Sarbanes-Oxley legislation applies to private sector, similar efforts are now occurring in the public sector. As a result of the passage of the Sarbanes-Oxley Act of 2002, the requirements of the Office of Management and Budget's (OMB) Circular A-123, which defines management's responsibility for internal control in federal agencies, were re-examined resulting in stricter standards.

In North Carolina, the Office of the State Controller is statutorily responsible for establishing internal control standards that define the minimum level of quality acceptable for internal control systems. In response to the recent efforts related to internal controls occurring in the private sector and at the federal level, OSC proposed in 2004 a new statewide initiative to proactively monitor compliance with prescribed internal control policies.

This effort, endorsed by the Governor and the General Assembly, includes agency reviews that assist management with assessing their risk tolerance through the identification of existing or potential internal control weaknesses within their operations. The reviews are also intended to provide an educational opportunity for raising awareness across state government of the vital importance of appropriate internal controls and to educate entity personnel on internal control best practices.

The task force, which began meeting in October, includes chairman Ben McLawhorn, OSC's risk mitigation services manager; as well as Mark Newsome and Eve-Simone Pastor, OSC's risk mitigation analysts; and Assistant State Controller Wesley Ray; Chief Financial Officer Rex A. Whaley of the Administrative Office of the Courts; State Purchasing Officer Mike Mangum of the Department of Administration; Internal Audit Director Vickie Haddock of the Department of Correction; Internal Audit Director Eddie Berryman of the Department of Health and Human Service; Internal Audit Director Joseph M. Hensgen of the Department of Revenue; Pam Wortham , the Deputy Treasurer for Financial Operations in the State Treasurer's Office; Director of External Audit Bruce Dillard of the Department of Transportation; Systems Accountant Kimberly L. Van Metre of the North Carolina Community College System; Management Engineer Kay Radford of the Office of State Budget and Management; Chief IT Procurement Officer Patricia Bowers of the Office of Information Technology Services; HR Managing Partner for Operations Carl Goodwin of the Office of State Personnel; Financial Controls Manager Stan Koziol of the University of North Carolina at Chapel Hill; Wesley Taylor, Financial Services Manager for the General Assembly; and Associate Vice President for Finance George Burnette of the University of North Carolina General Administration. Audit Manager Lee Linker of the Office of the State Auditor will serve as an advisory member.

Total information technology spending up by $46 million in 2005-06

Total spending on information technology by North Carolina state government increased by $46 million in the fiscal year ending June 30, 2006, when compared to the previous year, according to the latest Information Technology Expenditures Report produced by the Office of the State Controller.

Total IT expenditures, excluding the Office of Information Technology Services, were $940,796,365 in the 2005-06 fiscal year, according to the report. That is an increase of $46 million, or 5.1 percent, over the previous year. For the Office of Information Technology Services, total expenditures were $130,637,426, a decrease of $4.2 million, or 3.15 percent over the previous year.

Total IT expenditures include not only hardware and software, but also budgeted salaries and expenditures for IT-related employees. Those salary and benefit costs continue to be the largest piece of IT costs, accounting for 35 percent of total expenditures.

The latest report uses management tools that capture more detailed project and system financial costs. The comprehensive data, used for the first time in the new report, accounts for more than two-thirds of all reported IT expenditures. That's more than twice the specific project and system data included in the 2004-05 report, due mainly to the new management tools.

The full report is available on the OSC web site at: http://www.ncosc.net/financial/ITReport_06302006.pdf .

OSC SECC

 

OSC begins annual drive for

State Employees Combined Campaign

State Controller Robert Powell, in blue shirt, kicked off the annual State Employees Combined Campaign drive for OSC in October with a potluck dinner for the staff.

The dinner started a weeklong campaign blitz at OSC, including daily contests and prizes for those pledging to charity for the coming year.

The combined campaign allows employees to donate to their favorite charities through payroll deduction.

Powell is state chairman for the SECC drive this year.

 

 

 

Fiscal Officer Update Seminar set for December 14

The Office of the State Controller will host its annual Fiscal Officer Update Seminar on December 14 for chief financial officers and their representatives. The seminar will update fiscal officers of state agencies and institutions on current central management issues.

The daylong seminar at the McKimmon Center , which carries eight hours of CPE credit, will include sessions on the North Carolina Education Lottery, the State's retiree health care obligations and optional breakout sessions on cash management, and professional ethics and conduct. The ethics session meets the ethics CPE requirement for the State CPA Board, and the cash management update will include a working session on the development of agency/university cash management plans and a discussion of statewide cash management policies. Please indicate on your online registration if you would like to attend either breakout session.

Other subjects include updates on the General Fund, the State's bond rating, the Office of State Budget and Management, economic and budget issues, the Legislature, BEACON, e-commerce and payment card industry security.

Speakers include State Controller Robert Powell; Chief Deputy Gwen Canady; OSC staff; Deputy State Treasurer Vance Holloman; State Budget Director David McCoy; David Crotts and Lynn Muchmore of the Legislature's Fiscal Research Division; Lottery Director Tom Shaheen; Richard Ward of Aon Consulting; Tim Kennedy, CPA; and a representative of the Board of Ethics.

The registration fee for the conference is $50, which includes all course materials and lunch. Due to classroom size, the seminar will be limited to 295 participants.

Attendees must register online at the OSC web site: http://www.ncosc.net . A conference brochure will be available for download at the same site. The registration deadline is Monday, December 4. Payment can be made by check or electronic transfer.

Executive Budget Act rewrite brings changes to OSC operations

A rewrite of the Executive Budget Act approved by the General Assembly this year will result in some significant changes in how the Office of the State Controller does business, according to an analysis by OSC's Statewide Accounting Division. The changes are scheduled to take effect in 2007.

Major changes, or potential changes, as outlined by SAD include:

  • The State Controller will determine unreserved fund balance effective June 30 as defined by one section of the law. The terms used to define unreserved fund balance must be delineated. Also, a process must be developed to determine this balance and, as required by this section, to cause the beginning unreserved fund balance to equal the ending unreserved fund balance from the prior fiscal year. Unreserved fund balance is important as it is a term used to describe when a budget balances (§ 143C-4-1); how much to reserve to the Savings Reserve Account (§ 143C-4-2) and the Repairs and Renovations Reserve Account (§ 143C-4-3); and to describe methods to avoid a deficit (§ 143C-6-2).
  • OSC must update the fund study completed for implementation of GASB 34 and work with the Office of State Budget and Management and state agencies to revise fund type designations accordingly. New law defines fund types based on GAAP and requires the Controller to account for state resources through the use of those fund types. New law also gives the Controller the responsibility of determining the appropriate fund type designation of state resources when there is a conflict between legal and accounting designation. Furthermore, new law (Article 3) provides that the accounting classifications adopted by the State Controller shall be used in the development of the Governor's recommended budget. Furthermore, new law should cause the alignment of fund types included in the State Budget Manual with those in the NCAS Chart of Accounts.
  • Significant change may be necessary if (1) current numbering convention continues (the first digit of the center number ordinarily corresponds to the first digit of the budget code fund type) and (2) significant changes to fund type designations are made. New law provides that purpose or programs outlined in a recommended or enacted budget will be in accordance with the Budget Code Structure of NCAS Uniform Chart of Accounts as prescribed by Office of the State Controller.
  • State Controller will continue to transfer funds to the Savings Reserve Account (Rainy Day Fund); however, some change is necessary. The calculation of the transfer by the State Controller will be based on different criteria and a different target amount. The circumstances under which the Reserve is available also is different. New law provides that the annual transfer is based on unreserved fund balance as determined on a cash basis, and the reserve target is equal to or greater than 8% of the prior year's General Fund operating budget. Current law provides that the annual transfer is based on unreserved credit balance and that the reserve shall not exceed a 5% cap of the amount appropriated the preceding year for the General Fund operating budget, including local government tax-sharing funds, that were directly appropriated. Regarding availability, current law states that the Director may not use Reserve funds unless the use has been approved by an act of the General Assembly; whereas, new law provides Reserve funds are available only upon an act of appropriation by the General Assembly.

 

For a printer-friendly PDF version of the OSCAR, click here.


OSCAR, The OSC Activity Report, is published quarterly by the North Carolina Office of the State Controller
1410 Mail Service Center; Raleigh, NC 27699-1410