Audit Project Tracking System
The Audit Project Tracking System provides the Office of Internal Auditing a means for tracking projects and related issues, tracking staff time, and reporting.
Auditor Inquiry
As part of the Audit Project Tracking System, an Auditor or Project Administrator can view Projects and Issues by selecting from the various drop down boxes.
The selections will vary depending upon the Type selection of Project or Issue.
When Project is selected then the following fields are available for selection: Fiscal Year, Project Status, Work Type, and Assigned To.
When Issue is selected then the following fields are available for selection: Fiscal Year, Issue Status, Risk Rating, and Assigned To.
Only the Project Administrator has the Assigned To selection.
For Projects the following fields are displayed: Project Number, Fiscal Year, Work Type, Status, Name, Budgeted Hours, Actual Hours (from Timesheets), and Variance ((actual hours – budgeted hours)/budgeted hours)*100) .
For Issues the following fields are displayed: Project Number, Name, Issue Number, Description, Status, Rating, Target Resolution Date, and Age (system date minus target resolution date; if system date is before target resolution date then the age is displayed in GREEN; if system date is after target resolution date then the age is displayed in RED).
Intended Audience/Users: Project Administrator and Auditors
Auditor Worklist
As part of the Audit Project Tracking System, an Auditor can view active Projects and Issues assigned to them.
For Projects the following fields are displayed: Project Number, Fiscal Year, Work Type, Status, Name, Budgeted Hours, Actual Hours (from Timesheets), and Variance ((actual hours – budgeted hours)/budgeted hours)*100).
For Issues the following fields are displayed: Project Number, Name, Issue Number, Description, Status, Rating, Target Resolution Date, and Age (system date minus target resolution date; if system date is before target resolution date then the age is displayed in GREEN; if system date is after target resolution date then the age is displayed in RED).
Intended Audience/Users: Auditors
Budget Allocation Maintenance
As part of the Audit Project Tracking System, the Project Administrator will establish hours budgeted by fiscal year and work type. This information will be used for reporting budgeted to actual.
Intended Audience/Users: Project Administrator
Control Table Maintenance
As part of the Audit Project Tracking System, there are a number of data elements that are used throughout the system and need to be defined. The various data elements are listed in the Field Name drop-down box. As each different value is selected, there are different fields that must be entered (see table below).
Field Name
|
Available Fields
|
Category
|
Code, Description, Priority, Active
|
Disposition
|
Code, Description, Priority, Active, Report
|
Issue Status
|
Code, Description, Priority, Active, Maintenance, Color, Report
|
Project Status
|
Code, Description, Priority, Active, Maintenance, Timesheet, Color
|
Risk Area
|
Code, Description, Priority, Active
|
Risk Rating
|
Code, Description, Priority, Active, Color
|
Subcategory
|
Code, Description, Priority, Active, Category
|
Work Code
|
Code, Description, Priority, Active
|
Work Type
|
Code, Description, Priority, Active, Non-Project, Direct
|
Intended Audience/Users: Project Administrator
Employee Inquiry
As part of the Audit Project Tracking System, an Assigned Employee can view Issues by selecting from the various drop-down boxes.
The following fields are available for selection: Fiscal Year, Issue Status, and Risk Rating.
The following fields are displayed: Project Number, Issue Number, Status, Description, Issue Rating, Date Opened, Target Resolution Date, and Days til Due/Past Due (system date minus target resolution date; if system date is before target resolution date then the Days til Due/Past Due is displayed in GREEN; if system date is after target resolution date then the Days til Due/Past Due is displayed in RED).
Intended Audience/Users: Employees assigned to Issues
Employee Worklist
As part of the Audit Project Tracking System, an Assigned Employee can view active Issues assigned to them.
The following fields are displayed: Project Number, Name, Issue Number, Description, Status, Rating, Target Resolution Date, and Age (system date minus target resolution date; if system date is before target resolution date then the age is displayed in GREEN; if system date is after target resolution date then the age is displayed in RED).
Intended Audience/Users: Employees assigned to Issues
Global Table Maintenance
As part of the Audit Project Tracking System, there are a number of global data elements that are used throughout the system and need to be defined. Audit Team Members with Control Screen access will be able to enter and update values.
Intended Audience/Users: Audit Team Members with Control Screen access
Project Maintenance
As part of the Audit Project Tracking System, this screen is used to define Projects.
Intended Audience/Users: Auditors
Timesheet
As part of the Audit Project Tracking System, Audit staff will enter time associated to projects.
Intended Audience/Users: Project Administrator and Auditors
