14.1 sp822_smaudit

This table records ServiceManager user updates. Each record in the table relates to a single record in one of the tables in the range sp823_smaudit_empattr through to sp832_smaudit_empoverride. The value of the operation_type column indicates the type of operation carried out by the user, and therefore which of the tables the details of the operation is stored in. The category, category_id, and name record the entity type (e.g. 'Operative'), unique identifier (e.g. a sp210_employees.employee_ref value), and description (e.g. sp210_employees.name value) of the entity affected. A timestamp column records when the operation was carried out.

HouseKeeping

This table is tidied by sp_dbtidy's Audit group.

Table Definition

Field	Type	Default	Nullable
audit_seq_no	number(9)
operation_type	varchar2(30)
user_id	varchar2(50)
timestamp	date
category_type	varchar2(10)
category_id	varchar2(25)
category_name	varchar2(50)

Keys

primary key (audit_seq_no)
foreign key (category_type) references sp820_smaudit_category_types (category _type)
foreign key (operation_type) references sp821_smaudit_operation_types (operation_type)

Column Descriptions

Field	Description
audit_seq_no	Unique identifier : the sequence number of the action.
operation_type	Mnemonic for operation e.g. EmpUpdate.AddSkill, EmpCreate.Attr, EmpUpdate.RemWorkPatternLKRange.
user_id	OS User.
timestamp	Date and time at which these details were saved. (Uses the time zone of the DBMS server machine).
category_type	The type of entity of category_id / name.
category_id	ServiceOptimizer unique identifier of the entity affected e.g. sp210_employees.employee_ref.
category_name	ServiceOptimizer descriptive identifier of the entity affected e.g. sp210_employees.name.