SCC_NTF_CON_IDPrompt Table: SCC_NTF_CON_CFG
R=Read Only
U=Read/Update
SCC_NTF_INSCNVW(SQL View) |
Index Back |
|---|---|
Notification Consumer Security |
| SELECT A.SCC_NTF_CON_ID ,B.SCC_NTF_CON_NAME ,A.SCC_ACCESS_CODE FROM %Table(SCC_NTF_INSTCON) A , %Table(SCC_NTF_CON_CFG) B WHERE A.SCC_NTF_CON_ID = B.SCC_NTF_CON_ID |
| # | 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_NTF_CON_NAME | Character(40) | VARCHAR2(40) NOT NULL | Consumer Name |
| 3 | SCC_ACCESS_CODE | Character(1) | VARCHAR2(1) NOT NULL |
Access Code
R=Read Only U=Read/Update |