BUSINESS_UNITPROPOSAL_IDVERSION_IDSUB_PROP_NBRBUDGET_IDBUDGET_PERIOD_GMBUDGET_LNGM_BUD_CAT_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT A.BUSINESS_UNIT , A.PROPOSAL_ID , A.VERSION_ID ,A.SUB_PROP_NBR , A.BUDGET_ID , A.BUDGET_PERIOD_GM , A.BUDGET_LN ,C.BUD_CAT_TYPE FROM PS_GM_BUD_LINE_SUM A , PS_GM_BUD_CATEGORY C , PS_SET_CNTRL_REC S WHERE S.SETCNTRLVALUE = A.BUSINESS_UNIT AND S.RECNAME = 'GM_BUD_CATEGORY' AND C.SETID = S.SETID AND C.BUDGET_CATEGORY = A.BUDGET_CATEGORY AND C.EFF_STATUS = 'A' AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_GM_BUD_CATEGORY C1 WHERE C1.SETID = C.SETID AND C1.BUDGET_CATEGORY = C.BUDGET_CATEGORY AND C1.EFFDT <= %CurrentDateIn AND C1.EFF_STATUS = 'A') AND C.BUD_CAT_TYPE IN ('RSRC','XPNS') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PROPOSAL_ID |
Character(25) | VARCHAR2(25) NOT NULL | Proposal ID |
| 3 | VERSION_ID |
Character(7) | VARCHAR2(7) NOT NULL | Version ID |
| 4 | SUB_PROP_NBR |
Character(15) | VARCHAR2(15) NOT NULL | SUB_PROP_NBR |
| 5 | BUDGET_ID |
Character(15) | VARCHAR2(15) NOT NULL | BUDGET_ID |
| 6 | BUDGET_PERIOD_GM |
Number(3,0) | SMALLINT NOT NULL | BUDGET_PERIOD_GM |
| 7 | BUDGET_LN |
Number(6,0) | INTEGER NOT NULL | BUDGET_LN |
| 8 | BUD_CAT_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Budget Item Type |