EONC_CAT_REG_VW

(SQL View)
 Index Back

Notification Prompt

View on PTPN_CAT_REG.

SELECT A.PTPN_CATEGORY_NAME , A.PTPN_EVENTNAME , A.DESCR100 , A.OBJECTOWNERID , B.XLATLONGNAME , A.PTPN_FUNC_CATEGORY , A.PTPN_NOTIFICATION , A.PTPN_DEF_NOTIF , A.PTPN_EMAIL , A.PTPN_DEF_EMAIL , A.PTPN_MESSAGE , A.PTPN_DEF_TEXT , A.PTPN_WHATSAPP , A.PTPN_OVERRIDE , A.PTPN_MAND_NOTIF , C.XLATLONGNAME , E.XLATLONGNAME , D.XLATLONGNAME FROM PS_PTPN_CAT_REG A , PSXLATITEM B , PSXLATITEM C , PSXLATITEM D , PSXLATITEM E WHERE B.FIELDNAME = 'OBJECTOWNERID' AND B.FIELDVALUE = A.OBJECTOWNERID AND %EffdtCheck(PSXLATITEM B1, B, %CurrentDateIn) AND C.FIELDNAME = 'PSYESNO' AND C.FIELDVALUE = A.PTPN_NOTIFICATION AND %EffdtCheck(PSXLATITEM C1, C, %CurrentDateIn) AND D.FIELDNAME = 'PSYESNO' AND D.FIELDVALUE = A.PTPN_MESSAGE AND %EffdtCheck(PSXLATITEM D1, D, %CurrentDateIn) AND E.FIELDNAME = 'PSYESNO' AND E.FIELDVALUE = A.PTPN_EMAIL AND %EffdtCheck(PSXLATITEM E1, E, %CurrentDateIn)

  • Related Language Record: EONC_CAT_REG_LW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PTPN_CATEGORY_NAME Character(50) VARCHAR2(50) NOT NULL Notification Name
    2 PTPN_EVENTNAME Character(30) VARCHAR2(30) NOT NULL Event Name

    Prompt Table: PTPN_EVENTS_VW

    3 EONC_PTNOTIF_DESCR Character(100) VARCHAR2(100) NOT NULL PTPN Notification description
    4 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
    5 EONC_OBJOWNR_DESCR Character(30) VARCHAR2(30) NOT NULL Object Owner description
    6 PTPN_FUNC_CATEGORY Character(30) VARCHAR2(30) NOT NULL Functional Category

    Prompt Table: PTPN_FUNCAT_DVW

    7 PTPN_NOTIFICATION Character(1) VARCHAR2(1) NOT NULL In-App

    Default Value: Y

    Prompt Table: EONC_YESNO_VW

    8 PTPN_DEF_NOTIF Character(1) VARCHAR2(1) NOT NULL Notification Window
    N=No
    Y=Yes

    Default Value: Y

    Prompt Table: EONC_YESNO_VW

    9 PTPN_EMAIL Character(1) VARCHAR2(1) NOT NULL Email Notification

    Default Value: N

    Prompt Table: EONC_YESNO_VW

    10 PTPN_DEF_EMAIL Character(1) VARCHAR2(1) NOT NULL Email Notification
    N=No
    Y=Yes

    Default Value: N

    Prompt Table: EONC_YESNO_VW

    11 PTPN_MESSAGE Character(1) VARCHAR2(1) NOT NULL Text Message

    Default Value: N

    Prompt Table: EONC_YESNO_VW

    12 PTPN_DEF_TEXT Character(1) VARCHAR2(1) NOT NULL Text Message
    N=No
    Y=Yes

    Default Value: N

    Prompt Table: EONC_YESNO_VW

    13 PTPN_WHATSAPP Character(1) VARCHAR2(1) NOT NULL Whatsapp

    Default Value: N

    Prompt Table: EONC_YESNO_VW

    14 PTPN_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Allow Personalization
    N=No
    Y=Yes

    Default Value: N

    Prompt Table: EONC_YESNO_VW

    15 PTPN_MAND_NOTIF Character(1) VARCHAR2(1) NOT NULL MandatoryNotification
    N=No
    Y=Yes

    Default Value: N

    Prompt Table: EONC_YESNO_VW

    16 EONC_INAPP_FLG_DES Character(3) VARCHAR2(3) NOT NULL In-App
    17 EONC_EMAIL_FLG_DES Character(3) VARCHAR2(3) NOT NULL Email
    18 EONC_TEXT_FLG_DES Character(3) VARCHAR2(3) NOT NULL Text