Overview
This task creates a comma-separated value (CSV) file for Yellow Folder (www.yellowfolder.com) that contains basic staff demographic and contact information.
Data is exported vis SFTP
Selection of Data
All Staff members (Active and Inactive) are included.
Staff with the exclude From Third Party flag on their demographics page are not included.
File Layout
Filename: hr.csv
The file does contain a header row.
Column # | Column Name | Where to find data in SchoolFi |
|---|---|---|
| 1 | LastName | Last name on the demographics tab |
| 2 | FirstName | First name on the demographics tab |
| 3 | MiddleName | Middle name on the demographics tab |
| 4 | Last4ofSSN | Last 4 digits of Social Security Number on the demographics tab |
| 5 | Category | Staff member's category description |
| 6 | DateofBirth | Date of birth on the demographics tab in the format M/d/yyyy |
| 7 | IdentificationNumber | SMID / State Id Number on the demographics tab |
| 8 | Status | Employment statue field on the demographics tab. Active=Active and Archive=Inactive |
| 9 | HireDate | Date of hire on the demographics tab in the format M/d/yyyy |
| 10 | Alias | Always blank |
| 11 | Work Email | The first email set as Work under Demographics>>Contac |
| 12 | TerminationDate | The Employment End Date on the first record that is found with any of these exit codes: 25 |
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article