CONTRACT_NUMBUDGET_CATEGORYGM_PT_AWD_SPN_V(SQL View) |
Index Back |
|---|---|
budget Amount |
| SELECT DISTINCT B.CONTRACT_NUM , B.BUSINESS_UNIT , A.BUDGET_CATEGORY FROM PS_GM_PT_PRJ_BUD A , PS_GM_PT_PROJECT B WHERE A.AMOUNT_TYPE = 'SPD' AND B.BUSINESS_UNIT_PC = A.BUSINESS_UNIT_PC AND B.PROJECT_ID = A.PROJECT_ID UNION SELECT DISTINCT B1.CONTRACT_NUM , B1.BUSINESS_UNIT , A1.BUDGET_CATEGORY FROM PS_GM_PT_PRJ_TRN A1 , PS_GM_PT_PROJECT B1 WHERE A1.AMOUNT_TYPE = 'SPD' AND B1.BUSINESS_UNIT_PC = A1.BUSINESS_UNIT_PC AND B1.PROJECT_ID = A1.PROJECT_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | BUDGET_CATEGORY |
Character(15) | VARCHAR2(15) NOT NULL | BUDGET_CATEGORY |