This article contains:

1. Overview

Fields available through each dataset are indicated below. These will usually reflect the labels used within your cammsrisk application. However, please note that your Insights Administrator can;

change the names of datasets and fields for use within the Insights application.
show/hide specific fields/datasets based on your user role.

This section lists all datasets applicable for Risk, Audit and Incident solution areas of cammsrisk. Use the links below to jump directly to the dataset you are looking for,

Risk datasets
Audit datasets
Incident Datasets

2. Risk Datasets

Risk_RiskDetails_STND

This dataset will show all standard fields activated for a risk from the screen below. Fields that are activated for particular Phases will have the phase name prefixed e.g. Initial Risk Assessment Consequence.

Figure 2.1

Risk_RiskDetailsCustomFieldsInitial_STND

This dataset will show all custom fields activated for a risk for the initial phase from the screen below.

Figure 2.2

Risk_RiskDetailsCustomFieldsRevised_STND

Similar to above, will show all custom fields activated for a risk for the revised phase.

Risk_RiskDetailsCustomFieldsFuture_STND

Similar to above, will show all custom fields activated for a risk for the future phase.

Risk_RiskLinks_STND

This dataset will show all elements which can be linked to a Risk.

Field name in Insights	Notes

Field name in Insights	Notes
RISKID	Unique identifier for Risks – not usually displayed in reports.
GOALID	Used to get information of Goals linked to this Risk from Planning_PlanningHierarchy_STND.
OUTCOMEID	Used to get information of Outcomes linked to this Risk from Planning_PlanningHierarchy_STND.
STRATEGYID	Used to get information of Strategies linked to this Risk from Planning_PlanningHierarchy_STND.
DIRECTORATEID	Used to get information of Directorates linked to this Risk from Planning_OrgHierarchy_STND.
BUSINESSUNITID	Used to get information of Business Units linked to this Risk from Planning_OrgHierarchy_STND.
SERVICEID	Used to get information of Services linked to this Risk from Planning_OrgHierarchy_STND.
PROJECTID	Used to get information of Projects linked to this Risk from Project_ProjectRegister_STND.
ACTIONID	Used to get information of Actions linked to this Risk from Planning_ActionDetails_STND.
KPIID	Used to get information of KPIs linked to this Risk from Planning_KPIDetails_STND.
CONTROLID	Used to get information of Controls linked to this Risk from Risk_RiskControlDetails_STND.

Risk_RiskActionDetails_STND

This dataset will show all standard fields available for a risk action such as shown below.

Field name in Insights	Notes

Field name in Insights	Notes
RISKID	Unique identifier for Risks – not usually displayed in reports.
Risk Title	Name of the risk.
RISKACTIONID	Unique identifier for Risk actions – not usually displayed in reports.
Risk Solutions Title	Name of the risk action.
Risk Solutions Resource Requirement	Risk action resource requirement.
Risk Solutions Responsible Officer	Risk action responsible officer.
Risk Solutions Start Date	Start Date.
Risk Solutions End Date	End Date.
Risk Solutions Revised Start Date	Revised Start Date.
Risk Solutions Revised End Date	Revised End Date.
Risk Solutions Completion Date	Completed Date.
Risk Solutions Reporting Frequency	Reporting Frequency.
Risk Solutions Percentage Complete	Percentage Complete.
Risk Solutions Status	Status.
Risk Solutions Progress Comment	Comment.
Service Unit	Service Unit.
Last Updated By	Last Updated By.
Time Stamp	Time Stamp.
Next Update Required	Next Update Required.
SYSTEMPERIODID	Enables joining this dataset with System Period dataset to filter by system period.
BUSINESSUNITID	Used to get information of Business Unit linked to this Risk from Planning_OrgHierarchy_STND.

Risk_RiskControlDetails_STND

This dataset will show all standard fields available for a risk control such as shown below.

Field name in Insights	Notes

Field name in Insights	Notes
RISKID	Unique identifier for Risks – not usually displayed in reports.
Risk Title	Name of the risk.
RISKCONTROLID	Unique identifier for Risk controls – not usually displayed in reports.
Control Title	Name of the risk control.
Control Owner	Control Owner.
Control Owner Rating	Control Owner Rating.
Control Authorizer	Control Authorizer.
Control Authorizer Rating	Control Authorizer Rating.
Control Type	Control Type.
Control Review Date	Control Review Date.
Control Next Review Date	Control Next Review Date.
Control Status	Control Status.
Control Comment	Control Comment.
Authorizer Comment	Authorizer Comment.
Control Directorate	Control Directorate.
Control Business Unit	Control Business Unit.
Control Service Profile	Control Service Profile.

