Risk
Name Data Type Size Comments
A record of something which poses a threat
AssessmentCount int16 Count of child assessments
AttachmentCount int16 Count of child attachments
Comments richtext Unlimited rich text comments
Comments_Plain string Plain text equivilent of the corresponding rich text field
ControlCount int16 Count of child controls
CrossReferences string List of other items to which this item is cross-referenced
Description richtext Standard unlimited rich text description
Description_Plain string Plain text equivilent of the corresponding rich text field
FindingCount int16 Count of child findings
HasParent boolean Indicates if the item has a "parent" item at entity level
HasTemplate boolean Indicates if the item has a "template" item at library level
Locked boolean Whether or not the item definition is read-only to end users
Name string (555) Constructed from the Ref and Title
NoteCount int16 Count of child notes
Ref string (50) Standard short reference
ReviewCount int16 Count of child reviews
ReviewPointCount int16 Count of child review points
SOXAccountNames string List of names of the related SOX accounts
SOXAssertionNames string List of names of the related SOX assertions
TestCount int16 Count of child tests
Title string (500) Standard short title
Approval SignOff 1:1 Link to Sign Off which contains when the record was Approved and when
Assessments RiskAssessment 1:M Link to child assessments
Attachments Attachment 1:M Link to child Attachments
BusinessOwner Person M:1 Person who is responsible for the item in the business (used for permissions)
Category RiskCategory M:1 Simple segmentation
ChildFindings Finding 1:M Link to all child findings (i.e. including ones linked indirectly)
ChildTests Test 1:M Link to all child Tests (i.e. including ones linked indirectly)
Completion SignOff 1:1 Link to Sign Off which contains when the record was Completed and when
Confirmation SignOff 1:1 Link to Sign Off which contains when the record was confirmed and when
Controls Control 1:M Link to child Controls
CurrentAssessment RiskAssessment 1:1 Link to the current assessment (which will also be in the list of all assessments)
Findings Finding 1:M Link to child Findings
LastReview Review 1:1 Link to the last Review
LinkedControls Control M:M Link to all related Controls
LinkedFindings Finding M:M Link to all related Findings
LinkedTests Test M:M Link to all related Tests
Notes Note 1:M Link to child Notes
Objective Objective M:1 Link to parent Objective
OfflineCheckOut OfflineCheckOut 1:1 Link to child check out which contains who/when item was checked out
Owner Person M:1 Person who owns the item which is used for permissions
Parent EntityRisk M:1 Link to Entity item from which this item was created
Preparation SignOff 1:1 Link to Sign Off which contains when the record was prepared and when
ReviewPoints ReviewPoint 1:M Link to child Review Points
Reviews Review 1:M Link to child Reviews
ReviewState ReviewState M:1 Whether the item is "Not Reviewed", "Reviewed" or "Changed"
ScopeState ScopeState M:1 Whether the item is "In Scope" or "Out of Scope"
SignOffState SignOffState M:1 Whether the item is "Open", "Completed" or "Approved"
SOXAccounts SOXAccount M:M SOX Accounts to which the item relates
SOXAssertions SOXAssertion M:M SOX Assertions to which the item relates
Template RiskTemplate M:1 Link to the template from which this item was created
Tests Test 1:M Link to child Tests
Type RiskType M:1 Basic segmentation