...
This quarter we've got an exciting new enhancement to improve your user experience within the system, which will be available in your Test environment on 12th March 2022 and will be available in your Live instance on 26th March 2022.
List of items:
|
1. Introducing 20 new datasets for our new Control Module |
With the release of our revamped Controls Module, a set of new Control datasets will be introduced within Camms.Insights. These datasets will align with key areas of the module such as: control details, documents, and links.
New datasets created are as follows.
Control_ControlDetails_STND
Control_ControlDocuments_STND
Control_ControlActionDetails_STND
Control_ControlCausesLink_STND
Control_ControlConsequencesLink_STND
Control_ControlOrgHierarchyLink_STND
Control_ControlCustomHierarchyLink_STND
Control_ControlFlexOrgHierarchyLink_STND
Control_ControlFlexOrgHierarchyLinkRollup_STND
Control_DeletedControls_STND
Control_ControlRiskLink_STND
Control_ControlIncidentLink_STND
Control_ControlAuditLink_STND
Control_ControlAuditRecommendationLink_STND
Control_ControlAuditFindingLink_STND
Control_ControlComplianceLink_STND
Control_ControlAuthorityDocumentLink_STND
Control_ControlPolicyLink_STND
Control_ControlKPILink_STND
Control_ControlRegister_STND
1.1. Control_ControlDetails_STND
This dataset enables you to generate reports based on the data from the Control Details page. of the Control module.
...
1.2 Control_ControlDocuments_STND
This dataset enables you to retrieve data of the uploaded files i.e. Documents or URLs via the Control module when the Documents area is activated via Control Settings.
...
Join Type | Data Object | Join Field | Foreign Data Object | |
|---|---|---|---|---|
LEFT | Control_ControlDetails_STND | CONTROLID | = | Control_ControlDocuments_STND |
1.3 Control_ControlActionDetails_STND
The data for the Control_ControlActionDetails_STND dataset will be retrieved from the Control module, when the Control Solution Grid is enabled (ticked) from the Control Settings > Field Configuration > Details tab against the 'Control Detail' column.
...
1.4 Control_ControlCausesLink_STND
This dataset will present how a control record in the Control module is linked to its causes.
...
Join Type | Data Object | Join Field | Foreign Data Object | Join Field | |
|---|---|---|---|---|---|
LEFT | Control_ControlDetails_STND | CONTROLID | = | Control_ControlCausesLink_STND | CONTROLID |
1.5 Control_ControlConsequencesLink_STND
This dataset will present how a control record in the Control module is linked to its consequences.
...
Join Type | Data Object | Join Field | Foreign Data Object | Join Field | |
|---|---|---|---|---|---|
INNER | Control_ControlConsequences_STND | CONTROLID | = | Control_ControlConsequencesLink_STND | CONTROLID |
1.6 Control_ControlOrgHierarchyLink_STND
This dataset will present how a control record in the Control module is linked to your organisation hierarchy.
...
Join Type | Data Object | Join Field | Foreign Data Object | Join Field | |
|---|---|---|---|---|---|
LEFT | Control_ControlDetails_STND | CONTROLID | = | Control_ControlOrgHierarchyLink_STND | CONTROLID |
1.7 Control_ControlCustomHierarchyLink_STND
This dataset will present how a control record in the Control module is linked to your organisation's custom hierarchy.
...
Join Type | Data Object | Join Field |
| Foreign Data Object | Join Field |
LEFT | Control_ControlDetails_STND | CONTROLID | = | Control_ControlCustomHierarchyLink_STND | CONTROLID |
1.8 Control_ControlFlexOrgHierarchyLink_STND
This dataset will present how a control record in the Control module is linked to your organisation's flexible hierarchy.
...
Join Type | Data Object | Join Field | Foreign Data Object | Join Field | |
|---|---|---|---|---|---|
LEFT | Control_ControlDetails_STND | CONTROLID | = | Control_ControlFlexOrgHierarchyLink_STND | CONTROLID |
1.9 Control_ControlFlexOrgHierarchyLinkRollup_STND
This dataset will present how a control record in the Control module is directly linked to a particular node or to any nodes below it (rolled-up) in your flexible hierarchy.
...
Join Type | Data Object | Join Field | Foreign Data Object | Join Field | |
LEFT | Control_ControlDetails_STND | CONTROLID | = | Control_ControlFlexOrgHierarchyLinkRollup_STND | CONTROLID |
1.10 Control_DeletedControls_STND
This dataset retrieves any controls that have been deleted through the Control module.
...
Join Type | Data Object | Join Field | Foreign Data Object | Join Field | |
LEFT | Control_ControlDetails_STND | CONTROLID | = | Control_DeletedControls_STND | CONTROLID |
1.11 Control_ControlRiskLink_STND
This dataset will present how a control record in the Control module is linked to Risks.
...
Join Type | Data Object | Join Field | Foreign Data Object | Join Field | |
LEFT | Control_ControlDetails_STND | CONTROLID | = | Control_ControlRiskLink_STND | CONTROLID |
1.12 Control_ControlIncidentLink_STND
This dataset will present how a control record in the Control module is linked to Incidents.
...
Join Type | Data Object | Join Field | Foreign Data Object | Join Field | |
LEFT | Control_ControlDetails_STND | CONTROLID | = | Control_ControlIncidentLink_STND | CONTROLID |
1.13 Control_ControlAuditLink_STND
This dataset will present how a control record in the Control module is linked to Audits.
...
Join Type | Data Object | Join Field | Foreign Data Object | Join Field | |
LEFT | Control_ControlDetails_STND | CONTROLID | = | Control_ControlAuditLink_STND | CONTROLID |
1.14 Control_ControlAuditRecommendationLink_STND
This dataset will present how a control record in the Control module is linked to Audit Recommendations.
...
Join Type | Data Object | Join Field | Foreign Data Object | Join Field | |
LEFT | Control_ControlDetails_STND | CONTROLID | = | Control_ControlAuditRecommendationLink_STND | CONTROLID |
1.15 Control_ControlAuditFindingLink_STND
This dataset will present how a control record in the Control module is linked to Audit Findings.
...
Join Type | Data Object | Join Field | Foreign Data Object | Join Field | |
LEFT | Control_ControlDetails_STND | CONTROLID | = | Control_ControlAuditFindingLink_STND | CONTROLID |
1.16 Control_ControlComplianceLink_STND
This dataset will present how a control record in the Control module is linked to Compliance records.
...
Join Type | Data Object | Join Field | Foreign Data Object | Join Field | |
LEFT | Control_ControlDetails_STND | CONTROLID | = | Control_ControlComplianceLink_STND | CONTROLID |
1.17 Control_ControlAuthorityDocumentLink_STND
This dataset will present how a control record in the Control module is linked to Authority Documents.
...
Join Type | Data Object | Join Field | Foreign Data Object | Join Field | |
LEFT | Control_ControlDetails_STND | CONTROLID | = | Control_ControlAuthorityDocumentLink_STND | CONTROLID |
1.18 Control_ControlPolicyLink_STND
This dataset will present how a control record in the Control module is linked to Policies.
...
Join Type | Data Object | Join Field | Foreign Data Object | Join Field | |
LEFT | Control_ControlDetails_STND | CONTROLID | = | Control_ControlPolicyLink_STND | CONTROLID |
1.19 Control_ControlKPILink_STND
This dataset will present how a control record in the Control module is linked to KPIs.
...
Join Type | Data Object | Join Field | Foreign Data Object | Join Field | |
LEFT | Control_ControlDetails_STND | CONTROLID | = | Control_ControlKPILink_STND | CONTROLID |
1.20 Control_ControlRegister_STND
This dataset enables you to generate reports based on the data from the Control Register page of the Control module.
...
2. Introducing new datasets to retrieve data from Child Risks in Risk Aggregation |
Four (4) separate Risk datasets for each risk type is introduced in order to present the parent-child relationship of the risks (i.e.to show the parent risk along with the related child risks). These four datasets will capture all the child risks under each of the respective risk types.
Risk_StrategicChildRiskLinks_STND
Risk_OperationalChildRiskLinks_STND
Risk_ProjectChildRiskLinks_STND
Risk_CorporateChildRiskLinks_STND
The following fields are available in the dataset:
...