Camms.Insights | June 2022

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.

1. 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.

1.1 Compliance_ComplianceFlexOrgHierarchyLink_STND

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

Field Name

Data Type

Remarks

Compliance Title

Text

Name of the Compliance record.

COMPLIANCEID

Text

A 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

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

1.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 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 or rolled up to (e.g. Corporate Services).

Sample data included in the dataset:

Compliance Title

Hierarchy Name

Hierarchy Level

Node Name

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

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 

1.3 Compliance_ComplianceAuthorityDocumentFlexOrgHierarchyLink_STND

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

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 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

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

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

1.4 Compliance_ComplianceAuthorityDocumentFlexOrgHierarchyLinkRollu p_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

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

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

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

1.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

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

Text

Captures 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

Policy  Title 

Hierarchy Name

Hierarchy Level

Node Name

Authority

Compliance 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

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:

Administration: Configuring and enabling new datasets for use - Camms.Support Documentation - Confluence (atlassian.net)

Â