Skip to main content
Skip table of contents

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.

Back to Top

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:

  • Current School Only – Includes all student records associated with the current school that meets selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list.

  • All Schools – Includes all student records on the PowerSchool server that meet selection criteria.



The All Schools option is only available when running the report from the District Office.



Select Students

Choose one of the following:

  • The Selected [x] Students Only – Run the report for students in the current selection.

  • All Students – Run the report for all students in the current school or district.

Reporting Period

Choose a reporting period from the pop-up menu:

  • 40D

  • 80D

  • 120D

  • EOY

  • Summer

Back to Top

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.

  • SERVICE CODES (field 5) for Community Schools Program (Field 21 = CSP)

    • CIVICLEADERSHIP

    • FAMILYLITERACY

    • FINEARTS

    • HEALTHWELLNESS

    • HIGHYIELDLEARNING

    • LANGUAGECULTURE

    • PERFORMINGARTS

    • SOCIALEMOTIONAL

    • SPORTS

    • YOUTHLEADERSHIP

    • WORKFORCE

  • SERVICE CODES (field 5) for Extended Learning Time Program (Field 21 = ELTP)

    • ACADEMICENRICHMENT

    • EXPERIENTIAL

  • SERVICE CODES (field 5) for Expanded and Enriched Learning Time and Opportunities (Field 21 = EELTO)

    • Use to report out of school time academic and enrichment activities for only ELTP After School.

    • CCR

    • CIVICLEADERSHIP

    • FAMILYLITERACY

    • FINEARTS

    • HEALTHWELLNESS

    • HIGHYIELDLEARNING

    • LANGUAGECULTURE

    • PERFORMINGARTS

    • SOCIALEMOTIONAL

    • SPORTS

    • STEM-STEAM

    • YOUTHLEADERSHIP

[S_NM_STU_ProgramServFact_C] ServiceProvTypCde

The report translates the saved numeric value to the appropriate, state-specified value.

The list of Service Code:

  • For CSP:

    • CCR

    • CIVICLEADERSHIP

    • COMMUNITY

    • COUNSELING

    • CREDITRECOVERY

    • DENTAL

    • DROPOUTPREVENTION

    • ECE

    • ELD

    • ENRICHMENT

    • FAMILYLITERACY

    • FINEARTS

    • HEALTH

    • HEALTHWELLNESS

    • HERITAGELANGINST

    • HIGHYIELDLEARNING

    • HOMEVISIT

    • LANGUAGECULTURE

    • MENTOR

    • PERFORMINGARTS

    • POSITIVESCHCULTURE

    • REMEDIAL

    • SOCIALEMOTIONAL

    • SOCIALWRK

    • SPORTS

    • STEM-STEAM

    • TUTOR

    • VISION-HEARING

    • WRAP-AROUND

    • YOUTHLEADERSHIP

    • WORKFORCE

  • For ELTP:

    • ACADEMICENRICHMENT

    • CCR

    • EXPERIENTIAL

    • CREDITRECOVERY

    • DROPOUTPREVENTION

    • ELD

    • HERITAGELANGINST

    • MENTOR

    • POSITIVESCHCULTURE

    • REMEDIAL

    • STEM-STEAM

  • For EELTO:

    • CCR

    • CIVICLEADERSHIP

    • FAMILYLITERACY

    • HEALTHWELLNESS

    • HIGHYIELDLEARNING

    • LANGUAGECULTURE

    • PERFORMINGARTS

    • SOCIALEMOTIONAL

    • SPORTS

    • STEM-STEAM

    • YOUTHLEADERSHIP

    • WORKFORCE

6

Service Start Date

The start date of the service.

Valid values:

  • YYYY-10-01 = 40D

  • YYYY-12-15 = 80D

  • YYYY-03-01 = 120D

  • YYYY-06-01 = EOY

  • YYYY-06-29 = Summer

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:

  • 01 = Community-Based Organization

  • 02 = Community Recruit

  • 03 = Educational Assistant

  • 04 = Faith-Based Organization

[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:

  • BEFORESCHOOL

  • AFTERSCHOOL

  • WEEKEND

  • SUMMER

  • YEARROUND

[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:

  • CSP - Community School Program

  • ELTP - Extended Learning Time Program

  • EELTO - Expanded and Enriched Learning Time and Opportunities

[S_NM_STU_ProgramServFact_C] ServiceProvdrName


Back to Top

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.