To get an idea of this complex process, please read Direct Cert - Procedure Overview if you haven't already.
Step 1: Upload SLDS Files
Step 2: Download the DC File From AOE Edfusion Website
Step 3: Direct Cert: Format the AOE DC File
After you formatted the spreadsheet document in Step 3, you created a text file that will be used to import data into PowerSchool. This is the process to do that.
In PowerSchool, go to SQL Reports. We want to take a snapshot of the counts before and after the import.
Open the Demographics category and run Demographic Counts All Prek and Demographics Counts by School BSDK-12. Copy both of these into a new spreadsheet.
Select Special Functions from the Start page.
Select Importing and Exporting.
Select Quick Import.
Click on the Table dropdown and select Students
Click on the Choose File button.
Browse to the text file you created in Step 3 Direct Cert: Format the AOE DC File.
Click on Import.
Map the following fields
LCLSTUNUM -->> student_number
DC Status --->> direct_cert
3SquareSNAP -->>square3
ReachUpRUFA -->> ReachUp
Select the checkbox next to "Check to exclude first row."
Underneath that checkbox in the empty box, type the date that you downloaded the DC file from EdFusion
Click on the dropdown next to that and select U_STUDENTS_EXTENSION_direct_cert_date.
Under Advanced Import Options, Select "Update the student's record with the information from the file being imported."
Select Submit. The import will take a few minutes to run. You will see the circle processing on your tab header in the browser.
Run the Siblings report under the Food Service Category in SQL Reports and check for siblings that have different DC statuses. If one is Y the other should also be Y.
Now you will run the same two reports you ran in step 2.