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:
- 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 |
|
| 4 | Student ID | Char, Required, Key | Enter 9 digit student ID |
| 5 | Service Code | Char, Required, Key |
|
| 6 | Service Start Date | Date, Required, Key |
|
| 8 | Service Frequency | Char, Required, Updateable |
|
| 9 | Service Duration | Char, Required, Updateable |
|
| 12 | Service Provider Name | Char, Required, Updateable |
|
| 16 | Service Setting Code | Char, Required, Updateable |
|
| 20 | Program Code | Char, Required, Key |
|