The External Schools screen allows users to record all of the district's partner schools.
In order to view, add, and edit external schools, you must have permission to View and Edit enabled via Users > Profiles > Setup tab. Note: If you have permission to View and not Edit, you will be able to view external schools but not add or edit schools.
1. In the Setup menu, click External Schools.
![External Schools](https://media.screensteps.com/image_assets/assets/003/735/523/original/87fa44a6-eeb4-4484-80fe-50847d12d308.png)
The External Schools screen displays as existing external schools including the School Number, School Name, Partner, Customer, Contact Title, Contact Prefix, Contact First Name, Contact Last Name, Address 1, Address 2, Address 3, City, State, Zip Code, Phone, Fax, Email, County Name, County Number, Region Number, District Name, District Number, and the SAT Code.
2. To add a new external school, enter information in the top row.
3. Enter the School Number and the School Name.
4. Select the Partner from the pull-down, which links to ERP > Accounts Receivable > Funding Sources.
5. Select the Customer from the pull-down, which links to ERP > Purchasing/Accounts Payable > Vendors/Customers.
6. Enter the Contact Title, Contact Prefix, Contact First Name, and Contact Last Name of the main contact person at the school, such as the Principal.
7. Enter the school's Address 1, Address 2, Address 3, City, State, Zip Code, Phone, and Fax number.
8. Enter the contact person's Email address.
9. Enter the County Name, County Number, Region Number, District Name, and the District Number.
10. Enter the SAT Code, which is the SAT college and school four-digit codes assigned to every college and university. It can also be 6 digit code for K–12 schools known as the College Board code or CEEB code.
11. Select the Inactive check box to flag the school as inactive.
12. Press the Enter key to save the external school data entered.
13. To edit existing external schools, click the applicable field and make changes as needed.
14. To delete an external school, click the delete button (red minus sign).
![External Schools](https://media.screensteps.com/image_assets/assets/003/735/626/original/bb03e540-799b-475f-b1fc-26c0ab86d8b7.png)
15. Schools can be imported using a CSV file. Prepare a CSV file that includes a column for each column and click Import.
![External Schools](https://media.screensteps.com/image_assets/assets/003/735/628/original/ea898f48-9e81-4a5f-8a2e-21d633233027.png)
a. A browser will display so you can search and upload the CSV file. Locate the file and click Open.
![Open](https://media.screensteps.com/image_assets/assets/003/735/630/original/34e2f779-23ea-478f-84ca-c8699489e305.png)
b. The system will try to match the columns with the correct headers. For those that are missing, select the header from the pull-down. When complete, click the Import CSV button to proceed.
The data is added automatically.
To export the listed schools to an Excel spreadsheet, click on the Excel icon in the Export section.
![External Schools](https://media.screensteps.com/image_assets/assets/003/735/636/original/bbcd1560-3730-4f03-b27b-b590a97a9197.png)
To print data, click on the Printer icon in the Export section.
![External Schools](https://media.screensteps.com/image_assets/assets/003/735/638/original/38a5c8ec-85bf-4f0f-8e01-b3c7fa902a06.png)
Click Filters to breakdown data.
![External Schools](https://media.screensteps.com/image_assets/assets/003/735/640/original/04ef3846-f897-48b5-a573-bf0515b968e8.png)
a. To add more than one filter to a column, click on the green plus sign.
b. To delete an added filter, click on the red minus sign.
c. Select the gray arrow for more filtering options.
For more information, see Filters.
Click Toggle Columns to customize the columns displayed.
a. From the Toggle Columns pop-up window, clear the selected check boxes of columns you want to hide from the screens.
Hidden columns remain hidden until the applicable check boxes are selected again from the Toggle Columns pop-up window.