SCC_NTF_CON_PT(SQL View) |
Index Back |
---|---|
Notification Consumer Prompt |
SELECT SCC_NTF_CON_ID , SCC_NTF_CON_NAME ,SCC_STATUS ,DESCR254 FROM %Table(SCC_NTF_CON_CFG) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(40) | VARCHAR2(40) NOT NULL | Consumer ID | |
2 | SCC_NTF_CON_NAME | Character(40) | VARCHAR2(40) NOT NULL | Consumer Name |
3 | SCC_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Transaction Status
A=Active I=Inactive |
4 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |