FCLTY_CPBKUP_VW

(SQL View)
 Index Back

Commercial Paper Backup Line

Table to record backup Line of Credit for Commercial Paper facility

SELECT SETID , FCLTY_ID , EFFDT , DESCR , AMOUNT , CURRENCY_CD FROM PS_FCLTY_DFN A WHERE A.EFFDT = ( SELECT MAX(E.EFFDT) FROM PS_FCLTY_DFN E WHERE E.EFF_STATUS = 'A' AND E.FCLTY_ID = A.FCLTY_ID) AND A.FCLTY_CPBACKUP_FLG = 'Y'

  • Related Language Record: FCLTY_DFN_LNG

    • # 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 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
    6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL