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

  • 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

  • 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

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

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