Skip to main content
Skip table of contents

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

  • Select Multiple Schools – Select multiple schools to include in the report. To select multiple schools, use Ctrl+Click and select each school to be included. Select schools to include in the report.

  • Select Single School – From the list of schools, select one school for which you want to generate the report.

  • All Schools – Run the report for the entire district.

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:

  • Fall 2 – The extract includes course section records that meet the Fall 2 Student Course Section Enrollment Submission selection criteria. Submit only Postsecondary Status (PSTS) records for students who exited secondary education in the prior academic year that were identified as students who selected and completed a Career Technical Education Pathway. [S_CA_STU_StudentCTE_C]Completer

Report Mode

  • Submission Mode

  • Exception 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 
Note: This overrides the Use selection above.

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:

  • Blank: Add or update the record

  • D: Delete the record

  • R: Replace the record

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
Then Y;
Else N

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)
then the Reporting LEA must match the equivalent field in the most recent SSID Enrollment record in the prior year associated with the LEA.

[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



JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.