Meeting Details

Date/Time/Location

Attendees

Attendee	Present	Notes
Ann Crawford (Unlicensed)
Alyssa Keehan (Unlicensed)
Tedi Tehrani

Meeting Goals and Expected Preparation

Goals

• Check in on reporting status

Expected Preparation

• None

Agenda

Requirements

need employee organization hierarchy tied to position

• need to search by employee name and position
• update API to include position (includes reports to and type of position eg(faculty, staff, student , etc) ; location of position on site or remove location; 
• Employee - personal contact info: name, address, phone, email(campus and personal email)- get emergency contact info (each employee may have one or more contacts: this is in UC PATH
• employee is one table and position is another one to may positions to employee ; employee can have multiple supervisors
• can't work for multiple locations
• employees active as of the date of executing the report, need to look at start and end dates in position

Visuals 

• show the hierarchy (org chart) of the position
• show the hierarchy (org chart) of the people

Data

There is an employee entity in the payroll dataflow in ws_payroll https://app.powerbi.com/groups/2fcbdce9-6670-4dc7-bca5-b98ded13dd36/list

Action Items

• Ann Crawford (Unlicensed) - find old report
•