...
The sources used to population the fields in the report are derived from OASIS Banner (Database: PROD, Schema: SATURN), MD Banner (Database: MPROD, Schema: SATURN), and Appian.
| Report Column Name | Description | Source |
|---|---|---|
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 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 Level | This 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 |
| Concentration | This 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 DateTime |
...