Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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


Data Analytics & Reporting Team (DART)IT Analytics, SVC4010, Contact Us