P6_PRJTM_SRC_VW

(SQL View)
 Index Back

P6 Project Team Source View

PSFT Project Team resource records Note: restricted to (a) team members not previously imported from P6; and (b) class Labor or named Asset

SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.TEAM_MEMBER_CLASS , A.TEAM_MEMBER_IND , A.TEAM_MEMBER , A.BUSINESS_UNIT_AM , A.PLAN_PROJROLE FROM PS_PROJECT_TEAM A , PS_INSTALLATION B WHERE A.SOURCE_FLAG <> '6' AND A.TEAM_MEMBER_IND = 'E' AND (A.TEAM_MEMBER_CLASS = 'A' OR (A.TEAM_MEMBER_CLASS = 'L' AND (B.RS = 'N' OR A.RESOURCE_STS = 'CM')))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
3 TEAM_MEMBER_CLASS Character(1) VARCHAR2(1) NOT NULL 05/26/2004 - FS Translate Value "O" added.
A=Asset
L=Labor
M=Material
O=Other
4 TEAM_MEMBER_IND Character(1) VARCHAR2(1) NOT NULL Team Member Indicator
E=Employee
G=Generic Resource
N=Not Applicable
5 TEAM_MEMBER Character(30) VARCHAR2(30) NOT NULL Team Member
6 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
7 PLAN_PROJROLE Character(15) VARCHAR2(15) NOT NULL Requirement Project Role