Data views and standard log reports for labor timecards
Primary data views
- vw_ProjectInfo
- vw_ProjectInfoSimple
- vw_PrimeContractInfo
- vw_PrimeContractInfoSimple
- vw_EmployeeInfo
- vw_LaborTimecardsHR (Includes Cost and Bill Rates)
- vw_LaborTimecardsTE (Does Not Include Cost and Bill Rates)
- vw_LaborTimecardsClockInOutRawData
- vw_LaborTimecardsBreakStartEndRawData
Optional data views
- vw_CompanyInfo
- vw_CompanyInfoSimple
- vw_ContactInfo
- vw_JobCostCodes
- vw_ChangeOrderInfo
- vw_ChangeOrderInfoSimple
- vw_WorkOrderInfo
- vw_WorkOrderInfoSimple
Multi project labor timecard standard log reports
You can access multi-project labor timecards log reports either from the Time & Expenses or the Reports module.
| Report Name | Filter Parameters |
| Cross Project - Labor Clock In Out Data Grouped by Employee | ClockInFromDate, ClockInToDate, EmployeeId |
| Cross Project - Labor Timecard Billable Amount by Employee, Year, Month | TimecardStatus, TimecardFromDate, TimecardToDate |
| Cross Project - Labor Timecard Mileage Grouped by Employee | TimecardFromDate, TimecardToDate, TimecardStatus, EmployeeId |
| Cross Project - Labor Timecards Grouped by Employee | TimecardFromDate, TimecardToDate, TimecardStatus, EmployeeId, PayrollItemId |
| Cross Project - Labor Timecards Grouped by Employee With Billable Info | TimecardStatus, EmployeeId, PayrollItemId, TimecardFromDate, TimecardToDate |
| Cross Project - Labor Timecards Grouped by Export Status, Employee, and Project | ExportStatus, TimecardFromDate, TimecardToDate |
| 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 Hours by Employee Billable Status, Year, Month | TimecardStatus, TimecardFromDate, TimecardToDate |
| 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 |
Individual project labor timecard standard log reports
You can access labor timecards log reports for individual projects either from the appropriate project's Lbr. Timecards page or from the Reports module.
The reports are available to users with permissions to the Time & Expenses module 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 |