TASKRSRC_IDPC_SCH_RES_ASGN(SQL Table) |
Index Back |
|---|---|
Resource Assignment Temp TableTemporarily stores resource assignment data in the projects to scheduling product integration. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TASKRSRC_ID |
Character(4) | VARCHAR2(4) NOT NULL | Task Resource ID |
| 2 | PROJ_ID | Character(4) | VARCHAR2(4) NOT NULL | Project ID |
| 3 | TASK_ID | Character(18) | VARCHAR2(18) NOT NULL | Task Identification |
| 4 | RSRC_ID | Character(4) | VARCHAR2(4) NOT NULL | Resource ID |
| 5 | USER_TEXT1 | Character(20) | VARCHAR2(20) NOT NULL | User Text 1 |
| 6 | USER_TEXT2 | Character(20) | VARCHAR2(20) NOT NULL | User Text 2 |