GM_BUD_PERIOD

(SQL Table)
 Index Back

Grants Budget Period

The budget period is the first level of subdivision within a Grants budget. Periods are usually but not always one year in duration. Below period, the budget is further broken down into summary lines, detail lines, etc.

  • Related Language Record: GM_BUD_PER_LNG

  • 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

    Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT

    Prompt Table: SP_BU_PC_NONVW

    2 PROPOSAL_ID Character(25) VARCHAR2(25) NOT NULL Proposal ID

    Prompt Table: GM_PROP_ID_VW

    3 VERSION_ID Character(7) VARCHAR2(7) NOT NULL Version ID

    Prompt Table: GM_PROPOSAL

    4 SUB_PROP_NBR Character(15) VARCHAR2(15) NOT NULL SUB_PROP_NBR

    Prompt Table: GM_PROP_PROJ

    5 BUDGET_ID Character(15) VARCHAR2(15) NOT NULL BUDGET_ID

    Prompt Table: GM_BUD_HDR

    6 BUDGET_PERIOD_GM Number(3,0) SMALLINT NOT NULL BUDGET_PERIOD_GM

    Default Value: 1

    7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: GM_PROPOSAL.CURRENCY_CD

    8 BEGIN_DT Date(10) DATE NOT NULL Begin Date
    9 END_DT Date(10) DATE NOT NULL End Date
    10 TARGET_BUDGET_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Target Sponsor Budget
    11 ANTICIPATED_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Allowable Aniticipated Amount
    12 NO_ALLOW_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Not Allowable Anticipat Amount
    13 GM_SOURCE_INCOME Character(30) VARCHAR2(30) NOT NULL Source
    14 COST_SHARE_PCT Number(6,2) DECIMAL(5,2) NOT NULL COST_SHARE_PCT
    15 SPONSOR_FA_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL SPONSOR_FA_AMT
    16 COST_SHARE_FA_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL COST_SHARE_FA_AMT
    17 DAYS_ELAPSED Number(4,0) SMALLINT NOT NULL Days Elapsed
    18 NUM_TRNEES Number(3,0) SMALLINT NOT NULL Number of Participant/Trainees
    19 DESCRLONG Long Character CLOB Long Description