Student Program (SPRG)¶
Student Program Essentials
SPRG
- Student Search
- SPRG View
- SPRG Edit
- Free and Reduced Price Meal EDIT
- Free and Reduced Price Meal VIEW
Transaction Processing
- School of Attendance
- SSID
- Education Program Code
- Education Program Membership Start Date
- Education Service Academic Year
- Education Service Code
- School of Attendance
- SSID
- Education Program Code
- Education Program Membership Start Date
- Education Service Academic Year
- Education Service Code
Legend
Table Value Legend
Y = Required: Schools are expected to submit data and will receive validation errors if data are not submitted.
N = No: Schools should NOT submit data.
P = Permitted: Schools are permitted, but not expected to submit data, but if SSIDs are obtained for students enrolled within those schools, then the data required to maintain those SSIDs must be submitted, and will receive validation errors if data are not submitted. Additionally, for “P” schools, certification validations will only be processed if data is submitted.
Table Footnote Legend
(1) Students completing courses in grades 7-12 only.
(2) Records for students enrolled at Nonpublic Nonsectarian Certified Schools (NPS) or Private School Group should be submitted using school code 0000001 for NPS or school code 0000002 for Private School Group in the School of Attendance field (1.05) and NOT the individual NPS or Private School Group school codes. NOTE: For NPS only, the actual NPS school code is submitted in the School of Attendance NPS field (1.06).
(3) Open and recently closed schools are included.
(4) ROC/Ps will not submit data directly to CALPADS. CALPADS will collect data on student ROC/P course enrollment and completion through the student's primary school course enrollment and completion submission.
(5) Home and Hospital schools are assigned a distinct county-district-school code and are not the same as a district-level operated Home and Hospital Program.
(6) Updated SINF data for Infant (includes Toddlers) and Prekindergarten in EOY 2 are only required for purposes of certifying report 5.4 -Homeless Students Enrolled - Unduplicated Count by School.
(7) Grade Level Codes Ungraded Secondary (US) and Ungraded Elementary (UE) will be retired as of 6/30/18, but available for transactional purposes prior to AY 2018-2019.
| Participants / School Type | Fall 1 | EOY 2 |
|---|---|---|
| Traditional (non-educational options schools) | Y | Y |
| District Level Programs (Independent Study and Home Hospital Programs) | P | P |
| County Community | Y | Y |
| District Community Day | Y | Y |
| Youth Authority Schools (Division of Juvenile Justice) | Y | Y |
| Juvenile Court Schools | Y | Y |
| Continuation High Schools | Y | Y |
| Opportunity | Y | Y |
| Alternative Schools of Choice | Y | Y |
| State Special Schools | Y | Y |
| Home and Hospital Schools (5) | Y | Y |
| Department of Development Services | N | N |
| Department of State Hospitals | N | N |
| Special Education Consortium | Y | Y |
| Special Education | Y | Y |
| Non-Public School Group (0000001) (2) | P | P |
| Private School Group (0000002) (2) | P | N |
| ROP/ROC (4) | N | N |
Legend
Table Value Legend
Y = Required: Schools are expected to submit data and will receive validation errors if data are not submitted.
N = No: Schools should NOT submit data.
P = Permitted: Schools are permitted, but not expected to submit data, but if SSIDs are obtained for students enrolled within those schools, then the data required to maintain those SSIDs must be submitted, and will receive validation errors if data are not submitted. Additionally, for “P” schools, certification validations will only be processed if data is submitted.
Table Footnote Legend
(1) Students completing courses in grades 7-12 only.
(2) Records for students enrolled at Nonpublic Nonsectarian Certified Schools (NPS) or Private School Group should be submitted using school code 0000001 for NPS or school code 0000002 for Private School Group in the School of Attendance field (1.05) and NOT the individual NPS or Private School Group school codes. NOTE: For NPS only, the actual NPS school code is submitted in the School of Attendance NPS field (1.06).
(3) Open and recently closed schools are included.
(4) ROC/Ps will not submit data directly to CALPADS. CALPADS will collect data on student ROC/P course enrollment and completion through the student's primary school course enrollment and completion submission.
(5) Home and Hospital schools are assigned a distinct county-district-school code and are not the same as a district-level operated Home and Hospital Program.
(6) Updated SINF data for Infant (includes Toddlers) and Prekindergarten in EOY 2 are only required for purposes of certifying report 5.4 -Homeless Students Enrolled - Unduplicated Count by School.
(7) Grade Level Codes Ungraded Secondary (US) and Ungraded Elementary (UE) will be retired as of 6/30/18, but available for transactional purposes prior to AY 2018-2019.
| Grade Level | Fall 1 (3) Pgm | EOY 2 Pgm |
|---|---|---|
| Infants – IN (Includes Toddlers) | P | Y (6) |
| Prekindergarten - PS | P | Y (6) |
| Transitional Kindergarten - TK | Y | Y |
| Kindergarten - KN | Y | Y |
| First Grade - 01 | Y | Y |
| Second Grade – 02 | Y | Y |
| Third Grade – 03 | Y | Y |
| Fourth Grade – 04 | Y | Y |
| Fifth Grade – 05 | Y | Y |
| Sixth Grade – 06 | Y | Y |
| Seventh Grade – 07 | Y | Y |
| Eighth Grade – 08 | Y | Y |
| Ninth Grade – 09 | Y | Y |
| Tenth Grade – 10 | Y | Y |
| Eleventh Grade – 11 | Y | Y |
| Twelfth Grade – 12 | Y | Y |
| Ungraded Elementary – UE (7) | Y | Y |
| Ungraded Secondary – US (7) | Y | Y |
| Adult – AD | N | N |
Student Program Details¶
The Student Program container appears on the Student Details page. The page opens with the Student Program container in the collapsed position. Clicking the down arrow on the containers displays the individual program records for the selected student. The system will display all Program records by default, but only will allow editing of Program records belonging to the user’s LEA. The selected student’s historical records will be displayed in reverse chronological order. NOTE: If a user is not authorized to add, edit, or view confidential data types, some student program records will not be displayed.
Users may have the ability to edit program records that are owned by the LEA, if the role is assigned by your LEA Administrator. An authorized user may perform the following functions through this interface:
- View one or all of a student’s Program records belonging to the user’s or another’s LEA (depending on the user permissions)
- If the user is authorized, an Open button will display next to an existing Program record
- If the user is authorized, an Add a New Record button will display above the Program record(s)
- Modify the sequence of the displayed Program records
Navigating to the SPRG User Interface¶
A user first searches the student either through the SSID or demographic search process to get to the Student Details page. By default, the Student Program container will be in the collapsed position. Clicking the container header displays the individual program records for the selected student.
Student Detail Program Container¶
The Student Program container UI is depicted below followed by its screen elements table. Below that is the “Student Program” modal depiction followed by its screen elements table. Following the screen elements tables are the user interaction section and the system operations section with the available system functions, requirements and possible processes that may occur through these interfaces.
Clicking on the Student Program header expands the container and reveals existing records.
Container column headers enable users to sort or filter existing incident records based on parameters set. Open button enable users to view details of the student program record. Record can only be modified if the record is owned by the LEA the user is associated to. Since the container only shows limited records at a time, the page buttons allow users to move to the next set of records.If a user is authorized to add and edit records, the user will be able to click on the Open button of each record listed as well as the Add a New Record button.
If a user clicks either button the system will display the “Program” page with the respective fields populated with either values from the student’s existing record or the specified system default values. If the user attempts to navigate from the page before completing the process, the system will display a warning message for the user to confirm the update/addition data will not be submitted to the ODS.
Student Program Modal¶
The Student Program Details modal is depicted below followed by a screen elements table. If the user clicks to open an existing record, the Student Programs page appears with the values from the student’s selected record. If the Add a New Record button is clicked, all fields on the page will be populated with Null values when the page opens. LEA-level users will be able to modify the School of Attendance, but School-level users will not. All other input will conform to the Screen Elements described below.
| # | Field | Required | Validation/Business Rule |
|---|---|---|---|
| 1 | Reporting LEA | Y | Default to user’s current Org; only present values related to user’s Org. Field must meet the defined CALPADS’ data validation and processing requirements. |
| 2 | School of Attendance | Y | The 7-digit School (S) code must be submitted. |
| If the entity is an independently reporting charter school, the School (S) code must be submitted for both the School of Attendance and the Reporting LEA. | |||
| If student attends an NPS school, the School of Attendance is identified as 0000001. The NPS School is identified in the element "School of Attendance NPS" | |||
| 3 | Education Program Code | Y | If the user does not have authorization to add/edit confidential data types, some program codes will not be accessible. Field must meet the defined CALPADS’ data validation and processing requirements. Note: If codes are retired they will not be removed as a value via the dropdown as they need to exist for prior year submissions and reports. The effective end date in the code set will prevent future data from being submitted through an input validation. |
| 4 | Membership Start Date | Y | Field must meet the defined CALPADS’ data validation and processing requirements. See Data Guide Chapter 2.1.3 Start and end dates for program eligibility |
| 5 | Membership End Date | N | Field must meet the defined CALPADS’ data validation and processing requirements. See Data Guide Chapter 2.1.3 Start and End dates for program eligibility |
| 6 | California Partnership Academy ID | Required If Education Program Code = 113 (California Partnership Academy) | Must be a valid identifier on the CDE California Partnership Academy list |
| 7 | Migrant ID | Required If Education Program Code = 135 (Migrant) | This is the state Migrant Student Directory (MSD) number as assigned in the Migrant Student Information Network (MSIN) data system. This is NOT the identifier used in the COE Star system, which is alphanumeric. The Migrant Student ID must be exactly 11 characters with the first two characters beginning with "06" |
| 8 | Education Service Academic Year | Required if Education Program Code = 122 (NCLB Title 1 Part A Basic Targeted) | Field must meet the defined CALPADS’ data validation and processing requirements. |
| 9 | Education Service Code | Required if Education Program Code = 122 (NCLB Title 1 Part A Basic Targeted) | Field must meet the defined CALPADS’ data validation and processing requirements. |
| 10 | Homeless Dwelling Type Code | Required If Education Program = 191 (Homeless Program) | Homeless Dwelling Type Code |
| 11 | Unaccompanied Youth Indicator | Required If Education Program Code = 191 (Homeless Program) | An indication of whether or not a student who has been identified as homeless is not in the direct care of their parent or guardian. |
| Action Buttons | |||
| A | Delete Record | N/A | If clicked, the system will delete the student’s program record from the ODS when the user confirms the deletion. “Are you sure you want to delete this record? Yes/No” |
| B | Cancel | N/A | If clicked, the modal will close and the system will display the Program Container page. |
| C | Validate | N/A | Validation is a two-stage process – Stage 1 performs client-side validations on missing data in required fields and data type errors. Stage 2 performs validation checks on Student Programs IVRs. If no fatal errors detected on IVRs for Student Programs but Warning IVRs are triggered, then “Validation Successful and warnings exist”, followed by a list of warning IVRs. |
| If no fatal errors are detected on IVRs for Student Programs, two new buttons, Post and Cancel are presented. | |||
| D | Go Back/Edit | N/A | Appears after validation if no fatal errors are detected. If selected, system will return fields to editable, retaining any values that have already been changed from original record. |
| E | Post | N | If no fatal validation errors, this option will be presented. If the user clicks the button, system will post records. If not successful, “Post failed” with accompanying error message. |
Why is there no centered alignment?
- Student Search
- SPRG Edit
- SPRG VIew
Info
- Student Search
- SPRG Edit
- SPRG View
- Free and Reduced Price Meal EDIT
- Free and Reduced Price Meal VIEW
- Fall 1
- Fall 2
- EOY 3
Student Program Data Essentials¶
This file format is used to submit program information about a student. Program eligibility or participation data is submitted depending on the specific program and time of the collection.
Info
- SPRG
- Transaction Type
- School of Attendance
- SSID
- Education Program Code
- Education Program Membership Start Date
- Education Service Academic Year
- Education Service Code
- School of Attendance
- SSID
- Education Program Code
- Education Program Membership Start Date
- Education Service Academic Year
- Education Service Code
Data Collected¶
Student program eligibility and participation must be reported to CALPADS as soon as the information is available and continuiously maintained throughout the academic year. The following are the expected student programs collected in the different submissions.
| Code | Program Name | Type | Program Start Date | Program End Date | Should LEAs Close These Records? |
|---|---|---|---|---|---|
| 181 | Free Meal Program | Federal | Must be in the current academic year for each reporting year. Represents the date an approved NSLP meal application was received. |
Represents the date that the student exited the school for the academic year. | Yes. These records should be closed annually and a new eligibility determination must be made annually. NOTE: Records for students who exit a school with an exit code other than E150 will be auto-closed by CALPADS. |
| 182 | Reduced-Price Meal Program | Federal | Must be in the current academic year for each reporting year. Represents the date an approved NSLP meal application was received. |
Represents the date that the student exited the school for the academic year. | Yes. These records should be closed annually and a new eligibility determination must be made annually. NOTE: Records for students who exit a school with an exit code other than E150 will be auto-closed by CALPADS. |
| 127 | Gifted and Talented Education (GATE) | Federal | Represents the date the student was determined to be eligible for the GATE program within a school. Does not mean the student is participating in the GATE program. |
Represents the date the student was exited from the GATE program at a school. | No. These records should not be closed annually for returning students. For students exiting the school, these records may, but are not required to be closed. |
| 135 | Migrant Education | Federal | Represents the date the student was determined to be eligible for the Migrant Program (at any school in California) for a particular eligibility period (max of three years). If eligible again after three years, submit new record. |
Eligibility expired; or date student was determined ineligible for services within a school. |
No. These records should not be closed annually for returning students. For students exiting the school, these records may, but are not required to be closed. |
| 162 | Pregnant or Parenting Programs | State | Represents the date the student was determined to be eligible for pregnant or parenting program. | Represents the date the student was determined to be ineligible at a school or is no longer parenting. | No. These records should not be closed annually for returning students. For students exiting the school, these records may, but are not required to be closed. |
| 191 | Homeless Program | Federal | First date student was identified as homeless at any school in California. If eligibility is re-verified annually, close previous record and submit a new one. |
Date student is no longer homeless; or last day of the school year. |
No, not required to be closed at the end of the year or on exit. Best practice is annual reverification. LEAs can opt to close and reopen records to facilitate reverification. |
| 101 | 504 Accommodation Plan | State | First date student identified as having a 504 Plan. | Date student no longer identified as having a 504 Plan. | No. Not required to close annually. May be closed on exit. Best practice: evaluate annually and close if no longer eligible. |
| 192 | Armed Forces Family Member | Federal | Date student became eligible based on parent's most recent active military status. Must be on or after student’s birthdate, even if parent’s status was earlier. |
Date student is no longer considered armed forces family member; or last day of the school year. |
No. These records should not be closed annually for returning students. For students exiting the school, these records may, but are not required to be closed. |
| 301-307 | Language Instruction Program (LIP) | State | Date student became eligible and began participating in the LIP. NOTE: All English learners should be participating in a LIP. |
Date student exited the program. Students do not have to exit the program upon RFEP reclassification if they are still participating. |
No. These records should not be closed annually for returning students continuing in the program. For students exiting, records may but are not required to be closed. |
| Code | Program | Type |
|---|---|---|
| 181 | Free Meal Program | Federal |
| 182 | Reduced-Priced Meal Program | Federal |
| 127 | Gifted and Talented Education (GATE) | Federal |
| 135 | Title I Part C Migrant | State |
| 185 | Transitional Kindergarten | State |
| 191 | Homeless Program | Federal |
| 193 | Tribal Foster Youth | State |
| 300-307 | LIP - Developmental Bilingual Program | State |
| 301 | LIP - Dual-Language Immersion Program | State |
| 302 | LIP - Heritage or Indigenous Language | State |
| 303 | LIP - Newcomer Program (Various Models) | State |
| 304 | LIP - One-Way Immersion Program | State |
| 305 | LIP - Structured English Immersion Program or other predominantly English Language Instructional Models |
State |
| 306 | LIP - Transitional Bilingual Program | State |
| 307 | LIP - Parent Opted Out of EL Services | State |
| Code | Program | Type |
|---|---|---|
| 122 | Title I Part A Basic Targeted | Federal |
| 174 | Title I Part A Neglected | Federal |
| 191 | Homeless Program | Federal |
| 192 | Armed Forces Family Member | Federal |
| 101 | 504 Accommodation Plan | State |
| 108 | Opportunity Program | State |
| 113 | California Partnership Academy | State |
| 162 | Pregnant or Parenting Programs (formerly Cal-SAFE) | State |
| 185 | Transitional Kindergarten | State |
Note
If a student moves to another school within a district and still meets eligibility or is participating in the same programs, a new program record must be reported for the student at the new school.
| Code | Program | Type | Code | Program | Type |
|---|---|---|---|---|---|
| 181 | Free Meal Program | Federal | 122 | Title I Part A Basic Targeted | Federal |
| 182 | Reduced-Priced Meal Program | Federal | 174 | Title I Part A Neglected | Federal |
| 127 | Gifted and Talented Education (GATE) | Federal | 191 | Homeless Program | Federal |
| 135 | Title I Part C Migrant | State | 192 | Armed Forces Family Member | Federal |
| 185 | Transitional Kindergarten | State | 101 | 504 Accommodation Plan | State |
| 191 | Homeless Program | Federal | 108 | Opportunity Program | State |
| 193 | Tribal Foster Youth | State | 113 | California Partnership Academy | State |
| 300 | LIP - Developmental Bilingual Program | State | 162 | Pregnant or Parenting Programs (formerly Cal-SAFE) | State |
| 301 | LIP - Dual-Language Immersion Program | State | 185 | Transitional Kindergarten | State |
| 302 | LIP - Heritage or Indigenous Language | State | |||
| 303 | LIP - Newcomer Program (Various Models) | State | |||
| 304 | LIP - One-Way Immersion Program | State | |||
| 305 | LIP - Structured English Immersion Program or other predominantly English Language Instructional Models | State | |||
| 306 | LIP - Transitional Bilingual Program | State | |||
| 307 | LIP - Parent Opted Out of EL Services | State |
LIP Program Start and End Dates¶
Below are guidance on what program membership dates to use for LIP records.
- Students participating prior to the current academic year, use the date the student became eligible for and began participating in the program, or if that is not known, use the first day of school in the current academic year.
- For students who are newly identified as English learners (EL) in the current academic year, use their English Language Acquisition Status (ELAS) Start Date.
- For non-English learners who began participating in these programs in the current year, use their enrollment start date for the academic year.
- LEAs should not annually close SPRG language instruction program records at the end of the school year if returning students will continue in the same program the following school year. For students exiting the school, these records may, but are not required to be closed.
-
Students transferring school within the LEA mus have a new LIP record reported at the new school.
-
Students who are reclassified to RFEP must exit existing LIP programs (300, 303, 305, 307) with a date that is before teh RFEP status date, even if they are still participating in the program. git remte
- Adult EL students (ADEL) must exit existing open LIP programs (300, 303, 305, 307) with a date that is before the ADEL status date even if they are still participating in the program.
Language Instructional Program Mapping¶
|
New Education Program Code |
Name of New Education Program Code |
Retired Instructional Strategy Code |
Name of Retired Instructional Strategy Code |
|
300 |
LIP – Developmental Bilingual Program |
600 |
English Learner Bilingual Program |
|
301 |
LIP – Dual-Language Immersion Program |
400 |
Dual Language Immersion Program |
|
302 |
LIP – Heritage or Indigenous Language |
none |
n/a |
|
303 |
LIP – Newcomer Program (various models) |
none |
n/a |
|
305 |
LIP – Structured English Immersion Program or other predominantly English Language Instructional Models |
500 Or 650 |
Structured English Immersion/Other English Model English Learner Mainstreaming |
|
306 |
LIP – Transitional Bilingual Program |
600 |
English Learner Bilingual Program |
Language Instructional Program Codes¶
|
Code |
Program Name |
Description |
|
300 |
LIP - Developmental Bilingual Program (For EL students only) |
A language instructional program (LIP) designed for English learners which provides content instruction delivered in the students’ native language and English. |
|
301 |
LIP - Dual-Language Immersion Program |
A language instructional program (LIP) designed for English learners and native English speakers, which provides content instruction delivered in the English learners’ native language and English. Program models may include Two-Way Immersion, 50/50 Dual Immersion, 90/10 Dual Immersion, and other similar program models. |
|
302 |
LIP - Heritage or Indigenous Language |
A language instructional program (LIP) in English and another language for non-English speakers or students with limited literacy skills in their first language. Indigenous language programs support endangered minority languages in which students may have limited receptive and no productive skills. Both programs often serve American Indian students |
|
303 |
LIP - Newcomer Program (Various Models) (For EL students only) |
A language instructional program (LIP) designed for English learners who are new to the country with less than 12 months of schooling in the United States. This program provides instruction in designated and integrated English language development (ELD) based on the state-adopted CA ELD |
|
304 |
LIP - One-Way Immersion Program |
A language instructional program in English and another language for non-speakers of the other language, with the goals of language proficiency and academic achievement in English and the other language, and cross-cultural understanding. The portion of the instructional day delivered in each language varies by the type of program. |
|
305 |
LIP - Structured English Immersion Program or other predominantly English Language Instructional Models (For EL students only) |
A language instructional program (LIP) designed for English learners in which nearly all classroom instruction is provided in English with curriculum and a presentation designed for students who are learning English. The goals of this program are language proficiency and academic achievement in English. Students receive instruction in designated and integrated English language development (ELD) based on the state-adopted CA ELD standards |
|
306 |
LIP - Transitional Bilingual Program |
A language instructional program (LIP) designed for English learners utilizing English and students’ native language for literacy and academic instruction, with the goals of language proficiency and academic achievement in English |
|
307 |
LIP - Parent Opted Out of EL Program (For EL students only) |
The local educational agency (LEA) is not providing any instructional services designed for English learners because the parent of this English learner has opted this student out of EL services. The LEA maintains a record of the action to demonstrate the parents have chosen to opt out of such services. |
Additional References¶
CALPADS Error List¶
Look for Student Programs Tab
CALPADS File Specifications¶
Look for Student Programs Tab
CALPADS Data Guide¶
Chapter 2.2.2 provides additional information on Job classifications.