Tool Search: Programs Services Fact

The Programs Services Fact Template reports student's active records entered on the Community Services and Extended Learning (ELO) tabs.

Programs Services Fact Template Editor

Report Logic

Reports one record per active Community Schools (CSP) record that is active on the Snapshot Date selected on the extract editor.
Reports one record per active Extended Learning (ELO) record that is active on the Snapshot Date selected on the extract editor.
To report, students MUST be actively enrolled on the snapshot date selected in at least one calendar selected on the extract editor.
If a student has multiple active services, multiple services report.
Students are NOT included if
- their enrollment record is marked as State Exclude;
- their enrollment record is marked as No Show;
- their Grade Level of enrollment is marked as State Exclude; or
- their Calendar of enrollment is marked as State Exclude.

Report Editor

Field	Description
Submission Schedule	The Submission Schedule for which data is being submitted to the state.
Snapshot Date	The snapshot date of the collection. To report, the State Program must be active on the selected Snapshot Date.
Which Students would you like to include in the report?	Grade: Select a single grade or multiple grades (CTRL-click or SHIFT-click to select multiple). Ad Hoc Filter: Ad Hoc Filters allow you to limit report results to those included in the filter. This option is useful for troubleshooting.
Format	The format in which the report will generate. Options include State Format (CSV) and HTML.
Select Calendars	The calendar(s) from which data is pulled for the report.
Generate Extract Submit to Batch	The report can be marked to generate immediately using the Generate Extract button or can be marked to generate at a later time using the Submit to Batch button. See the Batch Queue article for additional guidance.

Report Layout

Element Name

Logic

Campus Database

Campus Location

DistrictCode

A three character district code.

District.number

District Information > State District Number

LocationCode

The Location Code selected on the Community Services or Extended Learning (ELO) state program of record.

FundedProgram.
locationCode

ExtendedLearning
Opportunity.location

Community Services > Community Services Detail > Location Code

Extended Learning (ELO) > Extended Learning Detail > Location Code

SchoolYearDate

The end year based on the year selected in the Campus toolbar.

Calendar.endYear

Calendar > End Year

StudentID

The state-assigned identifier for the student.

Person.stateID

Demographics > Student State ID

ServiceCode

The Service Provided or the Service Indicator.

FundedProgram.
serviceProvided

ExtendedLearning
Opportunity.indicator

Community Services > Community Services Detail > Service Provided

Extended Learning (ELO) > Extended Learning Detail > Service Indicator

ServiceStartDate

Reports based on the Submission Schedule selected on the extract editor AND the school year of the calendar/s being generated.

Submission Schedule	Reports	Example (2019-2020)
40D	YYYY-10-01	2019-10-01
80D	YYYY-12-15	2019-12-15
120D	YYYY-03-01	2020-03-01
EOY	YYYY-06-01	2020-06-01

N/A

Filler

N/A

ServiceFrequency

The number of days the student received the service.

FundedProgram.
daysAttended

elo.sessionsPerWk

Community Services > Community Services Detail > Sessions

Extended Learning (ELO) > Extended Learning Detail > Sessions

Filler

TN/A

N/A

Filler

N/A

Filler

N/A

Filler

N/A

Filler

N/A

Filler

N/A

Filler

N/A

ServiceSettingCode

Community Services Records Only

A description of when the service occurs.

ELO records report blank.

FundedProgram.
serviceSetting

Community Services > Community Services Detail > Service Setting

Filler

N/A

Filler

N/A

Filler

N/A

Filler

N/A

ProgramCode

Community Services records report CSP.

ELO records report the value selected in the Program Code field.

ExtendedLearningOpportunity.
programCode

Extended Learning (ELO) > Program Code

Programs Services Fact Template (New Mexico)

Report Logic

Report Editor

Report Layout

Related Articles