*HQHUDO
q Jobs and default pay rates are defined on the Jobs form.
2YHUWLPH3D\
q Conditions for awarding overtime are defined on the Time and Attendance form.
Notes
5HSRUWV3URGXFHG:KLOH(PSOR\HHV$UH&ORFNHG,Q
If this report is produced for the current day while employees are clocked in, the report shows a clock in with a date and time, but no clock out for these employees. The hours column shows the number of hours the employees have worked in this shift. The Job Totals and Total Hours Worked This Pay Period fields both include the current hours.
Regular Hours @Job1_Reg_Hours
Total Hours ∑ @Hours_Worked
Regular ∑ regular_hours time_card_dtl reg_hrs
Overtime ∑ overtime_hours time_card_dtl ovt_hrs
Pay Period Totals
Total Hours ∑ @Hours_Worked
Regular Hours ∑ regular_hours time_card_dtl reg_hrs Overtime Hours ∑ overtime_hours time_card_dtl ovt_hrs
Regular Pay ∑ regular_ttl time_card_dtl reg_dtl
Overtime Pay ∑ overtime_ttl time_card_dtl ovt_ttl
Total Pay @ttl_Rate_Total
3XUSRVH
This report summarizes labor information by job. It also provides weekly and period totals.
This information can be useful in analyzing scheduling and the wages of employees. For example, by reviewing this report you could discover that you have scheduled too many individuals in one labor classification and not enough in another.
)RUPDW
This report includes the following profile:
q Employee Labor Profile 7HPSODWH
TIME_003.RPT
2-17
5HSRUWV
View: v_R_employee_job_code
Stored Procedure: sp_R_employee_job_code
The following table lists each column in the Employee Labor Profile and provides detailed information on the source of each figure.
Report
Regular reg_hours dly_emp_job_code_ttl reg_hrs Overtime ovt_hours dly_emp_job_code_ttl otm_hrs
Total @ttl_Hours
% of Ttl @ttl_%_Of_Weekly_Hours
Labor Cost
Regular reg_ttl dly_emp_job_code_ttl reg_ttl Overtime ovt_ttl dly_emp_job_code_ttl otm_ttl
Total @ttl_Cost
% of Ttl @ttl_%_Of_Weekly_Cost
Weekly Total Hours Worked
Regular ∑ reg_hours dly_emp_job_code_ttl reg_hrs Overtime ∑ ovt_hours dly_emp_job_code_ttl otm_hrs
Total ∑ @ttl_Hours
% of Ttl @ttl_%_Of_Employee_Hours
Labor Cost
Regular ∑ reg_ttl dly_emp_job_code_ttl reg_ttl Overtime ∑ ovt_ttl dly_emp_job_code_ttl otm_ttl
Total ∑ @ttl_Cost
% of Ttl @ttl_%_Of_Employee_Cost
Total
Hours Worked
Regular ∑ reg_hours dly_emp_job_code_ttl reg_hrs Overtime ∑ ovt_hours dly_emp_job_code_ttl otm_hrs
Total ∑ @ttl_Hours
% of Ttl @ttl_%_Of_Hours
5HSRUWV
Programming Considerations
*HQHUDO
q Jobs and default pay rates are defined on the Jobs form.
Default pay rates are overridden by Employees | Job Rates | Override Regular Rate and Override Overtime Rate fields.
2YHUWLPH3D\
q Conditions for awarding overtime are defined on the Time and Attendance form.
Notes
5HSRUWV3URGXFHG:KLOH(PSOR\HHV$UH&ORFNHG,Q
If this report is produced for a time period that includes the current day, and employees are clocked in at the time, any hours they have worked in their current shift will be included in the report.
-RE3D\5DWHV
Wages will not reflect a consistent wage rate by job unless all employees clocking in under the same job use the default pay rates defined on the Jobs form.
Regular ∑ reg_ttl dly_emp_job_code_ttl reg_ttl Overtime ∑ ovt_ttl dly_emp_job_code_ttl otm_ttl
Total ∑ @ttl_Cost
% of Ttl @ttl_%_Of_Cost
Grand Total Hours Worked
Regular ∑ reg_hours dly_emp_job_code_ttl reg_hrs Overtime ∑ ovt_hours dly_emp_job_code_ttl otm_hrs
Total ∑ @ttl_Hours
Labor Cost
Regular ∑ reg_ttl dly_emp_job_code_ttl reg_ttl Overtime ∑ ovt_ttl dly_emp_job_code_ttl otm_ttl
Total ∑ @ttl_Cost
3XUSRVH
This report is similar to the Employee Job Summary except information for each employee is consolidated into one set of figures for each job, rather than being individually listed by date. The report also provides totals for each employee for the period of the report, and grand total figures that include all employees on the report.
)RUPDW
This report includes the following profile:
q Employee Labor Profile 7HPSODWH
TIME_004.RPT
2-17
5HSRUWV
View: v_R_employee_job_code
Stored Procedure: sp_R_employee job_code
The following table lists each column in the Employee Labor Profile and provides detailed information on the source of the figures in each column.
Report
Regular reg_hours dly_emp_job_code_ttl reg_hrs Overtime ovt_hours dly_emp_job_code_ttl otm_hrs
Total ∑ @ttl_Hours
% of Ttl @ttl_%_Of_Weekly_Hours
Labor Cost
Regular ∑ reg_ttl dly_emp_job_code_ttl reg_ttl Overtime ∑ ovt_ttl dly_emp_job_code_ttl otm_ttl
Total ∑ @ttl_Cost
% of Ttl @ttl_%_Of_Weekly_Cost
Total
Hours Worked
Regular ∑ reg_hours dly_emp_job_code_ttl reg_hrs Overtime ∑ ovt_hours dly_emp_job_code_ttl otm_hrs
Total ∑ @ttl_Hours
% of Ttl @ttl_%_Of_Hours
Labor Cost
Regular ∑ reg_ttl dly_emp_job_code_ttl reg_ttl Overtime ∑ ovt_ttl dly_emp_job_code_ttl otm_ttl
Total ∑ @ttl_Cost
% of Ttl @ttl_%_Of_Cost
5HSRUWV
Programming Considerations
*HQHUDO
q Jobs and default pay rates are defined on the Jobs form.
Default pay rates are overridden by Employees | Job Rates | Override Regular Rate and Override Overtime Rate fields.
2YHUWLPH3D\
q Conditions for awarding overtime are defined on the Time and Attendance form.
Notes
5HSRUWV3URGXFHG:KLOH(PSOR\HHV$UH&ORFNHG,Q
If this report is produced for a time period that includes the current day, and employees are clocked in at the time, any hours they have worked in their current shift will be included in the report.
-RE3D\5DWHV
Wages will not reflect a consistent wage rate by job unless all employees clocking in under the same job use the default pay rates defined on the Jobs form.
Hours Worked
Regular ∑ reg_hours dly_emp_job_code_ttl reg_hrs Overtime ∑ ovt_hours dly_emp_job_code_ttl otm_hrs
Total ∑ @ttl_Hours
Labor Cost
Regular ∑ reg_ttl dly_emp_job_code_ttl reg_ttl Overtime ∑ ovt_ttl dly_emp_job_code_ttl otm_ttl
Total ∑ @ttl_Cost
3XUSRVH
This report summarizes labor information by job for each revenue center.
It also provides labor category totals, revenue center totals, and daily totals.
)RUPDW
This report includes the following profile:
q Labor/Sales Profile 7HPSODWH
TIME_R011.RPT
2-21
5HSRUWV
5HSRUWV
View: v_R_job_code
Stored Procedure: sp_R_job_code_totals
The following table lists each column in the Labor/Sales Profile and provides detailed information on the source of the figures in each column.
Report
Regular reg_hours dly_job_code_ttl reg_hrs Overtime ovt_hours dly_job_code_ttl otm_hrs
Total @ttl_Hours
Labor Cost
Regular reg_ttl dly_job_code_ttl reg_ttl Overtime ovt_ttl dly_job_code_ttl otm_ttl
Total @ttl_Cost
% of Ttl @ttl_%_Of_Category_Cost
Net Sales net_sls_ttl dly_job_code_ttl net_sls_ttl
% of Ttl @ttl_%_Of_Category_Net_Sales
Labor/Sales @ttl_%_Of_Job_Labor
Job Category Total Hours Worked
Regular ∑ reg_hours dly_job_code_ttl reg_hrs Overtime ∑ ovt_hours dly_job_code_ttl otm_hrs
Total ∑ @ttl_Hours
Labor Cost
Regular ∑ reg_ttl dly_job_code_ttl reg_ttl Overtime ∑ ovt_ttl dly_job_code_ttl otm_ttl
Total ∑ @ttl_Cost
% of Ttl @ttl_%_Of_RVC_Cost
Net Sales ∑ net_sls_ttl dly_job_code_ttl net_sls_ttl
% of Ttl @ttl_%_Of_RVC_Net_Sales
Labor/Sales @ttl_%_Of_Category_Labor
Hours Worked
Regular ∑ reg_hours dly_job_code_ttl reg_hrs Overtime ∑ ovt_hours dly_job_code_ttl otm_hrs
Total ∑ @ttl_Hours
Labor Cost
Regular ∑ reg_ttl dly_job_code_ttl reg_ttl Overtime ∑ ovt_ttl dly_job_code_ttl otm_ttl
Total ∑ @ttl_Cost
% of Ttl @ttl_%_Of_Daily_Cost
Net Sales ∑ net_sls_ttl dly_job_code_ttl net_sls_ttl
% of Ttl @ttl_%_Of_Daily_Net_Sales
Labor/Sales @ttl_%_Of_RVC_Labor
Daily Total Hours Worked
Regular ∑ reg_hours dly_job_code_ttl reg_hrs Overtime ∑ ovt_hours dly_job_code_ttl otm_hrs
Total ∑ @ttl_Hours
Labor Cost
Regular ∑ reg_ttl dly_job_code_ttl reg_ttl Overtime ∑ ovt_ttl dly_job_code_ttl otm_ttl
Total ∑ @ttl_Cost
% of Ttl @ttl_%_Of_Weekly_Cost
Net Sales ∑ net_sls_ttl dly_job_code_ttl net_sls_ttl
% of Ttl @ttl_%_Of_Weekly_Net_Sales
Labor/Sales @ttl_%_Of_Daily_Labor
Weekly Total Hours Worked
Regular ∑ reg_hours dly_job_code_ttl reg_hrs Overtime ∑ ovt_hours dly_job_code_ttl otm_hrs
Total ∑ @ttl_Hours
5HSRUWV
Programming Considerations
*HQHUDO
q Jobs and default pay rates are defined on the Jobs form.
Default pay rates are overridden by Employees | Job Rates | Override Regular Rate and Override Overtime Rate fields.
2YHUWLPH3D\
q Conditions for awarding overtime are defined on the Time and Attendance form.
Notes
5HSRUWV3URGXFHG:KLOH(PSOR\HHV$UH&ORFNHG,Q
If this report is produced for a time period that includes the current day, and employees are clocked in at the time, any hours they have worked in their current shift will be included in the report.
-RE3D\5DWHV
Wages will not reflect a consistent wage rate by job unless all employees clocking in under the same job use the default pay rates defined on the Jobs form.
Regular ∑ reg_ttl dly_job_code_ttl reg_ttl Overtime ∑ ovt_ttl dly_job_code_ttl otm_ttl
Total ∑ @ttl_Cost
% of Ttl @ttl_%_Of_Grand_Cost
Net Sales ∑ net_sls_ttl dly_job_code_ttl net_sls_ttl
% of Ttl @ttl_%_Of_Grand_Net_Sales
Labor/Sales @ttl_%_Of_Weekly_Labor
Grand Total Hours Worked
Regular ∑ reg_hours dly_job_code_ttl reg_hrs Overtime ∑ ovt_hours dly_job_code_ttl otm_hrs
Total ∑ @ttl_Hours
Labor Cost
Regular ∑ reg_ttl dly_job_code_ttl reg_ttl Overtime ∑ ovt_ttl dly_job_code_ttl otm_ttl
Total ∑ @ttl_Cost
Net Sales ∑ net_sls_ttl dly_job_code_ttl net_sls_ttl
Labor/Sales @ttl_%_Of_Grand_Labor
3XUSRVH
This report is similar to the Revenue Center Job Summary except information for each revenue center is consolidated, rather than being individually listed by date.
)RUPDW
This report includes the following profile:
q Labor/Sales Profile 7HPSODWH
TIME_R012.RPT
2-21
5HSRUWV
View: v_R_job_code
Stored Procedure: sp_R_job_code_totals
The following table lists each column in the Labor/Sales Profile and provides detailed information on the source of the figures in each column.
Report
Regular ∑ reg_hours dly_job_code_ttl reg_hrs Overtime ∑ ovt_hours dly_job_code_ttl otm_hrs
Total ∑ @ttl_Hours
Labor Cost
Regular ∑ reg_ttl dly_job_code_ttl reg_ttl Overtime ∑ ovt_ttl dly_job_code_ttl otm_ttl
Total ∑ @ttl_Cost
% of Ttl @ttl_%_Of_Category_Cost
Net Sales ∑ net_sls_ttl dly_job_code_ttl net_sls_ttl
% of Ttl @ttl_%_Of_Category_Net_Sales
Labor/Sales @ttl_%_Of_Job_Labor
Job Category Total Hours Worked
Regular ∑ reg_hours dly_job_code_ttl reg_hrs Overtime ∑ ovt_hours dly_job_code_ttl otm_hrs
Total ∑ @ttl_Hours
Labor Cost
Regular ∑ reg_ttl dly_job_code_ttl reg_ttl Overtime ∑ ovt_ttl dly_job_code_ttl otm_ttl
Total ∑ @ttl_Cost
% of Ttl @ttl_%_Of_RVC_Cost
Net Sales ∑ net_sls_ttl dly_job_code_ttl net_sls_ttl
% of Ttl @ttl_%_Of_RVC_Net_Sales
Labor/Sales @ttl_%_Of_Category_Labor
5HSRUWV
Hours Worked
Regular ∑ reg_hours dly_job_code_ttl reg_hrs Overtime ∑ ovt_hours dly_job_code_ttl otm_hrs
Total ∑ @ttl_Hours
Labor Cost
Regular ∑ reg_ttl dly_job_code_ttl reg_ttl Overtime ∑ ovt_ttl dly_job_code_ttl otm_ttl
Total ∑ @ttl_Cost
% of Ttl @ttl_%_Of_Daily_Cost
Net Sales ∑ net_sls_ttl dly_job_code_ttl net_sls_ttl
% of Ttl @ttl_%_Of_Daily_Net_Sales
Labor/Sales @ttl_%_Of_RVC_Labor
Weekly Total Hours Worked
Regular ∑ reg_hours dly_job_code_ttl reg_hrs Overtime ∑ ovt_hours dly_job_code_ttl otm_hrs
Total ∑ @ttl_Hours
Labor Cost
Regular ∑ reg_ttl dly_job_code_ttl reg_ttl Overtime ∑ ovt_ttl dly_job_code_ttl otm_ttl
Total ∑ @ttl_Cost
% of Ttl @ttl_%_Of_Cost
Net Sales ∑ net_sls_ttl dly_job_code_ttl net_sls_ttl
% of Ttl @ttl_%_Of_Net_Sales
Labor/Sales @ttl_%_Of_Weekly_Labor
Grand Total Hours Worked
Regular ∑ reg_hours dly_job_code_ttl reg_hrs Overtime ∑ ovt_hours dly_job_code_ttl otm_hrs
Total ∑ @ttl_Hours
Programming Considerations
*HQHUDO
q Jobs and default pay rates are defined on the Jobs form.
Default pay rates are overridden by Employees | Job Rates | Override Regular Rate and Override Overtime Rate fields.
2YHUWLPH3D\
q Conditions for awarding overtime are defined on the Time and Attendance form.
Notes
5HSRUWV3URGXFHG:KLOH(PSOR\HHV$UH&ORFNHG,Q
If this report is produced for a time period that includes the current day, and employees are clocked in at the time, any hours they have worked in their current shift will be included in the report.
-RE3D\5DWHV
Wages will not reflect a consistent wage rate by job unless all employees clocking in under the same job use the default pay rates defined on the Jobs form.
Regular ∑ reg_ttl dly_job_code_ttl reg_ttl Overtime ∑ ovt_ttl dly_job_code_ttl otm_ttl
Total ∑ @ttl_Cost
Net Sales ∑ net_sls_ttl dly_job_code_ttl net_sls_ttl
Labor/Sales @ttl_%_Of_Labor
5HSRUWV
3XUSRVH
This report summarizes labor information by job for the entire system.
Labor category totals and daily totals are also provided.
)RUPDW
This report includes the following profile:
q Labor/Sales Profile 7HPSODWH
TIME_S011.RPT
2-21
5HSRUWV
View: v_R_job_code
Stored Procedure: sp_R_job_code_totals
The following table lists each column in the Labor/Sales Profile and provides detailed information on the source of the figures in each column.
Report
Regular ∑ reg_hours dly_job_code_ttl reg_hrs Overtime ∑ ovt_hours dly_job_code_ttl otm_hrs
Total ∑ @ttl_Hours
Labor Cost
Regular ∑ reg_ttl dly_job_code_ttl reg_ttl Overtime ∑ ovt_ttl dly_job_code_ttl otm_ttl
Total ∑ @ttl_Cost
% of Ttl @ttl_%_Of_Category_Cost
Net Sales ∑ net_sls_ttl dly_job_code_ttl net_sls_ttl
% of Ttl @ttl_%_Of_Category_Net_Sales
Labor/Sales @ttl_%_Of_Job_Labor
Job Category Total Hours Worked
Regular ∑ reg_hours dly_job_code_ttl reg_hrs Overtime ∑ ovt_hours dly_job_code_ttl otm_hrs
Total ∑ @ttl_Hours
Labor Cost
Regular ∑ reg_ttl dly_job_code_ttl reg_ttl Overtime ∑ ovt_ttl dly_job_code_ttl otm_ttl
Total ∑ @ttl_Cost
% of Ttl @ttl_%_Of_Daily_Cost
Net Sales ∑ net_sls_ttl dly_job_code_ttl net_sls_ttl
% of Ttl @ttl_%_Of_Daily_Net_Sales
Labor/Sales @ttl_%_Of_Category_Labor
5HSRUWV
Hours Worked
Regular ∑ reg_hours dly_job_code_ttl reg_hrs Overtime ∑ ovt_hours dly_job_code_ttl otm_hrs
Total ∑ @ttl_Hours
Labor Cost
Regular ∑ reg_ttl dly_job_code_ttl reg_ttl Overtime ∑ ovt_ttl dly_job_code_ttl otm_ttl
Total ∑ @ttl_Cost
% of Ttl @ttl_%_Of_Weekly_Cost
Net Sales ∑ net_sls_ttl dly_job_code_ttl net_sls_ttl
% of Ttl @ttl_%_Of_Weekly_Net_Sales
Labor/Sales @ttl_%_Of_Daily_Labor
Weekly Total Hours Worked
Regular ∑ reg_hours dly_job_code_ttl reg_hrs Overtime ∑ ovt_hours dly_job_code_ttl otm_hrs
Total ∑ @ttl_Hours
Labor Cost
Regular ∑ reg_ttl dly_job_code_ttl reg_ttl Overtime ∑ ovt_ttl dly_job_code_ttl otm_ttl
Total ∑ @ttl_Cost
% of Ttl @ttl_%_Of_Cost
Net Sales ∑ net_sls_ttl dly_job_code_ttl net_sls_ttl
% of Ttl @ttl_%_Of_Net_Sales
Labor/Sales @ttl_%_Of_Weekly_Labor
Grand Total Hours Worked
Regular ∑ reg_hours dly_job_code_ttl reg_hrs Overtime ∑ ovt_hours dly_job_code_ttl otm_hrs
Total ∑ @ttl_Hours
3URJUDPPLQJ&RQVLGHUDWLRQV
*HQHUDO
q Jobs and default pay rates are defined on the Jobs form.
Default pay rates are overridden by Employees | Job Rates | Override Regular Rate and Override Overtime Rate fields.
2YHUWLPH3D\
q Conditions for awarding overtime are defined on the Time and Attendance form.
Notes
5HSRUWV3URGXFHG:KLOH(PSOR\HHV$UH&ORFNHG,Q
If this report is produced for a time period that includes the current day, and employees are clocked in at the time, any hours they have worked in their current shift will be included in the report.
-RE3D\5DWHV
Wages will not reflect a consistent wage rate by job unless all employees clocking in under the same job use the default pay rates defined on the Jobs form.
Regular ∑ reg_ttl dly_job_code_ttl reg_ttl Overtime ∑ ovt_ttl dly_job_code_ttl otm_ttl
Total ∑ @ttl_Cost
Net Sales ∑ net_sls_ttl dly_job_code_ttl net_sls_ttl
Labor/Sales @ttl_%_Of_Labor
5HSRUWV
3XUSRVH
This report is similar to the System Job Summary except information for each revenue center is consolidated, rather than being individually listed by date.
)RUPDW
This report includes the following profile:
q Labor/Sales Profile 7HPSODWH
TIME_S012.RPT
2-21
5HSRUWV
View: v_R_job_code
Stored Procedure: sp_R_job_code_totals
The following table lists each column in the Labor/Sales Profile and provides detailed information on the source of the figures in each column.
Report
Regular ∑ reg_hours dly_job_code_ttl reg_hrs Overtime ∑ ovt_hours dly_job_code_ttl otm_hrs
Total ∑ @ttl_Hours
Labor Cost
Regular ∑ reg_ttl dly_job_code_ttl reg_ttl Overtime ∑ ovt_ttl dly_job_code_ttl otm_ttl
Total ∑ @ttl_Cost
% of Ttl @ttl_%_Of_Category_Cost
Net Sales ∑ net_sls_ttl dly_job_code_ttl net_sls_ttl
% of Ttl @ttl_%_Of_Category_Net_Sales
Labor/Sales @ttl_%_Of_Job_Labor
Job Category Total Hours Worked
Regular ∑ reg_hours dly_job_code_ttl reg_hrs Overtime ∑ ovt_hours dly_job_code_ttl otm_hrs
Total ∑ @ttl_Hours
Labor Cost
Regular ∑ reg_ttl dly_job_code_ttl reg_ttl Overtime ∑ ovt_ttl dly_job_code_ttl otm_ttl
Total ∑ @ttl_Cost
% of Ttl @ttl_%_Of_RVC_Cost
Net Sales ∑ net_sls_ttl dly_job_code_ttl net_sls_ttl
Net Sales ∑ net_sls_ttl dly_job_code_ttl net_sls_ttl