Data Views and Standard Log Reports - HR Module - Labor Timecards
Data Views - Primary
- vw_ProjectInfo
- vw_ProjectInfoSimple
- vw_PrimeContractInfo
- vw_PrimeContractInfoSimple
- vw_EmployeeInfo
- vw_LaborTimecardsHR (Includes Cost and Bill Rates)
- vw_LaborTimecardsClockInOutRawData
- vw_LaborTimecardsBreakStartEndRawData
Data Views - Optional
- vw_CompanyInfo
- vw_CompanyInfoSimple
- vw_ContactInfo
- vw_JobCostCodes
- vw_ChangeOrderInfo
- vw_ChangeOrderInfoSimple
- vw_WorkOrderInfo
- vw_WorkOrderInfoSimple
Standard Log Reports - HR Module - Cross Project - Labor Timecards
| Report Name | Filter Parameters |
| Cross Project - Labor Timecards Grouped by Employee | TimecardFromDate, TimecardToDate, TimecardStatus, EmployeeId, PayrollItemId |
| Cross Project - Labor Timecards Grouped by Employee With Billable Info | TimecardFromDate, TimecardToDate, TimecardStatus, EmployeeId, PayrollItemId |
| Cross Project - Labor Timecards Grouped by Export Status, Employee and Project | TimecardFromDate, TimecardToDate, Exported |
| Cross Project - Labor Timecards Grouped by Project And Employee | PayrollItemId TimecardFromDate, TimecardToDate, TimecardStatus, EmployeeId, PayrollItemId |
| Cross Project - Labor Timecards Grouped by Project And Employee With Billable Info | PayrollItemId TimecardFromDate, TimecardToDate, TimecardStatus, EmployeeId, PayrollItemId |
| Cross Project - Labor Timecards Grouped by Project, Prime Contract, Employee and Payroll Item | TimecardFromDate, TimecardToDate, TimecardStatus, EmployeeId |
| Cross Project - Labor Timecards Grouped by Status, Employee and Workers Comp Code | TimecardFromDate, TimecardToDate, TimecardStatus, EmployeeId, WCCId |
| Cross Project - Labor Timecards Grouped by Status, Employee, Payroll Item and Project | TimecardFromDate, TimecardToDate, TimecardStatus, EmployeeId |
| Cross Project - Labor Timecards Grouped by Status, Employee, Workers Comp Code and Labor Code | TimecardFromDate, TimecardToDate, TimecardStatus, EmployeeId, WCCId, LaborItemId |
| Cross Project - Labor Timecards Grouped by Status, Workers Comp Code and Employee | TimecardFromDate, TimecardToDate, TimecardStatus, EmployeeId, WCCId |
| Cross Project - Labor Timecards Summed by Employee Payroll Code and Day | TimecardFromDate, TimecardToDate, TimecardStatus |
| Cross Project - Labor Timecards Summed by Employee Project Payroll Code and Day | TimecardFromDate, TimecardToDate, TimecardStatus |
| Cross Project - Labor Timecards Summed by Project and Employee | TimecardFromDate, TimecardToDate, TimecardStatus |
| Cross Project - Labor Timecards Summed by Project, Employee and Payroll Item | TimecardFromDate, TimecardToDate, TimecardStatus |
| Cross Project - Labor Timecards Summed by Workers Comp Code and Employee | TimecardFromDate, TimecardToDate, PayrollItemId |
Standard Log Reports - HR Module - Cross Project - Labor Timecard Mileage
| Report Name | Filter Parameters |
| Cross Project - Labor Timecard Mileage Grouped by Employee | TimecardFromDate, TimecardToDate, TimecardStatus, EmployeeId |
Standard Log Reports - Project Time and Expense Module - Labor Timecards
The following reports will be shown in the Project Time and Expense module if the user has access to HR and Time Approval.
| Report Name | Filter Parameters |
| Labor Timecards Grouped by Prime Contract, CO and Cost Code | ProjectId, PrimeContractId, COId, TimecardStatus, TimecardFromDate, TimecardToDate, ShowComments |
| Labor Timecards Grouped by Prime Contract, CO and Employee | ProjectId, PrimeContractId, COId, TimecardStatus, TimecardFromDate, TimecardToDate, ShowComments |
| Labor Timecards Grouped by Prime Contract, Cost Code and Employee | ProjectId, PrimeContractId, TimecardStatus, TimecardFromDate, TimecardToDate, JCCId, EmployeeId, ShowComments |
| Labor Timecards Grouped by Prime Contract, Cost Code and Payroll Item | ProjectId, PrimeContractId, TimecardStatus, TimecardFromDate, TimecardToDate, JCCId, ShowComments |
| Labor Timecards Grouped by Prime Contract, Employee and Cost Code | ProjectId, PrimeContractId, TimecardStatus, TimecardFromDate, TimecardToDate, EmployeeId, JCCId, ShowComments |
| Labor Timecards Grouped by Prime Contract, Employee and Labor Code | ProjectId, PrimeContractId, TimecardStatus, TimecardFromDate, TimecardToDate, EmployeeId, LaborItemId, ShowComments |
| Labor Timecards Grouped by Prime Contract, Employee and Payroll Item | ProjectId, PrimeContractId, TimecardStatus, TimecardFromDate, TimecardToDate, EmployeeId |
| Labor Timecards Grouped by Prime Contract, Employee and Workers Comp Code | ProjectId, PrimeContractId, TimecardStatus, TimecardFromDate, TimecardToDate, EmployeeId, WCCId, ShowComments |
| Labor Timecards Grouped by Prime Contract, Status and Cost Code | ProjectId, PrimeContractId, TimecardStatus, TimecardFromDate, TimecardToDate, JCCId, ShowComments |
| Labor Timecards Grouped by Prime Contract, Status and Division | ProjectId, PrimeContractId, TimecardStatus, TimecardFromDate, TimecardToDate, JCCDivision, ShowComments |
| Labor Timecards Grouped by Prime Contract, Status and Employee | ProjectId, PrimeContractId, TimecardStatus, TimecardFromDate, TimecardToDate, EmployeeId |
| Labor Timecards Grouped by Prime Contract, Status and Labor Code | ProjectId, PrimeContractId, TimecardStatus, TimecardFromDate, TimecardToDate, LaborItemId, ShowComments |
| Labor Timecards Grouped by Prime Contract, Status and Owner Code | ProjectId, PrimeContractId, TimecardStatus, TimecardFromDate, TimecardToDate, OwnerCostCodeId, ShowComments |
| Labor Timecards Grouped by Prime Contract, Status and Payroll Item | ProjectId, PrimeContractId, TimecardStatus, TimecardFromDate, TimecardToDate, PayrollItemId, ShowComments |
| Labor Timecards Grouped by Prime Contract, Status and Workers Comp Code | ProjectId, PrimeContractId, TimecardStatus, TimecardFromDate, TimecardToDate, WCCId, ShowComments |
| Labor Timecards Grouped by Prime Contract, Work Order and Cost Code | ProjectId, PrimeContractId, WorkOrderId, TimecardStatus, TimecardFromDate, TimecardToDate, ShowComments |
| Labor Timecards Grouped by Prime Contract, Work Order and Employee | ProjectId, PrimeContractId, WorkOrderId, TimecardStatus, TimecardFromDate, TimecardToDate, ShowComments |
| Labor Timecards With Billable Info Grouped by Prime Contract, Status and Cost Code | ProjectId, PrimeContractId, TimecardStatus, TimecardFromDate, TimecardToDate, TimecardBillableStatus, JCCId, ShowComments |
| Labor Timecards With Billable Info Grouped by Prime Contract, Status and Division | ProjectId, PrimeContractId, TimecardStatus, TimecardFromDate, TimecardToDate, TimecardBillableStatus, JCCDivision, ShowComments |
| Labor Timecards With Billable Info Grouped by Prime Contract, Status and Employee | ProjectId, PrimeContractId, TimecardStatus, TimecardFromDate, TimecardToDate, TimecardBillableStatus, EmployeeId, ShowComments |
| Labor Timecards With Billable Info Grouped by Prime Contract, Status and Owner Code | ProjectId, PrimeContractId, TimecardStatus, TimecardFromDate, TimecardToDate, TimecardBillableStatus, OwnerCostCodeId, ShowComments |
Copyright © 2023 Corecon Technologies, Inc.