SAA_NTF_DATA_VW(SQL View) |
Index Back |
|---|---|
Notifcation Framework Data |
| SELECT A.SCC_NTFREQ_ID , A.SCC_NTFREQ_DTL_SEQ , A.SCC_NTFREQ_ITM_SEQ , B.SCC_NTFREQ_DAT_VAL , C.SCC_NTFREQ_DAT_VAL , D.SCC_NTFREQ_DAT_VAL , E.SCC_NTFREQ_DAT_VAL , F.SCC_NTFREQ_DAT_VAL , G.SCC_NTFREQ_TO , H.SCC_NTFREQ_TYPE , A.SCC_ROW_ADD_DTTM FROM PS_SCC_NTFREQ_DATA A LEFT OUTER JOIN PS_SAA_NTF_BND8_VW B ON B.SCC_NTFREQ_ID = A.SCC_NTFREQ_ID AND B.SCC_NTFREQ_DTL_SEQ = A.SCC_NTFREQ_DTL_SEQ AND B.SCC_NTFREQ_ITM_SEQ = A.SCC_NTFREQ_ITM_SEQ LEFT OUTER JOIN PS_SAA_NTF_BND9_VW C ON C.SCC_NTFREQ_ID = A.SCC_NTFREQ_ID AND C.SCC_NTFREQ_DTL_SEQ = C.SCC_NTFREQ_DTL_SEQ AND C.SCC_NTFREQ_ITM_SEQ = A.SCC_NTFREQ_ITM_SEQ LEFT OUTER JOIN PS_SAA_NTF_BN10_VW D ON D.SCC_NTFREQ_ID = A.SCC_NTFREQ_ID AND D.SCC_NTFREQ_DTL_SEQ = D.SCC_NTFREQ_DTL_SEQ AND D.SCC_NTFREQ_ITM_SEQ = A.SCC_NTFREQ_ITM_SEQ LEFT OUTER JOIN PS_SAA_NTF_BN11_VW E ON E.SCC_NTFREQ_ID = A.SCC_NTFREQ_ID AND E.SCC_NTFREQ_DTL_SEQ = E.SCC_NTFREQ_DTL_SEQ AND E.SCC_NTFREQ_ITM_SEQ = A.SCC_NTFREQ_ITM_SEQ LEFT OUTER JOIN PS_SAA_NTF_BN12_VW F ON F.SCC_NTFREQ_ID = A.SCC_NTFREQ_ID AND F.SCC_NTFREQ_DTL_SEQ = F.SCC_NTFREQ_DTL_SEQ AND F.SCC_NTFREQ_ITM_SEQ = A.SCC_NTFREQ_ITM_SEQ , PS_SCC_NTFREQ_RECP G , PS_SCC_NTFREQ_ITM H WHERE A.SCC_NTFREQ_DAT_KEY = '%1' AND G.SCC_NTFREQ_ID = A.SCC_NTFREQ_ID AND G.SCC_NTFREQ_DTL_SEQ = A.SCC_NTFREQ_DTL_SEQ AND G.SCC_NTFREQ_ITM_SEQ = A.SCC_NTFREQ_ITM_SEQ AND H.SCC_NTFREQ_ID = A.SCC_NTFREQ_ID AND H.SCC_NTFREQ_DTL_SEQ = A.SCC_NTFREQ_DTL_SEQ AND H.SCC_NTFREQ_ITM_SEQ = A.SCC_NTFREQ_ITM_SEQ AND G.SCC_NTFREQ_TO <> ' ' |
| # | 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 | ADVISEE_ID | Character(11) | VARCHAR2(11) NOT NULL | Advisee ID |
| 5 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 6 | SAA_NOTE_ID | Character(5) | VARCHAR2(5) NOT NULL | This field denotes the note sequence ID for a particular advisee and institution. |
| 7 | SAA_RECIPIENT_ID | Character(11) | VARCHAR2(11) NOT NULL | Recipient ID |
| 8 | FROM_ID | Character(11) | VARCHAR2(11) NOT NULL | From ID |
| 9 | SCC_NTFREQ_TO | Character(254) | VARCHAR2(254) NOT NULL | Email Address |
| 10 | 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 |
| 11 | SCC_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Created |