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

This quarter we've got a number of exciting new features and enhancements to improve your user experience within the system, which will be available in your Test environment on 3rd December 2022 and will be available in your Live instance on 17th December 2022.

List of items

1. Introducing new standard datasets to expose obligation and control survey data in Camms.Risk Compliance

2. Introducing a new standard dataset to expose staff FlexOrg Hierarchy roles assigned to users in Camms.Strategy

3. Introducing new datasets to capture revision history for Compliance, Policy and Authority Document modules in the Compliance application

4. Enhancement on default date/time columns in Project Task datasets.

New standard datasets are to be developed to link Surveys related to ‘Controls’ and ‘Obligation/Compliance’ modules in Camms.Compliance with the Survey_SurveyRegister_STND and Survey_SurveyResponses_STND datasets, that already exist in the system.

The following new link datasets have been introduced:

1.1 Survey_SurveyControlLink_ STND

This dataset will link Control Surveys with Survey_SurveyRegister_STND. The following fields will be included in this dataset to establish links with the Survey datasets.

1.2 Survey_SurveyResponseControlLink_STND

This dataset will link Control Survey responses with Survey_SurveyResponses_STND. The following fields will be included in this dataset to establish links with the Survey datasets.

1.3 Survey_SurveyComplianceLink_ STND

This dataset will link Compliance Surveys with Survey_SurveyRegister_STND. The following fields will be included in this dataset to establish links with the Survey datasets.

1.4 Survey_SurveyResponseComplianceLink_ STND

This dataset will link Compliance Survey responses with Survey_SurveyResponses_STND. The following fields will be included in this dataset to establish links with the Survey datasets.

 The data that will be available in the dataset will be based on the components illustrated below.

The Survey ID and Title will be derived from the ‘Survey Register’ module illustrated below. 

 Figure 1.4.1

The Control and Compliance IDs and Titles will be derived from the ‘Linkage’ tab as illustrated below. 

 Figure 1.4.2

The Question ID and Title will be derived from the ‘Questions’ tab as illustrated below 

 Figure 1.4.3

Default relationships can be defined for these datasets as follows. A combination of SURVEYID and QUESTIONID should be used as illustrated below for the ‘Join Field’ when creating relationships for the Survey_SurveyResponses_STND dataset.

A new standard dataset will be introduced to expose the FlexOrg Hierarchy roles assigned to staff in Camms.Strategy in the 'Staff' module. The dataset will allow the FlexOrg ‘Role’ details of each staff member defined in Camms.Strategy to be generated in reports.

2.1 Planning_StaffFlexAssignRole_STND

The data that will be available in the dataset will be based on the components illustrated below within the 'Staff' module of Camms.Strategy.

Camms.Strategy Menu > Staff 

Figure 2.1.1

Camms.Strategy Menu > Staff > Select Staff > Details

 Figure 2.1.2

Camms.Strategy Menu > Staff > Select Staff > Assign Role > 

 Figure 2.1.3

Camms.Strategy Menu > Staff > Select Staff > Assign Role > Add New

Figure 2.1.4

The dataset will include the following fields.

This dataset can be joined with other standard datasets using the unique identifiers to obtain other related information. Given below are some examples of how the standard datasets can be joined.

New standard datasets will be introduced exposing history data from each of the components in the Camms.Risk Compliance product as follows:

• Compliance_ComplianceHistoryExtended_STND
• Compliance_AuthorityDocumentHistoryExtended_STND
• Compliance_PolicyHistoryExtended_STND

Each of these datasets will have mandatory parameters imposed at a dataset level as follows:

The following fields will be included in the datasets for creation of revision history reports.

3.1 Compliance_PolicyHistoryExtended_STND

3.2 Compliance_ComplianceHistoryExtended_STND 

3.3 Compliance_AuthorityDocumentHistoryExtended_STND

The values for dataset fields 'Action Summary', 'Current Value', and 'Previous Value' is obtained from the 'History' module in the Camms.Risk Compliance application as illustrated below.

The 'Summary' field in Camms.Risk Compliance platform 'History' module is named as 'Action Summary' in the datasets.

 Figure 3.3.1 

The 'Current Representation' field in the Compliance platform 'History' module is named as 'Current Value ' in the datasets.

The 'Previous Representation' field in the Compliance platform 'History' module is named as 'Current Value ' in the datasets.

 Figure 3.3.2

The “Data Source” module in Camms.Insights will be modified to view the mandatory parameters of each new dataset where the 'Filter' panel will include the parameters of each dataset. The user is required to select values for these filters to select the dataset for the report 'Design'.

Illustration of parameters in the 'Data Source' selection module for Compliance_ComplianceHistoryExtended_STND dataset.

 Figure 3.3.3

Illustration of parameters in the 'Data Source' selection module for Compliance_AuthorityDocumentHistoryExtended_STND dataset.  

  Figure 3.3.4

Illustration of parameters in the 'Data Source' selection module for Compliance_PolicyHistoryExtended_STND datset.

Figure 3.3.5

The 'Start Date' and 'End Date' fields of Project Task datasets are made static by modifying the field data type to Date/Time. The fields in the following Project Task datasets have been modified.

• Project_TaskDetails_STND
• Project_TaskDetailsAll_STND
• Project_TaskDetailsCurrentPhase_STND