GM_BUD_CATE_VW

(SQL View)
 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

SELECT SETID ,BUDGET_CATEGORY ,EFFDT ,EFF_STATUS ,DESCR ,BUD_CAT_TYPE ,GM_BUD_GROUP FROM PS_GM_BUD_CATEGORY B WHERE GM_BUD_GROUP <> ' '

  • 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