SCC_NTFREQ_VW(SQL View) |
Index Back |
|---|---|
Notification Items ViewUsed to retrieve the list of notification items for the self service notification center component |
| SELECT DTL.EMPLID ,ITM.SCC_NTFREQ_TYPE MSGTYPE ,ITM.SCC_ROW_ADD_DTTM ,RECP.SCC_NTFREQ_SENDER ,ITM.SCC_NTFREQ_IMPTNCE IMPORTANCE ,ITM.SCC_NTFREQ_SUBJECT SUBJECT ,ITM.SCC_NTFREQ_ID ,ITM.SCC_NTFREQ_DTL_SEQ ,ITM.SCC_NTFREQ_ITM_SEQ ,ITM.SCC_NTFREQ_ITM_STS ,ITM.SCC_NTFREQ_SUB_STS ,RECP.SCC_NTFREQ_TO ,RECP.SCC_NTFREQ_CC ,ITM.SCC_NTFREQ_MSGTEXT ,CFG.SCC_NTF_CON_ID ,CFG.SCC_NTF_CON_NAME ,ITM.SCC_NTFREQ_TMPLTID ,SETUP.SCC_NTFREQ_TMPLT ,SETUP.SCC_NTFREQ_TO_CLS ,DTL.SCC_NTF_AUDCE ,ITM.SCC_NTF_DATE_FROM ,ITM.SCC_NTF_DATE_TO ,SETUP.SCC_NTF_MOB_APPNAM FROM PS_SCC_NTFREQ_HDR HDR ,PS_SCC_NTF_DTL_VW2 DTL ,PS_SCC_NTFREQ_ITM ITM ,PS_SCC_NTF_SETUP SETUP ,PS_SCC_NTFREQ_RECP RECP ,PS_SCC_NTF_CON_CFG CFG WHERE HDR.SCC_NTFREQ_ID = DTL.SCC_NTFREQ_ID AND DTL.SCC_NTFREQ_ID = ITM.SCC_NTFREQ_ID AND DTL.SCC_NTFREQ_DTL_SEQ = ITM.SCC_NTFREQ_DTL_SEQ AND ITM.SCC_NTFREQ_TMPLTID = SETUP.SCC_NTFREQ_TMPLTID AND ITM.SCC_NTFREQ_ID = RECP.SCC_NTFREQ_ID AND ITM.SCC_NTFREQ_DTL_SEQ = RECP.SCC_NTFREQ_DTL_SEQ AND ITM.SCC_NTFREQ_ITM_SEQ = RECP.SCC_NTFREQ_ITM_SEQ AND HDR.SCC_NTF_CON_ID = CFG.SCC_NTF_CON_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | 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 |
| 3 | SCC_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Created |
| 4 | SCC_NTFREQ_SENDER | Character(254) | VARCHAR2(254) NOT NULL | Sender |
| 5 | SCC_NTFREQ_IMPTNCE | Character(1) | VARCHAR2(1) NOT NULL |
Notification Importance
1=High 2=Medium 3=Low |
| 6 | SCC_NTFREQ_SUBJECT | Character(254) | VARCHAR2(254) NOT NULL | Subject |
| 7 | SCC_NTFREQ_ID | Number(16,0) | DECIMAL(16) NOT NULL | Notification ID |
| 8 | SCC_NTFREQ_DTL_SEQ | Number(5,0) | INTEGER NOT NULL | Notification Detail Sequence |
| 9 | SCC_NTFREQ_ITM_SEQ | Number(5,0) | INTEGER NOT NULL | Notification Item Sequence |
| 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 |
| 12 | SCC_NTFREQ_TO | Character(254) | VARCHAR2(254) NOT NULL | Email Address |
| 13 | SCC_NTFREQ_CC | Character(254) | VARCHAR2(254) NOT NULL | Email Address |
| 14 | SCC_NTFREQ_MSGTEXT | Long Character | CLOB | Message text |
| 15 | SCC_NTF_CON_ID | Character(40) | VARCHAR2(40) NOT NULL | Consumer ID |
| 16 | SCC_NTF_CON_NAME | Character(40) | VARCHAR2(40) NOT NULL | Consumer Name |
| 17 | SCC_NTFREQ_TMPLTID | Character(40) | VARCHAR2(40) NOT NULL | Notification Template ID |
| 18 | SCC_NTFREQ_TMPLT | Character(30) | VARCHAR2(30) NOT NULL | Template Name |
| 19 | SCC_NTFREQ_TO_CLS | Character(254) | VARCHAR2(254) NOT NULL | Application Class |
| 20 | SCC_NTF_AUDCE | Character(2) | VARCHAR2(2) NOT NULL |
Broadcast Messages Audience Flag
ER=Email Recipients NA=N/A ST=Student |
| 21 | SCC_NTF_DATE_FROM | Date(10) | DATE | Date From |
| 22 | SCC_NTF_DATE_TO | Date(10) | DATE | Date To |
| 23 | SCC_NTF_MOB_APPNAM | Character(50) | VARCHAR2(50) NOT NULL | Application Name |