Vector Solutions Export

Modified on Fri, Aug 11, 2023 at 2:50 PM

Overview

This task creates a comma-separated value (CSV) file for Vector Solutions that contains basic staff demographic, contact, and position information.

All Active Staff members are included.

Uses most recent contractual Position Tracking records.

Data is sorted by staff name.

The file does not contain a header row.

Column	Description	Notes
A	External ID	Schoolfi Staff Id
B	Username	Staff's portal user logon id
C	First Name	First name on the demographics tab
D	Middle Name	Middle name on the demographics tab
E	Last Name	Last name on the demographics tab
F	Email	Staff's primary email address
G	Phone	Staff's primary phone number
H	Address 1	Legal residence street address
I	Address 2	Legal residence apt number, etc.
J	Address 3
K	City	Legal residence city
L	State	Legal residence state
M	Postal Code	Legal residence zip code
N	Country	USA
O	Job Title	Job Title on staff's most recent contractual position tracking record
P	Job Location	Position Location on staff's most recent contractual position tracking record
Q	Job Position	Position Description on staff's most recent contractual position tracking record
R	Begin Date	Start Date on staff's most recent contractual position tracking record
S	End Date	End Date on staff's most recent contractual position tracking record
T	Permissions	Left blank