This report allows campus users to monitor their student employees' actual workload.

This report was developed using the following datasets:

• TL_Dataset-Student_Hours_Snowflake
• TL_Dataset-General_Snowflake
• TL_Dataset-Workgroup_Change_Snowflake

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

• Business Unit
• As of Date
• Exception Descr
• Department Tree Name
• Department Level 1
• Department Level 2
• Department Level 3
• Department Level 4
• Department Level 5

This report contains the following report fields:

• Business Unit
• Employee Name
• Employee ID
• Employee Record
• Department
• Job Code
• Job Title
• TRC
• Pay End Date
• Reports To
• Week Begin
• Week End
• FTE
• Quantity
• Weeks > 20
• > 20 Hrs a Week

This report identifies employees in more than one dynamic group.

This report was developed using the following dataset:

• TL_Dataset-General_Snowflake

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

• Business Unit
• HR Status
• As of Date
• Tree Name
• Department Level 1
• Department Level 2
• Department Level 3
• Department Level 4
• Department Level 5

This report contains the following report fields:

• Business Unit
• Employee Name
• Employee ID
• Employee Record
• Payroll Status
• Job Code
• Employee Type
• Employee Class
• Group ID
• T&L Group Type
• Count

This report identifies employees not in any dynamic group.

This report was developed using the following dataset:

• TL_Dataset-General_Snowflake

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

• Business Unit
• HR Status
• As of Date
• Department Tree
• Department Level 1
• Department Level 2
• Department Level 3
• Department Level 4
• Department Level 5

This report contains the following report fields:

• Business Unit
• Employee Name
• Employee ID
• Employee Record
• Department
• Payroll Status
• Employee Class
• Job Code
• Employee Type
• Effective Date

This report identifies employees with a mid-month job change (in Union Code and/or Employee Type) involving workgroups.

This report was developed using the following dataset:

• TL_Dataset-Workgroup_Change_Snowflake

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

• Business Unit
• HR Status
• Employee Class
• As of Date
• Department Tree
• Department Level 1
• Department Level 2
• Department Level 3
• Department Level 4
• Department Level 5

This report contains the following report fields:

• Business Unit
• Employee Name
• Employee ID
• Employee Record
• Department
• Job Effective Date
• HR Status
• Prior Union Code
• Union Code
• Prior Employee Type
• Employee Type
• Workgroup
• Effective Date

This report identifies employees with no TL setup and incomplete TL setup.

This report was developed using the following dataset:

• TL_Dataset-General_Snowflake

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

• Business Unit
• As of Date
• Job Code
• Paygroup
• Tree Name
• Dept Level 1
• Dept Level 2
• Dept Level 3
• Dept Level 4
• Dept Level 5
• Dept ID

This report contains the following report fields:

• Business Unit
• Company
• Job Emplid
• Job Employee Rcd
• T&L Employee ID
• T&L Employee Rcd
• Name
• Dept ID
• Description
• Job Effective Date
• Employee Status
• Employee Class
• Job Code
• Employee Type
• Workgroup
• Task Group
• Paygroup Fdescr
• Action
• Job Action Date
• Time Reporting Status
• Flag Inactive in T&L
• Flag Not in T&L
• Flag Workgroup

This report identifies employees with Orphan Dynamic Group Row Security rows.

This report was developed using the following dataset:

• TL_Dataset-General_Snowflake

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

• Business Unit
• As of Date
• Group ID
• Group Description
• Group Type Indicator

This report contains the following report fields:

• Business Unit
• Row Sec Class
• TL Group ID
• TL Group Descr

End of Article