PC_CPY_TMSC_TAO(SQL Table) |
Index Back |
|---|---|
Project Team Member |
| # | 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_ALL_VW |
| 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 Default Value: L |
| 4 | TEAM_MEMBER_IND |
Character(1) | VARCHAR2(1) NOT NULL |
Team Member Indicator
E=Employee G=Generic Resource N=Not Applicable Default Value: E |
| 5 | TEAM_MEMBER |
Character(30) | VARCHAR2(30) NOT NULL |
Team Member
Prompt Table: PROJ_MGR_VW |
| 6 | SCHED_NUM |
Number(5,0) | INTEGER NOT NULL |
Team sequence number
Default Value: 1 |
| 7 | PC_CPY_UNIQUEID |
Character(15) | VARCHAR2(15) NOT NULL | Copy Unique ID |
| 8 | PROJ_ROLE | Character(15) | VARCHAR2(15) NOT NULL |
Project Role
Prompt Table: PROJ_ROLE |
| 9 | START_DT | Date(10) | DATE | Start Date |
| 10 | END_DT | Date(10) | DATE | End Date |
| 11 | USER_FIELD_1 | Character(10) | VARCHAR2(10) NOT NULL | User Field 1 |
| 12 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 13 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 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 |
| 15 | AVAIL_UNITS | Number(6,0) | INTEGER NOT NULL |
Availability Units
Default Value: 100 |
| 16 | PROJ_MGR_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Project Manager Review |
| 17 | SCHEDULED_HRS | Signed Number(10,4) | DECIMAL(8,4) NOT NULL | Scheduled Hours |
| 18 | PC_DURATION_DAYS | Number(8,0) | INTEGER NOT NULL | Duration in Days |
| 19 | RES_UID | Character(15) | VARCHAR2(15) NOT NULL | Resource ID |
| 20 | REMOVAL_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Early Removal |
| 21 | ASSIGNMENT_SEQNO | Number(5,0) | INTEGER NOT NULL | Assignment Sequence Number |