EONC_UL_SRCH_LW

(SQL View)
 Index Back

Notification User List

Maps User List to sources or user list data e.g. roles, queries, application classes & SQL Definitions.

SELECT A.EONC_USER_LIST_ID , L.LANGUAGE_CD , COALESCE(( SELECT AL.DESCR100 FROM PS_EONC_USRLST_HDL AL WHERE AL.EONC_USER_LIST_ID = A.EONC_USER_LIST_ID AND AL.LANGUAGE_CD = L.LANGUAGE_CD) , (A.DESCR100), ' ') , COALESCE(( SELECT BL.XLATLONGNAME FROM PSXLATITEMLANG BL WHERE BL.FIELDNAME = 'EONC_USER_SOURCE' AND BL.FIELDVALUE = A.EONC_USER_SOURCE AND BL.LANGUAGE_CD = L.LANGUAGE_CD AND %EffdtCheck(PSXLATITEMLANG BL1, BL, %CurrentDateIn)), ( SELECT B.XLATLONGNAME FROM PSXLATITEM B WHERE B.FIELDNAME = 'EONC_USER_SOURCE' AND B.FIELDVALUE = A.EONC_USER_SOURCE AND %EffdtCheck(PSXLATITEM B1, B, %CurrentDateIn)), ' ') , COALESCE(( SELECT CL.XLATLONGNAME FROM PSXLATITEMLANG CL WHERE CL.FIELDNAME = 'EONC_UL_RSLT_TYPE' AND CL.FIELDVALUE = A.EONC_UL_RSLT_TYPE AND CL.LANGUAGE_CD = L.LANGUAGE_CD AND %EffdtCheck(PSXLATITEMLANG CL1, CL, %CurrentDateIn)), ( SELECT C.XLATLONGNAME FROM PSXLATITEM C WHERE C.FIELDNAME = 'EONC_UL_RSLT_TYPE' AND C.FIELDVALUE = A.EONC_UL_RSLT_TYPE AND %EffdtCheck(PSXLATITEM C1, C, %CurrentDateIn)), ' ') FROM PS_EONC_USRLST_HDR A, PSLANGUAGES L WHERE L.INSTALLED = 1 AND L.LANGUAGE_CD <> ( SELECT O.LANGUAGE_CD FROM PSOPTIONS O)

  • Related Language Record for EONC_UL_SRCH_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_UL_SRC_DESCR Character(30) VARCHAR2(30) NOT NULL User List Source: Role, Query, SQL Definition or Application Class.
    C=Application Class
    Q=Query
    R=Role
    S=SQL Definition
    5 EONC_UL_RSLT_DESCR Character(30) VARCHAR2(30) NOT NULL User List Resuts Type: U - User Ids, E - Email Addresses, P - Phone Numbers.
    E=Email Address
    P=Phone Number
    U=User ID