PSUSEROPTCAT_VW

index back

User Option Categories VW


SELECT DISTINCT OPTN_CATEGORY_LVL , OPTN_CATEGORY_GRP , OPTN_CATEGORY FROM PSUSEROPTNDEFN

PeopleSoft Field NameField TypeColumn TypeDescription
OPTN_CATEGORY_LVLCharacter(4)VARCHAR2(4) NOT NULLOption 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_GRPCharacter(12)VARCHAR2(12) NOT NULLOption Category Group
OPTN_CATEGORYCharacter(12)VARCHAR2(12) NOT NULLOption Category
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19