KK_BUDGET_TYPE

(SQL Table)
Index Back

  • Related Language Record: KK_BUD_TYP_LANG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID1 Character(5) VARCHAR2(5) NOT NULL SetID Value

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

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

    Prompt Table: SP_LGRPKK_NONVW
    Set Control Field: SETID1

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 DEFN_STATUS Character(1) VARCHAR2(1) NOT NULL Definition Status
    E=Not Valid
    N=Validation Required
    V=Valid

    Default Value: N

    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    6 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

    Default Value: 2

    7 BUDGET_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Status
    0=Open
    1=Closed
    2=Hold
    3=Default

    Default Value: 0

    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    9 BUDG_TYPE Character(1) VARCHAR2(1) NOT NULL Budget Type
    E=Expense
    R=Revenue
    10 ASSOC_EXP_BD Character(10) VARCHAR2(10) NOT NULL Associated Expenditure Budget

    Prompt Table: KK_EXP_BD_VW

    11 PARENT_BUDGET Character(10) VARCHAR2(10) NOT NULL Parent Control Budget

    Prompt Table: KK_BUDGET_TYPE

    12 CHILD_EXCEED Character(1) VARCHAR2(1) NOT NULL Child Budgets Exceed Option
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    13 CONTROL_CHARTFIELD Character(18) VARCHAR2(18) NOT NULL Control ChartField

    Prompt Table: %EDITTABLE8
    Set Control Field: SETID1

    14 ALL_VALUES Character(1) VARCHAR2(1) NOT NULL Tree Level All Values flag
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    15 BYPASS_BLANKS Character(1) VARCHAR2(1) NOT NULL The flag is used in commitment control budget definition to bypass processing when the control value in the transaction is blank.

    Y/N Table Edit

    Default Value: N

    16 FILTER_CHARTFIELD Character(18) VARCHAR2(18) NOT NULL Ruleset ChartField

    Prompt Table: %EDITTABLE9
    Set Control Field: SETID1

    17 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name

    Prompt Table: KK_FCF_TREE_DVW

    18 TREE_LEVEL Character(10) VARCHAR2(10) NOT NULL Tree Level Number

    Prompt Table: %EDITTABLE3

    19 ENABLE_FS Character(1) VARCHAR2(1) NOT NULL Enable Funding Source

    Y/N Table Edit

    Default Value: N

    20 KK_REV_TRACK_LG Character(10) VARCHAR2(10) NOT NULL Revenue Tracking Ledger Group
    21 TOLERANCE Signed Number(13,8) DECIMAL(11,8) NOT NULL Tolerance Percent
    22 BALANCED_LINES Character(1) VARCHAR2(1) NOT NULL Entries Must Balance

    Y/N Table Edit

    Default Value: N

    23 KK_ENABLE_STAT Character(1) VARCHAR2(1) NOT NULL Enable Statistical Budgeting

    Y/N Table Edit

    Default Value: N

    24 SUBTYPE Character(10) VARCHAR2(10) NOT NULL Ruleset
    25 EXPIRE_CHARTFIELD Character(18) VARCHAR2(18) NOT NULL Prior Year Adj Chartfield

    Prompt Table: %EDITTABLE10
    Set Control Field: SETID1