GM_FRNG_RT_VW

(SQL View)
 Index Back

Institution Fringe Benefit VW


SELECT A.SETID, A.INSTID, A.EFFDT, A.GM_FEDERAL_FLAG, A.FRINGE_RATE_TYPE, A.FRINGE_RATE, A.ANNUAL_FRINGE_AMT FROM PS_GM_IN_FRINGE_RT A

  • 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
    4 GM_FEDERAL_FLAG Character(1) VARCHAR2(1) NOT NULL Federal

    Y/N Table Edit

    Default Value: N

    5 FRINGE_RATE_TYPE Character(3) VARCHAR2(3) NOT NULL Fringe Rate Type
    FAC=Faculty
    OTH=Other
    REG=Regular
    TMP=Temporary
    6 FRINGE_RATE Number(6,2) DECIMAL(5,2) NOT NULL Fringe Rate
    7 ANNUAL_FRINGE_AMT Number(27,3) DECIMAL(26,3) NOT NULL ANNUAL_FRINGE_AMT