Triggers

Key

Symbol	Trigger Type	Triggering Event
←	before each row
→	after each row
		insert
		delete
		update

On SQL Server there is no concept of before/after each row. For SQL Server, all 'Trigger Types' are 'After' triggers.

Table	Trigger	Triggertype	Description
`sp083_system_parameters`	`sp083_audit`	→	Save important changed columns in `spaudit_sp083`.
`sp088_user_units`	`validate_unit_no`	→	Ensure unit type and unit number are valid.
`sp100_activities`	`sp100_audit`	←	Save important changed columns in `sp507_audit_sp100`.
`sp108_job_details`	`sp108_audit`	←	Save important changed columns in `sp508_audit_sp108`.
`sp111_jobs`	`sp111_audit`	←	Save important changed columns in `sp509_audit_sp111`.
`sp206_capabilities`	`sp206_audit`	→	Audit data to `sp511_audit_sp206`.
`sp213_scheduler_parameters`	`sp213_audit`	→	Save important changed columns in `spaudit_sp213`.
`sp400_components`	`validate_components`	→	Check entries in `fru_no` only refer to responsibility units with `fru` type.
`sp401_component_hierarchy`	`validate_component_hierarchy`	→	Check that the entries are not at risk of circular references: `sp405.hierarchy_level` of the client must be numerically lower than that of the server.
`sp402_monitors`	`audit_sp402`	→	Audit the table to `sp403_component_states_audit`.
`sp405_component_types`	`check_sp405_monitors`	after statement	Check that only one entry for the monitor (level 1) is added.
`sp406_monitors`	`audit_sp406`	→	Audit the table to `sp408_monitor_audit`.
`sp406_monitors`	`validate_monitors`	→	Check that the entries are only of component type for monitor (level 1 in hierarchy).
`sp410_component_alerts`	`check_sp410_component_alert`	→	Ensure that there is only 1 record in `sp410_component_alerts`.
`sp417_system_state`	`audit_sp417`	→	Audit data to `sp418_system_state_audit`.