Report to compare the fields & report if there is a change between the two tables (PS_JOB vs. PS_Position). Two separate reports were created to fulfill this requirement. This report displays job data only. See the Active Position (Position Data) Report Specification to see the report that display position data.

This report was developed using the following dataset:

• WA_Dataset-Active_Position_Job_Data_Snowflake

This report contains the following Control Prompts to allow users to filter data:

• Business Unit
• Department
• CBID
• Job Code
• Position Number
• As of Date
• Tree Name
• Dept Level 1
• Dept Level 2
• Dept Level 3
• Dept Level 4
• Dept Level 5

This report contains the following report fields:

• Business Unit
• Dept ID
• Department
• Position Number
• Position Descr
• Regular/Temp
• Full/Part Time
• CBID
• Job Code
• Job Code Descr
• Company
• Location
• Reports To ID
• Salary Admin. Plan
• Grade
• Step
• Standard Hours
• Standard Hours Frequency
• FLSA Status
• CSU Unit
• Primary Fund
• Business Title
• CSU MPP Job Family
• CSU MPP Job Func
• CSU MPP Rpt Cat

Report to compare the fields & report if there is a change between the two tables (PS_JOB vs. PS_Position). Two separate reports were created to fulfill this requirement. This report displays position data only. See the Active Position (Job Data) Report to see the report that display job data.

This report was developed using the following dataset:

• WA_Dataset-Active_Position_Position_Data_Snowflake

This report contains the following Control Prompts to allow users to filter data:

• Business Unit
• Department
• Job Code
• CBID
• Position
• As of Date
• Tree Name
• Dept Level 1
• Dept Level 2
• Dept Level 3
• Dept Level 4
• Dept Level 5

This report contains the following report fields:

• Business Unit
• Dept ID
• Dept Descr
• Position Number
• Position Descr
• Regular/Temp
• Full/Part Time
• CBID
• Job Code
• Company
• Location
• Reports To Empl ID
• Reports To Name
• Salary Admin. Plan
• Grade
• Step
• Standard Hours
• Standard Hours Frequency
• FLSA Status
• CSU Unit
• Primary Fund
• Business Title
• CSU MPP Job Family
• CSU MPP Job Func
• CSU MPP Rpt Cat

This report displays employees with address changes.

This report was developed using the following dataset:

• WA_Dataset-Address_Change_Snowflake

This report contains the following Control Prompts to allow users to filter data:

• Business Unit
• Department
• As Of Date
• Last Update Date (Address)
• Address Type
• Tree Name
• Dept Level 1
• Dept Level 2
• Dept Level 3
• Dept Level 4
• Dept Level 5

This report contains the following report fields:

• Business Unit
• Dept ID
• Department
• Employee ID
• Name
• Address Type
• Address1
• Address2
• Address3
• Address4
• City
• State
• Postal
• Effective Date
• Last Updated Date
• Last Updated OPRID
• Lastupddttm
• Last Updated Employee Name
• Reports To
• Supervisor Incumbent Emplid
• Supervisor Incumbent Name

This report display's the position's reporting structure for active employees.

This report was developed using the following dataset:

• WA_Dataset-Reporting_Structure_Only_Snowflake

This report contains the following Control Prompts to allow users to filter data:

• Business Unit
• Department

Position Effective Status

Position Number

As of Date

Tree Name

• Dept Level 1
• Dept Level 2
• Dept Level 3
• Dept Level 4
• Dept Level 5

This report contains the following report fields:

• Business Unit
• Name
• Employee ID
• Dept ID
• Department
• Position Number
• Position Description
• Position Effective Status
• Reports To
• Supervisor Incumbent Emplid
• Supervisor Incumbent Name

This report displays job data for active student employees.

This report was developed using the following dataset:

• WA_Dataset-All_Active_Student_Employees_Snowflake

This report contains the following Control Prompts to allow users to filter data:

