PRINT TIERED FRINGE ANALYSIS REPORT

Use this screen to create a report reflecting the total number of hours worked by employees of a union. From this report you will be able to determine the affected crew employees for a fringe percentage change. You will have to enter these fringe changes manually.

This report will include crew employees based on a timesheet date range, the local, and the employees' general labor category.

Use this screen after converting crew timesheets to Costpoint timesheets.

Sort

Use the options in this group box to determine how you will sort the report.

Employee Name

Select this radio button to sort this report by the employee name.

Employee ID

Select this radio button to sort this report by the employee ID.

Select

Union Code

Enter, or use Lookup to select, the union code you want included on this report. This is a required field.

Timesheet Date Range

From

Enter, or use Lookup to select, the starting timesheet date for this report. This is a required field.

To

Enter, or use Lookup to select, the ending timesheet date for this report. This is a required field.

Table Information

This screen uses the following tables:

Basic Employee Info - EMPL

Enter Timesheets - TS_HDR_HS

                            TS_LN_HS

Union Profile - UNION_PROFLE

                     UNION_PROFLE_PROJ

                     UNION_PROFLE_FRNG

Labor Settings - LAB_SETTINGS

Labor Group/Union - LAB_GRP

Labor Location/Local - LAB_LOCATION

Enter Crew Timesheets - CREW_TS_HDR

                                    CREW_TS_LN

Report Sources

Column Heading

Screen

Table Name

Union

Union Profile

UNION_PROFILE

Union Description

Labor Group/Union

LAB_GRP

Local

Pay Period

PAY_PD

Local Description

Labor Location/Local

LAB_LOCATION

Deduction/Contribution Code

Maintain Employee Earnings - Deduction subtask/Contributions subtask

EMPL_EARN_DED/ EMPL_EARN_ CONTRB

Deduction/Contribution Description

Deductions

DED_CD

Deduction/Contribution Description

Union Profile

UNION_PROFLE_DED

Employee ID

Basic Employee Info

EMPL

Employee Name

Basic Employee Info

EMPL

Project

Maintain Employee Earnings - Contributions/ Project Distribution

EMPL_E_CNTRB _ PROJ

Deduction Amount

Maintain Employee Earnings - Deductions subtask

EMPL_EARN_DED

Contribution Amount

Maintain Employee Earnings - Contributions subtask

EMPL_EARN_CNTRB

Deduction Code Totals

* No screen - Subtotal by deduction code

 

Local Totals

* No screen - Total of all deduction codes within the local(s) specified.