RS_MEMBER_GRID

(SQL View)
 Index Back

Resouce Pool Project - View

This is the view that will be used in Manage Resource Pool main page grid.

SELECT A.POOL_ID , A.MEMBER_ID , B.START_DATE , A.EMPLID , (CASE WHEN A.GENERIC_NAME = ' ' THEN E.NAME ELSE A.GENERIC_NAME END) , A.SETID_ROLE , (CASE WHEN M.PROJ_ROLE IS NULL THEN A.PROJ_ROLE ELSE M.PROJ_ROLE END) , (CASE WHEN M.REGION_CD IS NULL THEN A.REGION_CD ELSE M.REGION_CD END) , (CASE WHEN E.PER_STATUS IS NULL THEN A.PER_STATUS ELSE E.PER_STATUS END) , B.END_DATE , B.CAP_PERCENT , A.DESCR254 , B.POOL_ID_FROM FROM %Table(RS_POOL_MEMBER) A , %Table(PERSONAL_DATA) E , %Table(RS_WORKER_TBL) M , %Table(RS_MEMBER_DATES) B WHERE A.EMPLID = E.EMPLID (+) AND A.EMPLID = M.EMPLID (+) AND A.POOL_ID = B.POOL_ID AND A.MEMBER_ID = B.MEMBER_ID AND B.START_DATE = ( SELECT MIN(C.START_DATE) FROM %Table(RS_MEMBER_DATES) C WHERE A.POOL_ID = C.POOL_ID AND A.MEMBER_ID = C.MEMBER_ID AND (C.END_DATE IS NULL OR C.END_DATE >= %CurrentDateIn))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 POOL_ID Character(10) VARCHAR2(10) NOT NULL Pool ID field.
2 MEMBER_ID Number(6,0) INTEGER NOT NULL Member ID.
3 START_DATE Date(10) DATE Start Date for Gen Standing PO
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 GENERIC_NAME Character(50) VARCHAR2(50) NOT NULL Generic name.
6 SETID_ROLE Character(5) VARCHAR2(5) NOT NULL SetID Role is used in the resource profile to allow select a valid project role.
7 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role

Prompt Table: RS_PROJROLE_VW
Set Control Field: SETID_ROLE

8 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.

Prompt Table: REGION_CD
Set Control Field: SETID_ROLE

9 PER_STATUS Character(1) VARCHAR2(1) NOT NULL Personnel Status
E=Employee
N=Non-Employee
10 END_DATE Date(10) DATE End Date
11 CAP_PERCENT Number(3,0) SMALLINT NOT NULL Capacity Percent
12 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
13 POOL_ID_FROM Character(10) VARCHAR2(10) NOT NULL Pool ID from

Prompt Table: RS_RES_POOL