Attachment 2.1

GeorgiaStateUniversity

Expenditure Review Training

Speedtype by OwnerQueryInstructions

Updated: February 15, 2011

Purpose: Primarily used to identify all speedtypes within a particular college, department, or center (i.e., unit). (Speedtypes correspond to chart blocks, which uniquely identify units or sponsored projects on Spectrum for budgetary purposes. Non-project Speedtypes consist of four or five alpha/alpha-numeric digits; Project Speedtypes consist of ten alpha-numeric digits; and were created for convenience so Spectrum users would not have to remember the longer chart block.)

Description:

  • A Spectrum query of speedtypes by department.
  • Provides the name of the Principal Investigator responsible for each sponsored project.
  • All fund types, except Agency Funds (fund code 60000), are included.

Access instructions:

After logging onto Spectrum, access the Speedtype by Owner Query as follows:

1.Navigation: Reporting Tools QueryQuery Viewer

2.In the text box next to “Search By: Query Name”, type in “GSU_SPEEDTYPE_DEPT” and press the Search button

3.In the “Dept” field, type in the 9 digit department number and press the View Results button.

  • “Dept” field - enter a portion of the unit’s nine digit department numberdepending on the scope of your search and press the Look Up icon (magnifying glass). For example, enter:

11to access all speedtypes within College of Arts and Sciences;

1132to limit the 11 speedtypes to those within the Department of Psychology; and

11324 to limit the 1132 speedtypes to the Center for Brain Science.

Or enter the entire 9 digit department number 113240000

 If you know the Speedtype, but do not know the department number, use the Query, “GSU_SPEEDTYPE” to find the chartfield values associated with a SpeedType.

In the “SpeedType Key”, enter your SpeedType Key. Enter the % sign in all of the remaining fields (Account, Department, Fund Code, etc.)

Press “View Results” button.

4.To view query results, click on

HTML link(view results in a HTML webpage)

Excel link (view results in Excel spreadsheet)

5.The next screen displays the query resultswhich are all SpeedTypes applicable to the department. Listed below are the chartfield values the query displays.

SpeedType

Description

Account

Fund

DeptID

Program

Class

Budget Reference

Project

Project Manager

1