SCC_NTF_SUMM_VW

(SQL View)
 Index Back

Notification Request Item

Used to create Entity (NotificationRequestItem) for CS Notification framework. Child record of SCC_NTFREQ_DTL

SELECT A.SCC_NTFREQ_ID , A.SCC_NTFREQ_DTL_SEQ , A.SCC_NTFREQ_ITM_SEQ , B.EMPLID , B.SCC_NTF_AUDCE , C.SCC_NTF_CON_ID , A.SCC_NTF_DATE_FROM , A.SCC_NTF_DATE_TO , A.SCC_NTFREQ_TYPE , A.SCC_NTFREQ_TMPLTID , A.SCC_NTFREQ_SUBJECT , A.SCC_NTFREQ_IMPTNCE , A.SCC_NTFREQ_ITM_STS , A.SCC_NTFREQ_SUB_STS , A.SCC_NTFREQ_ITM_TAG , A.SCC_NTFREQ_ITMTAG1 , A.SCC_NTFREQ_ITMTAG2 , A.SCC_NTFREQ_ITMTAG3 , A.SCC_NTFREQ_ITMTAG4 , A.SCC_ROW_ADD_OPRID , A.SCC_ROW_ADD_DTTM , A.SCC_ROW_UPD_OPRID , A.SCC_ROW_UPD_DTTM , A.SCC_NTFREQ_MSGTEXT FROM PS_SCC_NTFREQ_ITM A , PS_SCC_NTFREQ_DTL B , PS_SCC_NTFREQ_HDR C WHERE A.SCC_NTFREQ_ID = B.SCC_NTFREQ_ID AND B.SCC_NTFREQ_ID = C.SCC_NTFREQ_ID AND A.SCC_NTFREQ_DTL_SEQ = B.SCC_NTFREQ_DTL_SEQ AND A.SCC_NTFREQ_ITM_STS <> 'E' AND A.SCC_NTFREQ_SUB_STS NOT IN ('D', 'T')

  • Related Language Record: SCC_NTFSM_LN_VW

  • Parent record: SCC_NTFREQ_DTL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_NTFREQ_ID Number(16,0) DECIMAL(16) NOT NULL Notification ID
    2 SCC_NTFREQ_DTL_SEQ Number(5,0) INTEGER NOT NULL Notification Detail Sequence
    3 SCC_NTFREQ_ITM_SEQ Number(5,0) INTEGER NOT NULL Notification Item Sequence
    4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    5 SCC_NTF_AUDCE Character(2) VARCHAR2(2) NOT NULL Broadcast Messages Audience Flag
    ER=Email Recipients
    NA=N/A
    ST=Student
    6 SCC_NTF_CON_ID Character(40) VARCHAR2(40) NOT NULL Consumer ID
    7 SCC_NTF_DATE_FROM Date(10) DATE NOT NULL Date From

    Default Value: %date

    8 SCC_NTF_DATE_TO Date(10) DATE Date To
    9 SCC_NTFREQ_TYPE Character(4) VARCHAR2(4) NOT NULL NotificationType
    ALT=Alert Notification
    EML=Email Notification
    PSH=Push Notification
    SMS=SMS Notification
    WKL=Worklist Notification
    10 SCC_NTFREQ_TMPLTID Character(40) VARCHAR2(40) NOT NULL Notification Template ID
    11 SCC_NTFREQ_SUBJECT Character(254) VARCHAR2(254) NOT NULL Subject
    12 SCC_NTFREQ_IMPTNCE Character(1) VARCHAR2(1) NOT NULL Notification Importance
    1=High
    2=Medium
    3=Low

    Default Value: 3

    13 SCC_NTFREQ_ITM_STS Character(1) VARCHAR2(1) NOT NULL Notification Item Status
    E=Error
    P=Pending
    S=Success
    U=Unknown
    W=Warning
    14 SCC_NTFREQ_SUB_STS Character(1) VARCHAR2(1) NOT NULL Notification Item SubStatus
    A=Acknowledged
    D=Deleted
    E=Error
    R=Ready
    S=Selected
    T=Timeout
    U=Unknown
    W=Worked

    Default Value: U

    15 SCC_NTFREQ_ITM_TAG Character(20) VARCHAR2(20) NOT NULL Notification Item Tag
    16 SCC_NTFREQ_ITMTAG1 Character(20) VARCHAR2(20) NOT NULL Notification Item Tag1
    17 SCC_NTFREQ_ITMTAG2 Character(20) VARCHAR2(20) NOT NULL Notification Item Tag2
    18 SCC_NTFREQ_ITMTAG3 Character(20) VARCHAR2(20) NOT NULL Notification Item Tag3
    19 SCC_NTFREQ_ITMTAG4 Character(20) VARCHAR2(20) NOT NULL Notification Item Tag4
    20 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    21 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    22 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    23 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time
    24 SCC_NTFREQ_MSGTEXT Long Character CLOB Message text