Annually Updating PS Accommodation Start Dates For TIDE Export

Purpose: In order to simplify the process of exporting TIDE Settings & Accommodations from PowerSchool, the accommodation start date (accomstartdt) needs to be changed to the first day of the current school year. Otherwise it will not be included in the export file.

 

Follow these steps prior to exporting the Setting & Accommodations:

 

Step 1: In the current year, select all active student on the Start Page, then navigate to the Data Export Manager (Data & Reports > Exports > Data Export Manager)

 

SBAAQykAAmOwMnrbQOOfFiLLkCjC9QaV2NvFcBCCDACgCNWyAAAQhAwETAIq4sgSxxEGAIMMtaog8EIAABCEAgDAIlV4CF8bbEhECGEkCAZejEMWwIQAACGUDAIq4sr2GJgwBDgFnWEn0gAAEIQAACYRBAgIVBlZgQCJgAAixgoISDAAQgAIEIAYu4suCyxEGAIcAsa4k+EIAABCAAgTAIIMDCoEpMCARMAAEWMFDCBUuALevB8iRa1hMo6q+URVxZJsUSBwGGALOsJfpAAAIQgAAEwiCAAAuDKjEhEDABBFjAQAkHAQhAAAIRAhZxZcFliYMAQ4BZ1hJ9IAABCEAAAmEQQICFQZWYEAiYAAIsYKCEgwAEIAABBJiIeELOL+ZiP7NcS3RP7OdTpyPA+OpBAAIQgAAEiosAAqy4yPNcCKRBAAGWBiy6QgACEIBAWgQsmVuWgJY4ZIAhwCxriT4QgAAEIACBMAggwMKgSkwIBEwAARYwUMJBAAIQgECEgEVcWXBZ4iDAEGCWtUQfCEAAAhCAQBgEEGBhUC1kzN9nzpQ3354su+zcTE44ukMho3F7aSCAACsNs8g7QAACECiZBCziyjJySxwEGALMspboAwEIQAACEAiDAAIsDKqFjNmzd59IhN6X9ZRdmjUrZERuz3QCCLBMn0HGDwEIQKDkErCIK8voLXEQYAgwy1qiDwQgAAEIQCAMAkEJsP8DOHSMOveyeTwAAAAASUVORK5CYII=

 

Step 2: On the Export Tab, in the Category dropdown menu, select Database Extensions:

 

OKf0xrCjEi0AAAAASUVORK5CYII=

 

Step 3: From the Export From dropdown menu, select S_ID_STU_SETTINGS_C:

 

CxxgtKpsrpcaljWVCETKYnxSKzMfEY73tr95hFwj0U5myMFnY3hwc547DfR5Mn1NG3atBzffCjy4ZfPteA57Hiw9sMhgGOdkyaqalflNIzJfog9pHc+P0cMJ4hIpKWPWvGEH1uvnP8HsIPP3JvcFzMAAAAASUVORK5CYII=

 

Step 3: Select all the fields on this table by checking the box next to STUDENTS.S_ID_STU_SETTINGS_C In the left column. Then select Next.

 

A9oLR1zdBISNAAAAAElFTkSuQmCC

 

Step 4: Check the box for Student to include. Then add two column filters. Filter by:

  • accomstartdt < Specific Date and firstdayofschool (ex. 09/02/2025)
  • accomenddt = Specific Date and nodate (i.e. leave date field blank)

 

Then select, Show Records:

 

B9gAVrhUqXblAAAAAElFTkSuQmCC

 

Step 5: Click on the Edit All FIltered Records button:

 

AAAAAElFTkSuQmCC

 

Step 6: Select the radio button next to accomstartdt, enter the date for the first day of school, and click Submit.

 

Xo57W1tfKJrK6uzucnw64RQAABBBBAAAEEEEAAAQQQQAABBBBAAAEEEEBg6QX+H9gVcYnd7Y9RAAAAAElFTkSuQmCC

 

Once the start date has been updated to the current year, you can run the Setting & Accommodations export from the Compliance Report screen to capture all active student accommodations.