P6_SYNC_ER_PROJ

(SQL Table)
 Index Back

P6 Project data errors

# 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
5 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
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 GUID Character(36) VARCHAR2(36) NOT NULL Unique Identifier
9 SEQNBR Number(5,0) INTEGER NOT NULL Sequence Number

Default Value: 1

10 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
11 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
12 TEAM_MEMBER_IND Character(1) VARCHAR2(1) NOT NULL Team Member Indicator
E=Employee
G=Generic Resource
N=Not Applicable
13 TEAM_MEMBER Character(30) VARCHAR2(30) NOT NULL Team Member
14 P6_ALTERNATE_KEY Character(254) VARCHAR2(254) NOT NULL Source Values
15 P6_INTEGRATE_TYPE Character(1) VARCHAR2(1) NOT NULL Direction
I=Inbound
O=Outbound
16 SYNC_REVIEW_STATUS Character(1) VARCHAR2(1) NOT NULL Review Status
F=Fixed
O=Open
17 INTFC_ID Number(8,0) INTEGER NOT NULL Interface ID
18 INTFC_LINE_NUM Number(8,0) INTEGER NOT NULL Interface Line Number
19 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
20 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
21 MESSAGE_PARM1 Character(30) VARCHAR2(30) NOT NULL Message Parameter 1
22 MESSAGE_PARM2 Character(30) VARCHAR2(30) NOT NULL Message Parameter 2
23 MESSAGE_PARM3 Character(30) VARCHAR2(30) NOT NULL Message Parameter 3
24 P6_FIELDNAME Character(30) VARCHAR2(30) NOT NULL Field Name
25 P6_VALUE Character(254) VARCHAR2(254) NOT NULL Value
26 P6_ERROR2_MSG Character(254) VARCHAR2(254) NOT NULL Error Message
27 P6_ERROR_MSG Long Character(1000) VARCHAR2(1000) Error Message