Skip to Content

Program Services Fact Template

Program Services Fact Template 2019-10-09T08:22:24-06:00

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 NumberField NameData Type, Required, CodeValid Values
1District CodeChar, Required, Key
2Location CodeChar, Required, Updateable
3School Year DateDate, Required, Key
  • 2020-06-30 = SY19-20
4Student IDChar, Required, KeyEnter 9 digit student ID
5Service CodeChar, Required, Key

  • 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
6Service Start DateDate, Required, Key

  • 2019-10-01 = 40D
  • 2019-12-15 = 80D
  • 2020-03-01 = 120D
  • 2020-06-01 = EOY

8Service FrequencyChar, Required, Updateable
  • A one to three digit number.
9Service DurationChar, Required, Updateable
  • A one to three digit number.
12Service Provider NameChar, Required, Updateable

  • Name of Community Service Provider Entity:
    • Example: PMS
16Service Setting CodeChar, Required, Updateable

  • BEFORESCHOOL
  • AFTERSCHOOL
  • WEEKEND
  • SUMMER
  • YEARROUND
20Program CodeChar, Required, Key
  • CSP = Community School Program
  • ELTP = Extended Learning Time Program
Page last updated October 9, 2019