GM_XML_BUD_PERS

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