PGM_TEAM_GEN_VW(SQL View) |
Index Back |
|---|---|
Project Team Gen Resourc ViewView of project team generic resources. |
| SELECT PT.BUSINESS_UNIT , PT.PROJECT_ID , PT.TEAM_MEMBER , PT.PLAN_STARTDT , PT.PLAN_ENDDT , PS.SCHEDULED_HRS , PS.AVAIL_UNITS , PT.PLAN_PROJROLE , PT.SO_ID , PT.SO_LINE , PT.TEAM_SCHED_CNT , PT.EMAILID , PT.EMAIL_NOTIFICATION , PT.SOURCE_FLAG , PT.RES_UID , PT.USER_FIELD_1 , PT.DESCRLONG , PT.POOL_ID , PT.REGION_CD , PT.PER_STATUS , PS.SCHED_NUM , PT.RESOURCE_STS ,PT.TASK_TYPE FROM PS_PROJECT_TEAM PT , PS_PROJ_TEAM_SCHED PS WHERE PT.TEAM_MEMBER_CLASS = 'L' AND PT.TEAM_MEMBER_IND = 'G' AND PT.BUSINESS_UNIT = PS.BUSINESS_UNIT AND PT.PROJECT_ID = PS.PROJECT_ID AND PT.TEAM_MEMBER = PS.TEAM_MEMBER AND PS.AVAIL_UNITS = ( SELECT MIN (X.AVAIL_UNITS) FROM PS_PROJ_TEAM_SCHED X WHERE X.BUSINESS_UNIT = PS.BUSINESS_UNIT AND X.PROJECT_ID = PS.PROJECT_ID AND X.TEAM_MEMBER_CLASS = PT.TEAM_MEMBER_CLASS AND X.TEAM_MEMBER_IND = PT.TEAM_MEMBER_IND AND X.TEAM_MEMBER = PS.TEAM_MEMBER) AND PS.SCHED_NUM = ( SELECT MIN (Y.SCHED_NUM) FROM PS_PROJ_TEAM_SCHED Y WHERE Y.BUSINESS_UNIT = PS.BUSINESS_UNIT AND Y.PROJECT_ID = PS.PROJECT_ID AND Y.TEAM_MEMBER_CLASS = PT.TEAM_MEMBER_CLASS AND Y.TEAM_MEMBER_IND = PT.TEAM_MEMBER_IND AND Y.TEAM_MEMBER = PS.TEAM_MEMBER AND Y.AVAIL_UNITS = PS.AVAIL_UNITS) |
| # | 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 | GEN_RESOURCE |
Character(30) | VARCHAR2(30) NOT NULL | Generic Resource Name |
| 4 | PLAN_STARTDT | Date(10) | DATE | Planned Start Date |
| 5 | PLAN_ENDDT | Date(10) | DATE | Planned End Date |
| 6 | SCHEDULED_HRS | Signed Number(10,4) | DECIMAL(8,4) NOT NULL | Scheduled Hours |
| 7 | AVAIL_UNITS | Number(6,0) | INTEGER NOT NULL | Availability Units |
| 8 | PLAN_PROJROLE | Character(15) | VARCHAR2(15) NOT NULL | Requirement Project Role |
| 9 | SO_ID | Character(15) | VARCHAR2(15) NOT NULL | Service Order ID |
| 10 | SO_LINE | Number(3,0) | SMALLINT NOT NULL | Line Number |
| 11 | TEAM_SCHED_CNT | Number(4,0) | SMALLINT NOT NULL | Project Team Count |
| 12 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
| 13 | EMAIL_NOTIFICATION | Character(1) | VARCHAR2(1) NOT NULL |
Email Notify for Status Change
N=No Y=Yes Default Value: Y |
| 14 | 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 |
| 15 | RES_UID | Character(15) | VARCHAR2(15) NOT NULL | Resource ID |
| 16 | USER_FIELD_1 | Character(10) | VARCHAR2(10) NOT NULL | User Field 1 |
| 17 | DESCRLONG | Long Character | CLOB | Long Description |
| 18 | POOL_ID | Character(10) | VARCHAR2(10) NOT NULL | Pool ID field. |
| 19 | REGION_CD | Character(10) | VARCHAR2(10) NOT NULL | Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to. |
| 20 | PER_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Personnel Status
E=Employee N=Non-Employee |
| 21 | SCHED_NUM | Number(5,0) | INTEGER NOT NULL | Team sequence number |
| 22 | 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 |
| 23 | TASK_TYPE | Character(18) | VARCHAR2(18) NOT NULL | Task Category |