P6_SYNC_HD_TIME

(SQL Table)
Index Back

Sync Log Header - Time Data

Synchronization log header table for Timesheet Data

# 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_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
5 RQSTDTTM DateTime(26) TIMESTAMP Request Date/Time
6 HDR_STATUS Character(3) VARCHAR2(3) NOT NULL Status of Synchronization
010=Complete
020=Error
030=Complete With Warnings
040=Processing
090=Complete With Errors
7 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

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

Default Value: N

9 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
10 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
11 MESSAGE_PARM1 Character(30) VARCHAR2(30) NOT NULL Message Parameter 1
12 MESSAGE_PARM2 Character(30) VARCHAR2(30) NOT NULL Message Parameter 2
13 MESSAGE_PARM3 Character(30) VARCHAR2(30) NOT NULL Message Parameter 3
14 MESSAGE_PARM4 Character(30) VARCHAR2(30) NOT NULL Message Parameter 4
15 P6_ERROR2_MSG Character(254) VARCHAR2(254) NOT NULL Error Message
16 P6_ERROR_MSG Long Character(1000) VARCHAR2(1000) Error Message