...
The sources used to population the fields in the report are derived from OASIS Banner (Database: PROD, Schema: SATURN), MD Banner (MPROD), and Appian.
...
Report Column Name | Description | Source |
---|---|---|
U Number | This field holds the student's University Id. | SATURN.SPRIDEN.SPRIDEN_ID@PRODID |
Last Name | This field holds the student's last name. | SATURN.SPRIDEN.SPRIDEN_LAST_NAME@PROD |
First Name | This field holds the student's first name. | SATURN.SPRIDEN.SPRIDEN_FIRST_NAME@PROD |
Health Banner | ||
This field holds the student's email address. | SATURN.GOREMAL.GOREMAL_EMAIL_ADDRESS@PROD | |
Phone | This field holds the student's phone number associated with the mailing address (i.e. sprtele_atype_code = 'ML'). | SATURN.SPRTELE_PHONE_NUMBER@PROD |
Campus | This field holds the student's campus associated with the effective term. | SATURN.SGBSTDN.SGBSTDN_CAMP_CODE@PROD |
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: SATURN. SGBSTDN.SGBSTDN_COLL_CODE_1@PROD College desc: SATURN. STVCOLL.STVCOLL_DESC@PRODDESC |
Student Level | This field holds the student's academic level for the effective term (e.g. Undergraduate). | Level code: SATURN. SGBSTDN.SGBSTDN_LEVL_CODE@PROD Level desc: SATURN. STVLEVL.STVLEVL_DESC@PRODDESC |
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'. | SATURN. Degree code: SGBSTDN.SGBSTDN_DEGC_CODE_1 @PRODDegree desc: STVDEGC.STVDEGC_DESC |
Major | This field holds the student's primary major within the primary curriculum for the effective term. | SATURN. Degree code: SGBSTDN.SGBSTDN_MAJR_CODE_1 @PRODDegree desc: STVMAJR.STVMAJR_DESC |
Program | This field holds the student's program code associated with the primary curriculum. | SATURN.SGBSTDN.SGBSTDN_PROGRAM_1@PROD |
Concentration | This field identifies the primary concentration within the primary curriculum for the effective term. | SATURN.SGBSTDN.SGBSTDN_MAJR_CODE_CONC_1@PROD |
Subject Code | This field holds the subject code of the course-section. | SATURN.SSBSECT.SSBSECT_SUBJ_CODE@PROD |
Course Number | This field holds the number of the course-section. | SATURN.SSBSECT.SSBSECT_CRSE_NUMB@PROD |
Section Number | This field holds the section number. | SATURN.SSBSECT.SSBSECT_SEQ_NUMB@PROD |
Course Title | This field holds the course-section title. | SATURN.SSBSECT.SSBSECT_TITLE@PROD |
Requested DateTime |
...