PGM_RES_SUMR_VW (SQL View)	Index Back
Project team summary view Combined view of Project Team and schedule. Primarily meant for the project team summary page. Returns one row for a team member with proj role and dates aggregated.

PGM_RES_SUMR_VW

(SQL View)

Project team summary view

Combined view of Project Team and schedule. Primarily meant for the project team summary page. Returns one row for a team member with proj role and dates aggregated.

SELECT PT.BUSINESS_UNIT , PT.PROJECT_ID , PT.TEAM_MEMBER_IND , PT.TEAM_MEMBER , 0 , ' ' , ' ' , PT.SO_ID , %Substring(PT.TEAM_MEMBER,1,11) , PT.SOURCE_REQ , %TextIn(' ') , MIN(SC.PROJ_ROLE) , MIN(SC.START_DT) , MAX(SC.END_DT) , COUNT(*) FROM PS_PROJECT_TEAM PT , PS_PROJ_TEAM_SCHED SC WHERE PT.BUSINESS_UNIT = SC.BUSINESS_UNIT AND PT.PROJECT_ID = SC.PROJECT_ID AND PT.TEAM_MEMBER_IND = SC.TEAM_MEMBER_IND AND PT.TEAM_MEMBER = SC.TEAM_MEMBER GROUP BY PT.BUSINESS_UNIT, PT.PROJECT_ID,PT.TEAM_MEMBER_IND, PT.TEAM_MEMBER, PT.SO_ID, PT.TEAM_MEMBER, PT.SOURCE_REQ

Parent record: PROJECT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: PROJECT.BUSINESS_UNIT
Prompt Table: SP_BU_PC_NONVW

2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
Prompt Table: PROJECT_VW

3 TEAM_MEMBER_IND Character(1) VARCHAR2(1) NOT NULL Team Member Indicator
E=Employee
G=Generic Resource
N=Not Applicable
Default Value: E

4 TEAM_MEMBER Character(30) VARCHAR2(30) NOT NULL Team Member
Prompt Table: PC_TEAM_SUMR_VW

5 SCHED_NUM Number(5,0) INTEGER NOT NULL Team sequence number

6 ASSIGNMENT_ID Character(15) VARCHAR2(15) NOT NULL Work Assignment ID

7 ASSIGN_STS Character(2) VARCHAR2(2) NOT NULL Assignment Status
A=Assign
C=Complete
I=Interview
P=Propose
R=Reject
S=Reserve
V=Pending Approval
X=Cancel
Prompt Table: RS_ASSGN_ST_TBL

8 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID

9 ASSIGN_EMPLID Character(11) VARCHAR2(11) NOT NULL Assigned To Employee ID

10 SOURCE_REQ Character(25) VARCHAR2(25) NOT NULL Source Requirement ID

11 DESCRLONG Long Character CLOB Long Description

12 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role
Prompt Table: PROJ_ROLE

13 START_DT Date(10) DATE Start Date

14 END_DT Date(10) DATE End Date

15 SCHED_COUNT Number(6,0) INTEGER NOT NULL Schedule Count

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: PROJECT.BUSINESS_UNIT Prompt Table: SP_BU_PC_NONVW
2	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: PROJECT_VW
3	TEAM_MEMBER_IND	Character(1)	VARCHAR2(1) NOT NULL	Team Member Indicator E=Employee G=Generic Resource N=Not Applicable Default Value: E
4	TEAM_MEMBER	Character(30)	VARCHAR2(30) NOT NULL	Team Member Prompt Table: PC_TEAM_SUMR_VW
5	SCHED_NUM	Number(5,0)	INTEGER NOT NULL	Team sequence number
6	ASSIGNMENT_ID	Character(15)	VARCHAR2(15) NOT NULL	Work Assignment ID
7	ASSIGN_STS	Character(2)	VARCHAR2(2) NOT NULL	Assignment Status A=Assign C=Complete I=Interview P=Propose R=Reject S=Reserve V=Pending Approval X=Cancel Prompt Table: RS_ASSGN_ST_TBL
8	SO_ID	Character(15)	VARCHAR2(15) NOT NULL	Service Order ID
9	ASSIGN_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Assigned To Employee ID
10	SOURCE_REQ	Character(25)	VARCHAR2(25) NOT NULL	Source Requirement ID
11	DESCRLONG	Long Character	CLOB	Long Description
12	PROJ_ROLE	Character(15)	VARCHAR2(15) NOT NULL	Project Role Prompt Table: PROJ_ROLE
13	START_DT	Date(10)	DATE	Start Date
14	END_DT	Date(10)	DATE	End Date
15	SCHED_COUNT	Number(6,0)	INTEGER NOT NULL	Schedule Count