SCC_NTFREQ_IDSCC_NTFREQ_DTL_SEQSCC_NTFREQ_ITM_SEQSAA_NTF_BN11_VW(SQL View) |
Index Back |
|---|---|
Recipient Email Template Bind |
| SELECT SCC_NTFREQ_ID , SCC_NTFREQ_DTL_SEQ , SCC_NTFREQ_ITM_SEQ , SCC_NTFREQ_DAT_VAL FROM PS_SCC_NTFREQ_DATA WHERE SCC_NTFREQ_DAT_KEY = '%11' |
| # | 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_NTFREQ_DAT_VAL | Long Character | CLOB | Value |