FCLTY_ID_LNG_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, 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_ID_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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description