Data Views and Standard Log Reports - Equipment Timecards

Data Views - Primary

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

Data Views - Optional

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

Standard Log Reports - Cross Projects - 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

Standard Log Reports - Individual Project - 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