SETIDLEDGER_GROUPEFFDTA=Active
I=Inactive
Default Value: A
E=Expense
R=Revenue
0=Control
1=Tracking w/ Budget
2=Track w/o Budget
3=Default from Higher Level
4=Control Initial Document
0=Open
1=Closed
2=Hold
3=Default
SP_LEDGKK_NONVW(SQL View) |
Index Back |
|---|---|
Budget Type Non-secure viewNon-secure view of KK_BUDGET_TYPE. |
| SELECT SETID1 , LEDGER_GROUP , EFFDT , EFF_STATUS , CONTROL_CHARTFIELD , FILTER_CHARTFIELD , DESCR , BUDG_TYPE , ASSOC_EXP_BD , CNTRL_OPTN , TOLERANCE , BUDGET_STATUS , ENABLE_FS FROM PS_KK_BUDGET_TYPE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | LEDGER_GROUP |
Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 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 |
| 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 |