OPRIDDefault Value: SCC_BAT_NTF_RC.OPRID
RUN_CNTL_IDDefault Value: SCC_BAT_NTF_RC.RUN_CNTL_ID
SCC_NTF_CON_IDSCC_NTFREQ_TMPLTIDSEQNOPrompt Table: PSRECFIELD
SCC_BATNTF_DATA(SQL Table) |
Index Back |
|---|---|
bat ntf data |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: SCC_BAT_NTF_RC.OPRID |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL |
Run Control ID
Default Value: SCC_BAT_NTF_RC.RUN_CNTL_ID |
| 3 | SCC_NTF_CON_ID |
Character(40) | VARCHAR2(40) NOT NULL | Consumer ID |
| 4 | SCC_NTFREQ_TMPLTID |
Character(40) | VARCHAR2(40) NOT NULL | Notification Template ID |
| 5 | SEQNO |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 6 | SCC_NTFREQ_DAT_KEY | Character(18) | VARCHAR2(18) NOT NULL | Data Key |
| 7 | SCC_NTFREQ_DAT_VAL | Long Character | CLOB | Value |
| 8 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: PSRECFIELD |