PTAI_ASSGN_VW

index back

Action Items Assign to Search

Action Items Lists Assign to Search View
SELECT B.OPRID , B.OPRDEFNDESC , C.PTAI_LIST_ID , %Substring(A.FIELDVALUE, 1, 1) FROM PSXLATITEM A , PSOPRDEFN B , PS_PTAI_LIST C WHERE A.FIELDNAME = 'PTAI_USER_TYPE'

PeopleSoft Field Name Field Type Column Type Description
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user
PTAI_LIST_ID Character(31) VARCHAR2(31) NOT NULL Action Items - Action Item List ID
PTAI_USER_TYPE Character(1) VARCHAR2(1) NOT NULL Action Items - User Type
M=Member Users
Z=All Users
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19