FCLTY_LMTDFN_VW

(SQL View)
 Index Back

Redefined Facility limit View

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

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

  • Related Language Record: FCLTY_LMD_LNG_V

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