Document toolboxDocument toolbox

sp660_notification_messages

Owned by Jason Andrew
Oct 02, 2024
1 min read

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 sp111_jobs (job_ref)

foreign key (resp_unit_no) references sp058_responsibility_units (resp_unit_no)
 



Column Descriptions

FieldDescription

job_ref                                   

The job_reference (from 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.