P6_SYNC_LN_MST

(SQL Table)
Index Back

Sync Log - Master Data Status

Synchronization Log table for statuses of Master/Global data ObjectTypes.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
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 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
6 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
7 IBTRANSACTIONID Character(36) VARCHAR2(36) NOT NULL Transaction ID
8 DTTM_EXPORT DateTime(26) TIMESTAMP Export To P6 Date/Time
9 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
10 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

11 P6_TFORM_FLAG Character(1) VARCHAR2(1) NOT NULL Error Data
E=Error
N=No Errors
W=Warning

Y/N Table Edit

Default Value: N

12 P6_ERROR_MSG Long Character(1000) VARCHAR2(1000) Error Message