Document toolboxDocument toolbox

14.1 sp660_notification_messages

Owned by Billy Sewell (Unlicensed)
Jan 26, 2024

External systems may need to be notified of changes to jobs that have been made within the ServiceOptimizer system. To enable this, all changes are persisted to this table so they are available to a notification service for sending to these external systems.

HouseKeeping

This table is tidied by sp_dbtidy’s Global group

 

Table Definition

Field
Type
Default
Nullable

job_ref

varchar2(50) (error)
resp_unit_nonumber (error)
timestampdate  (error)
message_content blob (tick)

Keys 

primary key (job_ref, timestamp)

foreign key (job_ref) references 14.1 sp111_jobs (job_ref)

foreign key (resp_unit_no) references /wiki/spaces/SCH141/pages/27099986 (resp_unit_no)
 



Column Descriptions

FieldDescription

job_ref                                   

The job_reference (from 14.1 sp111_jobs).
resp_unit_no  The responsibility unit to which the job is booked.
timestamp The timestamp at which the change occurred (UTC).
message_content  A blob of data relating to the change.