Way to upload older Risk Assessment Records into Advanced Risk Assessment Module

[PrakashRam]

Hi Friends,

We are trying to upload or migrate old risk data into the Advanced Risk Assessment Data. Somehow the color styles are not applied properly and also the old records does not reflect in Heatmap.

Is there any proper way to upload records like which key fields we need to consider for upload so that after upload, the we can see the data properly ?

Looking your valuable suggestions. @Rajesh_Singh , @Jan Spurlin , @Mary Hain , @britta , @Naveen Kumar4 

Thank in advance.

[surendarcs69]

Hi @PrakashRam @UTKARSH JAIN @Naveen Kumar4 ,

We are currently working on this requirement scope. Please can you let us know the challenges you had faced (as listed below) and how you were able to resolve those issues. Your guidance would be much helpful for us to align on this uploading requirement.

Thanks in advance.

[Naveen Kumar4]

This query is resolved.

[Eva Tee]

Hi @PrakashRam , are you able to share what's the solution to this? 

[PrakashRam]

Hi @Eva Tee ,

Happy to help !!!

Just to make it clear there are 2 imports we need to do in order to see your data properly with color code and also to see data in Heat Map as well

1, Assessment Data

2. Heat Map Data - If you avoid this import, then you wont see data in your heatmap for your old assessments.

1. Assessment Data - Sets the Value for each score fields in form with respective color codes

I have followed below template and below mapping you should do for every score fields,

Target Table: sn_risk_advanced_risk_assessment_instance

Risk Assessment Methodology

Risk

Entity

Owner

Assessor

State

Assessment Start Date

Assessment End Date

Due Date

Computed Inherent Score

Final Inherent Score

Computed inherent risk (Reference)

Computed inherent risk

Summary Inherent Risk

Summary Inherent Risk Score

Computed Control Score

Final Control Score

Computed Control Effectiveness (Reference)

Computed Control Effectiveness

Summary Control effectiveness

Summary Control effectiveness Score

Computed residual score

Final Residual Score

Computed Residual Risk (Reference)

Computed Residual Risk

Summary Residual Risk

Summary Residual Risk Score

Methodology 1

Risk_1

Sample Entity

Abel Tuter

Abraham Lincoln

Residual assessment

31-10-2022

31-10-2022

31-10-2022

3

3

0747a68509a13510367c44cbf455e032

Moderate (Score: 4)

0747a68509a13510367c44cbf455e032

Moderate (Score: 4)

2

2

5410b28909a53210367c44cbf455d036

Effective (Score: 2)

5410b28909a53210367c44cbf455d036

Effective (Score: 2)

1

1

a77a2bed09ad5d10367c44cbf455d0da

Low (Score: 1)

a77a2bed09ad5d10367c44cbf455d0da

Low (Score: 1)

Our goal is to import below three score fields with proper color style:

1. Inherent Score

2. Control Effectiveness Score

3. Residual Risk Score

In order to properly display score for each score field we have to map exactly 6 fields as in template above and follows the same for remaining other 2 score fields. So total 18 fields we have to map.

Computed Inherent Score	Numeric Value for Old Assessments
Final Inherent Score	Numeric Value for Old Assessments
Computed inherent risk (Reference)	Sys id of color code for inherent risk for mapped methodology
Computed inherent risk	String value of score to be displayed
Summary Inherent Risk	Sys id of color code for inherent risk for mapped methodology
Summary Inherent Risk Score	String value of score to be displayed

2. HeatMap Data - Sets the Value of each question for each assessment to show up in HeatMap

I have followed below template and below mapping you should do for each question in your Advanced Risk Assessment,

Target Table: sn_risk_advanced_risk_assessment_instance_response

Follow the same import structure for other 2 assessment question mapping ( Control Assessment and Residual Assessment )

Number	Risk	Impact	Factor Response	Qualitative Response	Assessment Type
RASMT00102000	Risk_1	c125620509613556057c44cbf455d0e7	1	1	Inherent Assessment

Impact	Sys Id of the question from your assessment (sn_risk_advanced_inherent_assessment) and similarly pick sys id from other tables
Factor Response	Numeric Response value for your question
Qualitative Response	Numeric Response value for your question
Assessment Type	Type of Assessment ex., Inherent Assessment, Control Assessment and Residual Assessment

Conclusion: After these 2 imports, your imported risk assessment should display Assessment data with proper color code and also it would display data in your respective heatmaps.