PSUSEROPTN_SRCH

index back

User Option View


SELECT A.OPTN_CATEGORY_LVL , A.OPTN_CATEGORY_GRP , A.USEROPTN , A.DESCR FROM PSUSEROPTNDEFN A

  • Related language record: PSUSEROPTNLSRCH
  • 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
    USEROPTNCharacter(12)VARCHAR2(12) NOT NULLUser Option
    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19