Preparing your risk library for import
This spreadsheet template should be used to structure your risks ready to import into 6clicks.
This table explains the columns and data requirement.
Risk library data import format
|Column Name||Description||Data Constraint||App Reference|
|Source||The author of the content - i.e. vendor name - "Risks 'R Us Pty Ltd"||30 characters||N/A|
|ContentRef||A reference to the underlying source of the content if/where the content has been derived online from an online source||30 characters||N/A|
|RiskLibrary||This is the name of the risk library as indicated to the right.||30 characters|
|RiskLibraryDescription||The description of the risk library||45 characters|
|RiskDomain||The risk domain name picked from the list shown here In the mobile app, the risk will then appear on a card with the risk domain as the title and the background colour as indicated here.||Lookup and reference the risk domain|
|Risk||The name of the risk.||45 characters|
|Description||The description of the risk||140 characters|
|Cause X||A common cause related to the risk. Note in the spreadsheet, that for each additional cause, you should populate the additional column - i.e. Cause 1, Cause 2, Cause 3 etc.|| 45 characters
|Impact X|| A potential impact related to the risk. Note in the spreadsheet, that for each additional cause, you should populate the additional column - i.e. Impact 1, Impact 2, Impact 3 etc.
Sharing the completed google sheet with us
Our process once we imported your risk library(s)
To ensure a collective and well structured underlying data model, we may de-duplicate and unify risks, causes and impacts so if we find an existing match we’ll use it (you can directly quote existing risks, causes and impacts if you like and want to help keep our data clean).