KK_BUDGET_TYPE(SQL Table) |
Index Back |
---|
# | 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
|
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
|
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
|
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
|