FCLTY_DFN_VW

(SQL View)
 Index Back

Redefined Facility View

View over the FCLTY_DFN table used in order to deactivate SETID and EFFDT for the purposes of entering fees.

select '1', X.FCLTY_ID, X.DESCR from PS_FCLTY_DFN x where effdt = (select max(a.effdt) from PS_FCLTY_DFN a where x.setid = a.setid and x.fclty_id = a.fclty_id and x.effdt = a.effdt) and x.eff_status = 'A'

  • Related Language Record: FCLTY_DFN_LNG_V

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FEE_TYPE Character(1) VARCHAR2(1) NOT NULL The fee transaction type.
    1=Facility Fees
    2=Deal Fees
    3=Bank Fees

    Default Value: 1

    2 FCLTY_ID Character(12) VARCHAR2(12) NOT NULL A unique key identifier that represents a given counterparty facility.

    Prompt Table: FCLTY_ID_VW

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description