CASH_SWP_ADD_VW

(SQL View)
Index Back

Cash Pool Add Search Record


SELECT A.SETID , A.CSH_SWEEP_ID , A.CSH_SWEEP_TYPE FROM PS_CSH_SWEEP_DEFN A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_CSH_SWEEP_DEFN B WHERE A.SETID = B.SETID AND A.CSH_SWEEP_ID = B.CSH_SWEEP_ID)

# 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

Default Value: P