SETIDLEDGER_GROUP0=Budget
1=Expense or Recognized Revenue
2=Encumbrance
3=Pre-Encumbrance
4=Collected Revenue
5=Planned
SP_LGRPBD_NONVW(SQL View) |
Index Back |
|---|---|
Com Cntrl Bud Ledgr Groups |
| SELECT DISTINCT A.SETID ,A.LEDGER_GROUP ,A.LEDGER_TYPE_KK FROM PS_LED_GRP_LED_TBL A ,PS_KK_BUDGET_TYPE B ,PS_KK_BD_SETID E WHERE A.LEDGER_TYPE_KK = '0' AND B.SETID1 = E.SETID1 AND B.LEDGER_GROUP = E.LEDGER_GROUP AND B.EFFDT = E.EFFDT AND A.LEDGER_GROUP = B.LEDGER_GROUP AND B.PARENT_BUDGET <> ' ' AND B.EFF_STATUS = 'A' AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_KK_BUDGET_TYPE C WHERE C.SETID1 = B.SETID1 AND C.LEDGER_GROUP = B.LEDGER_GROUP AND C.EFFDT <= %CurrentDateIn) |
| # | 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 | LEDGER_TYPE_KK | Character(1) | VARCHAR2(1) NOT NULL |
Commitment Control Ledger Type
0=Budget 1=Expense or Recognized Revenue 2=Encumbrance 3=Pre-Encumbrance 4=Collected Revenue 5=Planned |