PGM_ACT_WRK_VW

(SQL View)
 Index Back

Actual Work by Team Member

This view returns the actual work recorded by a team member for a given Project/Activity.

SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.ACTIVITY_ID , A.ACTIVITY_ID_DETAIL , A.EMPLID , %Round(SUM(%DecMult(%DecMult(A.RESOURCE_QUANTITY, D.CONVERSION_RATE), E.QUANTITY_MULTIPLY)), 2) FROM PS_PROJ_RESOURCE A , PS_PROJECT B , PS_BUS_UNIT_TBL_PC C , PS_UNITS_CVT_TBL D , PS_PROJ_AN_GRP_MAP E , PS_SET_CNTRL_REC F WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROJECT_ID = B.PROJECT_ID AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.UNIT_OF_MEASURE = D.UNIT_OF_MEASURE AND D.UNIT_OF_MEASURE_TO = C.UOM_HOURS AND F.RECNAME = 'PROJ_AN_GRP_MAP' AND F.SETCNTRLVALUE = A.BUSINESS_UNIT AND E.SETID = F.SETID AND A.ANALYSIS_TYPE = E.ANALYSIS_TYPE AND B.AN_GRP_TOT_COSTS = E.ANALYSIS_GROUP AND A.EMPLID <> ' ' GROUP BY A.BUSINESS_UNIT, A.PROJECT_ID, A.ACTIVITY_ID, A.ACTIVITY_ID_DETAIL, A.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
3 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
4 ACTIVITY_ID_DETAIL Character(15) VARCHAR2(15) NOT NULL This field identifies the detail Activity ID used for charging time reports in Expenses. This field is only used if the project charging level is set to summarize activity charges to level 1, 2, or 3 of the wbs. ACTIVITY_ID_DETAIL stores the detail activity used in time report charging, whereas the ACTIVITY_ID stores the parent activity at the appropriate charging level.
5 TEAM_MEMBER Character(30) VARCHAR2(30) NOT NULL Team Member
6 ACTUAL_WORK Signed Number(16,2) DECIMAL(14,2) NOT NULL Actual Work