EONC_UL_SRCH_VW

(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 , A.DESCR100 , A.EONC_USER_SOURCE , B.XLATLONGNAME , A.EONC_UL_RSLT_TYPE , C.XLATLONGNAME , A.QRYNAME , A.SQLID , A.ROLENAME , A.APP_CLASS , A.PACKAGEROOT || ' ' || A.APPCLASS_PATH || ' ' || A.APP_CLASS , CASE WHEN A.QRYNAME <> ' ' THEN A.QRYNAME WHEN A.SQLID <> ' ' THEN A.SQLID WHEN A.ROLENAME <> ' ' THEN A.ROLENAME ELSE A.PACKAGEROOT || ' ' || A.APPCLASS_PATH || ' ' || A.APP_CLASS END FROM PS_EONC_USRLST_HDR A , PSXLATITEM B , PSXLATITEM C WHERE B.FIELDNAME = 'EONC_USER_SOURCE' AND B.FIELDVALUE = A.EONC_USER_SOURCE AND %EffdtCheck(PSXLATITEM B1, B, %CurrentDateIn) AND C.FIELDNAME = 'EONC_UL_RSLT_TYPE' AND C.FIELDVALUE = A.EONC_UL_RSLT_TYPE AND %EffdtCheck(PSXLATITEM C1, C, %CurrentDateIn)

  • Related Language Record: EONC_UL_SRCH_LW

    • # 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 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    3 EONC_USER_SOURCE Character(1) VARCHAR2(1) NOT NULL User List Source: Role, Query, SQL Definition or Application Class.
    C=Application Class
    Q=Role Query
    R=Role
    S=SQL Definition
    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_TYPE Character(1) VARCHAR2(1) NOT NULL User List Resuts Type: U - User Ids, E - Email Addresses, P - Phone Numbers.
    E=Email Address
    P=Phone Number
    U=User ID
    6 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
    7 QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name

    Prompt Table: EONC_ROLEQRY_VW

    8 SQLID Character(30) VARCHAR2(30) NOT NULL SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE
  • SQLTYPE = 0: SQL object name
  • SQLTYPE = 1: Application Engine Step Identifier
  • SQLTYPE = 2: RECNAME
  • SQLTYPE = 6: Application Engine XSLT (XML definition)

    Prompt Table: PTAF_SQLID_VW

    • 9 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

    Prompt Table: EONC_ROLE_VW

    10 APP_CLASS Character(254) VARCHAR2(254) NOT NULL Implementation App Class

    Prompt Table: EONC_CLASS_VW

    11 EONC_APPCLASS Character(254) VARCHAR2(254) NOT NULL Application Class
    12 EONC_UL_SRC_DETAIL Character(30) VARCHAR2(30) NOT NULL User List Source: Role, Query, SQL Definition or Application Class.