Data views and standard log reports for equipment timecards

Access the reports

  1. Go to Reports.

  2. Select Project Specific Reports in the Report Category dropdown.

  3. Select Equipment Timecards in the Report Sub-Category dropdown.

  4. Select either Single Project Reports or Multi-Project Reports and select one or more relevant projects.

  5. Select the appropriate report in the Standard Reports section.

Alternatively, you can access the reports using one of the following options:

  • On the Project Home page, select Eqp. Timecards in the Time & Expenses section and select Reports on the Eqp. Timecards page.
  • On the Project Home page, select Time & Expense Overview in the Time & Expenses section and select the reports icon () in the Eqp. Timecards row of the Time & Expenses Stats section.
  • Go to Equipment and select the reports icon () in the Eqp. Timecards row of the Equipment Timecard Stats section.

Primary data views

  • vw_ProjectInfo
  • vw_ProjectInfoSimple
  • vw_PrimeContractInfo
  • vw_PrimeContractInfoSimple
  • vw_EquipmentItems
  • vw_EquipmentTimecards
  • vw_EquipmentTimecardsClockInOutRawData
  • vw_EquipmentTimecardsBreakStartEndRawData

Optional data views

  • vw_CompanyInfo
  • vw_CompanyInfoSimple
  • vw_ContactInfo
  • vw_JobCostCodes
  • vw_ChangeOrderInfo
  • vw_ChangeOrderInfoSimple
  • vw_WorkOrderInfo
  • vw_WorkOrderInfoSimple

Multi-project standard log reports for equipment timecards

Report Name Filter Parameters
Cross Project - Eqp Clock In Out Data Grouped by Eqp Item ClockInFromDate, ClockInToDate
Cross Project - Eqp Timecards Grouped by Eqp Item and Project with RT, IT and DT Hours TimecardFromDate, TimecardToDate, EqpType, ShowComments
Cross Project - Eqp Timecards Grouped by Eqp Type, Item and Project with RT, IT and DT Hours TimecardFromDate, TimecardToDate, EqpType, ShowComments
Cross Project - Eqp Timecards with Billable Info Grouped by Eqp Item and Project TimecardFromDate, TimecardToDate, TimecardBillableStatus, EqpType, ShowComments
Cross Project - Eqp Timecards with Billable Info Grouped by Eqp Type, Item and Project TimecardFromDate, TimecardToDate, TimecardBillableStatus, EqpType, ShowComments
Cross Project - Eqp Timecards with Billable Info Summed by Eqp Item and Project TimecardFromDate, TimecardToDate, TimecardBillableStatus, EqpType
Cross Project - Eqp Timecards with Billable Info Summed by Eqp Item Project Prime and JCC TimecardFromDate, TimecardToDate, TimecardBillableStatus, EqpType
Cross Project - Eqp Timecards with Billable Info Summed by Project and Eqp Item TimecardFromDate, TimecardToDate, TimecardBillableStatus, EqpType
Cross Project - Eqp Timecards with Billable Info Summed by Project Eqp Item Prime and JCC TimecardFromDate, TimecardToDate, TimecardBillableStatus, EqpType

Single project standard log reports for equipment timecards

Report Name Filter Parameters
Eqp Timecards Grouped by Prime Contract and CO with RT Hours Only ProjectId, PrimeContractId, COId, TimecardFromDate, TimecardToDate
Eqp Timecards Grouped by Prime Contract and Cost Code with RT Hours Only ProjectId, PrimeContractId, TimecardFromDate, TimecardToDate, JCCId, EqpType
Eqp Timecards Grouped by Prime Contract and Division with RT Hours Only ProjectId, PrimeContractId, TimecardFromDate, TimecardToDate, JCCDivision, EqpType
Eqp Timecards Grouped by Prime Contract and Eqp. Type with RT, IT and DT Hours ProjectId, PrimeContractId, TimecardFromDate, TimecardToDate, EqpType, ShowComments
Eqp Timecards Grouped by Prime Contract and Owner Code with RT Hours Only ProjectId, PrimeContractId, TimecardFromDate, TimecardToDate, OwnerCostCodeId, EqpType
Eqp Timecards Grouped by Prime Contract and Type with RT Hours Only ProjectId, PrimeContractId, TimecardFromDate, TimecardToDate, EqpType
Eqp Timecards Grouped by Prime Contract and Work order with RT Hours Only ProjectId, PrimeContractId, WorkOrderId, TimecardFromDate, TimecardToDate
Eqp Timecards Grouped by Prime Contract, CO and Equipment with RT, IT and DT Hours ProjectId, PrimeContractId, COId, TimecardFromDate, TimecardToDate, ShowComments
Eqp Timecards Grouped by Prime Contract, Cost Code and Eqp. Type with RT, IT and DT Hours ProjectId, PrimeContractId, TimecardFromDate, TimecardToDate, JCCId, EqpType, ShowComments
Eqp Timecards Grouped by Prime Contract, Cost Code and Equipment with RT, IT and DT Hours ProjectId, PrimeContractId, TimecardFromDate, TimecardToDate, JCCId, EqpType, ShowComments
Eqp Timecards Grouped by Prime Contract, Division and Equipment with RT, IT and DT Hours ProjectId, PrimeContractId, TimecardFromDate, TimecardToDate, JCCDivision, EqpType, ShowComments
Eqp Timecards Grouped by Prime Contract, Owner Code and Equipment with RT, IT and DT Hours ProjectId, PrimeContractId, TimecardFromDate, TimecardToDate, OwnerCostCodeId, EqpType, ShowComments
Eqp Timecards Grouped by Prime Contract, Work Order and Equipment with RT, IT and DT Hours ProjectId, PrimeContractId, WorkOrderId, TimecardFromDate, TimecardToDate, ShowComments
Eqp Timecards with Billable Info Grouped by Prime Contract and CO ProjectId, PrimeContractId, COId, TimecardFromDate, TimecardToDate, ShowComments
Eqp Timecards with Billable Info Grouped by Prime Contract and Cost Code ProjectId, PrimeContractId, TimecardFromDate, TimecardToDate, TimecardBillableStatus, JCCId, EqpType, ShowComments
Eqp Timecards with Billable Info Grouped by Prime Contract and Division ProjectId, PrimeContractId, TimecardFromDate, TimecardToDate, TimecardBillableStatus, JCCDivision, EqpType, ShowComments
Eqp Timecards with Billable Info Grouped by Prime Contract and Owner Code ProjectId, PrimeContractId, TimecardFromDate, TimecardToDate, TimecardBillableStatus, OwnerCostCodeId, EqpType, ShowComments
Eqp Timecards with Billable Info Grouped by Prime Contract and Type ProjectId, PrimeContractId, TimecardFromDate, TimecardToDate, TimecardBillableStatus, EqpType, ShowComments
Eqp Timecards with Billable Info Grouped by Prime Contract and Work Order ProjectId, PrimeContractId, WorkOrderId, TimecardFromDate, TimecardToDate, ShowComments