GM_BUD_FA_HDR

(SQL Table)
 Index Back

F&A Data by Header

Contains Fixed and Administrative (F&A) data by budget header/version.

  • Parent record: GM_BUD_HDR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 PROPOSAL_ID Character(25) VARCHAR2(25) NOT NULL Proposal ID
    3 VERSION_ID Character(7) VARCHAR2(7) NOT NULL Version ID
    4 SUB_PROP_NBR Character(15) VARCHAR2(15) NOT NULL SUB_PROP_NBR
    5 BUDGET_ID Character(15) VARCHAR2(15) NOT NULL BUDGET_ID
    6 FA_RATE_TYPE Character(5) VARCHAR2(5) NOT NULL FA_RATE_TYPE

    Prompt Table: GM_FA_RATE_TYPE

    7 FA_INST_BASE_ID Character(5) VARCHAR2(5) NOT NULL FA_INST_BASE_ID

    Prompt Table: GM_FA_BASE_DTL

    8 FA_SPNSR_BASE_ID Character(5) VARCHAR2(5) NOT NULL Sponsor Base

    Prompt Table: GM_FA_BASE_DTL

    9 FA_BASE_ID Character(5) VARCHAR2(5) NOT NULL FA_BASE_ID

    Prompt Table: GM_FA_BASE_DTL

    10 SAME_AS_INST Character(1) VARCHAR2(1) NOT NULL Same as Institution
    N=No
    Y=Yes

    Default Value: Y