SCC_NTF_ADMN_VW(SQL View) |
Index Back |
|---|---|
Notification Admin Record |
| SELECT B.EMPLID ,A.SCC_NTFREQ_ID ,A.SCC_NTFREQ_DTL_SEQ ,A.SCC_NTFREQ_ITM_SEQ ,A.SCC_NTFREQ_TYPE ,D.SCC_NTF_CON_ID ,D.SCC_NTF_CON_NAME ,F.SCC_NTFREQ_TMPLTID ,F.SCC_NTFREQ_TMPLT ,G.SCC_NTFREQ_TMP_CLS ,A.SCC_NTFREQ_IMPTNCE ,A.SCC_NTFREQ_ITM_STS ,A.SCC_NTFREQ_SUB_STS ,A.SCC_NTF_DATE_FROM ,A.SCC_NTF_DATE_TO ,A.SCC_NTFREQ_SUBJECT ,A.SCC_NTFREQ_MSGTEXT ,E.SCC_NTFREQ_SENDER ,E.SCC_NTFREQ_TO ,E.SCC_NTFREQ_CC ,E.SCC_NTFREQ_BCC ,A.SCC_ROW_ADD_DTTM ,A.SCC_ROW_ADD_OPRID ,B.SCC_NTF_AUDCE ,F.SCC_NTF_MOB_APPNAM FROM PS_SCC_NTFREQ_ITM A , PS_SCC_NTF_DTL_VW2 B ,PS_SCC_NTFREQ_HDR C ,PS_SCC_NTF_CON_CFG D , PS_SCC_NTFREQ_RECP E ,PS_SCC_NTF_SETUP F ,PS_SCC_NTF_CON_TMP G WHERE C.SCC_NTFREQ_ID = B.SCC_NTFREQ_ID AND B.SCC_NTFREQ_ID = A.SCC_NTFREQ_ID AND B.SCC_NTFREQ_DTL_SEQ = A.SCC_NTFREQ_DTL_SEQ AND A.SCC_NTFREQ_ID = E.SCC_NTFREQ_ID AND A.SCC_NTFREQ_DTL_SEQ = E.SCC_NTFREQ_DTL_SEQ AND A.SCC_NTFREQ_ITM_SEQ = E.SCC_NTFREQ_ITM_SEQ AND F.SCC_NTFREQ_TMPLTID = A.SCC_NTFREQ_TMPLTID AND D.SCC_NTF_CON_ID = C.SCC_NTF_CON_ID AND F.SCC_NTFREQ_TMPLTID = G.SCC_NTFREQ_TMPLTID AND C.SCC_NTF_CON_ID = G.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_ID |
Number(16,0) | DECIMAL(16) NOT NULL | Notification ID |
| 3 | SCC_NTFREQ_DTL_SEQ |
Number(5,0) | INTEGER NOT NULL | Notification Detail Sequence |
| 4 | SCC_NTFREQ_ITM_SEQ |
Number(5,0) | INTEGER NOT NULL | Notification Item Sequence |
| 5 | 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 |
| 6 | SCC_NTF_CON_ID | Character(40) | VARCHAR2(40) NOT NULL | Consumer ID |
| 7 | SCC_NTF_CON_NAME | Character(40) | VARCHAR2(40) NOT NULL | Consumer Name |
| 8 | SCC_NTFREQ_TMPLTID | Character(40) | VARCHAR2(40) NOT NULL | Notification Template ID |
| 9 | SCC_NTFREQ_TMPLT | Character(30) | VARCHAR2(30) NOT NULL | Template Name |
| 10 | SCC_NTFREQ_TMP_CLS | Character(254) | VARCHAR2(254) NOT NULL | Application Class |
| 11 | SCC_NTFREQ_IMPTNCE | Character(1) | VARCHAR2(1) NOT NULL |
Notification Importance
1=High 2=Medium 3=Low |
| 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 |
| 14 | SCC_NTF_DATE_FROM | Date(10) | DATE | Date From |
| 15 | SCC_NTF_DATE_TO | Date(10) | DATE | Date To |
| 16 | SCC_NTFREQ_SUBJECT | Character(254) | VARCHAR2(254) NOT NULL | Subject |
| 17 | SCC_NTFREQ_MSGTEXT | Long Character | CLOB | Message text |
| 18 | SCC_NTFREQ_SENDER | Character(254) | VARCHAR2(254) NOT NULL | Sender |
| 19 | SCC_NTFREQ_TO | Character(254) | VARCHAR2(254) NOT NULL |
Email Address
Prompt Table: PEOPLE_SRCH |
| 20 | SCC_NTFREQ_CC | Character(254) | VARCHAR2(254) NOT NULL | Email Address |
| 21 | SCC_NTFREQ_BCC | Character(254) | VARCHAR2(254) NOT NULL | Email Address |
| 22 | SCC_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Created |
| 23 | SCC_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Created By |
| 24 | SCC_NTF_AUDCE | Character(2) | VARCHAR2(2) NOT NULL |
Broadcast Messages Audience Flag
ER=Email Recipients NA=N/A ST=Student |
| 25 | SCC_NTF_MOB_APPNAM | Character(50) | VARCHAR2(50) NOT NULL | Application Name |