SCC_NTF_DTL_VW2

(SQL View)
 Index Back

Notification Request Detail

Used to create Entity (NotificationRequestDetail) for CS Notification framework. Child record of SCC_NTFREQ_HDR

SELECT D.SCC_NTFREQ_ID , D.SCC_NTFREQ_DTL_SEQ , CASE D.SCC_NTF_AUDCE WHEN 'ER' THEN E.EMPLID ELSE D.EMPLID END , E.SCC_NTF_RCP_TYP , D.SCC_NTF_AUDCE FROM PS_SCC_NTFREQ_DTL D LEFT OUTER JOIN PS_SCC_NTF_DTL_ER E ON D.SCC_NTFREQ_ID= E.SCC_NTFREQ_ID AND D.SCC_NTFREQ_DTL_SEQ = E.SCC_NTFREQ_DTL_SEQ

  • Parent record: SCC_NTFREQ_HDR

    • # 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    4 SCC_NTF_RCP_TYP Character(1) VARCHAR2(1) NOT NULL Recipient Level
    B=Bcc
    C=Cc
    T=To
    5 SCC_NTF_AUDCE Character(2) VARCHAR2(2) NOT NULL Broadcast Messages Audience Flag
    ER=Email Recipients
    NA=N/A
    ST=Student