Data Views and Standard Log Reports - Project Time and Expense Module - Labor Timecards

Data Views - Primary

• vw_ProjectInfo
• vw_ProjectInfoSimple
• vw_PrimeContractInfo
• vw_PrimeContractInfoSimple
• vw_EmployeeInfo
• vw_LaborTimecardsTE (Does Not Include 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 - Project Time and Expense Module - Cross Projects - Labor Timecards

Report Name	Filter Parameters
Cross Project - Labor Clock In Out Data Grouped by Employee	ClockInFromDate, ClockInToDate, EmployeeId
Cross Project - Labor Timecards Grouped by Employee	TimecardFromDate, TimecardToDate, TimecardStatus, EmployeeId, PayrollItemId
Cross Project - Labor Timecards Grouped by Project And Employee	TimecardFromDate, TimecardToDate, TimecardStatus, EmployeeId, PayrollItemId
Cross Project - Labor Timecards Grouped by Project, Prime Contract, Employee and Payroll Item	TimecardFromDate, TimecardToDate, TimecardStatus, EmployeeId, PayrollItemId
Cross Project - Labor Timecards Grouped by Status, Employee, Payroll Item and Project	TimecardFromDate, TimecardToDate, TimecardStatus, EmployeeId, PayrollItemId
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

Standard Log Reports - Project Time and Expense Module - Individual Project - Labor Timecards

Report Name	Filter Parameters
Labor Timecards Grouped by Prime Contract, Employee and Payroll Item	ProjectId, PrimeContractId, TimecardStatus, TimecardFromDate, TimecardToDate, EmployeeId, PayrollItemId, ShowComments
Labor Timecards Grouped by Prime Contract, Job Cost Code and Employee	ProjectId, PrimeContractId, TimecardStatus, TimecardFromDate, TimecardToDate, JCCId, EmployeeId
Labor Timecards Grouped by Prime Contract, Job Cost Code and Payroll Item	ProjectId, PrimeContractId, TimecardStatus, TimecardFromDate, TimecardToDate, JCCId
Labor Timecards Grouped by Prime Contract, Status and Employee	ProjectId, PrimeContractId, TimecardStatus, TimecardFromDate, TimecardToDate, EmployeeId, ShowComments