FCLTY_ID_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 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_ID_LNG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FCLTY_ID Character(12) VARCHAR2(12) NOT NULL A unique key identifier that represents a given counterparty facility.

    Prompt Table: FCLTY_DFN_VW

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