PSUSEROPTCAT_VW

index back

User Option Categories VW


SELECT DISTINCT OPTN_CATEGORY_LVL , OPTN_CATEGORY_GRP , OPTN_CATEGORY FROM PSUSEROPTNDEFN

PeopleSoft Field Name Field Type Column Type Description
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
OPTN_CATEGORY Character(12) VARCHAR2(12) NOT NULL Option Category
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20