SETIDFA_BASE_IDBUDGET_CATEGORYGM_FABASE_VW(SQL View) |
Index Back |
|---|---|
F&A Bud Categories by Base ID |
| select B.SETID, B.FA_BASE_ID, B.BUDGET_CATEGORY from PS_GM_FA_BASE_DTL A, PS_GM_FA_BASE_CAT B where A.EFFDT = (select max(EFFDT) from PS_GM_FA_BASE_DTL where SETID = A.SETID and FA_BASE_ID = A.FA_BASE_ID and EFFDT <= %CurrentDateIn) and A.EFF_STATUS = 'A' and B.SETID = A.SETID and B.FA_BASE_ID = A.FA_BASE_ID and B.EFFDT = A.EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | FA_BASE_ID |
Character(5) | VARCHAR2(5) NOT NULL | FA_BASE_ID |
| 3 | BUDGET_CATEGORY |
Character(15) | VARCHAR2(15) NOT NULL | BUDGET_CATEGORY |