Skip to main content
Skip table of contents

Index of Extract Processing Types and Operational Keys

This table is taken from the CALPADS File Specifications (CFS) document from the CDE.

#

Record Type

Processing Type

Operational Key

1

SSID Enrollment

Transaction Processing

SSID, School of Attendance, Student School Start Date

2

Student Information

Effective Date Processing

SSID

3

Student Program

Transaction Processing

School of Attendance, SSID, Education Program Code, Education Program Membership Start Date, Education Service Academic Year, Education Service Code

4

Student Incident Records

Replacement Processing

School of Attendance, Academic Year ID

5Student Incident Results RecordsReplacement ProcessingSchool of Attendance, Academic Year ID Incident Local ID
6Student Offense RecordsReplacement ProcessingSchool of Attendance, Academic Year ID Incident Local ID

7

Student Waivers

Replacement Processing

School of Attendance, Academic Year ID

8

Staff Demographics

Effective Date Processing

Reporting LEA, SEID

9

Staff Assignment

Replacement Processing

School of Assignment, Academic Year ID

10

Course Section

Replacement Processing

School of Course Delivery, Academic Year ID, Academic Term Code

11a

Student Course Section Enrollment

Replacement Processing

School of Course Delivery, Academic Year ID, Academic Term Code

11b

Student Course Section Completion

Replacement Processing

School of Course Delivery, Academic Year ID, Academic Term Code, Marking Period Code

12

Student Career Technical Education

Replacement Processing

School of Attendance, Academic Year ID

13

Student English Language Acquisition

Transaction Processing

Reporting LEA, SSID, English Language Acquisition Status Code

14a

Postsecondary Status (CTE - Fall 2)

Replacement Processing

School of Attendance, Academic Year ID, Postsecondary Status Code

14bPostsecondary Status *(SWD - EOY 4)**Replacement Processing

Academic Year, Reporting LEA, Education Program Participation Type Code.

15Student Test Settings *(effective 2021-2022)Replacement ProcessingReporting LEA, SSID, Education Plan Participation Type Code, Test Setting Code
16

Work-based Learning *

(effective 2020-2021 - EOY 1)

Replacement ProcessingSchool of Attendance, Academic Year ID
17

Student Services **

(PowerSchool Special Program Customers only)

Replacement ProcessingReporting LEA, SSID, Reporting SELPA, Student Special Education Meeting or Amendment Identifier
17

Student Special Education Program **

Transaction ProcessingReporting LEA, SSID, Reporting SELPA, Student Special Education Meeting or Amendment Identifier

*Future release

**PowerSchool Special Program (PSSP) Customers only

JavaScript errors detected

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

If this problem persists, please contact our support.