Document toolboxDocument toolbox

sp823_smaudit_empattr

Owned by Jason Andrew
Oct 02, 2024
2 min read

This table records ServiceManager user updates to the general attributes (i.e. those stored in sp210_employees) 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)
old_namevarchar2(50)  (tick)
new_namevarchar2(50)  (tick)
old_title varchar2(24) (tick)
new_title varchar2(24) (tick)
old_efficiency number(3) (tick)
new_efficiency number(3) (tick)
old_home_postcode varchar2(30) (tick)
new_home_postcode varchar2(30) (tick)
old_work_postcode varchar2(30) (tick)
new_work_postcode varchar2(30) (tick)
old_lkc_postcode varchar2(30) (tick)
new_lkc_postcode varchar2(30) (tick)
old_startloc_typenumber(1) (tick)
new_startloc_typenumber(1) (tick)
old_endloc_type number(1) (tick)
new_endloc_type number(1) (tick)
old_lkcloc_type number(1) (tick)
new_lkcloc_type number(1) (tick)
old_work_phone varchar2(40) (tick)
new_work_phone varchar2(40) (tick)
old_home_phone varchar2(40) (tick)
new_home_phone varchar2(40) (tick)
old_pager varchar2(20) (tick)
new_pager varchar2(20) (tick)
old_current_mdtnumber(1)  (tick)
new_current_mdtnumber(1)  (tick)
old_schedulable number(1) (tick)
new_schedulable number(1) (tick)
old_max_overtimenumber(4) (tick)
new_max_overtimenumber(4) (tick)
old_inform_lead number(4) (tick)
new_inform_lead number(4) (tick)
old_max_earmarked_jobs number(2) (tick)
new_max_earmarked_jobs number(2) (tick)
old_totanumber(4)  (tick)
new_totanumber(4)  (tick)
old_totbnumber(4)  (tick)
new_totbnumber(4)  (tick)
old_vehicle_capacity number(9) (tick)
new_vehicle_capacity number(9) (tick)
old_timezone_refvarchar2(32)  (tick)
new_timezone_refvarchar2(32)  (tick)
old_timezone_type number(1) (tick)
new_timezone_type number(1) (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. 
old_nameThe previous name value for this Operative.
new_nameThe new name value for this Operative.
old_title The previous title value for this Operative.
new_title The new title value for this Operative.
old_efficiency The previous efficiency value for this Operative.
new_efficiency The new efficiency value for this Operative.
old_home_postcodeThe previous home postcode value for this Operative.
new_home_postcodeThe new home postcode value for this Operative.
old_work_postcodeThe previous work postcode value for this Operative.
new_work_postcodeThe new work postcode value for this Operative.
old_lkc_postcodeThe previous local knowledge postcode value for this Operative.
new_lkc_postcodeThe new local knowledge postcode value for this Operative.
old_startloc_type The previous start location type value for this Operative.
new_startloc_type The new start location type value for this Operative.
old_endloc_typeThe previous end location type value for this Operative.
new_endloc_typeThe new end location type value for this Operative.
old_lkcloc_typeThe previous local knowledge location type value for this Operative.
new_lkcloc_typeThe new local knowledge location type value for this Operative.
old_work_phoneThe previous phone1 value for this Operative.
new_work_phoneThe new phone1 value for this Operative.
old_home_phoneThe previous phone2 value for this Operative.

new_home_phone

The new phone2 value for this Operative.
old_pager The previous pager value for this Operative.
new_pager The new pager value for this Operative.
old_current_mdtThe previous chosen MDT value for this Operative.
new_current_mdtThe new chosen MDT value for this Operative.
old_schedulable The previous schedulable value for this Operative.
new_schedulable The new schedulable value for this Operative.
old_max_overtimeThe previous maximum overtime value for this Operative.
new_max_overtimeThe new maximum overtime value for this Operative.
old_inform_leadThe previous inform lead time value for this Operative.
new_inform_leadThe new inform lead time value for this Operative.
old_max_earmarked_jobsThe previous maximum permissible number of earmarked jobs 
value for this Operative.
new_max_earmarked_jobsThe new maximum permissible number of earmarked jobs 
value for this Operative.
old_tota The previous TOTA value for this Operative.
new_tota The new TOTA value for this Operative.
old_totbThe previous TOTB value for this Operative.
new_totbThe new TOTB value for this Operative.
old_vehicle_capacityThe previous vehicle capacity value for this Operative.
new_vehicle_capacityThe new vehicle capacity value for this Operative.
old_timezone_ref The previous timezone value for this Operative.
new_timezone_ref The new timezone value for this Operative.
old_timezone_typeThe previous timezone type value for this Operative.
new_timezone_typeThe new timezone type value for this Operative.