| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_PC.OPRID
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
PROC_INSTANCE_SYNC |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance Sync
|
| 4 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_PC_NONVW
|
| 5 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table:
SP_PROJ_NONVW
|
| 6 |
PROJECT_OBJECTID |
Number(10,0) |
DECIMAL(10) NOT NULL |
A unique ID that is the Project key to a corresponding table in an external system such as Primavera.
|
| 7 |
SYNC_OBJ_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Synchronization Object Type
00=Net New Request
00A=Net New Request-Business Unit
01=Project Header
015=Project Team
02=Work Breakdown / Activities
03=Resource Assignment
04=Budget
05=Hours Worked
06=Actual Costs
07=Commitments
08=Create Acknowledgement
09=Labor Resources
10=Resource Rates
11=Materials
12=Equipment
13=Timesheets
|
| 8 |
IBTRANSACTIONID |
Character(36) |
VARCHAR2(36) NOT NULL |
Transaction ID
|
| 9 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 10 |
P6_TEMPLATE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
P6 Synchronization Template Id
|
| 11 |
DTTM_EXPORT |
DateTime(26) |
TIMESTAMP |
Export To P6 Date/Time
|
| 12 |
P6_EXPORT_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Export To P6 Status
010=Complete
020=Error
030=Complete With Warnings
040=Not Committed
050=Time Out
060=Not Processed
070=Sending
080=Received
090=Complete With Errors
|
| 13 |
DTTM_IMPORT |
DateTime(26) |
TIMESTAMP |
Import From P6 Date/Time
|
| 14 |
P6_IMPORT_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Import from P6 Status
010=Complete
020=Error
030=Complete With Warnings
050=Time Out
060=Not Processed
070=Sending
080=Received
090=Complete With Errors
|
| 15 |
P6_APP_ERR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Error Data
E=Error
F=Fault Error
N=No Errors
R=P6 Response Error
W=Warning
Default Value: N
|
| 16 |
P6_TFORM_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Error Data
E=Error
N=No Errors
W=Warning
Default Value: N
|