WCS_ECM_ROLE_VW

(SQL View)
 Index Back

WCS Self-Service Access Roles

View of WCS Manager Self-Service Access Roles

SELECT %Substring(FIELDVALUE ,1,1) , I.XLATLONGNAME FROM PSXLATITEM I WHERE FIELDNAME = 'WCS_SP_ACCESS_TYPE' AND %EffdtCheck(PSXLATITEM I1, I, %CurrentDateIn) AND I.EFF_STATUS = 'A'

  • Related Language Record: WCS_ECM_RLE_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 WCS_SP_ACCESS_TYPE Character(1) VARCHAR2(1) NOT NULL Access Type/Role
    A=Confirmer
    C=Compensation Adminstrator
    R=Reviewer
    S=Submitter
    2 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name