P6_SYNC_LN_MST(SQL Table) |
Index Back |
---|---|
Sync Log - Master Data StatusSynchronization 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 |