Skip to content
Printer-friendly version

Data Fields for Quarterly Section 1512 Reporting


The information below reflects quarterly requirements as they existed in November 2010. It is possible that additional guidance regarding reporting will become available or that the data requirements described below will change for future reporting periods. This information will be updated if necessary.

After submitting general information, separate reports must be submitted for each ARRA grant received. If there are multiple grants listed, please provide information for one grant, then return to the first menu to provide information for the second grant, and so on.

Once a grant award has been fully expended, subrecipients will no longer be required to complete the Section 1512 reporting. Grant information, as submitted for the final Section 1512 report, will be accessible through the menu page. To make changes to the final Section 1512 report after the end of the reporting period, contact the CDE via e-mail at ARRA@cde.ca.gov.

General Information

D-U-N-S Number

A D-U-N-S Number is a unique nine-digit identification number provided by Dun & Bradstreet. D-U-N-S Numbers may be obtained via the Dun & Bradstreet Web Form page (Outside Source) or by phone at (866) 705-5711. D-U-N-S Numbers requested through the Web can be created within one business day. The following information will be needed to apply for a D-U-N-S Number:

The SIC code identifies the primary industrial classification of an entity. SIC codes may be obtained via the U.S. Department of Labor, Occupational Safety and Health Administration Web site (Outside Source). In general, entities receiving ARRA funding through the California Department of Education (CDE) will be categorized in one of three SIC codes:

Centralized Contractor Registration (CCR) (Updated May 17, 2010)

The Centralized Contractor Registration (CCR) is the primary contractor database for the federal government. Subrecipients that are not currently registered must do so at the CCR Web page (Outside Source). Subrecipients that are not registered or in the process of registering in the CCR will not be able to enter grant award information in the ARRA Reporting and Data Collection System. The CCR registration process can take several weeks. The following information will be needed to register in CCR:

Reminder: Registration in CCR is required annually. Subrecipients are required to keep their registration in CCR current by renewing it as necessary.

(back to top)

Location (Updated February 23, 2010)

Subrecipients must identify their Congressional, State Senate, and State Assembly electoral districts. Each of these fields should be a two-digit number. The challenge is in situations where a subrecipient's territory is split among two or more electoral districts. For local educational agencies, choose the one electoral district in which the central office is located. For charter schools, use the electoral district where the school is located.

To determine the electoral district, use the following links:

Officers

Subrecipients must provide "names and compensation of each of the five most highly compensated officers of the subrecipient for the calendar year in which the award is awarded if (i) In the subrecipient's preceding fiscal year, the subrecipient received (A) 80 percent or more of its annual gross revenues from federal contracts (and subcontracts), loans, grants (and subgrants) and cooperative agreements; and (B) $25 million or more in annual gross revenues from federal contracts (and subcontracts), loans, grants (and subgrants) and cooperative agreements; and (ii) The public does not have access to information about the compensation of the senior executives through periodic reports filed under section 13(a) or 15(d) of the Securities Exchange Act of 1934 (15 U.S.C. 78m(a), 78o(d)) or section 6104 of the Internal Revenue Code of 1986" (see the Office of Management and Budget [OMB] guidance cited at the end of this document).

The first data field in this group asks whether or not the subrecipient is subject to this reporting requirement. Choose Yes if it applies and No if it does not. If applicable, provide the names and compensation of the five most highly compensated individuals.

Very few, if any, of the subrecipients of ARRA funds that the CDE manages will be subject to this reporting requirement.

(back to top)

Grant Information

Contact (Updated May 17, 2010)

Please provide contact information for the person who completed the data input and can answer questions regarding the data submitted.

Jobs Created or Retained (Updated September 1, 2010)

Creating and retaining jobs is the core purpose of ARRA. It is important that jobs data be reported completely and accurately. There are several preliminary points:

Calculating the number of jobs created/retained. The revised federal OMB guidance contains two separate methodologies for calculating jobs created or retained, the definite term methodology and the general methodology. The definite term methodology should be used when the subrecipient planned to pay for a position for a "definite term" (for LEAs, the definite term will most likely be the school year). The general methodology should be used when the subrecipient had not decided or was unable to determine the impact of its ARRA funds in advance. Both methodologies are described below.

Definite Term Methodology. The definite term methodology will apply to any subrecipient who can determine the impact of its ARRA funds at or near the beginning of a definite term. These funds may be spent at the beginning of the term or spent throughout the term. This methodology can also be used by subrecipients that are awarded their funds after the “definite term” has begun so long as they can accurately calculate the impact of these funds over the course of the definite term.

Subrecipients who spent all of their ARRA funds prior to October 1, 2009, should use this methodology if the funds were spent in the current definite term. For instance, if the subrecipient’s definite term is the 2009–10 school year and all of its funds were spent in August and September; the subrecipient should apply the definite term methodology to determine the job impact and report this impact over the remainder of the school year.

General Methodology. The general methodology will apply to any subrecipient that uses its ARRA funds on an as-needed-basis throughout the school year. Since the use of the funds is decided as the year progresses and there is no way to determine the job impact in advance, the subrecipient will report only on the jobs funded in that quarter.

The federal OMB issued updated guidance on December 18, 2009, that contains several pages of information on how to calculate jobs created/retained and includes examples. Please see the citation at the end of this document.

Summer School and Other More-Than-Full-Time Employment. Hours worked in addition to employees’ full-time schedule should be calculated into FTEs separately and then added to the regular full-time FTE for the quarter. This may result in more than 1 FTE being reported for an employee  For example, if a teacher worked in a summer school program funded by ARRA funds and the number of hours worked was equivalent to 0.5 FTE for the quarter, and the same teacher also worked a full-time regular schedule for the quarter, then the teacher would be reported as 1.5 FTE for the quarter.

