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 |
Copyright © 2023 Corecon Technologies, Inc.