Select EFA/EIA Funding Extract
Contents
Introduction
Each school must submit a Membership and Attendance Extract and Cumulative Class Extracts for the 45th and 135th days for state funding. During the school year they may run the SC02 Cumulative Class Report multiple times to create a 45 day or 135 day extract. They may run the SC06 Membership and Attendance Report multiple times to create a 45 day or 135 day extract.
The purpose of this function is to allow the schools to select which version of each of the following extracts should be used for submission to SCDE for state funding:
- 45 Day Membership and Attendance Extracts
- 135 Day Membership and Attendance Extracts
- 45 Day Cumulative Class Extracts
- 135 Day Cumulative Class Extracts
All of the Membership and Attendance extracts generated for the selected school year while processing the SC06 Membership and Attendance Report for All Students for Day 45 will be displayed in the 45 Day Membership and Attendance Extract section. The user will select one extract from this section to be used for state reporting.
All of the Membership and Attendance extracts generated for the selected school year while processing the SC06 Membership and Attendance Report for All Students for Day 135 will be displayed in the 135 Day Membership and Attendance Extract section. The user will select one extract from this section to be used for state reporting.
All of the Cumulative Class extracts generated for the selected school year while processing the SC02 Cumulative Class Report for Day 45 will be displayed in the 45 Day Cumulative Class Extract section. The user will select one extract from this section to be used for state reporting.
All of the Cumulative Class extracts generated for the selected school year while processing the SC02 Cumulative Class Report for Day 135 will be displayed in the 135 Day Cumulative Class Extract section. The user will select one extract from this section to be used for state reporting.
Selection Criteria
Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.
The Select EFA/EIA Funding Extract displays each extract that has been generated with the date and time it was created for the selected school year within the particular report section. The extracts are listed in ascending order.
The user selects one extract within each section.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
Membership and Attendance | This will show the extracts processed and the Date/Time Created for the:
|
Cumulative Class Extract | This will show the extracts processed and the Date/Time Created for the:
|
Select the extract for funding | Select the radio button beside the one extract within each section that is to be used for state funding. |
Report Output
No report is generated after clicking Submit. Internally the flags are set in the [SC_EFA_EIA_HEADER] table to identify which records will be used for state funding.
PowerSchool will update the SC_SubmitForStateFunding_Flag field in the [SC_EFA_EIA_HEADER] table for the selected extracts setting the SC_SubmitForStateFunding_Flag to “Y”. In addition, records for previously selected extracts will be updated so they are no longer marked as the selected extract by setting the SC_SubmitForStateFunding_Flag to “N”.