Delete Multiple SELA Records

To delete multiple SELA records, you will need to export the records, delete them from the export file, and import the changes back into PowerSchool SIS.

Export the Records

1. From the start page, select Page and Data Management, then Data Export Manager.

2. In the Category field, choose Database Extensions.

3. Choose to Export from the S_CA_STU_ELA_C table.

4. Select the checkbox for STUDENTS.S_CA_STU_ELA_C to select all the fields in the table.

5. Click Next.

6. Filter for the records you want to delete.

7. Click Show Records and verify these are the records you want to delete.

8. Click Next.

9. Verify the Records to Export count is the same number of records reviewed.

10. Verify that Include Column Headers is selected.

11. Click Export.

Modify the Export File

You will be making a permanent mass change to your data when you import this file back into PowerSchool SIS. It is important that you validate that all records in the export file are the records you want to delete.

1. Open the export file.

2. Validate that all the records in this file are the records you want to delete.

3. Delete the row values with the following exceptions:

   1. Do not modify the first row.

   2. Do not delete the values in the S_CA_STU_ELA_C.ID field.

4. Save the modified file.

Import and Delete the Records

1. From the start page, select Page and Data Management, then Data Export Manager.

2. Click Choose File and select the modified export file.

3. Select the Import Into, then S_CA_STU_ELA_C.

4. Click Next.

5. Verify all columns are mapped and click Next.

6. Select Check to exclude the first row (contains headers).

7. Choose to Update existing record when a record in the import file matches an existing record in the database.

8. Select Check to confirm that records should be deleted if blank rows exist in the import file.

9. Click Import.