Student Information - Universe Folder

Student Information

Admission Status

This field identifies the application decision value associated with the application decision status.

Source: Health Banner Table: SARAPPD

Admission Status Code

This field identifies the application decision value associated with the application decision status code.

Source: Health Banner Table: SARAPPD

Citizenship

Description of Citizen Type Code

Source: Health Banner Table: STVCITZ

Citizenship Code

Person Citizen Type

Source: Health Banner Table: SPBPERS

Degree Status Current

Students degree code (BS, BA, etc.).

Source: Health Banner Table: SHRDGMR

Degree Status Code Current

Status of students degree, for example sought, awarded, etc.

Source: MDBanner Table: SHRDGMR

Ethnicity

This field specifies the ethnic group associated with the ethnic code.

Source: Health Banner Table: STVETHN

Ethnicity Code

This field identifies the ethnic code defined by the U.S. government. The valid values are 1 - Not Hispanic or Latino, 2 - Hispanic or Latino, or empty.

Source: Health Banner Table: SPBPERS

Gender

This field maintains the sex of person. Valid values are: M - Male, F - Female, N - Unknown.

Source: Health Banner Table: SPBPERS

Global Department Name

Student's Global Department Name

Source: MDM_CURR

Graduation Date Current

Graduation Date. Graduation date of student.

Source: Health Banner Table: SHRDGMR

Is Admitted

If Admission Status Code is 'AD', 'A', 'AS', or 'AW' then it will display 'Y' otherwise it will be 'N'. This field is known to have significant issues for some cohorts/matriculation terms.

Source: Health Banner Table: Derived

Latest Program Code

A latest student program code which represents a specific university program associated with the max effective term.

Source: Health Banner Table: SGBSTDN

Name - First

This field identifies the first name of the person.

Source: Health Banner Table: SPRIDEN

Name - Last

This field defines the last name of the person.

Source: Health Banner Table: SPRIDEN

Name - Last, First

Combination of the Name Last, Name First of the person.

Source: Health Banner Table: Derived

Name - Middle

This field identifies the middle name of the person.

Source: Health Banner Table: SPRIDEN

Name - Unique

Combined field of Name Last, Name First - U-Number

Source: Health Banner Table: Derived

Name Prefix

This field maintains the prefix (Mr, Mrs, etc) used before the person's name.

Source: Health Banner Table: SPBPERS

Name Suffix

This field maintains the suffix (Jr, Sr, etc) used after the person's name. 

Source: Health Banner Table: SPBPERS

Resident

This field specifies the residency status associated with the residency code.

Source: Health Banner Table: STVRESD

SPRIDEN ID

This field defines the identification number used to access a person in Health Banner.  WARNING: There are some historical situations where this may contain an SSN, though normally it is a generated ID or a USF U-Number.

Source: MDBanner Table: SPRIDEN

Student Attribute Code Current

Attribute assigned to the student, currently it is used to determine the different Curriculum Programs of SLCT and CORE. Previously it was also used to determine which year of coursework a student was taking.

Source: Health Banner Table: SGRCHRT

Student Attribute Current

Description of Student Attribute Code assigned to the student. Currently it is used to determine the different Curriculum Programs of Select and Core. Previously it was also used to determine which year of coursework a student was taking.

Source: Health Banner Table: STVATTS

Student Status Code

Code for student's current status; AS = Active, IG = Inactive-Graduated, IS = Inactive, UNKN = Unknown

Student Status Description

Description of student's current status: Active, Inactive, Inactive-Graduated, Unknown

Resident Code

This field identifies the residency classification of the applicant.

Source: Health Banner Table: SARADAP

UNumber

U-number for the student to uniquely identify them from other students.

Source: Health Banner Table: SPRIDEN

Record Refresh Date

Date when data was last updated.