GM_XML_BUD_PER2

(SQL View)
 Index Back

Person summary budget


SELECT A.OPRID , A.RUN_CNTL_ID , A.PROPOSAL_ID , A.VERSION_ID , B.BUDGET_ID , B.BUDGET_PERIOD_GM , B.EMPLID , B.NAME , B.PROJECT_ROLE , 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) , B.NAME_PREFIX , B.NAME_SUFFIX , B.FIRST_NAME , B.LAST_NAME , B.MIDDLE_NAME , B.PROF_ROLE_TYPE 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 IN ('PI' ,'CPI', 'KEY', 'MENT', 'CMNT' , 'DHD', 'STF') GROUP BY A.OPRID, A.RUN_CNTL_ID, A.PROPOSAL_ID, A.VERSION_ID, B.BUDGET_ID, B.BUDGET_PERIOD_GM, B.NAME, B.PROJECT_ROLE,B.NAME_PREFIX, B.NAME_SUFFIX, B.FIRST_NAME, B.LAST_NAME, B.MIDDLE_NAME, B.PROF_ROLE_TYPE, B.EMPLID

# 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_ID Character(15) VARCHAR2(15) NOT NULL BUDGET_ID
6 BUDGET_PERIOD_GM Number(3,0) SMALLINT NOT NULL BUDGET_PERIOD_GM
7 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
8 NAME Character(50) VARCHAR2(50) NOT NULL Name
9 PROJECT_ROLE Character(30) VARCHAR2(30) NOT NULL Project Role
10 ANNUAL_SALARY_GM Number(27,3) DECIMAL(26,3) NOT NULL NNUAL_SALARY_GM
11 BUDGET_SALARY Signed Number(28,3) DECIMAL(26,3) NOT NULL BUDGET_SALARY
12 FRINGE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL FRINGE_AMT
13 BUDGET_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL BUDGET_AMT
14 FED_NON_FED Number(27,3) DECIMAL(26,3) NOT NULL Total
15 CA_PERSON_MONTHS Number(3,0) SMALLINT NOT NULL Person Months
16 AC_PERSON_MONTHS Number(3,0) SMALLINT NOT NULL Person Months
17 SU_PERSON_MONTHS Number(3,0) SMALLINT NOT NULL Person Months
18 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix
1=Mr.
2=Mrs.
3=Ms.
19 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix
20 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
21 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
22 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL Middle Name
23 PROF_ROLE_TYPE Character(4) VARCHAR2(4) NOT NULL Role Type