.
 

Enterprise Systems

 

Globe and planet

     

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