• Business Unit
• Department
• Job Code
• Empl Status
• Effective Date Before
• CSU Payroll Status
• Tree Name
• Dept Level 1
• Dept Level 2
• Dept Level 3
• Dept Level 4
• Dept Level 5

This report contains the following report fields:

• Company
• Business Unit
• Dept ID
• Department
• Employee ID
• Name
• Job Code
• Job Code Descr
• Position Number
• Position Descr
• Reports To
• Supervisor Incumbent Emplid
• Supervisor Incumbent Name
• Action
• Action Reason
• Last Asgn Start Dt
• Hire Dt
• Asgn Start Dt
• Effective Date
• Expected End Date
• Last Update OprID
• Last Update Employee Name
• Last Update Date/Time

This report displays the employee’s highest level of education and degree. This report allows users to audit and compare the employee's Highest Education Level and Degree.

This report was developed using the following dataset:

• WA_Dataset-Audit_Highest_Education_Level_Against_Degree_Snowflake

This report contains the following Control Prompts to allow users to filter data:

• Business Unit
• Department
• Job Code
• Highest Education Level
• As of Date
• Tree Name
• Dept Level 1
• Dept Level 2
• Dept Level 3
• Dept Level 4
• Dept Level 5

This report contains the following report fields:

• Business Unit
• Department
• Employee ID
• Employee Name
• Empl Rcd
• Orig Hire Dt
• Effective Date
• Last Hire Dt
• Job Code
• Job Code Descr
• Highest Level of Education
• Degree
• Major
• School
• Date Degree Attained

This report displays job related data for employees.

This report was developed using the following dataset:

• WA_Dataset-Dept_View_of_Employees_Snowflake

This report contains the following Control Prompts to allow users to filter data:

• Business Unit
• Department
• Position Number
• Job Code
• Empl Status
• Employee Class
• Data As Of
• Tree Name
• Dept Level 1
• Dept Level 2
• Dept Level 3
• Dept Level 4
• Dept Level 5

This report contains the following report fields:

• Business Unit
• Dept ID
• Dept Descr
• Employee ID
• Empl Rcd
• Name
• Position Number
• Position Descr
• Job Indicator
• Job Code
• CSU Working Title
• CSU Prob Cd
• Employee Class Descr
• Hire Dt
• Orig Hire Dt
• Last Hire Dt
• FTE
• Comp Frequency
• Salary Admin. Plan
• Pay Grade
• Comprate
• Monthly Rt
• Annl Benef Base Rt
• Reports To
• Supervisor Incumbent Emplid
• Supervisor Incumbent Name

This report displays employees who have a terminal degree for their discipline.

This report was developed using the following dataset:

• WA_Dataset-Employees_who_have_Terminal_Degrees_Snowflake

• Job Code
• Highest Education Level
• As Of Date
• Tree Name
• Dept Level 1
• Dept Level 2
• Dept Level 3
• Dept Level 4
• Dept Level 5

This report contains the following report fields:

• Business Unit
• Department
• Employee ID
• Employee Name
• Empl Rcd
• Orig Hire Dt
• Effective Date
• Last Hire Dt
• Job Code
• Job Code Descr
• Highest Education Level
• Degree
• Major
• School
• Date Attained

This report displays employees with a degree from a CSU campus.

This report was developed using the following dataset:

• WA_Dataset-Employees_with_Degrees_from_CSU_Snowflake

• Job Code
• Degree
• As of Date
• Tree Name
• Dept Level 1
• Dept Level 2
• Dept Level 3
• Dept Level 4
• Dept Level 5

This report contains the following report fields:

• Business Unit
• Department
• Employee ID
• Employee Name
• Empl Rcd
• Orig Hire Dt
• Effective Date
• Last Hire Dt
• Job Code
• Job Code Descr
• Highest Level of Education
• Degree
• Major
• CSU School
• Dates Degree Attained

This report displays employees whose work authorization in the U.S. is expiring.

This report was developed using the following dataset:

• WA_Dataset-Expiring_Work_Authorization_Snowflake

