| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 IBTRANSACTIONID |
Character(36) |
VARCHAR2(36) NOT NULL |
Transaction ID
|
| 2 |
P6_PROJECT_GUID |
Character(36) |
VARCHAR2(36) NOT NULL |
Project GUID
|
| 3 |
P6_WBS_GUID |
Character(36) |
VARCHAR2(36) NOT NULL |
P6 WBS GUID
|
| 4 |
P6_ACTIVITY_GUID |
Character(36) |
VARCHAR2(36) NOT NULL |
P6 ACTIVITY GUID
|
| 5 |
P6_TEAM_GUID |
Character(36) |
VARCHAR2(36) NOT NULL |
P6 Project Team GUID
|
| 6 |
P6_FIELDNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Field Name
|
| 7 |
P6_VALUE |
Character(254) |
VARCHAR2(254) NOT NULL |
Value
|
| 8 |
P6_ACTION |
Character(15) |
VARCHAR2(15) NOT NULL |
For indicating Action to Primavera on Request Messages
|
| 9 |
P6_ACTION_EXECUTED |
Character(15) |
VARCHAR2(15) NOT NULL |
For indicating Action to Primavera on Request Messages
|
| 10 |
P6_STATUS |
Character(30) |
VARCHAR2(30) NOT NULL |
P6 Mapping PC to P6 Status
|
| 11 |
P6_ERROR2_MSG |
Character(254) |
VARCHAR2(254) NOT NULL |
Error Message
|
| 12 |
P6_ERROR_MSG |
Long Character(1000) |
VARCHAR2(1000) |
Error Message
|