SCC_TRANSAC_CDSAD_PDL_TRAN_VW(SQL View) |
Index Back |
|---|---|
View for Transaction codes.View for Transaction codes of SAD_PDL_HDR_STG. |
| SELECT DISTINCT A.SCC_TRANSAC_CD ,B.SCC_TRANSACTION FROM PS_SAD_PDL_HDR_STG A ,PS_SCC_TRNS_CD_VW B WHERE A.SCC_TRANSAC_CD=B.SCC_TRANSAC_CD AND A.INSTITUTION=' ' |
| # | 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 |