SCC_NTFREQ_DTL

(SQL Table)
Index Back

Notification Request Detail

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

  • 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_NTFREQ_DTL_STS Character(1) VARCHAR2(1) NOT NULL Notification Detail Status
    E=Error
    P=Pending
    R=Partial Success
    S=Success
    5 SCC_NTF_AUDCE Character(2) VARCHAR2(2) NOT NULL Broadcast Messages Audience Flag
    ER=Email Recipients
    NA=N/A
    ST=Student

    Default Value: NA

    6 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    7 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    8 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    9 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time