PA Employee Activity By Organization

Description

Categories
Enginatics
Repository
GitHub
Labor hours summary by employee, project, and task showing total, billable, and non-billable hours with cost amounts for the expenditure organization.

SQL 51 lines

Parameters 5

ParameterTypeList of values SQL
Operating UnitLOV
haouv.name=:operating_unit
ProjectLOV
ppa.segment1=:project_number
Date FromDate
peia.expenditure_item_date>=:date_from
Date ToDate
peia.expenditure_item_date<:date_to+1
EmployeeLOV
ppx.full_name=:employee