PC_CUR_BUD_ITEM

(SQL View)
 Index Back

Prompt for Budget Items


SELECT A.SETID , A.BUDGET_CATEGORY , A.EFFDT , A.DESCR , A.RESOURCE_CLASS , A.RESOURCE_TYPE , A.RESOURCE_CATEGORY , A.RESOURCE_SUB_CAT , A.EMPLID , A.JOBCODE , A.PROJ_ROLE , A.BUSINESS_UNIT_BI , A.BUSINESS_UNIT_GL , A.ACCOUNT , A.ALTACCT , A.DEPTID , A.STATISTICS_CODE , %subrec(CF28_AN_SBR, A) FROM %Table(GM_BUD_CATEGORY) A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM %Table(GM_BUD_CATEGORY) B WHERE %Join(COMMON_KEYS, GM_BUD_CATEGORY A, GM_BUD_CATEGORY B, EFFDT) AND B.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A'

  • 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
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 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
    6 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type

    Prompt Table: PROJ_RES_TYP_VW

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

    Prompt Table: %EDIT_RES_CAT

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

    Prompt Table: %EDIT_RES_SUB

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

    Prompt Table: PROJ_TEAM_VW

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

    Prompt Table: JOBCODE_TBL

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

    Prompt Table: PROJ_ROLE

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

    Prompt Table: SP_BU_BI_NONVW

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

    Prompt Table: SP_BUPCIT_NONVW

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

    Prompt Table: GL_ACCT_BUGL_VW

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

    Prompt Table: ALT_BUGL_VW

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

    Prompt Table: DEPTID_BUGL_VW

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

    Prompt Table: STAT_BUGL_VW

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

    Prompt Table: OPRUNT_BUGL2_VW

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

    Prompt Table: PRODCT_BUGL2_VW

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

    Prompt Table: FUND_BUGL2_VW

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

    Prompt Table: CLASS_BUGL2_VW

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

    Prompt Table: PROGRM_BUGL2_VW

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

    Prompt Table: BUDREF_BUGL2_VW

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

    Prompt Table: AFFILIATE_VW

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

    Prompt Table: %EDIT_INTRA01

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

    Prompt Table: %EDIT_INTRA01

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

    Prompt Table: CF1_BUGL2_VW

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

    Prompt Table: CF2_BUGL2_VW

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

    Prompt Table: CF3_BUGL2_VW