Public School Works Export

Modified on Mon, Aug 19 at 3:11 PM

Overview

This task creates a comma-separated value (CSV) file for Public School Works that contains basic staff demographic information.

Active Staff members are included by default.

1 staff member per row.

Data is sorted by staff name.

The file does contain a header row.

Column	Column	Description	Notes
1	A	Unique ID	Staff Id
2	B	First Name	First name on the demographics tab
3	C	Last Name	Last name on the demographics tab
4	D	Email Address	Primary Email in contacts tab
5	E	Username	Portal User Logon Id
6	F	Password	Left Blank
7	G	Primary Work Site	Primary Location name on demographics tab
8	H	Primary Occupation	Current Position Tracking Record description, Primary Department name, or Category description depending on data selection option
9	I	Secondary Occupation	Visible if the option is selected - 2nd Current Position Tracking Record description
10	J	Department	Primary Department name, or Category 2 description depending on data selection option
11	K	Supervisor Email	Visible if the option is selected - left blank
12	L	Training Start Date	Visible if the option is selected - left blank