Postsecondary Status Report
Introduction
The CALPADS Postsecondary Status Report allows districts to submit data about student employment and educational status the year after completing secondary education (graduates from the prior academic year). This information is collected for any student who was part of and completed a Career Technical Education (CTE) Program or was participating in the California Partnership Academy Program (State Code 113).
Use this file format to submit the employment and educational status of any student after completing secondary education. This information is collected for students with disabilities, career technical education concentrators and completers, and students participating in the California Partnership Academy Program.
The Postsecondary (PSTS) file contains the following information:
Education Program Participation information
Postsecondary Status
CTE Related Program or Employment-related information.
One record should be submitted for each postsecondary status provided. The postsecondary statuses for each student (SSID) are grouped by:
Reporting LEA (District of Service)
School of Attendance
Selection Criteria
The Postsecondary Status Report includes records for students that meet the following criteria:
Students who are not excluded from State Reporting.
Students whose school enrollment is not excluded from State Reporting, except the following:
All Primary, Secondary, Short term, and Services Only enrollments are included.
Concurrent enrollments, as defined on the CALPADS Student Concurrent (Non-Primary) Enrollments page, cannot be excluded from state reporting; however, excluding the student will exclude all their school enrollments.
Students enrolled on Census date in the previous Academic Year to the year in the Term Selector.
Students enrolled in a school that is not excluded from state reporting.
Students who completed their secondary education and graduated in the previous Academic Year (promoted to the Graduated Students school with STUDENTS.SchoolID = 999999 and STUDENTS.Grade_Level = 99).
Students enrolled in a CTE program at any time in their High School career AND who are also marked as a CTE Pathway Completer.
The Postsecondary Status Code field has been populated.
The California Department of Education (CDE) has added a new grade level of ‘TK’ that districts must use when reporting Transitional Kindergarten students to CALPADS. This new grade level will be effective starting with the 2023-2024 school year.
To support this functionality, PowerSchool has updated all California state reporting pages and reports to honor the grade level mappings as defined by each district.
The grade level is reported as mapped in all CA-specific reports once you meet the following criteria:
You are on PS Version 23.1 or higher
LTK Pref is enabled
While running the report, the selected school year is 23-24 or higher.
LTK Grade Level Mapping - valid values:
Grade 0 = KN
Grades -1 and below = TK, PS, IN
Grades >12 = AD
Report Input
This report is run at the District and School level.
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
---|---|
Term | Select the previous year for including records for students who graduated in the previous academic year. |
Select Schools |
If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list. |
Submission | Choose the following option from the menu:
|
Report Mode |
|
Bypass Validation | Choose Yes or No from the menu to run the validation portion of the extract. The validation ensures that specified fields used for the extract are populated correctly. If the report identifies errors in student data, an HTML page displays the list of the errors. If the report does not identify any data errors, extract completes as expected.
|
School Group | Choose a group of schools to override the above "Use" parameter indicating District-Wide vs.Current School Only. The extract includes student records associated with the selected schools that meet the selection criteria. Note: This parameter is optional. The “School Group“ Report parameter will only be available when the sub-district functionality is not enabled. |
Report Output
Field | Data Element | Description | [Table]FieldName | Max Length | Field Type | O/U | Required |
---|---|---|---|---|---|---|---|
17.01 | Record Type Code | A category describing the type of data record being submitted. | Always PSTS | 4 | CS | N/A | Y |
17.02 | Transaction Type Code | The action the system should take on the data record being submitted. CALPADS uses the following transaction codes to determine how to handle records:
| This field is calculated based on the updatable fields and operational keys. | 1 | CS | N/A | N |
17.03 | Local Record ID | A local field to provide the system record identifier for a submitted record in any California Longitudinal Pupil Achievement Data System (CALPADS) file format. | Derived | 255 | CS | X | N |
17.04 | Reporting LEA | The district number in PowerSchool. A unique identifier for the educational service institution responsible for obtaining and maintaining a student's Statewide Student Identifier by way of an enrollment record in the California Longitudinal Pupil Achievement Data System (CALPADS). State Business Rules: If the Education Program Participation Type Code = 20 (Career Technical Education) then the Reporting LEA must match the equivalent field in the most recent SSID Enrollment record in the prior year associated with the LEA. | [Prefs]Name=districtnumber [Prefs]Value | 7 | CS | N/A | Y |
17.05 | School of Attendance | The school in which the student is enrolled. The extract uses the school of attendance associated with the student’s program enrollment. State Business Rules: If the student attends an independently reporting charter school, the School number must be submitted for both the School of Attendance and the Reporting LEA. If the student attends an NPS school, the School of Attendance must be 0000001. | [S_CA_STU_CALPADSPrograms_C]SchoolID [S_CA_SCH_X]StateSchoolNumber [Schools]School_Number | 7 | CS | N/A | Y |
17.06 | School of Attendance NPS | A unique identifier (school code) for the certified non-public non-sectarian school the student attends. This field is extracted if the student’s School of Attendance is 0000001. | [S_CA_STU_X]NPS_CDS_SchoolCode [S_CA_REN_X]NPS_CDS_SchoolCode [S_CA_STU_ConcurrentEnroll_C] NPS_CDS_SchoolCode | 7 | CS | X | If School of Attendance = 0000001 |
17.07 | Academic Year ID | A unique identifier assigned to a specific Academic Year in which the data are being reported. An Academic Year is the period during which school is in regular session and provides a required number of days of instruction (175 days in California). Extracted in the format CCYY-CCYY State Business Rules: Academic Year ID must be a valid academic school year combination and no more than one year in the future. | [Terms]FirstDay [Terms]LastDay The report extracts the last four digits of the date value stored in both the FirstDay and LastDay fields. | 9 | CS | X | Y |
17.08 | SSID | The unique identifier for the student assigned to or by the first California district in which the student is enrolled as per the CDE established standards. This number follows the student from school to school throughout their association within the California educational system. State Business Rules: Must be a valid CALPADS SSID. If Education Program Participation Type Code = 20 (Career Technical Education) | [Students]State_StudentNumber | CS | N/A | Y | |
17.09 | Local Special Education Student ID | A unique identifier assigned to a student by a Special Education Local Plan Area (SELPA) or State Operated Program (SOP), the identifier may or may not be the same as the identifier in the local student information system. State Business Rules: If Education Program Participation Type Code = 20 (Career Technical Education), then this value must be blank. | Always blank. | 16 | CS | N/A | N |
17.10 | Reporting SELPA | A unique identifier assigned by the California Department of Education Special Education Division to each Educational Service Institution serving as a Special Education Local Plan Area (SELPA). | Always blank. | 4 | CS | X | N |
17.11 | Education Program Participation Type Code | A coded value representing the education program that the student last participated before completing grade 12. State Business Rules: If Education Program Participation Type Code = 20 (Career Technical Education), then Student School Completion Status in ODS must = 100 (HSDiploma) and CTE Pathway Completion Year must be the same academic year as the Enrollment Exit Date. | Always = 20 (Career Technical Education). [S_CA_STU_StudentCTE_C]Completer | 2 | CS | N/A | Y |
17.12 | Postsecondary Status Code | A coded value representing the student's postsecondary status after exiting secondary education. State Business Rules: If the Postsecondary Status Code is not equal to 950 or 960, then another Postsecondary Status record for the same SSID and Education Program Participation Code cannot equal 950 or 960. | [S_CA_STU_X]Post2ndProgram | 3 | CS | N/A | Y |
Filler | Filler | N/A | N/A | 1 | CS | N/A | N/A |