...
List of items:
|
1. Introducing new standard datasets to expose obligation and control survey data in Camms.Risk Compliance |
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.
...
Field Name | Data Type | Field Description |
SURVEYID | int | Unique identifier for Survey in the Survey Register. |
Survey Title | nvarchar | Title of Survey in the Survey Register. |
CONTROLID | int | Unique identifier of the Control, linked in Linkage tab. |
Control Title | nvarchar | Title of linked Control. |
QUESTIONID | int | Unique identifier of Question linked in the Questions tab. |
Question Title | nvarchar | Title of Question in the Questions tab. |
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.
...
Join Type | Dataset | Join Field | = | Dataset | Join Field |
LEFTOUT | Survey_SurveyRegister_ | SURVEYID | Survey_SurveyControlLink_ Stnd | SURVEYID | |
LEFTOUT | Survey_SurveyRegister_ | SURVEYID | Survey_SurveyComplianceLink_ | SURVEYID | |
LEFTOUT | Survey_SurveyResponses_ | SURVEYID (AND) QUESTIONID | Survey_SurveyResponseControlLink_ | SURVEYID (AND) QUESTIONID | |
LEFTOUT | Survey_SurveyResponses_ | SURVEYID (AND) QUESTIONID | Survey_SurveyResponseComplianceLink_ | SURVEYID (AND) QUESTIONID |
2. Introducing a new standard dataset to expose staff FlexOrg Hierarchy roles assigned to users in Camms.Strategy |
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.
...
Join Type | Dataset | Join Field | = | Dataset | Join Field |
Left | Planning_Staff_STND | STAFF ID | Planning_StaffFlexOrgUserRoles_ | STAFFID | |
Left | Planning_UserList_STND | USER ID | Planning_StaffFlexOrgUserRoles_ | USERID | |
Left | Planning_StaffFlexOrgHierarchyLink_ | STAFF ID | Planning_StaffFlexOrgUserRoles_ | STAFFID |
3. Introducing new datasets to capture revision history for Compliance, Policy and Authority Document modules in the Compliance application |
New standard datasets will be introduced exposing history data from each of the components in the Camms.Risk Compliance product as follows:
...
| Info |
|---|
Note: These datasets are not recommended to be joined with other datasets due to performance constraints. Each of these datasets must be used independently. |
4. Enhancement on default date/time columns in Project Task datasets. |
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.
...