View Public Events Calendar
NM Public Education Department logo
stripes illustration

Program Services Fact Template

  1. Home
  2. Offices and Programs
  3. Information Technology
  4. STARS Information, Manuals, and Supporting Documents
  5. Groups and Programs Domain
  6. Program Services Fact Template

Target Table: PROGRAMS_SERVICES_FACT

Data Submission Schedule: 40 Day, 80 Day, 120 Day, End of Year (EOY)

Grain: One record per district / location / snapshot date / student / service

Load Sequences/Dependencies:

  1. Student Required

Template Description – 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).

School Year 2019-2020 Changes: 

  • This is a new template

File Name Format:  DDD_PROGRAMS_SERVICES_FACT_YYYYMMDDHHMM.fff
File Name Format Example:  001_PROGRAMS_SERVICES_FACT_201907071201.csv

Field Number Field Name Data Type, Required, Code Valid Values
1 District Code Char, Required, Key
2 Location Code Char, Required, Updateable
3 School Year Date Date, Required, Key
  • 2020-06-30 = SY19-20
4 Student ID Char, Required, Key Enter 9 digit student ID
5 Service Code Char, Required, Key
Valid Values
  • ENRICHMENT = Enrichment
  • STEM-STEAM = STEM-STEAM
  • HERITAGELANGINST = Heritage Language Instruction
  • CCR = College and Career Readiness
  • TUTOR = Tutoring
  • CREDITRECOVERY = Credit Recovery
  • REMEDIAL = Remedial Education
  • MENTOR = Mentoring Program
  • ELD = English Language Development
  • ECE = Early Childhood Education
  • SOCIALWRK = Social Work-Social Services
  • COUNSELING = Counseling Services
  • HEALTH = Health Services
  • VISION-HEARING = Vision and Hearing Services
  • DENTAL = Dental Services
  • HOMEVISIT = Home Visits
  • COMMUNITY = Community-Service Learning
  • WRAP-AROUND = Wrap-around Services
  • DROPOUTPREVENTION = Drop-out Prevention Program
  • POSITIVESCHCULTURE = Positive School Culture Program
6 Service Start Date Date, Required, Key
SY 19-20 Valid Values
  • 2019-10-01 = 40D
  • 2019-12-15 = 80D
  • 2020-03-01 = 120D
  • 2020-06-01 = EOY
8 Service Frequency Char, Required, Updateable
  • A one to three digit number.
9 Service Duration Char, Required, Updateable
  • A one to three digit number.
12 Service Provider Name Char, Required, Updateable
Valid Values
  • Name of Community Service Provider Entity:
    • Example: PMS
16 Service Setting Code Char, Required, Updateable
Valid Values
  • BEFORESCHOOL
  • AFTERSCHOOL
  • WEEKEND
  • SUMMER
  • YEARROUND
20 Program Code Char, Required, Key
  • CSP = Community School Program
  • ELTP = Extended Learning Time Program