PTAI_ASSGN_PVW

index back

Action Items Assignee Search

Action Items Assignee Search Search View
SELECT A.PTAI_LIST_ID , A.PTAI_USER_TYPE , A.OPRID , A.OPRDEFNDESC FROM PS_PTAI_ASSGN_VW A WHERE A.PTAI_USER_TYPE = 'Z' OR (A.PTAI_USER_TYPE = 'M' AND EXISTS ( SELECT 'X' FROM PS_PTAI_LIST_PRIV B WHERE B.PTAI_LIST_ID = A.PTAI_LIST_ID AND EXISTS ( SELECT 'X' FROM PSROLEUSER X WHERE X.ROLEUSER = A.OPRID AND ((B.PTAI_MBR_TYPE = 'USER' AND B.PTAI_MBR_NAME = X.ROLEUSER) OR (B.PTAI_MBR_TYPE = 'ROLE' AND B.PTAI_MBR_NAME = X.ROLENAME)))))

PeopleSoft Field NameField TypeColumn TypeDescription
PTAI_LIST_IDCharacter(31)VARCHAR2(31) NOT NULLAction Items - Action Item List ID
PTAI_USER_TYPECharacter(1)VARCHAR2(1) NOT NULLAction Items - User Type
M=Member Users
Z=All Users
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
OPRDEFNDESCCharacter(30)VARCHAR2(30) NOT NULLDescription field for a user
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19