Programs Services Fact Template (New Mexico)

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.

Screenshot of  Programs Services Fact Template Editor . 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

FieldDescription
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.   
FormatThe format in which the report will generate. Options include State Format (CSV) and HTML.
Select CalendarsThe 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 NameLogic

Campus Database

Campus Location

1DistrictCode

A three character district code.

District.number

District Information > State District Number
2LocationCodeThe 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

3SchoolYearDateThe end year based on the year selected in the Campus toolbar.Calendar.endYearCalendar > End Year
4StudentIDThe state-assigned identifier for the student.Person.stateIDDemographics > Student State ID
5ServiceCodeThe 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

6ServiceStartDate

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

Submission
Schedule
ReportsExample
(2019-2020)
40DYYYY-10-012019-10-01
80DYYYY-12-152019-12-15
120DYYYY-03-012020-03-01
EOYYYYY-06-012020-06-01
N/AN/A
7FillerN/AN/AN/A
8ServiceFrequencyThe 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

9Filler
TN/A

N/A


N/A


10FillerN/AN/AN/A
11FillerN/AN/AN/A
12Filler

N/A

N/A

N/A

13Filler
N/A
N/A
N/A
14FillerN/AN/AN/A
15FillerN/AN/AN/A
16ServiceSettingCode

Community Services Records Only

A description of when the service occurs.

ELO records report blank.

FundedProgram.
serviceSetting

Community Services > Community Services Detail > Service Setting

17FillerN/AN/AN/A
18FillerN/AN/AN/A
19FillerN/AN/AN/A
20FillerN/AN/AN/A
21ProgramCode

Community Services records report CSP.

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

ExtendedLearningOpportunity.
programCode

Extended Learning (ELO) > Program Code