SETIDLEDGER_GROUPEFFDTA=Active
I=Inactive
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
GM_KK_EXP_VW(SQL View) |
Index Back |
|---|---|
KK Expense Ledger Groups |
| SELECT SETID1 ,LEDGER_GROUP ,EFFDT ,EFF_STATUS ,CONTROL_CHARTFIELD ,BUDG_TYPE ,CNTRL_OPTN ,BUDGET_STATUS ,PARENT_BUDGET FROM PS_KK_BUDGET_TYPE WHERE BUDG_TYPE = 'E' AND CONTROL_CHARTFIELD = 'PROJECT_ID' AND PARENT_BUDGET <> ' ' |
| # | 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 |
| 5 | CONTROL_CHARTFIELD | Character(18) | VARCHAR2(18) NOT NULL | Control ChartField |
| 6 | BUDG_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Budget Type
E=Expense R=Revenue |
| 7 | 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 |
| 8 | BUDGET_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Budget Status
0=Open 1=Closed 2=Hold 3=Default |
| 9 | PARENT_BUDGET | Character(10) | VARCHAR2(10) NOT NULL | Parent Control Budget |