BUDGET_ITEM_MAT

(SQL View)
Index Back

Budget Items for Material

06/03/2004 - PR_FS_B005 Estimanting Labor PRL/ARL Changes New view

SELECT SETID , BUDGET_CATEGORY , RESOURCE_CLASS , DESCR 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' AND RESOURCE_CLASS IN ('M', ' ')

  • Related Language Record: PC_BUD_ITEM_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 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
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description