Programs Fact Services Extract
Introduction
This template tracks services received by students for the Community Schools Program (CSP), both Community Schools Act Programs as well as Title I funded Community Schools. It also tracks services received by students for the Extended Learning Time Program (ELTP).
The extract reports data based on which school the student was enrolled in on the date of the reporting period selected when the report is run.
Selection Criteria
Selection criteria determine which records are reported.
Program Fact Services Selection
The report selects Program Fact records from the [S_NM_ProgramServFact_C] table based on the following criteria:
The Program Fact Services record start date must occur on or before the date associated with the selected reporting period.
The Program Fact Services record end date must occur after the date associated with the selected reporting period.
Student Selection
The report selects student records from the [Students] or [ReEnrollments] table based on the following criteria:
The student must not be excluded from state reporting.
The student must be enrolled in a school included in the report.
The student is HSDA-flagged.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
Select Schools | Choose one of the following:
The All Schools option is only available when running the report from the District Office. |
Select Students | Choose one of the following:
|
Reporting Period | Choose a reporting period from the pop-up menu:
|
Report Output
Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.
Field# | Data Element | Description | [Table]FieldName | Notes |
1 | District Code | The PED-defined 3-digit district code. | [Students]State_StudentNumber | |
2 | Location Code | The PED-defined 3-digit location code. | [S_NM_STU_X]LocationCode [S_NM_REN_X]LocationCode [Schools]Alternate_School_Number [Schools]School_Number | The Location Code is reported based on what school the student was enrolled in (or the building the student was last enrolled in) as of the date associated with the selected reporting period. |
3 | School Year Date | The date associated with the school year. | Always [YYYY]-06-30 | |
4 | Student ID | The student’s state ID number. | [Students]State_StudentNumber | |
5 | Service Code | The code for the service provided for either the Community Schools Program (CSP) or the Extended Learning Time Program (ELTP) or Expanded and Enriched Learning Time and Opportunities (EELTO). If a student participated in all three programs during the reporting period, a minimum of 3 records would be submitted per student indicating the type of service received. In addition, a student may have received multiple services for a single program.
| [S_NM_STU_ProgramServFact_C] ServiceProvTypCde | The report translates the saved numeric value to the appropriate, state-specified value. The list of Service Code:
|
6 | Service Start Date | The start date of the service. Valid values:
| Derived from the reporting period. | |
7 | Not Collected | N/A | N/A | |
8 | Service Frequency | The number of days the student received Extended Learning Time within the reporting period. This should not exceed 10 days per student for the year. | 40D - [S_NM_STU_ProgramServFact_C] ServiceFreq 80D - [S_NM_STU_ProgramServFact_C] ServiceFreq80 120D - [S_NM_STU_ProgramServFact_C] ServiceFreq120 EOY - [S_NM_STU_ProgramServFact_C] ServiceFreqEOY | |
9 | Service Duration | The number of days the Community School service or Extended Learning Time was offered during the reporting period. This number should not exceed the number of days within the reporting period. | 40D - [S_NM_STU_ProgramServFact_C] ServiceFreq 80D - [S_NM_STU_ProgramServFact_C] ServiceFreq80 120D - [S_NM_STU_ProgramServFact_C] ServiceFreq120 EOY - [S_NM_STU_ProgramServFact_C] ServiceFreqEOY | |
10 | Not Collected | N/A | N/A | |
11 | Not Collected | N/A | N/A | |
12 | Service Provider Name | The name of the Community Service Provider Entity. Required if EELTO is selected in Field 21 - Program Code (old name Service Provider Type Code) | [S_NM_STU_ProgramServFact_C] ServiceProvName | If the Community Schools Act school is providing the service, this field remains blank because the school in the Location Code field is providing the service. If a Community Service Provider is providing the service, the name of the entity is reported instead of the individual's name. This field is blank for ELTP records. |
13 | Service Provider Type Code | The role of the individual who is providing the service for Expanded and Enriched Learning Time and Opportunities (EELTO). Valid Codes:
| [S_NM_STU_ProgramServFact_C]erviceProvCode | This field is blank if the Program Code (field 21) is NOT EELTO. |
14 | Not Collected | N/A | N/A | |
15 | Not Collected | N/A | N/A | |
16 | Service Setting Code | A description of when the service occurs. Valid Values:
| [S_NM_STU_ProgramServFact_C] ServiceSetCd | The report translates the saved numeric value to the appropriate, state-specified value. This field is blank for ELTP records. |
17 | Not Collected | N/A | N/A | |
18 | Not Collected | N/A | N/A | |
19 | Not Collected | N/A | N/A | |
20 | Not Collected | N/A | N/A | |
21 | Program Code | The Program Code associated with the Service Code (field #5). The same Service Code may be used for different programs. Valid Values:
| [S_NM_STU_ProgramServFact_C] ServiceProvdrName |