Camms is pleased to bring you the Quarterly Product Release Note for Camms.Insights.

This quarter we've got an exciting new feature and enhancement to improve your user experience within the system, which will be available in your Test environment on 11th June 2022 and will be available in your Live instance on 25th June 2022.


List of items

New datasets for Camms.Risk Compliance to support Flexible Organisation Hierarchy Linkages

1. Compliance_ComplianceFlexOrgHierarchyLink_STND

2. Compliance_ComplianceFlexOrgHierarchyLinkRollup_STND

3. Compliance_ComplianceAuthorityDocumentFlexOrgHierarchyLink_STND

4. Compliance_ComplianceAuthorityDocumentFlexOrgHierarchyLinkRollup_STND

5. Compliance_CompliancePolicyFlexOrgHierarchyLinkRollup_STND


New datasets for Camms.Risk Compliance to support Flexible Organisation Hierarchy Linkages

The following new datasets will be introduced to view Compliance records (Obligations, Authority Documents, Policies) linked to the different levels of the Flexible Organisation Hierarchy:

Note: This feature is currently applicable only to customers who have enabled the new Flexible Hierarchy permission structure, which is currently in beta.


This dataset is introduced to let you view Compliance records linked to the different levels of the Flexible Organisation Hierarchy. It will obtain Compliance records in the Camms.Risk Compliance product that are linked directly to a particular hierarchy node.

Fields included in the dataset:

Field Name

Data Type

Remarks

Compliance Title
Text
Name of the Compliance record.
COMPLIANCEID
TextA unique identifier for each Compliance record that can be used to link other datasets.
Hierarchy Level
Text
Captures the level of the Hierarchy the Compliance record is linked to (e.g. Business Unit).
Hierarchy Name
Text
Captures the name of the Hierarchy the Compliance record is linked to (e.g. Organisation Hierarchy).
HIERARCHYID
Text
Unique ID of the Hierarchy that can be used to link with other related datasets.
HIERARCHYLEVELID
Text
Unique ID of the Hierarchy Level that can be used to link with other related datasets.
HIERARCHYNODEID
Text
Unique ID of the Hierarchy Node that can be used to link with other related datasets.
Node Name
Text
Captures the Hierarchy Node the Compliance record is linked to (e.g. Corporate Services).


Sample data in the dataset:

Compliance Title
Hierarchy Name
Hierarchy Level
Node Name
Copyright Compliance
Compliance Framework
Unit
Legal & General
Personal Information 
Organisation Hierarchy
Section
HR Service
Legal and Regulatory Compliance 
Compliance Framework
Unit
Legal & General
Electronic Devices and Services 
Infrastructure Hierarchy
Section
IT Service


The default relationship that can be set up for a System Administrator:

Join Type

Data Object

Join Field


Foreign Data Object

Join Field

INNER

<Core Compliance 
Register dataset> e.g. Compliance_Obligation
Register_REG

COMPLIANCEID


=
Compliance_ComplianceFlexOrgHierarchy
Link_STND

COMPLIANCEID

 

2. Compliance_ComplianceFlexOrgHierarchyLinkRollup_STND

This dataset will let you view Compliance records that are linked either directly to a particular Hierarchy node or to any nodes below it (rolled-up).

Fields included in the dataset:

Field Name

Data Type

Remarks

Compliance Title
Text
Name of the Compliance record.
COMPLIANCEID
Unique ID
A unique identifier for each Compliance record that can be used to link with other datasets.
Hierarchy Level
Text
Captures the level of the Hierarchy the Compliance record is linked or rolled up to (e.g. Business Unit).
Hierarchy Name
Text
Captures the name of the Hierarchy that the Compliance record is linked to (e.g. Organisation Hierarchy).
HIERARCHYID
Unique ID
Unique ID of the Hierarchy that can be used to link with other related datasets.
HIERARCHYLEVELID
Unique IDUnique ID of the Hierarchy Level that can be used to link with other related datasets.
HIERARCHYNODEID
Unique ID
Unique ID of the Hierarchy Node that can be used to link with other related datasets.
Node Name
Text
Captures the Hierarchy Node the Compliance record is linked or rolled up to (e.g. Corporate Services).


Sample data included in the dataset:

Compliance Title
Hierarchy Name
Hierarchy Level
Node Name
Copyright Compliance
Compliance Framework
Unit
Legal & General
Personal Information
Organisation Hierarchy
Section
HR Service
Legal and Regulatory ComplianceCompliance Framework
Unit
Legal & General
Electronic Devices and Services
Infrastructure Hierarchy
Section
IT Service


The default relationship that can be set up for a System Administrator:

Join Type

Data Object

Join Field


Foreign Data Object

Join Field

INNER


<Core Compliance 
Register dataset> e.g. Compliance_Obligation
Register_REG
COMPLIANCEID

=

Compliance_ComplianceFlexOrgHierarchy
LinkRollup_STND
COMPLIANCEID 

 

This dataset is introduced to let you view Authority Documents linked to the different levels of the Flexible Organisation Hierarchy. It will obtain Authority Documents from the Camms.Risk Compliance product that are linked directly to a particular Hierarchy node.

Fields included in the dataset:

Field Name

Data Type

Remarks

