GM_FA_OPTIONS

(SQL Table)
 Index Back

F&A Options by Business Unit

Facilities and Administration options for each Business Unit. Used in Grants Management for the F&A calculation process.

  • Parent Record Of GM_FA_OPTIONS2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_GL_NONVW

    2 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

    Prompt Table: ACCOUNT_EXP_VW

    3 DST_ID Character(10) VARCHAR2(10) NOT NULL Distribution Code

    Prompt Table: DST_CODE_REV_VW

    4 TREE_SETID Character(5) VARCHAR2(5) NOT NULL Tree SetID

    Prompt Table: SP_SETID_NONVW

    5 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name

    Prompt Table: GM_TREE_NAME_VW
    Set Control Field: TREE_SETID

    6 FA_CALC_SPONSOR Character(1) VARCHAR2(1) NOT NULL Sponsor F&&A

    Y/N Table Edit

    Default Value: Y

    7 FA_CALC_WAIVED Character(1) VARCHAR2(1) NOT NULL Waived F&&A

    Y/N Table Edit

    Default Value: N

    8 FA_CALC_COSTSHARED Character(1) VARCHAR2(1) NOT NULL Cost Shared F&&A

    Y/N Table Edit

    Default Value: N

    9 FA_BCM_EXPENSE Character(1) VARCHAR2(1) NOT NULL Expense

    Y/N Table Edit

    Default Value: Y

    10 FA_BCM_REV_OFFSET Character(1) VARCHAR2(1) NOT NULL Revenue Offset

    Y/N Table Edit

    Default Value: N

    11 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template

    Prompt Table: JRNLGEN_APPL_ID

    12 EXCLUDE_PROJECT Character(1) VARCHAR2(1) NOT NULL Exclude Project From Offsets

    Y/N Table Edit

    Default Value: N

    13 FA_PREAWD_STATUS Character(3) VARCHAR2(3) NOT NULL Preaward Spending
    PND=Pending
    RDY=Ready

    Default Value: RDY

    14 FA_AWARD_STATUS Character(3) VARCHAR2(3) NOT NULL Generated Award
    PND=Pending
    RDY=Ready

    Default Value: RDY

    15 FA_RDY_ACTIVATE Character(1) VARCHAR2(1) NOT NULL Ready at Activation

    Y/N Table Edit

    Default Value: N