FCLTY_DFN_LNG_V

(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, B.LANGUAGE_CD, X.DESCR from ps_fclty_dfn x, PS_FCLTY_DFN_LNG b where x.setid = b.setid and x.fclty_id = b.fclty_id and x.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 for FCLTY_DFN_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description