PSAUTHOPTN_VW

Return to Index

used to discplay the authorized cateogy level and group on the Permission List Options page.

PlatformView Text
DefaultSELECT 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 NameDescription
CLASSIDThe name of the class
OPTN_CATEGORY_LVLOption Category Level
CRM=Customer Relationship Mgmt
CSTM=Custom
EPM=Enterprise Performance Mgmt
FIN=Financials
HRMS=Human Resources Management
LS=Learning Solutions
PPTL=PeopleTools
SCM=Supply Chain Management
OPTN_CATEGORY_GRPOption Category Group

Prompt Table: PSOPTNCATGRPTBL

Author: PeopleTools

Return to Index

© Go-Faster Consultancy Ltd.  Last updated 24 July 2010