GM_IN_FA_RT_VW

(SQL View)
 Index Back

Institution F&A Rate VIEW


SELECT A.SETID , A.INSTID , A.EFFDT , A.FA_RATE_TYPE , A.FA_RATE_PCT , A.DESCR FROM PS_GM_IN_FA_RATE A , PS_GM_IN_FA_AGRMT B WHERE B.SETID = A.SETID AND B.INSTID = A.INSTID AND B.EFFDT = A.EFFDT AND B.EFF_STATUS = 'A'

  • Related Language Record: GM_FA_RATE_LNG

  • Parent record: GM_IN_FA_AGRMT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    2 INSTID Character(5) VARCHAR2(5) NOT NULL Institution ID

    Prompt Table: GM_INSTITUTION

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: GM_IN_FA_AGRMT.EFFDT

    4 FA_RATE_TYPE Character(5) VARCHAR2(5) NOT NULL FA_RATE_TYPE

    Prompt Table: GM_FA_RATE_TYPE

    5 FA_RATE_PCT Number(6,2) DECIMAL(5,2) NOT NULL FA_RATE_PCT
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description