WCS_ECM_RLE_LVW

(SQL View)
 Index Back

WCS Self-Service Access Rls LG

Language view of WCS Manager Self-Service Access Roles

SELECT %Substring(FIELDVALUE ,1,1) , XL.LANGUAGE_CD , XL.XLATLONGNAME FROM PSXLATITEMLANG XL WHERE FIELDNAME = 'WCS_SP_ACCESS_TYPE' AND %EffdtCheck(PSXLATITEMLANG XL1, XL, %CurrentDateIn)

  • Related Language Record for WCS_ECM_ROLE_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name