Tables installed with Audit Management

GRC: Audit Management adds the following tables.

Table Description
Activity

[sn_audit_activity]

Extends Audit Task [sn_audit_task] and stores audit activities
Audit Task

[sn_audit_task]

Extends Planned Task [planned_task] and is a generic table for all tasks associated with an audit
Base Audit Test

[sn_audit_base_test]

Base table for Test Templates and Test Plans
Control Test

[sn_audit_control_test]

Extends Audit Task [sn_audit_task] and stores control tests
Control to Engagement

[sn_audit_m2m_control_engagement]

Stores many-to-many relationships between controls and engagements
Engagement

[sn_audit_engagement]

Extends Planned Task [planned_task] and stores engagements
Interview

[sn_audit_interview]

Extends Audit Task [sn_audit_task] and stores interviews
Profile to Engagement

[sn_audit_m2m_profile_engagement]

Stores many-to-many relationships between profiles and engagements
Risk to Engagement

[sn_audit_m2m_risk_engagement]

Stores many-to-many relationships between risks and engagements
Test Plan

[sn_audit_test_plan]

Extends Base Audit Test [sn_audit_base_test] and stores test plans
Test plan to Engagement

[sn_audit_m2m_test_plan_engagement]

Stores many-to-many relationships between test plans and engagements
Test Template

[sn_audit_test_template]

Extends Base Audit Test [sn_audit_base_test] and stores test templates
Walkthrough

[sn_audit_walkthrough]

Extends Audit Task [sn_audit_task] and stores walkthroughs
Note: All additional tables installed by the dependent plugins are also needed for GRC: Audit Management.