CandidateAudit
Name Data Type Size Comments
A placeholder for an Audit which may or may not take place
BudgetEffort decimal (18,2) Number of days the audit is budgeted to take (if not using Retain)
DepartmentNames string List of names of the related departments
Description richtext Standard unlimited rich text description
Description_Plain string Plain text equivilent of the corresponding rich text field
HasPlannedEndDateVariance boolean Indicates if the Planned End Date Variance is set
HasPlannedStartDateVariance boolean Indicates if the Planned Start Date Variance is set
Name string (555) Constructed from the Ref and Title
PlannedEffort decimal (18,2) Number of days the audit is planned to take (if not using Retain)
PlannedEndDate date (8) Date when the candidate audit is planned to end
PlannedEndDateVariance int32 Difference (in days) between the Planned End Date and the Planning Period Start Date
PlannedStartDate date (8) Date when the candidate audit is planned to start
PlannedStartDateVariance int32 Difference (in days) between the Planned Start Date and the Planning Period Start Date
Purpose richtext Unlimited rich text purpose
Purpose_Plain string Plain text equivilent of the corresponding rich text field
Ref string (50) Standard short reference
ScopeNames string List of entity/processes which are covered by the item scope
Title string (500) Standard short title
Audit Audit 1:1 Link to parent Audit
CandidateState CandidateState M:1 Whether the item is "candidate" or "confirmed"
Client Client M:1 Link to parent Client
Departments Department M:M Department to which the item is assigned (used for permissions)
Period AuditPeriod M:1 Link to parent period
PlannedEndDatePeriod PlannedDatePeriod M:1 Calculated segmentation based on planned end date
PlannedStartDatePeriod PlannedDatePeriod M:1 Calculated segmentation based on planned start date
PlanningPeriod PlanningPeriod M:1 Link to parent Planning Period
PriorAudit Audit 1:1 Link to the item from which this was "rolled forward"
Scope EntityProcessPeriod M:M Entity/Processes (i.e universe matrix) which are covered by the Audit
Type AuditType M:1 Simple segmentation