SCC_TRNDTL_UC_V(SQL View) |
Index Back |
---|---|
Tran Mgr RegistryThe Constituent Transaction Manager Core setup table view. Only UCAS and APPLY transactions will be returned. |
SELECT SCC_TRANSAC_CD , SCC_TRANSACTION FROM PS_SCC_TRNSAC_DTLS WHERE SCC_TRANSAC_CD IN ('UCAS', 'APPLY') |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SCC_TRANSAC_CD | Character(25) | VARCHAR2(25) NOT NULL | Transaction |
2 | SCC_TRANSACTION | Character(30) | VARCHAR2(30) NOT NULL | Transaction Name |