SCC_NTF_CON_IDPrompt Table: SCC_NTF_CON_CFG
SCC_NTFREQ_TMPLTIDPrompt Table: SCC_NTF_TSTR_VW
Prompt Table: PEOPLE_SRCH
1=High
2=Medium
3=Low
ER=Email Recipients
NA=N/A
ST=Student
Default Value: NA
SCC_NTF_TESTER(SQL Table) |
Index Back |
|---|---|
NFK Tester RecordThe underlying record for NFK Tester utility |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCC_NTF_CON_ID |
Character(40) | VARCHAR2(40) NOT NULL |
Consumer ID
Prompt Table: SCC_NTF_CON_CFG |
| 2 | SCC_NTFREQ_TMPLTID |
Character(40) | VARCHAR2(40) NOT NULL |
Notification Template ID
Prompt Table: SCC_NTF_TSTR_VW |
| 3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
| 4 | SCC_NTFREQ_ITM_TAG | Character(20) | VARCHAR2(20) NOT NULL | Notification Item Tag |
| 5 | SCC_NTFREQ_ITMTAG1 | Character(20) | VARCHAR2(20) NOT NULL | Notification Item Tag1 |
| 6 | SCC_NTFREQ_ITMTAG2 | Character(20) | VARCHAR2(20) NOT NULL | Notification Item Tag2 |
| 7 | SCC_NTFREQ_ITMTAG3 | Character(20) | VARCHAR2(20) NOT NULL | Notification Item Tag3 |
| 8 | SCC_NTFREQ_ITMTAG4 | Character(20) | VARCHAR2(20) NOT NULL | Notification Item Tag4 |
| 9 | SCC_NTFREQ_IMPTNCE | Character(1) | VARCHAR2(1) NOT NULL |
Notification Importance
1=High 2=Medium 3=Low |
| 10 | SCC_NTF_AUDCE | Character(2) | VARCHAR2(2) NOT NULL |
Broadcast Messages Audience Flag
ER=Email Recipients NA=N/A ST=Student Default Value: NA |
| 11 | SCC_NTF_TST_PATH | Character(254) | VARCHAR2(254) NOT NULL | Email Attachment File Path. Use full path for the shared location - e.g., "\\slc00sun\Share\Attach.txt" |
| 12 | SCC_NTF_TST_NAME | Character(128) | VARCHAR2(128) NOT NULL | Email Attachment File Name |