SCC_NTF_ITM_HST

(SQL Table)
 Index Back

Notification Request Item Hist

History record for SCC_NTFREQ_ITM

  • Parent record: SCC_NTFREQ_DTL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
    2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
    3 SCC_NTFREQ_ID Number(16,0) DECIMAL(16) NOT NULL Notification ID
    4 SCC_NTFREQ_DTL_SEQ Number(5,0) INTEGER NOT NULL Notification Detail Sequence
    5 SCC_NTFREQ_ITM_SEQ Number(5,0) INTEGER NOT NULL Notification Item Sequence
    6 SCC_NTF_DATE_FROM Date(10) DATE NOT NULL Date From

    Default Value: %date

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

    Default Value: 3

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

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