Share 911 Export

Modified on Tue, Mar 7, 2023 at 9:56 AM

Overview

This task creates an Excel (XLSX) file for Share 911 that contains basic staff demographic, contact, and position information.

Files are sent via SFTP

All Active Staff members are included.

Takes Staff member's most recent contractual Position Tracking record.

Takes Staff member's first contact listed as an emergency contact.

Data is sorted by staff name.

Column	Description	Notes
1	Employee ID	Staff ID
2	Emails	List of all emails for staff
3	First Name	First name on the demographics tab
4	Last Name	Last name on the demographics tab
5	Title	Description of staff member's position on their position tracking record
6	Mobile
7	Manager IDs
8	Channel IDs
9	Emergency Contact Name	Staff member's first emergency contact's name
10	Emergency Contact Phone	Staff member's first emergency contact's phone number
11	Emergency Contact Email	Staff member's first emergency contact's email
12	Permissions
13	User Groups