PGM_ACT_WRK_TE (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 for time entered in Expenses Time Entry.

PGM_ACT_WRK_TE

(SQL View)

Actual Work by Team Member

This view returns the actual work recorded by a team member for a given Project/Activity for time entered in Expenses Time Entry.

SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.ACTIVITY_ID , A.ACTIVITY_ID_DETAIL , A.EMPLID , SUM(A.RESOURCE_QUANTITY) FROM PS_PROJ_RESOURCE A , PS_PROJECT B , PS_BUS_UNIT_TBL_PC C , PS_UNITS_CVT_TBL D 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 A.SYSTEM_SOURCE = 'BEX' AND A.TIME_SHEET_ID <> ' ' 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

#	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