• Visa Permit Status
• Visa Expiration Date
• Employee Type
• Tree Name
• Dept Level 1
• Dept Level 2
• Dept Level 3
• Dept Level 4
• Dept Level 5

This report contains the following report fields:

• Business Unit
• Employee ID
• Employee Name
• Employee Class
• Employee Type
• Birth Country
• Address 1
• Address 2
• City
• State
• Postal
• Visa Permit Class
• Visa Permit Type
• Visa Permit Type Desclong
• Visa Permit Status
• Effective Date
• Visa Expiration Date
• Country Issued

The purpose of this report is to provide license details or various Expiration dates that exist for employees in PS. This report will be available along with other sets of HR audit reports.

This report was developed using the following dataset:

• WA_Dataset-Audit_Highest_Education_Level_Against_Degree_Snowflake

This report contains the following Control Prompts to allow users to filter data:

• Business Unit
• Union Code
• Expiration Date w/in next 45 days

This report contains the following report fields:

• Business Unit
• Dept ID
• Department
• EmplID
• Employee Name
• Empl Rcd
• HR Status
• Empl Status
• Union Code
• Job Code
• Job Code Descr
• Empl Class
• CSU Unit
• Type
• License Type
• License Descr
• Effective Status
• Date Issued
• Expiration Date

This report displays data to help users monitor employee data.

This report was developed using the following dataset:

• WA_Dataset-Monitor_Employee_Data_Report_Snowflake

This report contains the following Control Prompts to allow users to filter data:

• Business Unit
• Department
• Job Code
• As Of Date
• Tree Name
• Dept Level 1
• Dept Level 2
• Dept Level 3
• Dept Level 4
• Dept Level 5

This report contains the following report fields:

• Business Unit
• Dept ID
• Department
• Employee ID
• Employee Name
• Effective Date
• Hire Date
• Job Code
• Job Code Descr
• Email Address (Bus)
• Phone Number (Bus)

This report displays academic employees who are new hires.

This report was developed using the following dataset:

• WA_Dataset-New_Hire_Academic_Employee_Snowflake

This report contains the following Control Prompts to allow users to filter data:

• Business Unit
• Union Code (CBID)
• Job Code
• Employee Class
• Original Hire Date Between
• Position Hire Date Between
• Tree Name Equals
• Dept Level 1
• Dept Level 2
• Dept Level 3
• Dept Level 4
• Dept Level 5
• As Of Date

This report contains the following report fields:

• Business Unit
• Division (Level 2)
• College (Level 3)
• Dept ID
• Dept Descr
• Name
• Employee ID
• Empl Rcd
• Job Code
• Job Code Descr • Union Code
• Employee Class
• Empl Class Descr • Grade
• Original Hire Date
• Effective Date
• Position Entry Date
• Exptected End Date
• Tenure-Track Hire Date
• Labor Faculty Entry Date
• Pay End Date
• Annual Rt
• Monthly Rt
• Hourly Rt
• FTE
• Comprate
• Paid FTE
• Faculty Fraction
• Supervisor Incumbent Emplid
• Supervisor Incumbent Name

This report displays employees who are new hires.

This report was developed using the following dataset:

• WA_Dataset-New_Hire_Employee_Snowflake

This report contains the following Control Prompts to allow users to filter data:

• Business Unit
• Union Code (CBID)
• Job Code
• Employee Class
• Original Hire Date Between
• Position Hire Date Between
• Tree Name Equals
• Dept Level 1
• Dept Level 2
• Dept Level 3
• Dept Level 4
• Dept Level 5
• As Of Date

This report contains the following report fields:

• Business Unit
• Division (Level 2)
• College (Level 3)
• Dept ID
• Department
• Employee ID
• Name
• Job Code
• Job Code Descr
• Employee Class
• Empl Class Descr
• Empl Rcd
• Grade
• Original Hire Date
• Position Entry Date
• Effective Date
• Action Dt

Expected End Date

Supervisor Incumbent Emplid

Supervisor Incumbent Name

