PSAUTHOPTN_VW

index back

Authorized optnions view

used to discplay the authorized cateogy level and group on the Permission List Options page.
SELECT DISTINCT A.CLASSID , A.OPTN_CATEGORY_LVL , B.OPTN_CATEGORY_GRP FROM PSAUTHOPTN A , PSUSEROPTNDEFN B WHERE A.OPTN_CATEGORY_LVL = B.OPTN_CATEGORY_LVL AND A.USEROPTN = B.USEROPTN

PeopleSoft Field Name Field Type Column Type Description
CLASSID Character(30) VARCHAR2(30) NOT NULL The name of the class (see PSCLASSDEFN).
OPTN_CATEGORY_LVL Character(4) VARCHAR2(4) NOT NULL Option Category Level
CRM=Customer Relationship Mgmt
CSTM=Custom
EPM=Enterprise Performance Mgmt
FIN=Financials
HRMS=Human Capital Management
LS=Enterprise Learning Management
PPTL=PeopleTools
SCM=Supply Chain Management
OPTN_CATEGORY_GRP Character(12) VARCHAR2(12) NOT NULL Option Category Group

Prompt Table: PSOPTNCATGRPTBL

index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19