Employee Information Reporting for AB 119



Description of Issue

Need to report employee information to collective bargaining groups, per AB 119.



Context
  • Payroll

  • Reporting



Cause

California Assembly Bill (AB) 119 requires public employers to provide a union representative with the name, job title, department, work location, work and home address, personal cellular telephone number and personal email address on file with the employer of newly hired employees within 30 days of hire or by the first pay period of the month following hire. Additionally, public employers must provide this information to the exclusive representative for all employees in the bargaining unit at least once every 120 days, unless the parties can agree to different time frames.



Resolution

Use the Employee Inquiry program to produce the report in Excel. 

  1. Open the Employee Inquiry program

  2. Select Search

  3. Select Status Active

  4. Select Accept

  5. Select Excel

  6. Use the Select column of the Export filter to select the data you need to include

  7. Select Save so you don't have to repeat this step each time you need the report

  8. Select Accept to produce the Excel file

Excel will allow you to filter by Group/BU as needed.  You could also choose to include Group/BU in the Employee Inquiry Search and create a separate file for each applicable Group/BU.