Versions Compared

Key

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

...

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

 

Report Column Name

Description

Source

U Number

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

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



Email

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@PROD

Student LevelThis 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@PROD

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.SGBSTDN.SGBSTDN_DEGC_CODE_1@PROD

Major

This field holds the student's primary major within the primary curriculum for the effective term.SATURN.SGBSTDN.SGBSTDN_MAJR_CODE_1@PROD

Program

This field holds the student's program code associated with the primary curriculum.SATURN.SGBSTDN.SGBSTDN_PROGRAM_1@PROD
ConcentrationThis 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



 

 

 

 

 

 

 

...