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