PRCSRQSTITEMDST

index back

Request Distribution Work Rec

Table contains list of all user ID or roles names who are authorized to view all generated reports and/or logs for this process
SELECT PRCSTYPE , PRCSNAME , DISTID ,DISTIDTYPE FROM PS_PRCSDEFNCNTDIST

PeopleSoft Field NameField TypeColumn TypeDescription
PRCSTYPECharacter(30)VARCHAR2(30) NOT NULLProcess Type
PRCSNAMECharacter(12)VARCHAR2(12) NOT NULLProcess Name
DISTIDCharacter(30)VARCHAR2(30) NOT NULLDistribution ID

Prompt Table: %EDITTABLE

DISTIDTYPECharacter(3)VARCHAR2(3) NOT NULLDistribution ID Type
2=User ID
3=Role Name
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19