Student Waiver Records Report

Use

If run at the district level, choose one of the following from the pop-up menu:

• Default – District Wide. Includes all records on the PowerSchool server that meet selection criteria.

• Current School Only – Includes all records associated with the current school that meet the selection criteria.

• District Wide – Includes all records on the PowerSchool server that meet the selection criteria.

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.

Students to Include

Indicate which students to include in the report by selecting one of the following options:

• The selected [number] students only – Run the report for students in the current selection.

• All students – Run the report for all students in the current school or district that meet the selection criteria.

Note: If running the report for a single student, or group of students, select the students prior to running report.

Processing Options

Choose a time to run the report from the pop-up menu:

• In Background Now (Recommended) – Execute the report immediately in the background.

• ASAP – Execute the report in the order it is received in the Report Queue.

• At Night – Execute the report during the next evening.

• On Weekend – Execute the report during the next weekend.

• On Specific Time – Execute the report on the date and time specified.

Specific Date/Time

Enter a date using the format mm/dd/yyyyor mm-dd-yyyyto run the report on a specific day. The incorrect format displays an alert and the date field is submitted as a blank entry.

Use the pop-up menus to schedule the report to be run at a specific hour and minute.

Example: 7/29/2008 @ 10 AM : 05.

Start Date

Enter the report start date. It is recommended to enter the first day of the current school year, as defined in the Years & Terms, as the start date.

End Date

Enter the report end date. It is recommended to use enter the last day of the current school year, as defined in the Years & Terms, as the end date.

Bypass Validation

Choose Yes or No from the pop-up menu to run the validation portion of extract, which is used to validate 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.

See Extract Validations for a list of potential validation errors.

6.01

Record Type Code

The type of data record being submitted.

Always SWAV

4

CS

N/A

Y

6.02

Transaction Type Code

The action taken when the data record is submitted.

CALPADS processes the following Transaction Type Codes:

• Blank: Add or update the record

• D: Delete the current record

This value is calculated based on the updatable fields and operational keys.

1

CS

N/A

N

6.03

Local Record ID

A local use field to provide the system record identifier for a submitted record in any CALPADS file format.

This field is calculated by concatenating internal ID fields. The values for the internal fields may be separated by periods.

[S_CA_STU_Waivers_C]Unique_ID

255

CS

U

N

6.04

Reporting LEA

The district number; a unique identifier for the LEA responsible for obtaining and maintaining a student's SSID by way of an enrollment record in the CALPADS.

State Business Rules:

The county district (CD) code must be reported if the reporting LEA is a district or county office. The school (S) code must be reported if the reporting LEA is an independently reporting charter school.

[Prefs]Name=districtnumber

[Prefs]Value

7

CS

N/A

Y

6.05

School of Attendance

The school in which the student is enrolled.

State Business Rules:

The school (S) code must be reported if the reporting LEA is an independently reporting charter school.

If the student attends an NPS school, the School of Attendance must be 0000001.

[S_CA_STU_Waivers_C]SchoolID

[S_CA_SCH_X]StateSchoolNumber

[Schools]School_Number

The report locates the School of Attendance for a student based on the school associated with the Waiver. Each school is assigned a 7-digit School Number, which is used as the School of Attendance value.

7

CS

O

N

6.06

Academic Year ID

The 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 (175 days in California).

Extracted in the format CCYY-CCYY, such as 2018-2091.

[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

O

Y

6.07

SSID

The unique identifier for the student assigned by the first California district in which the student is enrolled.

State Business Rules:

Must be a valid CALPADS SSID.

[Students]State_StudentNumber

10

CS

N/A

Y

6.08

Local Student ID

A unique identifier assigned to the student by an LEA.

State Business Rules:

Updates to this field must be made through the SSID Enrollment extract. The field is included in this extract to assist with the identification of the student.

[Students]Student_Number

15

CS

N/A

Y

6.09

Student Legal First Name

The first name given to the student after birth or through legal action.

State Business Rules:

Updates to this field must be made through the Student Information extract. The field is included in this extract to assist with the identification of the student.

[Students]First_Name

30

CS

N/A

Y

6.10

Student Legal Last Name

The last name given to the student after birth or through legal action.

State Business Rules:

Updates to this field must be made through the Student Information extract. The field is included in this extract to assist with the identification of the student.

[Students]LastName

50

CS

N/A

Y

6.11

Student Birth Date

The student’s date of birth, extracted in the format CCYYMMDD, e.g. 20081025.

State Business Rules:

Updates to this field must be made through the Student Information extract. The field is included in this extract to assist with the identification of the student.

[Students]DOB

8

DT

N/A

Y

6.12

Student Gender Code

The student’s gender.

State Business Rules:

Updates to this field must be made through the Student Information extract. The field is included in this extract to assist with the identification of the student.

Notes: 

• If populated, the student's legal gender overrides the student's preferred gender.

• If the student's preferred gender is X, the student's legal gender must be M or F.

[StudentCoreFields]PSCore_Legal_Gender

[Students]Gender

1

CS

N/A

Y

6.13

Education Regulatory Exemption Code

The type of exemption, which is a request from a parent/guardian, LEA or special education local plan area to a forego section of the California Education Code.

Valid values:

• 1 – CAHSEE Math Waiver

• 2 – CAHSEE ELA Waiver

• 3 – CAHSEE Exemption

State Business Rules:

If the exception code is 1, 2, or 3, then the student must have a 144 or 101 program record.

[S_CA_STU_Waivers_C]ExemptionCode

1

CS

O

Y

6.14

Education Regulatory Exemption Outcome Code

The outcome of the request for an exemption.

Valid values:

• 1 – Granted

• 2 – Denied

• 3 – Withdrawn

[S_CA_STU_Waivers_C]ExemptionOutcomeCode

1

CS

N/A

Y

6.15

Education Regulatory Exemption Outcome Start Date

The date the exemption outcome became effective, extracted in the format CCYYMMDD, e.g. 20181025.

[S_CA_STU_Waivers_C]OutcomeStartDate

8

CT

N/A

Y