SCC_TRN_SCTY_VW

(SQL View)
 Index Back

Transaction Security by OPRID

Transaction Security View by Oprid

SELECT DISTINCT A.SCC_TRANSAC_CD ,B.OPRID FROM PS_SCC_TRNSAC_DTLS A , PS_SCC_SL_TRN_SCTY B WHERE A.SCC_STATUS = 'A' AND (A.SCC_TRANSAC_CD = B.SCC_TRANSAC_CD OR B.SCC_TRANSAC_CD = 'ALL') AND B.ACCESS_CD = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCC_TRANSAC_CD Character(25) VARCHAR2(25) NOT NULL Transaction
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).