FCLTY_DFN_SCH_L

(SQL View)
Index Back

Search Record for Facilities


SELECT F.SETID , F.FCLTY_ID , F.FACILITY_TYPE , R.LANGUAGE_CD , R.DESCR FROM PS_FCLTY_DFN F , PS_FCLTY_DFN_LNG R WHERE F.SETID = R.SETID AND F.FCLTY_ID = R.FCLTY_ID AND R.EFFDT = ( SELECT MAX(E.EFFDT) FROM PS_FCLTY_DFN_LNG E WHERE E.SETID = R.SETID AND E.FCLTY_ID = R.FCLTY_ID)

  • Related Language Record for FCLTY_DEBT_SRCH FCLTY_DFN_SRCH
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

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

    Prompt Table: FCLTY_DFN

    3 FACILITY_TYPE Character(1) VARCHAR2(1) NOT NULL 3/19/2004 RJB Facility Type field for determining LOC, CP, and Other types of Facilities
    1=Other Cash Needs
    2=Line of Credit
    3=Commercial Paper

    Default Value: 1

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description