PGM_CHC_REQ_BUD

(SQL Table)
Index Back

Budget Change Request

This record contains the details of the Budget Change Requests

  • Related Language Record: PGM_CHC_BUD_LG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    3 CHANGE_REQ_ID Character(15) VARCHAR2(15) NOT NULL Change Request ID
    4 CURRENCY_CD_PC Character(3) VARCHAR2(3) NOT NULL Projects BU Currency

    Default Value: PROJECT.CURRENCY_CD

    5 CST_BUD_ID_OLD Number(3,0) SMALLINT NOT NULL Old Budget Plan
    6 CST_BUD_AMT_OLD Number(27,3) DECIMAL(26,3) NOT NULL Total Cost Budget
    7 CST_BUD_ID_NEW Number(3,0) SMALLINT NOT NULL New Budget Plan

    Prompt Table: PGM_FIN_CST_BUD

    8 CST_BUD_AMT_NEW Number(27,3) DECIMAL(26,3) NOT NULL New Cost Budget Amount
    9 CST_CHC_DESCR Character(50) VARCHAR2(50) NOT NULL Description
    10 REV_BUD_ID_OLD Number(3,0) SMALLINT NOT NULL Old Budget Plan
    11 REV_BUD_AMT_OLD Number(27,3) DECIMAL(26,3) NOT NULL Total Revenue Budget
    12 REV_BUD_ID_NEW Number(3,0) SMALLINT NOT NULL New Budget Plan

    Prompt Table: PGM_FIN_REV_BUD

    13 REV_BUD_AMT_NEW Number(27,3) DECIMAL(26,3) NOT NULL Revenue Budget Amount
    14 REV_CHC_DESCR Character(50) VARCHAR2(50) NOT NULL Description
    15 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
    16 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
    17 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
    18 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.