Search | Directories | Reference Tools
UW Home > Admin Systems > Systems on Keynes > SDB 

man working
Online Guides--    [ FIN ] [ PAS ] [ SDB ]
[Systems Operating Hours]
[Administrative Systems Status]


Getting Access to
Online Systems

Access Forms and Instructions

Communications Software

Signing On


System Hours




Transcript Information

University of Washington Course Records

The Student Data Base System contains two types of inquiries into the University of Washington regular course records:

  1. Standard Transcript Inquiry
  2. A quarter-by-quarter summary and listing (Academic Summary)

In addition, you may view:

  1. courses taken in the University's Extension program, independent studies, and credits by examination
  2. Courses accepted for transfer credit from other institutions
  3. Degrees and Certificates
  4. Pending changes in a student's class or major on the Future Control Field Inquiry

Transcript Inquiry System

To access the Transcript Inquiry System:

The menu screen will appear.

To access a student not retained from a previous screen:
"student number"

If the student is not otherwise available to you:
"PAC number" ­ (with leading zeroes to make six digits) in Access Key field


Action Codes

There are four main action in the Transcript Inquiry System:

(Action 1)

Online documentation is available throughout the Transcript Inquiry System. You may specify general information, or by typing a keyword in the Help With Selection Field, you may request detailed instruction on the use of particular commands. Typing a (1) in the Action Box will display HELP.

(Action 2)

The screen on page 41 is the Standard Menu. It shows the standard selections. Typing a (2) in the Action Box will display this menu.

(Action 3)

The Custom Menu is a display of the selection codes in the Transcript Inquiry System. Typing a (3) in the Action Box will display this menu.

(Action 4)

Creates a report based upon the Selection which you have chosen. Inquiries are activated by typing a (4) in the Action Box.

All of the above actions are available from any of the screens of the Transcript Inquiry System; you may get Help from an Inquiry screen, or build a custom selection from the Standard Selection Menu, for example,


To choose general help:
[Shift] + [Tab]

A help screen consists of two parts; the "help" itself, and a control area which retains the selection, the student, and the action. Separating these two parts is a line of reversed (dark on bright) display which will give you directions and show you the status of your help request. On the screen above, you are informed that there is more information available on this topic.


The Standard Menu is divided into selections for the current year and for the entire transcript. "All" will display all courses within the year or for the entire transcript. "Students Major Dept" will produce a listing of courses taken within the student's department of declared major. Be aware that this selection will look only at the department of the major; a major in CLASSICS will only show classes with the department CLAS. Greek and Latin classes will not be displayed. Likewise, the definition of your "department" may include more or less than your group of majors. You may contact Hugh Parker at hughp@u to have this adjusted. The major college and your college include all courses taken in either the college of the student's currently declared first major or in the college of your department.

To use the Standard Selections:
"standard selection number" ­ in the selection field
"4" ­ in the action box

Screen Layout

All transcript reporting screens, whether you use Standard Menu Selections or create your own selection through the Custom Selection process, are divided into five major sections. Using the screen above as an example, these sections are:

  1. Transcript Title
    Description of the inquiry. This will be "Entire Transcript," "Current Year," or "Custom Selection." In this case, the title is

  2. Student Identification and Cumulative Summary
    The student's student number, social security number, name, and birthdate are displayed.

    Under this is a line identifying the student's current information:



Graduate School






Grade Point Average



Earned Credits



Credits earned at the University



Transfer credits allowed



Extension credits allowed

  1. Transcript Data
    Two main columns, made up of five secondary columns make up the transcript data:


Quarter and year


Department abbreviation and course number


Short form of the course description


Credits attempted


Numerical grade earned

  1. Selection Summary
    This transcript summary reflects the selection which you have made, rather than the cumulative summary in the upper portion of the screen. Within this selection are shown:


Grade Points earned


Grade Point Average


Credits Earned


Graded credits attempted


Nongraded credits attempted

  1. Control Area
    The control area shows you information from the computer in the block of reverse video, in this case, "PRESS SEND FOR MORE INFORMATION." The selection that you have made has been expanded from "9" to its "Custom Menu" form, ALL.CCO=C., and the student number is sown next to the Action Box.


There are times when the standard selections do not give you the selection or inclusiveness that you require for a transcript. The Custom Selection Menu provides help for constructing these more specific queries.

To access the custom menu
"4" ­ in the action box

Each of the Custom Selection Codes has its own meaning and "syntax" or usage. This usage, or "syntax" as it is called on the help screens, varies with the selection code, and is summarized in the Appendix to this document. As with the Standard Inquiry, there is on-line help available. Each Selection Code has its own help screen which provides detailed documentation and examples