This report display's employees whose country of citizenship is not "USA", or whose visa permit class is A or W.

This report was developed using the following dataset:

• WA_Dataset-NRA_and_RA_Report_Snowflake

This report contains the following Control Prompts to allow users to filter data:

• Business Unit
• Department

Job Code

As Of Date

Tree Name

Dept Level 1

• Dept Level 2
• Dept Level 3
• Dept Level 4
• Dept Level 5
• Visa Permit Class

This report contains the following report fields:

• business_unit
• Department
• Employee ID
• Name
• Job Code
• Country (Visa Country)
• Citizenship Status
• Visa Permit Type
• Visa Class Description
• Visa Expiration Date
• Issuing Authority

This report displays position rows where the Reports_To field is blank.

This report was developed using the following dataset:

• WA_Dataset-Position_Audit_Snowflake

This report contains the following Control Prompts to allow users to filter data:

• Business Unit
• Department ID
• Job Code
• Position Number
• Position Effective Status equals
• As Of Date
• Tree Name Equals
• Dept Level 1
• Dept Level 2
• Dept Level 3
• Dept Level 4
• Dept Level 5

This report contains the following report fields:

• Business Unit
• Dept ID
• Dept Descr
• Position Number
• Position Title
• Job Code
• Job Code Description
• Primary Fund
• Reports To
• Supervisor Incumbent Emplid
• Supervisor Incumbent Name
• FTE

This report displays position data and the current Position_Pool_ID

This report was developed using the following dataset:

• WA_Dataset-Position_Pool_ID_Snowflake

This report contains the following Control Prompts to allow users to filter data:

• Business Unit
• Department ID
• Position Number
• Job Code
• As Of Date
• Tree Name Equals
• Dept Level 1
• Dept Level 2
• Dept Level 3
• Dept Level 4
• Dept Level 5

This report contains the following report fields:

• Business Unit
• Position Number
• Position Descr
• Dept ID
• Dept Descr
• Job Code
• Working Title
• FTE
• Position Pool ID

This report displays employees with a preferred name change for directory.

This report was developed using the following dataset:

• WA_Dataset-Preferred_Name_Change_Report_Snowflake

This report contains the following Control Prompts to allow users to filter data:

• Business Unit
• Department ID
• Name Effective Date Before
• Tree Name
• Dept Level 1 Dept Level 2 Dept Level 3
• Dept Level 4
• Dept Level 5

This report contains the following report fields:

• Business Unit
• Employee ID
• Current Preferred Name
• Previous Preferred Name
• Dept ID
• Department
• Job Code
• Job Code Descr

This report displays position rows where the Reports_To field is blank.

This report was developed using the following dataset:

• WA_Dataset-Reports_to_Blank_Snowflake

This report contains the following Control Prompts to allow users to filter data:

• Business Unit
• Department
• Position Number
• Tree Name
• Dept Level 1
• Dept Level 2
• Dept Level 3
• Dept Level 4
• Dept Level 5
• As Of Date

This report contains the following report fields:

• Business Unit
• Employee ID
• Name
• Employee Record Number
• Dept ID
• Department
• Union Code
• Union Code Descr
• Jobcode
• Jobcode Descr
• Employee Position Number
• Position Descr Short
• Description
• Effective Status
• FTE
• Reports To
• Supervisor Empl ID
• Supervisor Incumbent Name

Supervisor Incumbent Position #

Report of employees retired in the last 180 days

This report was developed using the following dataset:

• WA_Dataset-Retired_Employees_180_Days_Snowflake

This report contains the following Control Prompts to allow users to filter data:

• Business Unit
• Department
• Job Code
• Union Code
• Tree Name
• Dept Level 1
• Dept Level 2
• Dept Level 3
• Dept Level 4
• Dept Level 5

This report contains the following report fields:

• Business Unit
• Employee ID
• Employee Name
• Job Code
• Union Code
• Termination Date
• Days Since Retirement <=180

This report displays vacant positions.