PROJ_TM_SCH_VW

(SQL View)
 Index Back

Project Team Member

To be used on Console

SELECT DISTINCT CONTRACT_NUM , CONTRACT_LINE_NUM , BUSINESS_UNIT , SCHED.PROJECT_ID , TEAM_MEMBER_CLASS , TEAM_MEMBER_IND , TEAM_MEMBER , SCHED_NUM , PROJ_ROLE , START_DT , END_DT , ASSIGNMENT_ID , ASSIGNMENT_SEQNO , EXTENSION_CNT , REMOVAL_FLAG , EXCEPTION_NUM , USER_FIELD_1 , DESCR , RES_UID , SOURCE_FLAG , PROJ_MGR_FLAG , FMS_DTTM_STAMP , FMS_OPRID , FMS_LASTUPDDTTM , FMS_LASTUPDOPRID , AVAIL_UNITS , SCHEDULED_HRS , RESOURCE_STS , PC_DURATION_DAYS FROM PS_CA_DETAIL_PROJ DTL , PS_PROJ_TEAM_SCHED SCHED WHERE SCHED.BUSINESS_UNIT = DTL.BUSINESS_UNIT_PC AND SCHED.PROJECT_ID = DTL.PROJECT_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

Prompt Table: CA_CONTR_HDR

2 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: PROJECT.BUSINESS_UNIT

Prompt Table: SP_BU_PC_NONVW

4 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: PROJECT_ALL_VW

5 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

Default Value: L

6 TEAM_MEMBER_IND Character(1) VARCHAR2(1) NOT NULL Team Member Indicator
E=Employee
G=Generic Resource
N=Not Applicable
7 TEAM_MEMBER Character(30) VARCHAR2(30) NOT NULL Team Member

Prompt Table: %EDITTABLE

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

Default Value: 1

9 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role

Default Value: PROJECT_TEAM.PLAN_PROJROLE

Prompt Table: PROJ_ROLE

10 START_DT Date(10) DATE Start Date

Default Value: PROJECT_TEAM.PLAN_STARTDT

11 END_DT Date(10) DATE End Date

Default Value: PROJECT_TEAM.PLAN_ENDDT

12 ASSIGNMENT_ID Character(15) VARCHAR2(15) NOT NULL Work Assignment ID
13 ASSIGNMENT_SEQNO Number(5,0) INTEGER NOT NULL Assignment Sequence Number
14 EXTENSION_CNT Number(3,0) SMALLINT NOT NULL Extension Count
15 REMOVAL_FLAG Character(1) VARCHAR2(1) NOT NULL Early Removal
16 EXCEPTION_NUM Number(3,0) SMALLINT NOT NULL Exception Flag
17 USER_FIELD_1 Character(10) VARCHAR2(10) NOT NULL User Field 1
18 DESCR Character(30) VARCHAR2(30) NOT NULL Description
19 RES_UID Character(15) VARCHAR2(15) NOT NULL Resource ID
20 SOURCE_FLAG Character(1) VARCHAR2(1) NOT NULL Team member created from
6=Primavera P6
G=Proposal Management
M=MSP
P=Projects online
R=Resource Management

Default Value: P

21 PROJ_MGR_FLAG Character(1) VARCHAR2(1) NOT NULL Project Manager Review

Y/N Table Edit

Default Value: N

22 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
23 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
24 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
25 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.
26 AVAIL_UNITS Number(6,0) INTEGER NOT NULL Availability Units

Default Value: 100

27 SCHEDULED_HRS Signed Number(10,4) DECIMAL(8,4) NOT NULL Scheduled Hours

Default Value: PROJECT.PC_HOURS_PER_DAY

28 RESOURCE_STS Character(2) VARCHAR2(2) NOT NULL 11/15/2004 - New field added.
AL=Allocated
CA=Cancelled
CM=Committed
CO=Considered
CP=Completed
RE=Rejected
RQ=Requested

Default Value: CO

29 PC_DURATION_DAYS Number(8,0) INTEGER NOT NULL Duration in Days