Camms is pleased to bring you the Quarterly Product Release Notification 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 11th September 2021 and will be available in your Live instance on 25th September 2021.
1. Updates to Risk Initial Datasets
1.1 Introducing an Approval Status field to Risk Initial datasets in Camms.Risk
A new 'Approval Status' field will be incorporated into all four Risk Initial datasets to filter risks based on the statuses available in the Risk Approval Process. This field will enable to filter records based on the following approval statuses:
Draft
Submitted
Approved
Rejected
Resubmitted
The following risk initial datasets will be incorporated with the 'Approval Status' field:
Risk_StrategicRiskInitial_STND
Risk_OperationalRiskInitial_STND
Risk_ProjectRiskInitial_STND
Risk_CorporateRiskInitial_STND
To ensure these modifications are applied to the datasets for use within your Camms.Insights application, please click the link below and follow the steps:
Administration: Updating datasets for configuration changes - Camms.Support Documentation - Confluence (atlassian.net)
1.2 Enhancement to the Risk Initial datasets in Camms.Risk
The newly introduced Primary Risk Sub Categories for a Primary Risk Category feature in Camms.Risk will now reflect within all four Risk Initial datasets. The Risk Initial datasets will now contain four different fields to indicate the Primary category, Primary Sub categories, Secondary categories and Secondary Sub categories.
To ensure these modifications are applied to the datasets for use within your Camms.Insights application, please click the link below and follow the steps:
1.3 Enhancement to the Corporate and Operational Risk datasets in Camms.Risk
The flexible field configuration introduced within Camms.Risk will be applied to all datasets related to Corporate and Operational Risk types.
To ensure these modifications are applied to the datasets for use within your Camms.Insights application, please click the link below and follow the steps:
2. Enhancement to the Incident History Records dataset in Camms.Risk Incident
The Incident_IncidentHistoryExtended_STND dataset in Camms.Risk Incident will be expanded to cater history records under each Incident object. It is modified with new mandatory filters: Incident Object Name, Date From, and Date To, to return records based on a given time period and selected Incident object.
The following mandatory filters (parameters) are included in the dataset:
Field Name | Data Type | Remarks |
---|---|---|
@DATEFROM | Date Time | Start date of the period Incident history records should be filtered from |
@DATETO | Date Time | End date of the period Incident history records should be filtered to |
@IncidentObjectName | Text | Relevant Incident object history records should be filtered from (e.g. Injury, Hazard, Close) |
Following are some sample data included in the dataset:
@DATEFROM | @DATETO | @IncidentObject | Field Name | Previous Value | Current Value | Time Stamp | Title | User Name |
---|---|---|---|---|---|---|---|---|
2020-09-01T00:00:00 |
| Close | Status | Open | Closed | 2021-06-28T11:58:29.457 | Nose broken | Tim Jones |
2020-09-01T00:00:00 |
| Close | Closure Date | 30/09/2019 | 27/11/2020 | 2020-12-17T15:19:58.94 | Severe cut in right hand | Thomas Grey |
Click the link below in case any report errors are occurred due to the dataset modification:
https://cammsgroup.freshdesk.com/a/solutions/articles/43000639376
To ensure these modifications are applied to the datasets for use within your Camms.Insights application, please click the link below and follow the steps:
3. Introducing a new standard dataset to provide additional summary level project risk information
This new dataset will include the following summary level information for every project: Average Risk Rating Score, Average Risk Rating Description, Highest Risk Rating Score, and Highest Risk Rating Description. This can be joined with the existing Project Register dataset to present further details about a project, if required.
The following fields are included in the dataset:
Field Name | Data Type | Remarks |
---|---|---|
PROJECTID | Text | A unique ID of the project that can be used to link with other related datasets |
Project Title | Text | Captures the title of the project |
Average Risk Rating Score | Numeric | Average risk rating score of the project |
Average Risk Rating Description | Text | The risk rating description which corresponds to the average risk rating score |
Highest Risk Rating Score | Numeric | Highest risk rating score of the project |
Highest Risk Rating Description | Text | The risk rating description which corresponds to the highest risk rating score |
Following are some sample data included in the dataset:
Project Title | Average Risk Rating Score | Average Risk Rating Description | Highest Risk Rating Score | Highest Risk Rating Description |
---|---|---|---|---|
Traffic management on East Highway | 33 | Medium | 50 | High |
Safety improvement on West Highway | 41.75 | High | 90 | Extreme |
The below table shows the default relationship which you can setup as a System Administrator:
Join Type | Data Object | Join Field |
| Foreign Data Object | Join Field |
---|---|---|---|---|---|
INNER | Project_ProjectRegister_STND | PROJECTID | = | Project_ProjectOverallRiskRating_STND | PROJECTID |
To ensure this new dataset is enabled for use within your Camms.Insights application, please click the link below and follow the steps:
Administration: Configuring and enabling new datasets for use - Camms.Support Documentation - Confluence (atlassian.net)
4. Enhancement to the Project Task Details dataset in Camms.Project
The Project_TaskDetails_STND dataset in Camms.Project will include a field which shows if a task is a milestone or not. The field will return a yes or no value. This will be based on the existing field, 'Duration' in the same dataset and if the task duration is 0, then it will be considered as a milestone.
To ensure these modifications are applied to the datasets for use within your Camms.Insights application, please click the link below and follow the steps:
5. Introducing a new standard dataset for Project Portfolio view
This dataset will enable you to reproduce the Project Portfolio view of Camms.Project, enabling you to design reports which easily mimic the hierarchy of projects as seen within the solution. All columns configured to be visible for this page of Camms.Project, through Project Settings > Project Portfolio View will be available via the dataset as well.
The below table shows you the default relationship which you can set up as a System Administrator:
Join Type | Data Object | Join Field |
| Foreign Data Object | Join Field |
---|---|---|---|---|---|
INNER | Project_ProjectRegister_STND | PROJECTID | = | Project_PortfolioProjectView_STND | PROJECTID |
Following are some sample data included in the dataset:
Project Name | Project Start Date | Project End Date | Responsible Person | Project Sponsor | Duration | Progress% | Project Type |
---|---|---|---|---|---|---|---|
Capital Works | 31/12/2018 | 29/6/2023 | Joe Smith | Jack Watts | 1648 | 53 | Portfolio |
Public Infrastructure Improvement | 30/6/2019 | 15/10/2022 | Joe Smith | Sean Arnold | 1298 | 54 | Program |
Footpath Construction | 30/6/2019 | 29/6/2022 | Joe Smith | Jenifer Rance | 1095 | 68 | Capital Works |
Tunnel Design | 30/6/2019 | 29/6/2022 | Paul Hilton | John Wayne | 1187 | 36 | Capital Works |
To ensure this new dataset is enabled for use within your Camms.Insights application, please click the link below and follow the steps: