| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 IBTRANSACTIONID |
Character(36) |
VARCHAR2(36) NOT NULL |
Transaction ID
|
| 2 |
P6_RSRC_GUID |
Character(36) |
VARCHAR2(36) NOT NULL |
Resource GUID
|
| 3 |
PSFT_RSRC_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
PeopleSoft Resource Identifier
|
| 4 |
RSRC_OBJECTID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Resource Object ID
|
| 5 |
REAL_OBJECTID |
Number(10,0) |
DECIMAL(10) NOT NULL |
A unique ID that is the key to a corresponding table in an external system such as Primavera.
|
| 6 |
P6_ACTION |
Character(15) |
VARCHAR2(15) NOT NULL |
For indicating Action to Primavera on Request Messages
|
| 7 |
P6_ACTION_EXECUTED |
Character(15) |
VARCHAR2(15) NOT NULL |
For indicating Action to Primavera on Request Messages
|
| 8 |
P6_STATUS |
Character(30) |
VARCHAR2(30) NOT NULL |
P6 Mapping PC to P6 Status
|
| 9 |
P6_ERROR_MSG |
Long Character(1000) |
VARCHAR2(1000) |
Error Message
|
| 10 |
P6_ERROR2_MSG |
Character(254) |
VARCHAR2(254) NOT NULL |
Error Message
|