PROCESS_INSTANCEBUSINESS_UNITPROJECT_IDTEAM_MEMBER_CLASSA=Asset
L=Labor
M=Material
O=Other
TEAM_MEMBER_INDE=Employee
G=Generic Resource
N=Not Applicable
TEAM_MEMBERUPG_PC_TASK_TAO(SQL Table) |
Index Back |
|---|---|
Upgrade Task & Qual temp tableTemp table for identifying Task Type for Project Team upgrade. It is also used for initializing the Project Team qualification profile based on existing qualification template in Resource Management. Used in Upgrade only. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 4 | 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 |
| 5 | TEAM_MEMBER_IND |
Character(1) | VARCHAR2(1) NOT NULL |
Team Member Indicator
E=Employee G=Generic Resource N=Not Applicable |
| 6 | TEAM_MEMBER |
Character(30) | VARCHAR2(30) NOT NULL | Team Member |
| 7 | SCHED_NUM | Number(5,0) | INTEGER NOT NULL | Team sequence number |
| 8 | ASSIGNMENT_ID | Character(15) | VARCHAR2(15) NOT NULL | Work Assignment ID |
| 9 | TASK_TYPE | Character(18) | VARCHAR2(18) NOT NULL | Task Category |
| 10 | PROJ_ROLE | Character(15) | VARCHAR2(15) NOT NULL | Project Role |
| 11 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 12 | RS_RESRC_TEMPLT_ID | Character(10) | VARCHAR2(10) NOT NULL | Resource Template ID |