GRP_INCR_BUDGET

(SQL Table)
 Index Back

Group Pay Increase Budget

GRP_INCR_BUDGET is the budget record for the Salary Planning application. It contains information regarding each budget period being planned as of the start date of the planning process for each group participating in the plan. There will be one record in this table for each group/budget start date/salary action combination. This allows for the establishment of separate budgets for salary actions such as pay increases and promotions. The budgeting portion of the Salary Planning application is an optional feature. It will be completed only by users who want to capture budgets and compare the salary increase plans to those budgets.

  • Parent record: GRP_INCR_BUDGT1

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.

    Prompt Table: GB_GROUP_TBL

    2 BUDGET_START_DT Date(10) DATE NOT NULL Budget Period Start Date

    Default Value: GROUP_INCR_CNTL.BUDGET_START_DT

    Prompt Table: GROUP_INCR_CNTL

    3 BUDGET_ID Character(10) VARCHAR2(10) NOT NULL Budget ID
    4 EFFDT Date(10) DATE NOT NULL Effective Date
    5 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    6 ACTION Character(3) VARCHAR2(3) NOT NULL Action

    Prompt Table: ACTION_SP_VW

    7 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code

    Prompt Table: ACTN_REASON_TBL

    8 REQUESTED_PCT Number(6,2) DECIMAL(5,2) NOT NULL Requested Percent
    9 REQUESTED_AMT Number(19,3) DECIMAL(18,3) NOT NULL Requested Amount
    10 REQUEST_DT Date(10) DATE Request Date
    11 CURR_BUDGET_PCT Number(6,2) DECIMAL(5,2) NOT NULL Current Budget Percent
    12 CURR_BUDGET_AMT Number(19,3) DECIMAL(18,3) NOT NULL Current Budget Amount
    13 BUDGET_APPROVED Character(1) VARCHAR2(1) NOT NULL Budget Approved

    Y/N Table Edit

    Default Value: N

    14 BUDGET_APPROVAL_DT Date(10) DATE Budget Approval Date
    15 APPROVED Character(1) VARCHAR2(1) NOT NULL Approved

    Y/N Table Edit

    Default Value: N

    16 APPRVL_DT Date(10) DATE Approval Date
    17 APPROVER_ID Character(11) VARCHAR2(11) NOT NULL Approver EmplID

    Default Value: GB_GROUP_TBL.MANAGER_ID

    Prompt Table: PERSON_NAME

    18 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    19 TOTAL_CALC_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Total Budget Amount
    20 TOTAL_PERCENT Signed Number(9,2) DECIMAL(7,2) NOT NULL Total Percent Increases
    21 AVG_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Average Percent by Actn Reason
    22 SP_BUDGET_TYPE Character(20) VARCHAR2(20) NOT NULL Budget Type

    Prompt Table: SP_BUD_TYPE_VW

    23 CURR_BUDGET_AMT2 Signed Number(20,3) DECIMAL(18,3) NOT NULL Current Budget Amount
    24 APPRV_BUDGET_AMT Signed Number(20,3) DECIMAL(18,3) NOT NULL Approved Budget Amount
    25 ALLOC_BUDGET_AMT Signed Number(20,3) DECIMAL(18,3) NOT NULL Allocation Amount
    26 RESERVE_AMT Signed Number(20,3) DECIMAL(18,3) NOT NULL Reserve Amount
    27 VAC_POS_BUDGET_AMT Signed Number(20,3) DECIMAL(18,3) NOT NULL Vacant Position Budget Amount
    28 NEW_POS_BUDGET_AMT Signed Number(20,3) DECIMAL(18,3) NOT NULL New Position Budget Amount
    29 USER_DEFINED_FLD1 Signed Number(20,3) DECIMAL(18,3) NOT NULL User Defined field
    30 USER_DEFINED_FLD2 Signed Number(20,3) DECIMAL(18,3) NOT NULL User Defined field
    31 USER_DEFINED_FLD3 Signed Number(20,3) DECIMAL(18,3) NOT NULL User Defined field
    32 USER_DEFINED_FLD4 Signed Number(20,3) DECIMAL(18,3) NOT NULL User Defined field
    33 USER_DEFINED_FLD5 Signed Number(20,3) DECIMAL(18,3) NOT NULL User Defined field
    34 USER_DEFINED_FLD6 Signed Number(20,3) DECIMAL(18,3) NOT NULL User Defined field
    35 SP_CHECKBOX1 Character(1) VARCHAR2(1) NOT NULL Checkbox

    Y/N Table Edit

    Default Value: N

    36 SP_CHECKBOX2 Character(1) VARCHAR2(1) NOT NULL Checkbox

    Y/N Table Edit

    Default Value: N

    37 SP_CHECKBOX3 Character(1) VARCHAR2(1) NOT NULL Checkbox

    Y/N Table Edit

    Default Value: N

    38 SP_CHECKBOX4 Character(1) VARCHAR2(1) NOT NULL Checkbox

    Y/N Table Edit

    Default Value: N

    39 SP_CHECKBOX5 Character(1) VARCHAR2(1) NOT NULL Checkbox

    Y/N Table Edit

    Default Value: N

    40 SP_CHECKBOX6 Character(1) VARCHAR2(1) NOT NULL Checkbox

    Y/N Table Edit

    Default Value: N