Several types of tables are installed with the Operational Resilience application.

Tables installed with Operational Resilience

Table 1. Tables installed with Operational Resilience
Table name Description
Activity log [sn_oper_res_activity_log] Activity log for the application.
ASMT rating scale [sn_oper_res_asmt_rating_scale] ASMT rating scale.
BCM plan [sn_oper_res_bcm_plan] BCM plan.
Choice [sn_grc_choice] List of all GRC choices.
Change request [sn_oper_res_change_request] Change request created for the application.
Critical service outage [sn_oper_res_critical_service_outage] Outage of the critical service.
Event [sn_oper_res_event] Event recorded for the application.
Failed control [sn_oper_res_failed_control] Failed control.
GRC Profile [sn_grc_profile] List of all GRC entities.
Importance impact tolerance assessment [sn_oper_res_importance_impact_tolerance_assessment] Importance of the impact tolerance assessment.
Incident [sn_oper_res_incident] Incident registered due to an event.
Issue [sn_oper_res_issue] Issue logged due to an event.
M2M analysis participant [sn_oper_res_m2m_analysis_participant] Association between analysis and participant.
M2M analysis scenario event [sn_oper_res_m2m_analysis_scenario_event] Association between analysis and scenario event.
M2M scenario analysis service [sn_oper_res_scenario_analysis_service] Association between scenario and analysis service.
M2M scenario event [sn_oper_res_m2m_scenario_event] Association between scenario and event.
M2M service importance impact tolerance assessment [sn_oper_res_m2m_service_importance_impact_tolerance_assessment] Association between service and importance of the impact tolerance assessment.
Operational Resilience profile [sn_oper_res_profile] Operational Resilience entity. The table has all the latest dependencies.
Profile type [sn_grc_profile_type] List of all GRC entity types.
Risk [sn_oper_res_risk] Risk defined in the application. Starting with the Xanadu release (Release 19.0.4), the Advanced Risk Assessment (ARA) integration with Operational Resilience uses the Status field. When an entity is shared between Operational Resilience and Advanced Risk Assessment (ARA), and the ARA has the highest risk rating with a status of Completed, a record is created for the ARA integration and stored in the [sn_oper_res_risk] table.
Scenario [sn_oper_res_scenario] Scenario defined in the application.
Scenario analysis [sn_oper_res_scenario analysis] Scenario analysis defined in the application.
Service impact analysis [sn_oper_res_service_impact_analysis] Service impact analysis defined in the application.
Service process pillar [sn_oper_res_service_process_pillar] Service process pillar defined in the application.
Task [sn_oper_res_task] Task defined in the application.
Vulnerability profile [sn_oper_res_vul_profile] Vulnerability profile defined in the application.
Services with operational vulnerabilities [sn_oper_res_vulnerability_profile] Services with operational vulnerabilities.
M2M scenario event participant [sn_opres_res_m2m_scenario_event_participant] Each participant can be associated with one or more scenario events. This table stores many-to-many relationships between the participant and scenario events.
M2M scenario event issue [sn_oper_res_m2m_scenario_event_issue] Stores many-to-many relationships between the issues and scenario events.
Service related information [sn_oper_res_service_related_info] Service related information defined in the application.
Service Summary [sn_oper_res_service_summary] Service summary defined in the application.
Service tasks [sn_oper_res_resp_task] Service tasks defined in the application.
Response tasks [sn_oper_res_response_task] Response tasks that are defined in the application.

Tables installed with Digital resilience incident reporting

Table 2. Tables installed with Digital resilience incident reporting
Table name Description
Action task [sn_grc_case_mgmt_case_task] Action tasks associated with the case.
Digital Resilience Incident [sn_grc_inc_rptg_case_task] Incident reporting case task.
Impacted area [sn_grc_case_mgmt_impacted_area] Impacted area for the case.
Related area [sn_grc_case_mgmt_related_area] Related area for the case.

Database views

Table 3. Database views
Table view name Database view label Plural
sn_oper_res_risk_dependency Services with high risk Services with high risks
Services with high risk Vulnerable entity Vulnerable entities
sn_oper_res_failed_control_dependency Services with failed control Services with failed controls
sn_oper_res_service_outage Service Outage Service Outage