KK_BD_TYPE_VW

(SQL View)
 Index Back

Budget Type

MPL Aug-24-2001 -> Was added the FILTER_CHARTFIELD field because it got pcode compile error for program KK_BUDGET_ENTRY.GBL.KK_WRK.PB_BD_ATTRIBS.FieldChange when I go to Budget Overview Result.

SELECT SETID1 , LEDGER_GROUP , EFFDT , EFF_STATUS , CONTROL_CHARTFIELD , FILTER_CHARTFIELD , DESCR , BUDG_TYPE , ASSOC_EXP_BD , CNTRL_OPTN , TOLERANCE , BUDGET_STATUS , ENABLE_FS , PARENT_BUDGET , CHILD_EXCEED , ALL_VALUES , TREE_NAME , TREE_LEVEL , KK_REV_TRACK_LG , BALANCED_LINES , KK_ENABLE_STAT , SUBTYPE , EXPIRE_CHARTFIELD FROM PS_KK_BUDGET_TYPE

  • Related Language Record: KK_BD_TYPE_LANG

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

    Prompt Table: SP_SETID_NONVW

    2 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group

    Prompt Table: SP_LGRP_A_NONVW

    3 EFFDT Date(10) DATE Effective Date
    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 CONTROL_CHARTFIELD Character(18) VARCHAR2(18) NOT NULL Control ChartField
    6 FILTER_CHARTFIELD Character(18) VARCHAR2(18) NOT NULL Ruleset ChartField

    Prompt Table: CFS_KK_VW
    Set Control Field: SETID1

    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 BUDG_TYPE Character(1) VARCHAR2(1) NOT NULL Budget Type
    E=Expense
    R=Revenue
    9 ASSOC_EXP_BD Character(10) VARCHAR2(10) NOT NULL Associated Expenditure Budget
    10 CNTRL_OPTN Character(1) VARCHAR2(1) NOT NULL Commitment Control Option
    0=Control
    1=Tracking w/ Budget
    2=Track w/o Budget
    3=Default from Higher Level
    4=Control Initial Document
    11 TOLERANCE Signed Number(13,8) DECIMAL(11,8) NOT NULL Tolerance Percent
    12 BUDGET_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Status
    0=Open
    1=Closed
    2=Hold
    3=Default
    13 ENABLE_FS Character(1) VARCHAR2(1) NOT NULL Enable Funding Source
    14 PARENT_BUDGET Character(10) VARCHAR2(10) NOT NULL Parent Control Budget
    15 CHILD_EXCEED Character(1) VARCHAR2(1) NOT NULL Child Budgets Exceed Option
    N=No
    Y=Yes
    16 ALL_VALUES Character(1) VARCHAR2(1) NOT NULL Tree Level All Values flag
    N=No
    Y=Yes
    17 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
    18 TREE_LEVEL Character(10) VARCHAR2(10) NOT NULL Tree Level Number
    19 KK_REV_TRACK_LG Character(10) VARCHAR2(10) NOT NULL Revenue Tracking Ledger Group
    20 BALANCED_LINES Character(1) VARCHAR2(1) NOT NULL Entries Must Balance
    21 KK_ENABLE_STAT Character(1) VARCHAR2(1) NOT NULL Enable Statistical Budgeting
    22 SUBTYPE Character(10) VARCHAR2(10) NOT NULL Ruleset
    23 EXPIRE_CHARTFIELD Character(18) VARCHAR2(18) NOT NULL Prior Year Adj Chartfield