Risk_RiskControlSolutionDetails_STND

This dataset will show all standard fields available for a risk control action which is similar to Risk_RiskActionDetails_STND. However, note that Risk_RiskActionDetails_STND only produces actions directly associated with risks, while this dataset only produces actions directly associated with a control.

3. Audit Datasets

Audit_AuditDetails_STND

This dataset will show all fields activated for the Audit Detail screen as shown below.

Audit_AuditFindingDetails_STND

This dataset will show all fields activated for the Audit Finding screen as shown below.

Audit_AuditRecomendationDetails_STND

This dataset will show all fields activated for the Audit Recommendation screen as shown below.

Audit_AuditLink_STND

This dataset will show all elements which can be linked to an audit.

Field name in Insights	Notes

Field name in Insights	Notes
AUDITID	Unique identifier for audits – not usually displayed in reports.
Audit Title	Audit Title.
RISKID	Used to get information of risks linked to this audit from Risk_RiskDetails_STND.
Risk Title	Risk Title.
CONTROLID	Used to get information of Controls linked to this audit from Risk_RiskControlDetails_STND.
Control Title	Control Title.

Audit_AuditFindingLink_STND

This dataset will show all elements which can be linked to an Audit Finding.

Field name in Insights	Notes

Field name in Insights	Notes
AUDITID	Unique identifier for audits – not usually displayed in reports.
Audit Title	Audit Title.
AUDITFINDINGID	Unique identifier for audit findings – not usually displayed in reports.
Audit Finding Title	Audit Finding Title.
RISKID	Used to get information of risks linked to this audit finding from Risk_RiskDetails_STND.
Risk Title	Risk Title.

Audit_AuditRecommendationLink_STND

This dataset will show all elements which can be linked to an Audit Finding.

Field name in Insights	Notes

Field name in Insights	Notes
AUDITID	Unique identifier for audits – not usually displayed in reports.
Audit Title	Audit Title.
AUDITFINDINGID	Unique identifier for audit findings – not usually displayed in reports.
Audit Finding Title	Audit Finding Title.
RECOMMENDATIONID	Unique identifier for audit recommendations – not usually displayed in reports.
Audit Recommendation Title	Audit Recommendation Title.
RISKID	Used to get information of risks linked to this audit recommendation from Risk_RiskDetails_STND.
Risk Title	Risk Title.

4. Incident Datasets

Incident_IncidentDetails_STND

This dataset will show all fields activated for the standard incident details object across all your workflows. It includes a fixed field ‘Workflow’ which enables you to filter incidents for a specific Workflow.

Incident_Investigate_STND

This dataset will show all fields activated for the standard Investigation object.

Incident_Actions_STND

This dataset will show all fields activated for the standard Action object.

Incident_Documents_STND

This dataset will show all fields activated for the standard Documents object.

Incident_RootCauseAnalysis_STND

This dataset will show all fields activated for the standard Root Cause Analysis object.

Incident_CustomObject_STND

This dataset will show all fields activated for all instances of the custom object across all your workflows. It includes fixed fields ‘Workflow’ and ‘Object Name’ which enables you to filter the data as needed.

Note: If you need to generate a dedicated dataset for each custom object please refer Section 13.3.1 - Datasets for cammsincident Custom Objects/Tables

Incident_Links_STND

This dataset will show all elements which can be linked to an Incident.

Field name in Insights	Notes

Field name in Insights	Notes
INCIDENTID	Unique identifier for Incidents – not usually displayed in reports.
Incident Name	Name of the incident.
PROJECTID	Used to get information of the Project this Incident is linked to from Project_ProjectRegister_STND.
RISKID	Used to get information of the Risk this Incident is linked to from Risk_RiskDetails_STND.
Linkage	The name of the risk or project the incident is linked to.

Incident_Close_STND

This dataset will show all fields activated for the standard Close object.

<< Previous section
Standard Project Datasets

Table of Contents

Next section >>
Understanding SQL Joins

Camms.Support Documentation

Appendix: Standard Risk Datasets

1. Overview

2. Risk Datasets

3. Audit Datasets

4. Incident Datasets