Data Views and Standard Log Reports - Employee Misc Expenses

Data Views - Primary

• vw_ProjectInfo
• vw_ProjectInfoSimple
• vw_PrimeContractInfo
• vw_PrimeContractInfoSimple
• vw_EmployeeInfo
• vw_MiscExpenses

Data Views - Optional

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

Standard Log Reports - Cross Projects - Employee Misc Expenses

Report Name	Filter Parameters
Cross Project - Misc Expenses Grouped by Export Status, Payment Type and Project	MiscExpenseFromDate, MiscExpenseToDate, Exported, MiscExpenseType, MiscExpensePaymentType
Cross Project - Misc Expenses Grouped by Status, Employee, Project and Contract	MiscExpenseFromDate, MiscExpenseToDate, MiscExpenseStatus, MiscExpenseType, MiscExpensePaymentType
Cross Project - Misc Expenses Grouped by Status, Payee Vendor, Project and Contract	MiscExpenseFromDate, MiscExpenseToDate, MiscExpenseStatus, MiscExpenseType, MiscExpensePaymentType
Cross Project - Misc Expenses Grouped by Status, Payment Type, Project and Contract	MiscExpenseFromDate, MiscExpenseToDate, MiscExpenseStatus, MiscExpenseType, MiscExpensePaymentType
Cross Project - Misc Expenses Grouped by Status, Type, Project and Contract	MiscExpenseFromDate, MiscExpenseToDate, MiscExpenseStatus, MiscExpenseType, MiscExpensePaymentType

Standard Log Reports - Individual Project - Employee Misc Expenses

Report Name	Filter Parameters
Misc Expenses Grouped by Cost Plus Contract, Billable Status and Cost Code	ProjectId, PrimeContractId, MiscExpenseFromDate, MiscExpenseToDate, MiscExpenseStatus, MiscExpenseBillableStatus, JCCId, MiscExpensePaymentType, MiscExpenseType
Misc Expenses Grouped by Prime Contract, CO and Status	ProjectId, PrimeContractId, MiscExpenseFromDate, MiscExpenseToDate, MiscExpenseStatus, MiscExpenseType, MiscExpensePaymentType
Misc Expenses Grouped by Prime Contract, Division and Cost Code	ProjectId, PrimeContractId, MiscExpenseFromDate, MiscExpenseToDate, MiscExpenseStatus, JCCDivision, MiscExpenseType, MiscExpensePaymentType
Misc Expenses Grouped by Prime Contract, Status and Cost Code	ProjectId, PrimeContractId, MiscExpenseFromDate, MiscExpenseToDate, MiscExpenseStatus, JCCId, MiscExpenseType, MiscExpensePaymentType
Misc Expenses Grouped by Prime Contract, Status and Division	ProjectId, PrimeContractId, MiscExpenseFromDate, MiscExpenseToDate, MiscExpenseStatus, JCCDivision, MiscExpenseType, MiscExpensePaymentType
Misc Expenses Grouped by Prime Contract, Status and Employee	ProjectId, PrimeContractId, MiscExpenseFromDate, MiscExpenseToDate, MiscExpenseStatus, EmployeeId, MiscExpenseType, MiscExpensePaymentType
Misc Expenses Grouped by Prime Contract, Status and Owner Code	ProjectId, PrimeContractId, MiscExpenseFromDate, MiscExpenseToDate, MiscExpenseStatus, OwnerCostCodeId, MiscExpenseType, MiscExpensePaymentType
Misc Expenses Grouped by Prime Contract, Status and Payee Vendor	ProjectId, PrimeContractId, MiscExpenseFromDate, MiscExpenseToDate, MiscExpenseStatus, MiscExpensePayeeVendorId, MiscExpenseType, MiscExpensePaymentType
Misc Expenses Grouped by Prime Contract, Status and Payment Type	ProjectId, PrimeContractId, MiscExpenseFromDate, MiscExpenseToDate, MiscExpenseStatus, MiscExpenseType, MiscExpensePaymentType
Misc Expenses Grouped by Prime Contract, Status and Type	ProjectId, PrimeContractId, MiscExpenseFromDate, MiscExpenseToDate, MiscExpenseStatus, MiscExpenseType, MiscExpensePaymentType
Misc Expenses Grouped by Prime Contract, Work Order and Status	ProjectId, PrimeContractId, WorkOrderId, MiscExpenseFromDate, MiscExpenseToDate, MiscExpenseStatus, MiscExpenseType, MiscExpensePaymentType