To get help on a Custom Selection Code:
[Tab] to the Help with Selection field
"custom selection code"
[Tab to the Action Box

In a Custom Selection Help


The Selection abbreviation or "keyword" is first defined. In this case, DCR is defined as "Courses selected by Department and Course Number range."


Following the definition is a statement of the syntax or usage of the keyword. The expression following the keyword may contain one or more "parameters" or specifications of the keyword. For DCR, you are required to specify a department by its time schedule abbreviation and a course range (DCR=DEPTA nnn-mmm). You may specify up to five course ranges. These must be separated by a comma and the last one of these must end with a period (DEPTB nnn-mmm.).


An explanation of the Selection is given ("Use this selection to select a range of courses from specified departments.").


Any particular limits are listed ("You may enter up to 12 ranges.").


An example is provided and explained.

The codes used in the Custom Selection Inquiries, except where otherwise noted, are the standard codes issued by the Registrar's Office and found in the University Catalog and the quarterly Time Schedule.

Note: you may build your custom selection at the help screen by typing the information in the Selection Field.

Creating a Custom Selection

Simple Selection Expressions:
Custom selections are built of one or more custom selection expressions. Each custom selection expression is composed of a single keyword, a comparison sign, if required, and parameters, as required. A selection expression for courses in the Colleges of Engineering and Arts and Sciences would be:

CCO = C, J.

The components of this selection request are:


Keyword, "Courses in the College Of"


Comparison sign


Parameter, College of Arts & Sciences


Separated by a comma, indicating selection will be the preceding parameter OR the following one


Parameter, College of Engineering


Ended with a period, indicating no more selections.

Spaces do not matter in a Custom Selection, except in department abbreviations. If the time schedule states that Electrical Engineering is abbreviated as E_E (the character _ indicates a blank or a space), then you must key in E_E. EE or E__E will not be recognized by the system.

Multiple Selection Expressions:
Custom Selection Expressions are combined into Custom Selections by appending Selection Expressions to the selection list, separating each selection expression by a period. A selection to display all courses in the colleges of Engineering and Arts and Sciences that are incomplete would be:

CCO = C, J. CRS = I.


Custom selection expression


Separated by a period, indicating selection will be the preceding parameter AND the following one


Custom selection expression


Ended with a period, indicating no more selections.

As noted above, more than one parameter may be combined in a single selection expression. For example, you might need to look at Education courses from course number 400 to course number 799, and Educational Psychology courses in the graduate stream (courses above 500). Both of these can be combined into a single selection expression:

DCR=EDUC 400-799, EDPSY 500-799.

This selection will show all the courses that are either Education 400-799 or Educational Psychology 500-799.

A selection that combines multiple selection expressions will display only those courses which meet all of the criteria specified. Within a selection code, a course must meet any of the criteria specified. Thus


will show courses that are in the departments of PHYSics, MATH, or PSYCHology, taken while an EDUCation major, which are Writing or Incomplete courses, taken in the CURrent academic year.

Another way of thinking about a multiple selection expression is to imagine it as a series of funnels or filters; only those courses which "fit through" the selection criteria make it to the following funnels or filters. Only those courses which pass through all of the funnels or filters will be printed:

Is the department MATH, PHYSics, or PSYCHology?

If "yes" continue,
if "no," quit.

Is the student an EDUCation major?

If "yes" continue,
if "no," quit.

Are the courses Writing courses or Incomplete?

If "yes" continue,
if "no," quit.

Were the courses taken in the current year?

If "yes" continue,
if "no," quit.

Display the transcript.

Although this student might have courses that are Physics, Math, or Psychology or courses taken as an Education major, and some courses which were writing or incomplete, or courses which were taken in the current year, there may be no courses that meet all of the above criteria.

To request a custom transcript:
[Tab] to action box

This Custom Selection transcript is a request for Christopher Dannon's History courses from course 500 to course number 699. The transcript is displayed in reversed quarter order, from the most recent quarter to the earliest quarter. Note the indication of graduation:

******* DEGREE EARNED SU93 *********

To redisplay a transcript from the beginning of the inquiry:
[5] ­ in Action Box

Printing a Transcript

To request a transcript be printed on the printer attached to your terminal:
PRT ­ in Selection: field

Academic Summary

The Student Academic summary and its associated Transcript Inquiry provide quarter-oriented views into the student's academic transcript. These two screens are best used when you want a quick look at one quarter's work or a general summary of the entire program.

To access the Student Academic Summary:

You can either transfer a student's information or select the student by entering one of the student keys.

The Student Academic Summary contains:

  1. High school (and high school number) from which the student graduated. This may not always be included for graduate students who did not take their first degree at the University
  2. Prior Summary. Summaries are provided for prior study at the University for those students who were not active in Winter of 1983 but have since returned to the University. The Prior Summary also includes any transfer or extension classes accepted for credit.
  3. Cumulative GPA and Cumulative Credits reference the credits and grade points earned toward the current degree.
  4. Starting Quarter. If this field is not blank, there is additional information. The values in this field may be changed to start the display at any particular quarter, but note that the field requires the full name, and not the abbreviation, of the quarter.

    You may place an "X" in any one of the spaces in the Action column (ACTN) to select the transcript for any individual quarter on record. The CU GPA column contains the cumulative GPA for the student's program, and the GPA column contains the quarterly GPA. Scholarship (SCHOL) indicates whether the student is on scholarship advisory or commendation. An asterisk (*) next to the Scholarship column heading (SCHOL*) indicates that there is a scholarship recalculation pending.

Quarter Inquiry

To specify an individual quarter for inspection from SRF310:
"X" ­ in the action (ACTN) column

To specify an individual quarter for inspection from elsewhere in the Student System:

An introductory screen will be displayed.

To access the Transcript Quarter information:
"student number" ­ if not transferred from previous screen
"quarter abbreviation and year"

Transcript Inquiry displays one quarter's academic activity.

The first pair of lines under the student information references the quarter under examination

  1. On the third line, the Quarter and Year fields may be changed to explore other quarters' transcripts.
    The scholarship status for this quarter is displayed at the end of this line. (NONE)
  2. "(QTR IN CUM)" informs you that the quarter selected is part of the student's current academic program. Were this a quarter in a previous degree program, "(QTR NOT IN CUM)" would have been displayed.
  3. The major (MAJ:) is the one declared in the quarter in question.

The second pair of lines reflects the student's current status; the fields displayed reflect the current (or last):

  1. Cumulative Credits (CUM CREDITS)
  2. Grade Point Average (GPA)
  3. Major (MAJ)

Other Topics in this Guide:

Doing UW Administrative Work Online Guides--    [ FIN ] [ PAS ] [ SDB ]
[ SDB-older content ]