CALPADS Postsecondary Status Summary (PSTS)

Tool Search: CALPADS Postsecondary Status Summary

The CALPADS Postsecondary Status Summary allows districts to submit data about student employment and.or 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 CTE Program or was participating in the California Partnership Academy Program (State Code 113).

Screenshot of the CALPADS Postsecondary Status Summary Extract, located at Reporting, CA State Reporting. CLAPDS Postsecondary Status Summary Extract

Report Logic

Students are included in the report when:

  • The student is no longer an active student, meaning the student's enrollment record for the selected calendar has an End Date and an Enrollment Status indicating no longer a student.
  • The student's Enrollment End Status for the reporting year is one of the following:
    • 100
    • 120
    • 250
    • 320
    • 330
    • 360
  • The student was part of a CTE Program OR was assigned a Program/Flag with a State Code of 113 - Educational Options: CA Partnership Academy.
  • The student's CTE record has a Pathway Completion Date.
  • The student must have a value in the Postsecondary Status Code in the State Reporting Graduation Fields editor. One record report for each Postsecondary Status Code assigned to the student.

Validate PSTS Data

Use the Data Validation Report to correct any student data prior to the submitting the CALPADS file to the state. Validation Groups and Validation Rules are provided by Infinite Campus for a specific CALPADS extract (listed below). These groups are used to return certain rules assigned to each group.

Modifications to the Validation Rules and Validation Groups can be made if your district has purchased the Campus Analytics Suite; otherwise, they are read-only. 

Users can select the Missing or Incorrect Data Validation Group, which returns any missing or incorrect data that is reported in the CALPADS Extract, like a missing enrollment exit reason or an incorrect date, for example.

Note that examples refer to CALPADS SENR.

Screenshot of the Data Validation Report editor. Data Validation Report - Missing/Incorrect Data

The report first lists a Summary of the issues found and the total number of occurrences.

Screenshot of an example of the Data Validation Report summary list. Validate Report Summary List

Then, click the Rule in the Summary column (for HTML format), or scroll through the report to see which students meet the criteria of the rule logic.

Screenshot of an example of the Data Validation Report results. Validate Report Results

Refer to the tables below, which includes the rule, rule logic and location, for correcting the data.

Missing or Incorrect Data

The Missing or Incorrect Data Report uses the following rules and logic (open the Click here to Expand section below to see each rule).

Click here to expand...

Rule NumberIssueLogicLocation
GERR0001A required field for the submitted Records Type is missing.Indicates at least one of the following is missing:
  • Record Type Code
  • Reporting LEA
  • School of Attendance
  • Academic Year ID
  • SSID
  • Education Program Participation Type Code
  • Postsecondary Status Code

District Information > State District Number


District.number


School Information > State School Number


School.stateSchoolNumber


School Year Setup > Start Year/End Year


Calendar.schoolYear


Demographics > Person Identifiers > State ID


Person.stateID


Flags


Program.code


Graduation > State Reporting Graduation Fields > Postsecondary Status Code

Graduation.postSecondaryCode

Report Editor

FieldDescription

Transaction Type

Indicates the type of transaction that will occur - Add/Update or Delete.

Format

Determines how the report will generate. Select State Format (Caret Delimited) if submitting records to the state. Other formats available for testing and review purposes are CSV and HTML.

Ad hoc Filter

Select which students to include in the extract by choosing a filter that was created in the Filter Designer.

Calendar Selection

Select the calendar of enrollment from which to pull student data. Calendars can be chosen by the active year, by the school name or by the year.

Report Generation Options

Choose the Generate Extract to display the results of the chosen items immediately. Choose the Submit to Batch option to generate the report at a specified time. This option is helpful when generating large amounts of data.

Generate the Extract

  1. Select the Transaction Type from the dropdown list - Add/Update or Delete.
  2. Select the Format of the file.
  3. Use the Ad hoc Filter to select students already included in a filter. This is not required. If not chosen, all students who have the appropriate enrollment start or end status during the entered date range are included.
  4. Select the Calendars to include in the file.
  5. Click the Generate Extract button. Or generate the extract at a specified time using the Submit to Batch button. The file appears in a new window in the selected format.

