Delete Custom Field From PowerSchool

Summary

This article explains how to properly delete a custom field.

• Note: To avoid data loss, custom fields should only be deleted outside of regular business hours when other users are not editing PowerSchool information. 
• Note: Deleting a custom field that has data in it can result in unexpected behaviour.  Before deleting it, always clear the custom field of any data (including for non-active students) by using Student Field Value.

Process

1. Log in to PowerSchool Admin
2. Select the District Office
3. Search for all active and inactive students or staff (Search for /)
4. From the Functions dropdown, select Student Field Value or Staff Field Value
5. Click the Fields link to select the field you would like to delete, or type it in.
6. Check Clear Field Value
7. Click Submit
8. Confirm the change by clicking Submit at the preview screen.
9. Start >System > Page and Data Management > Manage Database Extensions
10. Database table to extend = Students 
11. Workflow type = Advanced Extension > Next
12. Select extension name > Next
13. Select table name > Next
14. Find Field name and click on delete button then submit

• Note: Depending on how much data is related to the custom field being deleted, it may only take a few minutes to remove the field, or in larger districts, an hour or more.
• Note: PowerSchool may need to be restarted for the custom fields to be cleared from the cache.

Removal from Oracle

ATTENTION! If the field still shows in the search field, go delete the record out of FIELDSTABLE from Oracle.

delete from fieldstable where name = 'fieldname';