GM_BUD_CATEGORY

(SQL Table)
 Index Back

Budget Category Control Table

This table stores Budget Category/Budget Item detail information. Budget Items are used to default values into PC_BUD_DETAIL and also for comparisons of Budget vs Actual for Budget Analysis. 06/01/2004- PR_FS_B005 Changes as per Estimanting Labor PRL/ARL changes TDD 11/11/2004 - Changing the Object Owner Id to Projects

  • Related Language Record: GM_BUD_CAT_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 BUDGET_CATEGORY Character(15) VARCHAR2(15) NOT NULL BUDGET_CATEGORY
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %DATE

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 BUD_CAT_TYPE Character(4) VARCHAR2(4) NOT NULL Budget Item Type

    Prompt Table: GM_BUD_CAT_TYPE

    7 GM_BUD_GROUP Character(4) VARCHAR2(4) NOT NULL Grants.Gov Grouping Type
    DTRV=Domestic Travel
    EQUP=Equipment
    FEE=Fee
    FTRV=Foreign Travel
    ODIR=Other Direct Cost
    PERS=Personnel
    PTRN=Participant/Trainee Support
    8 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage

    Prompt Table: UNITS_TBL

    9 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type

    Prompt Table: PROJ_RES_TYPE

    10 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category

    Prompt Table: PROJ_CATG_TBL

    11 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory

    Prompt Table: PROJ_SUBCAT_TBL

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

    Prompt Table: PROJ_TEAM_VW

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

    Prompt Table: JOBCODE_TBL

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

    Prompt Table: PROJ_ROLE

    15 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

    Prompt Table: SP_BU_GL_NONVW

    16 PROJ_TRANS_TYPE Character(3) VARCHAR2(3) NOT NULL Project Transaction Type

    Prompt Table: PROJ_TRANS_TYPE

    17 PROJ_TRANS_CODE Character(5) VARCHAR2(5) NOT NULL Project Transaction Code

    Prompt Table: PROJ_TRANS_CODE

    18 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit

    Prompt Table: SP_BU_BI_NONVW

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

    Prompt Table: GL_ACCT_CTLB_VW

    20 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account

    Prompt Table: ALT_BUGL_VW

    21 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPTID_BUGL2_VW

    22 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code

    Prompt Table: STAT_BUGL_VW

    23 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

    Prompt Table: OPRUNT_BUGL2_VW

    24 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField

    Prompt Table: PRODCT_BUGL2_VW

    25 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

    Prompt Table: FUND_BUGL2_VW

    26 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field

    Prompt Table: CLASS_BUGL2_VW

    27 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

    Prompt Table: PROGRM_BUGL2_VW

    28 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference

    Prompt Table: BUDREF_BUGL2_VW

    29 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate

    Prompt Table: AFFILIATE_VW

    30 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

    Prompt Table: %EDIT_INTRA01

    31 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

    Prompt Table: %EDIT_INTRA01

    32 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1

    Prompt Table: CF1_BUGL2_VW

    33 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2

    Prompt Table: CF2_BUGL2_VW

    34 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3

    Prompt Table: CF3_BUGL2_VW

    35 PC_WEIGHT_POINTS Number(10,0) DECIMAL(10) NOT NULL Weight Points
    36 WHERE_CLAUSE_LONG Long Character(4000) CLOB Where Clause
    37 RESOURCE_CLASS Character(1) VARCHAR2(1) NOT NULL 05/26/2004 - FS Translate Value "O" added. 06/07/2004 FS Changed all Eff. Dates to 01/01/1900
    A=Asset
    L=Labor
    M=Material
    O=Other
    38 COST_CLASSIFICATN Character(100) VARCHAR2(100) NOT NULL Cost Classification

    Prompt Table: GM_COSTCLSS_TBL

    39 ALLOWABLE_FLG Character(1) VARCHAR2(1) NOT NULL Allowable Cost?

    Y/N Table Edit