AUTHORITYDOCUMENTID
Unique IDA unique identifier for each Compliance Authority Document that can be used to connect with other datasets.
Authority Document Title
TextName of the Authority Document.
Hierarchy Level
Text
Captures the level of the Hierarchy the Compliance record is linked to (e.g. Business Unit).
Hierarchy Name
Text
Captures the name of the Hierarchy the Compliance record is linked to (e.g. Organisation Hierarchy).
HIERARCHYID
Unique ID
Unique ID of the Hierarchy that can be used to link with other related datasets.
HIERARCHYLEVELID
Unique ID
Unique ID of the Hierarchy Level that can be used to link with other related datasets.
HIERARCHYNODEID
Unique ID
Unique ID of the Hierarchy Node that can be used to link with other related datasets.
Node Name
Text
Captures the Hierarchy Node the Compliance record is linked to (e.g. Corporate Services).


Sample data included in the dataset:

Authority Document Title 
Hierarchy Name
Hierarchy Level
Node Name
Legal and Regulatory Document
Compliance Framework
Unit
Legal & General
Personal Information Form
Organisation HierarchySection
HR Service
Electronic Devices and Services Inventory Report
Compliance Framework
Unit
Legal & General
Authority Payroll Document
Infrastructure Hierarchy
Section
IT Service


The default relationship that can be set up as a System Administrator:

Join Type

Data Object

Join Field


Foreign Data Object

Join Field

LEFT

<Core Authority Document 
Register dataset> e.g. Compliance_AuthorityDocument
Register_REG

AUTHORITY

DOCUMENTID

=

Compliance_ComplianceAuthority
DocumentFlexOrgHierarchyLink_STND

AUTHORITY

DOCUMENTID

 

4. Compliance_ComplianceAuthorityDocumentFlexOrgHierarchyLinkRollup_STND

This dataset will let you view Authority Documents that are linked either directly to a particular Hierarchy Node or to any Nodes below it (rolled-up).

Fields included in the dataset:

Field Name

Data Type

Remarks

AUTHORITYDOCUMENTID 
Unique ID 
A unique identifier for each Compliance Authority Document that can be used to connect with other datasets.
Authority Document Title 
Text
Name of the Authority Document.
Hierarchy Level
Text
Captures the level of the Hierarchy the Compliance Authority Document is linked or rolled up to (e.g. Business Unit).
Hierarchy Name
Text
Captures the name of the Hierarchy that the Compliance Authority Document is linked to (e.g. Organisation Hierarchy).
HIERARCHYID
Unique ID
Unique ID of the Hierarchy that can be used to link with other related datasets.
HIERARCHYLEVELID
Unique ID
Unique ID of the Hierarchy Level that can be used to link with other related datasets.
HIERARCHYNODEID
Unique ID
Unique ID of the Hierarchy Node that can be used to link with other related datasets.
Node Name
Text
Captures the Hierarchy Node the Compliance Authority Document is linked or rolled up to (e.g. Corporate Services).


Sample data included in the dataset:

Authority Document Title 
Hierarchy Name
Hierarchy Level
Node Name
Legal and Regulatory Document
Compliance Framework
Unit
Legal & General
Personal Information Form
Organisation Hierarchy
Section
HR Service
Electronic Devices and Services Inventory Report
Compliance Framework
Unit
Legal & General
Authority Payroll Document
Infrastructure Hierarchy
Section
IT Service


The default relationship that can be set up as a System Administrator:

Join Type

Data Object

Join Field


Foreign Data Object

Join Field

INNER

<Core Authority Document 
Register dataset> e.g. Compliance_AuthorityDocument
Register_REG

AUTHORITY

DOCUMENTID

=

Compliance_ComplianceAuthority
DocumentFlexOrgHierarchy
LinkRollup_STND

AUTHORITY

DOCUMENTID

 

5. Compliance_CompliancePolicyFlexOrgHierarchyLinkRollup_STND

This dataset is introduced to let you view Policies linked to the different levels of the Flexible Organisation Hierarchy. It will obtain Policies from the Camms.Risk Compliance product that are linked directly to a particular Hierarchy Node or to any Nodes below it (rolled-up).

Fields included in the dataset:

Field Name

Data Type

Remarks
POLICYID
Unique ID 
This is a unique identifier for each policy and can be used to connect with other datasets 
Policy Title 
Text
The name of the policy 
Hierarchy Level
Text
Captures the level of the Hierarchy the policy is linked or rolled up to (e.g., Business Unit) 
Hierarchy Name
TextCaptures the name of the Hierarchy that the policy is linked to (e.g. Organisation Hierarchy) 
HIERARCHYID
Unique ID
Unique ID of the Hierarchy that can be used to link with other related datasets 
HIERARCHYLEVELID
Unique ID
Unique ID of the Hierarchy Level that can be used to link with other related datasets 
HIERARCHYNODEID
Unique ID
Unique ID of the Hierarchy Node that can be used to link with other related datasets 
Node Name
Text
Captures the Hierarchy Node the policy is linked or rolled up to (e.g. Corporate Services) 


Sample data included in the dataset:

Policy  Title 
Hierarchy Name
Hierarchy Level
Node Name
AuthorityCompliance Framework
Unit
Legal & General
Personal Information Policy
Organisation Hierarchy
Section
HR Service
Legal and Regulatory Compliance Policy
Compliance Framework
Unit
Legal & General
Electronic Devices and Services Policy
Infrastructure Hierarchy
Section
IT Service


The default relationship that can be set up as a System Administrator:

Join Type

Data Object

Join Field


Foreign Data Object

Join Field

LEFT

<Core Policy Register dataset> e.g. Compliance_PolicyRegister_REG
POLICYID=
Compliance_CompliancePolicy
FlexOrgHierarchyLinkRollup_STND
POLICYID


To ensure these new fields are enabled for use within your Camms.Insights application, please click the link below or copy and paste the link into your web browser and follow the steps:

https://cammsgroup.freshdesk.com/support/solutions/articles/43000509883-administration-configuring-and-enabling-new-datasets-for-use