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.
Use the options in this group box to determine how you will sort the report.
Select this radio button to sort this report by the employee name.
Select this radio button to sort this report by the employee ID.
Enter, or use Lookup to select, the union code you want included on this report. This is a required field.
Enter, or use Lookup to select, the starting timesheet date for this report. This is a required field.
Enter, or use Lookup to select, the ending timesheet date for this report. This is a required field.
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
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. |
|