EntityProcess
Name Data Type Size Comments
Mapping between entities and processes (i.e. which are active)
Active boolean Whether or not the item is currently available for use
AttachmentCount int16 Count of child attachments
AuditFrequency int16 Number of months between which audits should be scheduled
BudgetEffort decimal (18,2) Number of days the entity/process is budgeted to take (if not using Retain)
CertificationComments richtext Unlimited rich text to explain the certification
CertificationComments_Plain string Plain text equivilent of the corresponding rich text field
CertifiedTime datetime Date/time when the item was certified
ChildCount int16 Count of children
Comments richtext Unlimited rich text comments
Comments_Plain string Plain text equivilent of the corresponding rich text field
CrossReferences string List of other items to which this item is cross-referenced
EntityObjectiveCount int16 Count of child objectives
Name string (1200) Constructed from the Ref and Title
NoteCount int16 Count of child notes
SOXAccountNames string List of names of the related SOX accounts
Actions Action 1:M Link to child actions
Assignments EntityAssignment M:M Link to child assignments
Attachments Attachment 1:M Link to child Attachments
AuditProcesses AuditProcess 1:M Link to child audit/processes
Audits Audit M:M Link to child Audits
BusinessOwner Person M:1 Person who is responsible for the item in the business (used for permissions)
BusinessReviewer Person M:1 Person who is responsible for reviewing the item in the business (used for permissions)
CertificationState CertificationState M:1 Whether the item is "Not Certified", "Certified With Exceptions" or "Certified"
CertifiedBy Person M:1 Link to Person who certified the item
Configuration MatrixConfiguration M:1 Link to (matrix) configuration which applies to item
Controls EntityControl 1:M Link to child Controls
CurrentAudit Audit M:1 Link to the current Audit
Entity Entity M:1 Link to parent Entity
EntityObjectives EntityObjective 1:M Link to child Entity Objectives
Findings Finding 1:M Link to child Findings
Incidents Incident M:M Link to child Incidents
KeyIssues KeyIssue M:M Link to child key issues
LastAudit Audit M:1 Link to the last Audit
Notes Note 1:M Link to child Notes
Objectives Objective 1:M Link to child Objectives
Owner Person M:1 Person who owns the item which is used for permissions
Periods EntityProcessPeriod 1:M Link to child periods
PlanningRiskAssessments PlanningRiskAssessment 1:M Link to child planning Risk assessments
Problems Problem M:M Link to child problems
Process Process M:1 Link to parent Process
SOXAccounts SOXAccount M:M SOX Accounts to which the item relates
Tests EntityTest 1:M Link to child Tests