BUSINESS_UNIT_PROPPROPOSAL_ID_TOVERSION_ID_TOGM_BUD_PROP_VW9(SQL View) |
Index Back |
|---|---|
Budget Proposal ViewThis view rolls up pre-award budget data to the proposal level (GM_PROPOSAL). It is used to display the Pending Other Support budget amounts for an investigator. This view is ultimately based on GM_BUD_LSUM_VW9, which selects only budget headers that have 'Include in Proposal' turned ON. |
| SELECT BUSINESS_UNIT , PROPOSAL_ID , VERSION_ID , SUM(SPONSOR_AMT) , SUM(COST_SHARE_IN_AMT) , SUM(COST_SHARE_TP_AMT) , SUM(SPONSOR_FA_AMT) , SUM(COST_SHARE_FA_AMT) , SUM(TOTAL_DIRECT_COST) , SUM(TOTAL_BUDGET_AMT) FROM PS_GM_BUD_MHD2_VW9 GROUP BY BUSINESS_UNIT , PROPOSAL_ID , VERSION_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_PROP |
Character(5) | VARCHAR2(5) NOT NULL | Proposal Business Unit |
| 2 | PROPOSAL_ID_TO |
Character(25) | VARCHAR2(25) NOT NULL | Proposal ID |
| 3 | VERSION_ID_TO |
Character(7) | VARCHAR2(7) NOT NULL | Version ID To |
| 4 | SPONSOR_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | SPONSOR_AMT |
| 5 | COST_SHARE_IN_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | COST_SHARE_IN_AMT |
| 6 | COST_SHARE_TP_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | COST_SHARE_TP_AMT |
| 7 | SPONSOR_FA_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | SPONSOR_FA_AMT |
| 8 | COST_SHARE_FA_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | COST_SHARE_FA_AMT |
| 9 | TOTAL_DIRECT_COST | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | TOTAL_DIRECT_COST |
| 10 | TOTAL_BUDGET_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | TOTAL_BUDGET_AMT |