JOBQUEUEGUID

VARCHAR2(36) not null

Unique identifier for synchronization job.

JOBQUEUESTATUS

VARCHAR2(50)null

String representing the current status of the job. Possible values are:

• PENDING
• COMPLETE
• RUNNING
• FAULT

JOBQUEUESTARTTIME

DATE null

Start Time for synchronization job.

JOBQUEUELASTUPDATE

null

Time of last heartbeat as entered by the Synchronization Monitor (SM) thread.

JOBQUEUEENDTIME

DATE null

End time for synchronization job.

SYNCHGUID

VARCHAR2(36) null

Foreign key to synchronization connection table (CIS_SYNCHCONNECTIONS) establishing the synch connection to which a particular job is related.

SYNCHVERSION

INTEGER null

Foreign key to Synch Connection table (CIS_SYNCHCONNECTIONS) establishing the version of the synch connection to which a particular job is related.

MACHINEGUID

VARCHAR2(50) null

Foreign key to load-balance machine table (CIS_LB_MACHINES) establishing the processor handling a connection.

MACHINEVERSION

INTEGER null

Foreign key to load-balance machine table (CIS_LB_MACHINES) establishing version of the processor handling a connection.

CURRENTACTION

VARCHAR2(50) null

String further describing the current activity on an active synchronization. Possible values are:

• JOB_CREATED
• MACHINE_ASSIGNED
• JOB_INITIALIZED
• CREATING_PROTOCOL
• PROCESSING_MAPPINGS
• INFORM_TO_CLINTRIAL
• CLINTRIAL_TO_INFORM
• SYNC_JOB_COMPLETE

CLINTRIALPROCESSED

INT null

Number indicating the cumulative number of transactions that have been processed by the Clintrial software for this job.

INFORMPROCESSED

INT null

Number indicating the cumulative number of transactions that have been processed by the InForm software for this job.