SCC_NTFREQ_ITM

(SQL Table)
 Index Back

Notification Request Item

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

  • 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 SCC_NTF_DATE_FROM Date(10) DATE NOT NULL Date From

    Default Value: %date

    5 SCC_NTF_DATE_TO Date(10) DATE Date To
    6 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
    7 SCC_NTFREQ_TMPLTID Character(40) VARCHAR2(40) NOT NULL Notification Template ID
    8 SCC_NTFREQ_SUBJECT Character(254) VARCHAR2(254) NOT NULL Subject
    9 SCC_NTFREQ_IMPTNCE Character(1) VARCHAR2(1) NOT NULL Notification Importance
    1=High
    2=Medium
    3=Low

    Default Value: 3

    10 SCC_NTFREQ_ITM_STS Character(1) VARCHAR2(1) NOT NULL Notification Item Status
    E=Error
    P=Pending
    S=Success
    U=Unknown
    W=Warning
    11 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

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