auditPlanID | key | no | Unique reference number assigned by the system to an audit plan record. | AUDIT_PLAN_ID | | SVR_INT64 |
auditPlanReference | details | | A unique ID for an audit plan. The auditPlanReference exists so that a meaningful ID can be displayed to a user for each audit plan. | AUDIT_PLAN_REF | | SVR_STRING<40> |
auditPlanStatus | details | | The status of an audit plan. The status will change through the lifecycle of the audit plan. For example, when an audit plan is first created, its status is 'pending', but once auditors are assigned to work on it, it becomes 'in progress'. | AUDIT_PLAN_STATUS | AuditPlanStatus | SVR_STRING<10> |
recordStatus | details | | The record status is used to indicate if the audit plan has been logically deleted. | RECORD_STATUS | RecordStatus | SVR_STRING<10> |
createdDate | details | | The date the audit plan was created. | CURAM_DATE | | SVR_DATE |
createdBy | details | | The user who created the audit plan. | USER_NAME | | SVR_STRING<64> |
coordinator | details | | The user who is the coordinator of this audit plan. | USER_NAME | | SVR_STRING<64> |
purpose | details | | The purpose of or type of audit. | AUDIT_PLAN_PURPOSE | AuditPlanPurpose | SVR_STRING<10> |
priority | details | | Indicates the importance of the audit plan. | AUDIT_PLAN_PRIORITY | AuditPlanPriority | SVR_STRING<10> |
userAccess | details | | Indicates what a case owner and supervisor can view in relation to a case audit.
If View Findings and Provide Feedback is selected, the caseworker and supervisor will be notified when the audit is complete and that feedback is required. They will be allowed to view the findings and enter feedback.
If View Findings Only is selected, the caseworker and supervisor will be notified when the audit is complete, and will be allowed to view the findings (however they will not be allowed to add feedback).
If No Access to Audit Information is selected, the caseworker and supervisor will not be able to view the findings or provide feedback.
| AUDIT_PLAN_USER_ACCESS | AuditPlanUserAccess | SVR_STRING<10> |
percentageCases | details | | The percentage of cases to be audited, specified by the audit coordinator, to be used in the case selection algorithm employed by the agency.
If the auditor selected a number of cases, the system populates this field with the percentage of cases matching the specified number.
| AUDIT_PLAN_PERCENTAGE_CASES | | SVR_DOUBLE |
numberCases | details | | The number of cases to be audited, specified by the audit coordinator, to be used in the case selection algorithm employed by the agency.
If the auditor selected a percentage of cases, the system populates this field with the number of cases matching the specified percentage.
| AUDIT_PLAN_NUMBER_CASES | | SVR_INT32 |
scheduledStartDate | details | | The date the audit is scheduled to commence. | CURAM_DATE | | SVR_DATE |
scheduledEndDate | details | | The date the audit is scheduled to end. | CURAM_DATE | | SVR_DATE |
| details | | Scheduling notations entered by the user regarding time frames, locations for interviews, expected audit time frames. | COMMENTS | | SVR_STRING<300> |
casesUserSelected | details | | Indicates if the user has selected specific cases to audit rather than letting the system produce a random sample based on selection criteria. | CURAM_INDICATOR | | SVR_BOOLEAN |
| details | | Comments recorded by a user relating to the audit plan. This enables the user to give a brief description about why the audit plan is needed or any additional information which is required. | COMMENTS | | SVR_STRING<300> |
auditCaseConfigID | details | | Identifier of the Audit Case Configuration associated with this Audit Plan | AUDIT_CASE_CONFIG_ID | | SVR_INT64 |
findingsText | details | | Overall summary findings text added by the coordinator. | RICH_TEXT_DATA | | SVR_STRING<10000> |
selectionQueryID | details | | The selection query used to generate the case sample. | SELECTION_QUERY_ID | | SVR_INT64 |