SCC_TXN_PROC_VW

(SQL View)
 Index Back

Constituent Stage SearchRecord

Constituent Staging Search Record that joins to a security view

SELECT SEC.OPRID ,TXDEF.SCC_TRANSAC_CD ,TXDEF.SCC_TRNSAC_DESCR ,TXDEF.RECNAME FROM PS_SCC_TRNSAC_DTLS TXDEF , PS_SCC_SL_TRN_SCTY SEC WHERE TXDEF.SCC_STATUS = 'A' AND TXDEF.SCC_NUR_INDICATOR = 'N' AND (TXDEF.SCC_TRANSAC_CD = SEC.SCC_TRANSAC_CD OR SEC.SCC_TRANSAC_CD = 'ALL') AND SEC.ACCESS_CD = 'Y' AND EXISTS ( SELECT 'X' FROM PSRECFIELD RF1 WHERE RF1.RECNAME = TXDEF.RECNAME AND RF1.FIELDNAME = 'SCC_TEMP_ID' ) AND EXISTS ( SELECT 'X' FROM PSRECFIELD RF1 WHERE RF1.RECNAME = TXDEF.RECNAME AND RF1.FIELDNAME = 'SCC_TRANS_STS' ) AND EXISTS ( SELECT 'X' FROM PSRECFIELD RF1 WHERE RF1.RECNAME = TXDEF.RECNAME AND RF1.FIELDNAME = 'SCC_TRANSAC_CD' )

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

Prompt Table: SCC_TRN_SCTY_VW

3 SCC_TRNSAC_DESCR Character(200) VARCHAR2(200) NOT NULL Transaction Description
4 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).