GM_BUD_LINE_DTL

(SQL Table)
 Index Back

Grants Budget Line Detail

Budget line detail contains an optional breakdown of a budget summary line. For example, the detail level can identify major pieces of equipment that are summarized in the parent 'Equipment' summary line. For salary and fringe categories, the detail level describes the participation of individual employees/investigators.

  • Related Language Record: GM_BUD_LN_LNG

  • Parent record: GM_BUD_LINE_SUM

    • # 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_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

    Prompt Table: GM_BUD_PERIOD

    7 BUDGET_LN Number(6,0) INTEGER NOT NULL BUDGET_LN
    8 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
    9 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    10 BEGIN_DT Date(10) DATE Begin Date

    Default Value: GM_BUD_PERIOD.BEGIN_DT

    11 END_DT Date(10) DATE End Date

    Default Value: GM_BUD_PERIOD.END_DT

    12 UNIT_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Unit Cost
    13 QTY_GM Number(9,2) DECIMAL(8,2) NOT NULL QTY_GM
    14 BUDGET_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL BUDGET_AMT
    15 ROW_NUMBER Number(3,0) SMALLINT NOT NULL Row_Number

    Prompt Table: GM_PROP_PROF

    16 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

    Prompt Table: GM_BUD_JOB_VW

    17 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage

    Default Value: 100

    18 APPT_TYPE_CALENDAR Character(1) VARCHAR2(1) NOT NULL APPT_TYPE_CALENDAR

    Y/N Table Edit

    Default Value: N

    19 APPT_TYPE_ACADEMIC Character(1) VARCHAR2(1) NOT NULL APPT_TYPE_ACADEMIC

    Y/N Table Edit

    Default Value: N

    20 APPT_TYPE_SUMMER Character(1) VARCHAR2(1) NOT NULL APPT_TYPE_SUMMER

    Y/N Table Edit

    Default Value: N

    21 APPT_TYPE_MONTHS Number(3,0) SMALLINT NOT NULL Months for Appointment Type
    22 ANNUAL_SALARY_GM Number(27,3) DECIMAL(26,3) NOT NULL NNUAL_SALARY_GM
    23 ANNUAL_FRINGE_AMT Number(27,3) DECIMAL(26,3) NOT NULL ANNUAL_FRINGE_AMT
    24 FRINGE_RATE Number(6,2) DECIMAL(5,2) NOT NULL Fringe Rate
    25 COST_LIV_INCR_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Cost of Living Increase Pct
    26 COST_LIV_INCR_DT Date(10) DATE COST_LIV_INCR_DT
    27 MERIT_INCR_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL MERIT_INCR_PCT
    28 MERIT_INCR_DT Date(10) DATE MERIT_INCR_DT
    29 FIXED_SALARY_AMT Number(27,3) DECIMAL(26,3) NOT NULL FIXED_SALARY_AMT
    30 FIXED_FRINGE_AMT Number(27,3) DECIMAL(26,3) NOT NULL FIXED_FRINGE_AMT
    31 FRINGE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL FRINGE_AMT
    32 NUMBER_OF_ANIMALS Number(5,0) INTEGER NOT NULL NUMBER_OF_ANIMALS
    33 ANIMALS_PER_CAGE Number(5,0) INTEGER NOT NULL ANIMALS_PER_CAGE
    34 AMOUNT_1ST_DAY Number(27,3) DECIMAL(26,3) NOT NULL AMOUNT_1ST_DAY
    35 AMOUNT_DAILY_CHARG Number(27,3) DECIMAL(26,3) NOT NULL AMOUNT_DAILY_CHARG
    36 DAYS_ELAPSED Number(4,0) SMALLINT NOT NULL Days Elapsed
    37 APPT_TYPE Character(3) VARCHAR2(3) NOT NULL Appointment Type
    38 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    39 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: PC_RATE_JOBC
    Set Control Field: BUSINESS_UNIT_PC

    40 QTY_INTEGER Number(11,0) DECIMAL(11) NOT NULL Quantity Rounded to 0 Decimals

    Default Value: 1

    41 NBR_OF_HOURS Number(5,0) INTEGER NOT NULL Number of Hours
    42 QTY_X_HOURS Number(11,0) DECIMAL(11) NOT NULL Quantity * Hours
    43 NBR_OF_DAYS Number(5,0) INTEGER NOT NULL Number of Days
    44 WEEKLY_WEEKS Number(3,0) SMALLINT NOT NULL Weeks
    45 QTY_X_WEEKS Number(11,0) DECIMAL(11) NOT NULL Quantity * Weeks
    46 STD_BILL_RATE Number(27,3) DECIMAL(26,3) NOT NULL Standard Bill Rate

    Default Value: 0

    47 ADJUSTED_FLAG_BILL Character(1) VARCHAR2(1) NOT NULL Adjusted Flag
    H=Header Level Adjustment
    L=Line Level Adjustment
    N=No Adjustments

    Default Value: N

    48 ADJUST_OPTION_BILL Character(1) VARCHAR2(1) NOT NULL Adjustment Option Bill Rate
    A=Flat Amount
    N=No Adjustment
    P=Percentage
    R=New Rate

    Default Value: N

    49 ADJUSTMENT_BILLAMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Adjustment Bill Amount
    50 ADJUSTMENT_BILLPCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Adjustment Bill Percent
    51 ADJUSTMENT_BILL_RT Number(27,3) DECIMAL(26,3) NOT NULL Adjustment Bill Rate
    52 ACTUAL_BILL_RATE Number(27,3) DECIMAL(26,3) NOT NULL Actual Bill Rate
    53 STD_COST_RATE Number(27,3) DECIMAL(26,3) NOT NULL Standard Cost Rate

    Default Value: 0

    54 ADJUSTED_FLAG_COST Character(1) VARCHAR2(1) NOT NULL Adjusted Flag
    H=Header Level Adjustment
    L=Line Level Adjustment
    N=No Adjustments

    Default Value: N

    55 ADJUST_OPTION_COST Character(1) VARCHAR2(1) NOT NULL Adjustment Option Cost Rate
    A=Flat Amount
    N=No Adjustment
    P=Percentage
    R=New Rate

    Default Value: N

    56 ADJUSTMENT_COSTAMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Adjustment Cost Amount
    57 ADJUSTMENT_COSTPCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Adjustment Cost Percent
    58 ADJUSTMENT_COST_RT Number(27,3) DECIMAL(26,3) NOT NULL Adjustment Cost Rate
    59 ACTUAL_COST_RATE Number(27,3) DECIMAL(26,3) NOT NULL Actual Cost Rate
    60 BILL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Bill Amount
    61 COST_AMT Number(27,3) DECIMAL(26,3) NOT NULL Cost Amount
    62 PM_MARGIN_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Margin Percent
    63 RS_RESRC_TEMPLT_ID Character(10) VARCHAR2(10) NOT NULL Resource Template ID

    Prompt Table: RS_RESRC_TMP_VW

    64 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role

    Prompt Table: RS_PROJROLE_VW

    65 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PC_RATE_EMPL

    66 REVIEW Character(1) VARCHAR2(1) NOT NULL Review
    67 RES_RATE_FLG Character(1) VARCHAR2(1) NOT NULL Resource Rate
    E=Employee ID
    J=Job Code
    R=Role Type

    Default Value: J

    68 NOTE Long Character(256) VARCHAR2(256) Note