SCC_NTF_ITM_VW

(SQL View)
 Index Back

Notification Request Item view

Notification Request Item view

SELECT SCC_NTFREQ_ID ,SCC_NTFREQ_DTL_SEQ ,SCC_NTFREQ_ITM_SEQ ,SCC_NTF_DATE_FROM ,SCC_NTF_DATE_TO ,SCC_NTFREQ_TYPE ,SCC_NTFREQ_TMPLTID ,SCC_NTFREQ_SUBJECT ,SCC_NTFREQ_IMPTNCE ,SCC_NTFREQ_ITM_STS ,SCC_NTFREQ_SUB_STS ,SCC_NTFREQ_ITM_TAG ,SCC_NTFREQ_ITMTAG1 ,SCC_NTFREQ_ITMTAG2 ,SCC_NTFREQ_ITMTAG3 ,SCC_NTFREQ_ITMTAG4 ,SCC_NTFREQ_MSGTEXT FROM %Table(SCC_NTFREQ_ITM)

  • Parent record: SCC_NTF_DTL_VW

    • # 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_NTFREQ_MSGTEXT Long Character CLOB Message text