GM_IN_FA_AGRMT

(SQL Table)
 Index Back

F&A Rate Agreement

  • Related Language Record: GM_FA_AGRMT_LNG

  • Parent Record Of GM_FA_RATE_LNG GM_FRNG_RT_VW GM_IN_FA_RATE GM_IN_FA_RT_VW GM_IN_FRINGE GM_IN_FRINGE_RT

    • # 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: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 FA_AGREEMENT_NBR Character(11) VARCHAR2(11) NOT NULL Agreement Number
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 NEGOTIATION_AGENCY Character(1) VARCHAR2(1) NOT NULL Negotiation Agency
    D=DHHS
    O=ONR
    T=Other

    Default Value: D

    8 FA_AGREEMENT_DT Date(10) DATE Agreement Date
    9 FA_NEG_RT_STAT Character(4) VARCHAR2(4) NOT NULL Rate Negotiation Status
    FINL=Final
    FIXD=Fixed
    PRED=Pre-determined
    PROV=Provisional
    10 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50