USF Pass/Fail Grade Request Report

This report displays students who have requested a Pass/Fail grade for courses. 




General Filters (left panel)

How to use the General Filters:

  • To select a filter value, click on the filter's drop down arrow, then select the value. The values in the report table will update to show the results associated with that value.
  • To select multiple values, click on a value, hold down the Ctrl key, and then select the other value(s).
  • To remove a filter, either deselect the values in the drop down list.


Attribute Filters

How to use the Attribute Filters:

  • To select a filter row, click one of the filter rows. The rows in the table will change to display only the rows that meet the selected filter(s). 
  • To deselect a filter row, click on the filter row(s) you've already selected. The rows in the table will change to no longer display rows associated with that filter(s).
  • To select multiple filter rows, hold down the Ctrl key, and then select the filter rows you want. The rows in the table will change to display only rows that meet the filters selected. 



Unique Pass/Fail Student Count

The graphic displays the unique count of students, not the count of records, since a student can have more than one record.




Unique Count of Students by Campus/College Name

This pie chart graphic displays the unique count of students by campus. It does not display a count of records by campus, since a student can have more than one record per campus. To view the unique count of students by campus and college, click on the arrow pointing downward at the top of the graphic. The pie chart will change to display a drill-down by college for that campus.



Report Column Sources

The sources used to population the fields in the report are derived from OASIS Banner (Database: PROD, Schema: SATURN) and MD Banner (Database: MPROD, Schema: SATURN). 


Report Column Name

Description

Source
RescindsThis field indicate the request has been rescinded. (Y/N)[PROD_RO].[eai.grade_conversion_requests]
Manual EntryThis field indicate the record was manually entered. (Y/N)[PROD_RO].[eai.grade_conversion_requests]

U Number

This field holds the student's University Id.SPRIDEN.SPRIDEN_ID

Last Name

This field holds the student's last name.SPRIDEN.SPRIDEN_LAST_NAME

First Name

This field holds the student's first name.SPRIDEN.SPRIDEN_FIRST_NAME

Health Banner

This field identifies that the student is a health student.appiandb.SSM_gradeConversionRequest.dateSubmitted.IsHealth

Email

This field holds the student's email address.GOREMAL.GOREMAL_EMAIL_ADDRESS where GOREMAL.GOREMAL_STATUS_IND = 'A' and GOREMAL.GOREMAL_EMAL_CODE = 'USF'

Phone

This field holds the student's phone number associated with the mailing address (i.e. sprtele_atype_code = 'ML').SPRTELE.SPRTELE_PHONE_NUMBER

Campus

This field holds the student's campus associated with the effective term.

Campus code: SGBSTDN.SGBSTDN_CAMP_CODE

Campus desc: STVCAMP.STVCAMP_DESC

College

This field holds identifies the student's college, which is associated with the primary curriculum for the effective term. The description of the code is displayed.

College code: SGBSTDN.SGBSTDN_COLL_CODE_1

College desc: STVCOLL.STVCOLL_DESC

Student LevelThis field holds the student's academic level for the effective term (e.g. Undergraduate).

Level code: SGBSTDN.SGBSTDN_LEVL_CODE

Level desc: STVLEVL.STVLEVL_DESC

Degree

This field holds the student's degree within the primary curriculum for the effective term. If the student has not declared a degree the value will be 'Undeclared'.

Degree code: SGBSTDN.SGBSTDN_DEGC_CODE_1

Degree desc: STVDEGC.STVDEGC_DESC

Major

This field holds the student's primary major within the primary curriculum for the effective term.

Degree code: SGBSTDN.SGBSTDN_MAJR_CODE_1

Degree desc: STVMAJR.STVMAJR_DESC

Program

This field holds the student's program code associated with the primary curriculum.SGBSTDN.SGBSTDN_PROGRAM_1
ConcentrationThis field identifies the primary concentration within the primary curriculum for the effective term.SGBSTDN.SGBSTDN_MAJR_CODE_CONC_1

Subject Code

This field holds the subject code of the course-section.SSBSECT.SSBSECT_SUBJ_CODE

Course Number

This field holds the number of the course-section.SSBSECT.SSBSECT_CRSE_NUMB

Section Number

This field holds the section number.SSBSECT.SSBSECT_SEQ_NUMB

Course Title

This field holds the course-section title.SSBSECT.SSBSECT_TITLE

Requested Date

This field holds the date the request was submitted.Date from appiandb.SSM_gradeConversionRequest.dateSubmitted
Requested TimeThis field holds the time of day this request was submitted

Time from appiandb.SSM_gradeConversionRequest.dateSubmitted


IT Analytics, SVC4010, Contact Us