EONC_ULST_PR_LW

(SQL View)
 Index Back

Rel Lang for EONC_ULST_PR_VW

Rellated Language record for EONC_ULST_PR_VW.

SELECT U.EONC_USER_LIST_ID , L.LANGUAGE_CD , COALESCE(( SELECT UL.DESCR100 FROM PS_EONC_USRLST_HDL UL WHERE UL.EONC_USER_LIST_ID = U.EONC_USER_LIST_ID AND UL.LANGUAGE_CD = L.LANGUAGE_CD) , (U.DESCR100), ' ') , COALESCE(( SELECT XL.XLATSHORTNAME FROM PSXLATITEMLANG XL WHERE XL.FIELDNAME = 'EONC_USER_SOURCE' AND XL.FIELDVALUE = U.EONC_USER_SOURCE AND XL.LANGUAGE_CD = L.LANGUAGE_CD AND %EffdtCheck(PSXLATITEMLANG XL1, XL, %CurrentDateIn)), ( SELECT X.XLATSHORTNAME FROM PSXLATITEM X WHERE X.FIELDNAME = 'EONC_USER_SOURCE' AND X.FIELDVALUE = U.EONC_USER_SOURCE AND %EffdtCheck(PSXLATITEM X1, X, %CurrentDateIn)), ' ') FROM PS_EONC_USRLST_HDR U, PSLANGUAGES L , PSXLATITEM X1 WHERE L.INSTALLED = 1 AND L.LANGUAGE_CD <> ( SELECT O.LANGUAGE_CD FROM PSOPTIONS O)

  • Related Language Record for EONC_ULST_PR_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EONC_USER_LIST_ID Character(30) VARCHAR2(30) NOT NULL Identifies the user list to be used when creating the notification.
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    4 EONC_ULIST_TYPE Character(10) VARCHAR2(10) NOT NULL User List Type