EX_ENFPOOL_ACT

(SQL View)
Index Back

Enforce Team O/P View

Activity prompt table for Expenses when Pool security is enforced.

SELECT A.EMPLID , A.BUSINESS_UNIT , A.PROJECT_ID , B.ROW_NUMBER_5 , B.WBS_ID , B.DESCR , A.ACTIVITY_ID , MAX(A.POOL_ID) , MIN(A.START_DATE) , MAX(A.END_DATE) FROM %Table(PGM_POOL_CACH) A , %Table(PROJ_ACTIVITY) B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROJECT_ID = B.PROJECT_ID AND A.ACTIVITY_ID = B.ACTIVITY_ID AND B.EFF_STATUS = 'A' AND B.COSTING_ACT_SW = 'Y' AND A.EMPLID <> ' ' GROUP BY A.EMPLID , A.BUSINESS_UNIT , A.PROJECT_ID , B.ROW_NUMBER_5 , B.WBS_ID , A.ACTIVITY_ID , B.DESCR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
3 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
4 ROW_NUMBER_5 Number(5,0) INTEGER NOT NULL Row Number
5 WBS_ID Character(100) VARCHAR2(100) NOT NULL WBS ID
6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
7 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
8 POOL_ID Character(10) VARCHAR2(10) NOT NULL Pool ID field.
9 START_DATE Date(10) DATE Start Date for Gen Standing PO
10 END_DATE Date(10) DATE End Date