FS_BP_KKDFN_AET

(SQL Table)
Index Back

BP - KK Definition State Rec

The following state record is used in the FS Budget Processor (FS_BP). This state record contains the commitment conrol definition fields.

  • Parent record: BU_LED_GRP_TBL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    2 EFFDT_BD Date(10) DATE Effective Date for Budget Defn
    3 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

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

    Default Value: 0

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

    Prompt Table: KK_EXP_BD_VW

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

    Prompt Table: KK_BUDGET_TYPE

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: %EDITTABLE8
    Set Control Field: SETID1

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

    Y/N Table Edit

    Default Value: N

    12 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.
    13 FILTER_CHARTFIELD Character(18) VARCHAR2(18) NOT NULL Ruleset ChartField

    Prompt Table: %EDITTABLE9
    Set Control Field: SETID1

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

    Prompt Table: KK_FCF_TREE_DVW

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

    Prompt Table: %EDITTABLE3

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    21 SUBTYPE Character(10) VARCHAR2(10) NOT NULL Ruleset
    22 EXPIRE_CHARTFIELD Character(18) VARCHAR2(18) NOT NULL Prior Year Adj Chartfield

    Prompt Table: %EDITTABLE10
    Set Control Field: SETID1

    23 SETID_EXP_CF Character(5) VARCHAR2(5) NOT NULL Expiration ChartField Setid
    24 SETID_RULESET_CF Character(5) VARCHAR2(5) NOT NULL KK Control Chartfield SetID
    25 SETID_CONTROL_CF Character(5) VARCHAR2(5) NOT NULL KK Control Chartfield SetID
    26 ACCOUNT_TRXOFF Character(10) VARCHAR2(10) NOT NULL Transaction Offset Account. Used in budget processor AE program (FS_BP_KKDFN).
    27 ACCOUNT_BDOFF Character(10) VARCHAR2(10) NOT NULL Budget Offset Account. Used in budget processor AE program (FS_BP_KKDFN).
    28 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive
    29 DEFN_STATUS Character(1) VARCHAR2(1) NOT NULL Definition Status
    E=Not Valid
    N=Validation Required
    V=Valid