Screenshot of the report in state format.CALPADS PSTS Extract - State Format

Screenshot of the report in CSV format.CALPADS PSTS Extract - CSV Format

Screenshot of the report in HTML format.CALPADS PSTS Extract - HTML Format

Report Layout

ElementsDescriptionLocation

Record Type Code

Type of data record being submitted as chosen on the Extract Editor. Reports as PSTS.


Alphanumeric, 4 characters

Data not stored

Transaction Type Code

Action the state should take with this record as chosen on the Extract Editor. Add/Update is the default.

  • D = Delete
  • R = Replace
  • Blank or no transaction type = Add/Update

Alphanumeric, 1 character

Data not stored

Local Record ID

 N/A

N/A

Reporting LEA

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


If the reporting calendar is from a School with Type = 15: Independently Reporting Charter, the State School Number reports (not the State District Number).


This field reports the Secondary District Number when the reporting calendar has a School Type of 16: Secondary State District Number.


Numeric, 7 digits

District Information > State District Number


District.number


 School Information > School Number


School.number


 School Information > Type


School.type

School of Attendance

A unique identifier for the school that delivers a majority of educational instruction and services and is where the student attends. A District-level school entity should use the State District Number for the State School Number.


If the CDS Number is populated on the School editor, that value reports.


Numeric, 7 digits

School Information > State School Number


School.stateSchoolNumber


School Information > CDS Number


school.CDSNumber

School of Attendance NPSReports the last seven digits of the NPS School Code if available on the student's enrollment record. Otherwise, reports a blank value.

Numeric, 7 digits
Enrollment > NPS School Code

Enrollment.npsSchool

Academic Year ID

A unique identifier assigned to a specific Academic Year. An Academic Year is the period during which school is in regular session and provides a required number of days of instruction.

A value of 2019-2020 reports for an enrollment record in the 2018-2019 school year.


Date field, 9 characters (CCYY-CCYY)

School Year Setup > Start Year/End Year


Calendar.schoolYear

SSID

The unique identifier for the student assigned to or by the first California district in which the student is enrolled in accordance with CDE established standards. This number follows the student from school to school throughout his/her K-12 career.


Alphanumeric, 10 characters

 Demographics > Person Identifiers > State ID


Person.stateID

Local Special Education Student IDThis field reports blank. N/A
Reporting SELPAThis field reports blank.N/A

Education Program Participation Type Code

Reports a value of 10 when the student is assigned a Program/Flag with a State Code of 113.


Reports a value of 20 when student is assigned a CTE Program record with a Pathway Completion Date between July 1 and June 30 of the selected calendar.


Numeric, 2 digits

Flags


Program.code


CTE > Pathway Completion Date


CTEStatusCA.completionDate

Postsecondary Status Code

Reports the Postsecondary Status Code assigned on the student's Graduation record.

This field on the Enrollment record allows for multiple selections. In this extract, one row reports for each code assigned to the student.


Numeric, 3 digits

Graduation > State Reporting Graduation Fields > Postsecondary Status Code

Graduation.postSecondaryCode
Educational Institution TypeThe Educational Institution Type lists the type of educational or training institution based on the institution’s tax status.

Numeric, 2 digits
Graduation > State Reporting Graduation Fields > Educational Institution Type

Graduation.eduInstitutionType
Industry FieldIndicates the desired sector that best represents the field in which the respondent is employed, or the field in which the respondent will potentially be employed upon completion of the educational or training program where they are currently enrolled.

Reports the code assigned to the selected industry when the Postsecondary Status Code is 200, 210, 220, 300, 310, 320, 330, 340, 350, 360, 370, 910, 920, or 9.

Numeric , 3 digits
Graduation > State Reporting Graduation Fields > Industry Field

Graduation.employabilitySkills
Post-High School Credential Reports the industry-recognized certification provided by a third-party entity, a degree or certificate issued by a postsecondary institution, a license issued by the State of California, or other measure of technical skill attainment that the student received.

Numeric, 2 digits
Graduation > State Reporting Graduation Fields > Post-High School Credential

Graduation.postsecondaryReadyCompetencies