Data views and standard log reports for labor timecards
-
Go to Reports.
-
Select Project Specific Reports from the Report Category dropdown.
-
Select Labor Timecards from the Report Sub-Category dropdown.
-
Select either Single Project Reports or Multi-Project Reports and select one or more relevant projects.
-
Select the appropriate report in the Standard Reports tab.
Alternatively, you can access the reports using one of the following options:
- On the Project Home page, select Lbr. Timecards in the Time & Expenses section and select Reports on the Lbr. Timecards page.
- On the Project Home page, select Time & Expense Overview in the Time & Expenses section and select the reports icon (
) in the Lbr. Timecards row of the Time & Expenses Stats section. - Go to Time & Expenses and select the reports icon (
) in the Lbr. Timecards row of the Timecard and Expense Stats section.
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
Single project standard log reports for labor timecards
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 |
Multi-project standard log reports for labor timecards
| 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 |