Vendor/Sub-grantee Jobs. Subrecipients are required to generate estimates of job impact by directly collecting specific data from vendors and sub-grantees on the total FTEs resulting from a sub-award or vendor contract. To facilitate the gathering of jobs information, subrecipients should consider including a clause in its vendor contracts requiring the vendor to report ARRA related jobs to the subrecipient. To assist subrecipients with tracking the vendor and sub-grantee jobs, we have developed the Sample Vendor/Sub-grantee Jobs Tracking Form (DOC). (Use of this form is optional.)

Vendor and sub-grantee jobs are calculated in the same manner in which subrecipient jobs are calculated. In order to perform the calculation, a vendor or sub-grantee will need the total number of hours worked by employees in the most recent quarter (the quarter being reported) in jobs that meet the definition of a job created or a job retained as defined above. The vendor or sub-grantee will also need the number of hours in a full-time schedule for the quarter. For instance, if a full-time schedule is 2,080 hours/year, the number of hours in a full-time schedule for a quarter is 520 (2,080 hours/4 quarters = 520). The number of jobs to report is calculated using the following formula:  

Total Number of Hours Worked and Funded by ARRA within Reporting Quarter
Quarterly Hours in a Full-time Schedule

Corrections to Jobs Data. Jobs that were created or saved in prior quarters and paid for with funds in the current quarter should not be reported in the current quarter. The Office of Management and Budget (OMB) is developing a process by which changes and corrections can be made to prior quarters’ reports. Subrecipients should keep a record of any changes that need to be made to jobs numbers and any corrections that need to be made to any other areas of prior quarters’ reports so that the changes can be reported once the details of the process are released by OMB.

(back to top)

ARRA Funds Expended or Obligated (Updated February 23, 2010)

Subrecipients must report ARRA funds expended or obligated for the reporting period.

For the annual report required by Section 14008 of ARRA, and possibly for later quarterly reports, please note that details regarding the types of expenditures/obligations will be required.

Vendors (Updated May 17, 2010)

Subrecipients must report the D-U-N-S number or the name and location (zip+4) of any vendor that has been paid more than $25,000 in ARRA funds during the quarter (note: vendor jobs should be reported irrespective of the total contract amount). According to the federal OMB, a vendor: "(1) Provides the goods and services within normal business operations; (2) Provides similar goods or services to many different purchasers; (3) Operates in a competitive environment. (4) Provides goods or services that are ancillary to the operation of the federal program and (5) Is not subject to compliance requirements of the federal program" (see OMB Implementing Guidance at the end of this document).

A vendor does not include a sub-grantee that provides the services supported by the grant. For example, a SELPA payment to constituent school district or to a nonpublic school for special education services would be considered a payment to a sub-grantee and not a payment to a vendor.

The award number field is optional and may be used by subrecipients for internal tracking purposes.

(back to top)

Infrastructure (Revised October 30, 2009)

Subrecipients must provide information regarding infrastructure expenditures from ARRA funds. The U.S. Department of Education (ED) issued a "tip sheet" that defines infrastructure as follows: "An infrastructure investment is financial support for a physical asset or structure needed for the operation of a larger enterprise. Therefore, infrastructure investments include support for tangible assets or structures such as roads, public buildings (including schools), mass transit systems, water and sewage systems, communication and utility systems and other assets or structures that provide a reliable flow of products and services essential to the defense and economic security of the United States, the smooth functioning of government at all levels, and society as a whole." (See citation at the end of this document.)

Subrecipients will be required to provide the amount of infrastructure spending, identify the purpose, and explain the rationale for funding infrastructure with ARRA funds. The rationale should include how the infrastructure investment will contribute to one or more of the purposes of ARRA: preserve and create jobs and promote economic recovery; assist those most impacted by the recession; spur technological advances; provide long-term economic benefits; and stabilize state and local governments.

ARRA Section 1511 Infrastructure Certification. Several ARRA grants—State Fiscal Stabilization Fund (SFSF), Individuals with Disabilities Education Act (IDEA), and Child Care and Development Fund (CCDF), Quality Renovation and Repair—allow expenditures for infrastructure. All infrastructure investments using ARRA funds require a certification that the project has received the full review and vetting required by law and that the investment is an appropriate use of taxpayer dollars. Infrastructure investments using IDEA funds are subject to additional requirements beyond Section 1511. For information on the certification process for SFSF and CCDF grants, please refer to our SFSF Web page. For information on the certification process for IDEA, see our IDEA ARRA Web page.

Education Jobs Fund (Added November 26, 2010)

Subrecipients are required to provide information on the use of the Education Jobs funds. Please check all the boxes that correspond to the manner in which the funds are being used. Subrecipients that check the "other" box are asked to provide a brief description (100 characters or less) of how the funds are being expended.

Education Jobs funds must only be used for compensation and benefits and other expenses, such as support services, necessary to retain existing employees, to recall or rehire former employees, and to hire new employees, in order to provide early childhood, elementary, or secondary educational and related services. For purposes of this program, compensation and benefits and support services includes, salaries, performance bonuses, health insurance, retirement benefits, incentives for early retirement, pension fund contributions, tuition reimbursement, student loan repayment assistance, transportation subsidies, and reimbursement for childcare expenses.

Other Resources (Updated November 26, 2010)

(back to top)

Questions: Government Affairs Branch | ARRA@cde.ca.gov | 916-319-0821