Interface Processing | PowerSchool ERP

The following table summarizes the steps for processing Aesop data files and lists the section of the user guide that provides the instructions for each step.

Step Chapter/Section Usage Notes	Create Reference Table Records Reference Table Setup This step is done at implementation as well as when new codes are added.
Aesop Pay Code Crosswalk	This option is used to create a crosswalk of pay codes used by the Aesop and PowerSchool ERP applications. The crosswalk is needed only when the pay code values in the Aesop file are not numeric.
Aesop Budget Unit & Account Code Mask	This option can be used to assign the substitute's budget code and account using masking including wildcards. Long Term Substitute Pay Codes This table will only be used if the option Check Long Term Sub is selected on the Load Aesop Attendance page.
Prepare Aesop File Exporting Data from Aesop	User procedures to export data from the Aesop application.
Transferring the Data File	User procedures to transfer the Aesop data file to the PowerSchool ERP application server.
Import Aesop Records Load Aesop Attendance	This option creates records in the aesattend table and generates two summary reports. The user would review the reports, make changes to the Aesop and/or PowerSchool ERP data, and re-create and re-load the Aesop export file as needed. This process can be repeated until the information is suitable.
Post Aesop Records to Attendance Post Aesop Attendance	This option creates attendance records in the attend table from the Aesop records in the aesattend table. The posting process does not create attendance records for Aesop records with errors. If needed, the user could create attendance manually for the records with errors after the Aesop Post.
Payroll Processing N/A	The user would return to standard PowerSchool ERP payroll processing. These attendance records can be edited and posted the same way as manually created records.
Update Aesop Leave Balances - Export Leave Balances	This option creates a file with leave balance information from PowerSchool ERP to upload to the Aesop system. This step can be performed as needed if the user wants to transfer leave balance data to Aesop.