OPRIDRUN_CNTL_IDBUDGET_PERIOD_GMGM_XML_BUD_PER5(SQL View) |
Index Back |
|---|---|
Person sum budget for UGSTUndergraduate Students |
| SELECT A.OPRID , A.RUN_CNTL_ID , A.PROPOSAL_ID , A.VERSION_ID , B.BUDGET_PERIOD_GM , 'Undergraduate Students' , SUM( B.ANNUAL_SALARY_GM) , SUM( B.BUDGET_SALARY) , SUM( B.FRINGE_AMT) , SUM( B.BUDGET_AMT) , SUM(B.FED_NON_FED) , SUM(B.CA_PERSON_MONTHS) , SUM(B.AC_PERSON_MONTHS) , SUM(B.SU_PERSON_MONTHS) FROM PS_GM_XML_PROPOSAL A , PS_GM_EC_BUD_PERS B WHERE B.PROPOSAL_ID = A.PROPOSAL_ID AND B.VERSION_ID = A.VERSION_ID AND B.PROF_ROLE_TYPE = 'UGST' GROUP BY A.OPRID, A.RUN_CNTL_ID, A.PROPOSAL_ID, A.VERSION_ID, B.BUDGET_ID, B.BUDGET_PERIOD_GM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | PROPOSAL_ID | Character(25) | VARCHAR2(25) NOT NULL | Proposal ID |
| 4 | VERSION_ID | Character(7) | VARCHAR2(7) NOT NULL | Version ID |
| 5 | BUDGET_PERIOD_GM |
Number(3,0) | SMALLINT NOT NULL | BUDGET_PERIOD_GM |
| 6 | PROJECT_ROLE | Character(30) | VARCHAR2(30) NOT NULL | Project Role |
| 7 | ANNUAL_SALARY_GM | Number(27,3) | DECIMAL(26,3) NOT NULL | NNUAL_SALARY_GM |
| 8 | BUDGET_SALARY | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | BUDGET_SALARY |
| 9 | FRINGE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | FRINGE_AMT |
| 10 | BUDGET_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | BUDGET_AMT |
| 11 | FED_NON_FED | Number(27,3) | DECIMAL(26,3) NOT NULL | Total |
| 12 | CA_PERSON_MONTHS | Number(3,0) | SMALLINT NOT NULL | Person Months |
| 13 | AC_PERSON_MONTHS | Number(3,0) | SMALLINT NOT NULL | Person Months |
| 14 | SU_PERSON_MONTHS | Number(3,0) | SMALLINT NOT NULL | Person Months |