P6_SYNC_LN_P_VW

(SQL View)
 Index Back

Sync Log - Project Line View

Synchronization Log. View of HD and LN tables for Search By Project ID.

SELECT A.OPRID , A.RUN_CNTL_ID , A.PROC_INSTANCE_SYNC , A.BUSINESS_UNIT , A.PROJECT_ID , A.PROJECT_OBJECTID , A.SYNC_OBJ_TYPE , B.RQSTDTTM , A.IBTRANSACTIONID , A.DESCR , A.P6_TEMPLATE_ID , A.DTTM_EXPORT , A.P6_EXPORT_STATUS , A.DTTM_IMPORT , A.P6_IMPORT_STATUS , A.P6_APP_ERR_FLAG , A.P6_TFORM_FLAG FROM %Table(P6_SYNC_LN_PROJ) A , %Table(P6_SYNC_HD_PROJ) B WHERE A.OPRID = A.OPRID AND A.RUN_CNTL_ID = A.RUN_CNTL_ID AND A.PROC_INSTANCE_SYNC = B.PROC_INSTANCE_SYNC

# 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 RQSTDTTM DateTime(26) TIMESTAMP Request Date/Time
9 IBTRANSACTIONID Character(36) VARCHAR2(36) NOT NULL Transaction ID
10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
11 P6_TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL P6 Synchronization Template Id
12 DTTM_EXPORT DateTime(26) TIMESTAMP Export To P6 Date/Time
13 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
14 DTTM_IMPORT DateTime(26) TIMESTAMP Import From P6 Date/Time
15 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
16 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
17 P6_TFORM_FLAG Character(1) VARCHAR2(1) NOT NULL Error Data
E=Error
N=No Errors
W=Warning