Document toolboxDocument toolbox

14.1 sp831_smaudit_empact

Owned by Billy Sewell (Unlicensed)
Jan 26, 2024

This table records ServiceManager user updates to the non-working periods (aka Standard Activities) of an Operative. The date and time the change was made, who made it, and the Operative modified are stored in sp822_smaudit. 

HouseKeeping

This table is tidied by sp_dbtidy's Audit group.

 

Table Definition

Field
Type
Default
Nullable
audit_seq_nonumber(9) (error)
activity_nonumber(9) (error)
old_activity_type number(2) (tick)
new_activity_type number(2) (tick)
old_expected_startdate (tick)
new_expected_startdate (tick)
old_expected_enddate (tick)
new_expected_enddate (tick)
old_postcode varchar2(30) (tick)
new_postcode varchar2(30) (tick)

Keys

primary key (audit_seq_no) 
foreign key (audit_seq_no) references sp822_smaudit (audit_seq_no)

Column Descriptions

FieldDescription
audit_seq_noUnique identifier : the sequence number of the action. 
activity_no A number identifying the activity.
old_activity_type The previous type of this activity.
new_activity_type The new type of this activity.
old_expected_start The previous expected start of this activity.
new_expected_start The new expected start of this activity.
old_expected_endThe previous expected end of this activity.
new_expected_endThe new expected end of this activity.
old_postcodeThe previous location (postcode) of this activity.
new_postcodeThe new location (postcode) of this activity.