This report identifies all active employees without reports to.

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 provides year-end vacation balance projections.

This report was developed using the following dataset:

• AM_Accruals_Snowflake

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

• Campus
• Department
• Hierarchy Name
• Tree Level 1
• College (Level 2)
• Division (Level 3)
• Tree Level 4
• Tree Level 5
• As Of Date

This report contains the following report fields:

• Campus
• Division
• College/Area
• Dept Id
• Department Name
• Employee Name
• Empl Id
• Empl Rcd
• Job Code
• Job Title
• Union ID
• Manager/Supervisor Position Nbr
• Manager/Supervisor EmplID
• Manager/Supervisor Name
• Est. Vacation Balance
• Max Vacation Hrs Allowed
• Max Vacation Days Allowed
• Projected Hours Over Max
• Est. State Service Level
• Projected Days Over Max

This report identifies all active student employees.

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
• Jobcode
• Employee Status
• As Of Date
• 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:

• Business Unit
• Dept ID
• Description
• Employee ID
• Name
• Jobcode
• Description
• Position Number
• Description
• Position Union Cd
• Grade (job)
• Grade (Position)
• CSU Unit
• Serial Number
• Job Action
• Action Reason

Comprate

• Annual Rate
• FTE
• Faculty Fraction
• Reports To
• Reports To Dotted Line
• Report Dotted Line Employee Name
• Supervisor Incumbent EmplID
• Supervisor Incumbent Name
• Last Assign Start Date
• Job Hire Date
• Assign Start Date
• Eff Date
• Assign End Date
• Last Updated Date Time
• Last Updated OprID
• Last Update Date

This report identify if someone should earn HC/ADO based on their schedule and did not enter it.

This report was developed using the following dataset:

• AM_ADO_HC_Earn

• Campus
• GP Pay Group

This report contains the following report fields:

• Campus
• Employee ID
• Employee Name
• Empl Rcd
• CSU Unit
• Department ID
• Department Descr
• Schedule
• GP Pay Group
• Holiday Date
• Holiday Descr

Identifies when sick/vacation, etc. is entered on a campus holiday to reach out to the employee to correct.

This report was developed using the following dataset:

• AM_Check_Time_on_Holiday

• Campus
• Absence Type

This report contains the following report fields:

• Campus
• Employee ID
• Employee Name
• Empl Rcd
• CSU Unit
• Department ID
• Department Descr
• Absence Type
• Absence Date • Holiday
• Holiday Descr
• Hours Reported

This report helps to identify errors where employees enter Holiday CTO on days that are not holidays.

This report was developed using the following dataset:

• AM_CTO_Holiday

• Campus
• Absence Type
• GP Pay Group

This report contains the following report fields:

• Campus
• Employee ID
• Employee Name
• Empl Rcd
• CSU Unit
• Department ID
• Department Descr
• Absence Type
• Absence Date
• GP Pay Group
• Hours Reported

This report identifies R06 employees with CTO balance over 240 hours; R02, R04, R05, R07, R09, R10, E99, and C99 employees with CTO balance over 120 hours; and R08 employees with CTO balance over 200 hours.

This report was developed using the following dataset:

• AM_CTO_Balance

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

• Campus
• Union Code

This report contains the following report fields:

• Campus
• Employee ID
• Employee Name
• Empl Rcd
• Union Code
• Union Code Descr
• FLSA Status
• CSU Unit
• Department ID
• Department Descr
• CTO Over
• CTO Balance

Identifies employees who have a negative balance before the current month accrual is posted. This report is focused on checking adjustments.

This report was developed using the following dataset:

• AM_Employee_Negative_Time

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

• Campus
• Department ID
• Job Code
• Absence Type
• GP Pay Type

This report contains the following report fields:

• Campus
• Employee ID
• Employee Name
• Empl Rcd
• CSU Unit
• Department ID
• Department Descr
• Job Code
• Job Code Descr
• Absence Type
• GP Pay Group
• Hrs Calculated

Exempt employees with CTO balances (or other) that they are not eligible for. This report is used to flag users to pay the time out (if applicable).

This report was developed using the following dataset:

• AM_Exempt_Ineligible_Balance

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

• Campus
• GP Pay Group

This report contains the following report fields:

• Campus
• Employee ID
• Employee Name
• Empl Rcd
• CSU Unit
• Department ID
• Department Descr
• GP Pay Group
• Absence Type
• Absence Amount

Identify employees using too much funeral leave (> 24 hrs or > 40 hrs, as appropriate).

This report was developed using the following dataset:

• AM_Funeral_Leave_Audit

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

• Campus
• Department ID
• GP Pay Group

This report contains the following report fields:

• Campus
• Employee ID
• Employee Name
• Empl Rcd
• CSU Unit
• Department ID
• Department Descr
• GP Pay Group
• Absence Date
• Absence Type
• Absence Reason
• Absence Comments
• Reports To Name

This will show employees who take more than 30 days (240 hours) parental/maternity leave.

This report was developed using the following dataset:

• AM_Parental_Leave_Audit

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

• Campus
• Department ID
• GP Pay Group
• Absence Type

This report contains the following report fields:

• Campus
• Employee ID
• Employee Name
• Empl Rcd
• CSU Unit
• Department ID
• Department Descr
• GP Pay Group
• Absence Type
• Absence Date
• Work Schedule
• Hours

Non-exempt, part-time employees with no schedule.

This report was developed using the following dataset:

• AM_NonExempt_PartTime_No_Sched

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

• Campus

This report identifies part-time employees submitting CTO, Holiday CTO, or CTS.

This report was developed using the following dataset:

• AM_Exempt_PartTime_CTO_Earn

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

• Campus

Rehired Annuitants enrolled in FERP Eligibility Group. To identify and fix. (Please note: This audit report may appear blank if there are no Rehired Annuitants enrolled in a FERP related Eligibility Group.)

This report was developed using the following dataset:

• Adhoc_dl_employment_Snowflake

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

• None

Identify terminated employees with leave balances over 6 to 10 months.

This report was developed using the following dataset:

• AM_Employees_Terminated_Over_6_10_Months_Balance

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

• Campus
• Department ID
• Job Code
• Absence Type
• GP Pay Group

This report contains the following report fields:

• Campus
• Employee ID
• Employee Name
• Empl Rcd
• CSU Unit
• Department ID
• Department Descr
• GP Pay Group
• Termination Date
• Absence Type
• Hours

End of Article