CSWEEP_REQ_VW

(SQL View)
 Index Back

Cash Sweep Request View


SELECT A.SETID , A.CSH_SWEEP_ID , A.CSH_SWEEP_TYPE , A.CSH_SWEEP_ACT_TYPE , A.BANK_CD , A.BANK_ACCT_KEY FROM PS_CSH_SWEEP_DEFN A WHERE A.APPR_STATUS = 'A' AND A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_CSH_SWEEP_DEFN WHERE SETID = A.SETID AND CSH_SWEEP_ID = A.CSH_SWEEP_ID AND CSH_SWEEP_TYPE = A.CSH_SWEEP_TYPE)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

2 CSH_SWEEP_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies a Cash Sweep/Concentratoin structure. The identifier is manually entered by the user and not automatically generated by the system.
3 CSH_SWEEP_TYPE Character(1) VARCHAR2(1) NOT NULL Cash Sweep Type - Physical or Notional.
N=Notional
P=Physical
4 CSH_SWEEP_ACT_TYPE Character(1) VARCHAR2(1) NOT NULL Cash Sweep Activity Type
B=Bi-Directional
C=Concentration
F=Funding
5 BANK_CD Character(5) VARCHAR2(5) NOT NULL Master Bank Code
6 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank