Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 24 Next »

Universe Description

This universe contains information related to student and course grades.  Grades are provided for each student per course.


Universe Objects

Course Information

Course Number

Course number associated with the subject for the course - usually 4 numbers and sometimes a 5th character.

Source: Health Banner Table:SCBSRSE

Course Title Current

Most recent course name for selected course.

Source: Health Banner Table: SCBCRSE

Related Course Number

Related course number is derived from the course number. It is the first 4 characters of the course number.

Source: Health Banner Table: Derived

Subject

Main instructional subject area for this course

Source: Health Banner Table: STVSUBJ

Error rendering macro 'excerpt-include' : No link could be created for 'EduDW Subject Course Code'.

Record Refresh Date

Date when data was last updated.

Part of Term Information

Part of Term Code

This field identifies the Part of Term Code for the Term. 

Source: Health Banner Table: SOBPTRM

Part of Term Description

This field identifies the description of Part of Term Code for the Term. 

Source: Health Banner Tables: SOBPTRM

Part of Term End Date

Date part of term ends.

Source: Health Banner Tables: SOBPTRM.

Part of Term Start Date

Date part of term start.

Source: Health Banner Tables: SOBPTRM.

Part of Term Weeks

Part of Term Weeks duration in weeks.

Source: Health Banner Tables: SOBPTRM.

Record Refresh Date

Date when data was last updated.

Term

This field identifies the term referenced in the Catalog.

Source: Health Banner Table: STVTERM

Term Code

This field identifies the term code referenced in the Catalog, Recruiting, Admissions, Gen. Student, Registration.

Source: Health Banner Table: STVTERM

Term End Date

This field identifies the term end date and is fomatted DD-MON-YY.

Source: Health Banner Table: STVTERM

Term Start Date

This field identifies the term start date and is formatted DD-MON-YY.

Source: Health Banner Table: STVTERM

Program Information

 

Campus

The campus description associated with the campus code for the degree program.

Source: Health Banner Table: STVCAMP

Campus Code

Campus code for the degree program.

Source Health Banner Table: SMRPRLE

College

The description associated to the college code. This is Banner's highest administrative unit.

Source: Health Banner Table: STVCOLL

College Code

The code for the college or school offering the degree program. Referenced in the Catalog, Class Schedule, Recruiting, Admissions, General Student, Registration, Academic History and Degree Audit Modules.

Source: Health Banner Table: STVCOLL

Degree

The description (e.g. Bachelor of Business Administration, Master of Arts, Juris Doctor, etc.) of the associated degree code.

Source: Health Banner Table: STVDEGC

Degree Code

The degree code of the degree the student is pursuing or has obtained at USF Health. Referenced in the Recruiting, Admissions, Gen. Student, Registration, Academic History and Degree Audit Modules.

Source: Health Banner Table: STVDEGC

Major

The description associated with the major code.

Source: Health Banner Table: STVMAJR

Major Code

Identifies the major code of the student. Referenced in the Catalog, Class Schedule, Recruiting, Admissions, General Student, Registration, and Academic History Modules.

Source: Health Banner Table: STVMAJR

Level Code

Identifies the level code of the degree program. Referenced in the Catalog, Recruiting, Admissions, General Student, Registration, and Academic History Modules.

Source: Health Banner Table: SMRPRLE

Level Course

This field specifies the student level (e.g. undergraduate, graduate, professional) associated with the student level code.

Source: Health Banner Table: STVLEVL

Level Student

The description (e.g. undergraduate, graduate, professional) associated with the student level code.

Source: Health Banner Table: STVLEVL

Level Student Code

Identifies the student level code of the degree program. Referenced in the Catalog, Recruiting, Admissions, General Student, Registration, and Academic History Modules.

Source: Health Banner Table: STVLEVL

Record Refresh Date

Date when data was last updated.

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 Code

The degree code of the degree the student is pursuing or has obtained at USF Health. Referenced in the Recruiting, Admissions, Gen. Student, Registration, Academic History and Degree Audit Modules.

Source: Health Banner Table: STVDEGC

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

Graduation Cohort Current

Full description of Cohort Code when a student is currently expected to graduate or has graduated.

Source: Health Banner Table: STVCHRT

Graduation Cohort Code Current

Code denoting the year when a student is currently expected to graduate or has graduated.

Source: Health Banner Table: SGRCHRT

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

Error rendering macro 'excerpt-include' : No link could be created for 'EduDW Matriculation Termcode Current'.

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 - Middle

This field identifies the middle name of the person.

Source: Health Banner Table: SPRIDEN

Error rendering macro 'excerpt-include' : No link could be created for 'EduDW Name First Name Scrubbed'.

Error rendering macro 'excerpt-include' : No link could be created for 'EduDW Name Last Name Scrubbed'.

Error rendering macro 'excerpt-include' : No link could be created for 'EduDW Name Middle Name Scrubbed'.

Error rendering macro 'excerpt-include' : No link could be created for 'EduDW Name - Prefix'.

Error rendering macro 'excerpt-include' : No link could be created for 'EduDW Name - Suffix'.

PDIM

This field identifies the internal identification number of the applicant.

Source: MDBanner Table: SPRIDEN

Record Refresh Date

Date when data was last updated.

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

Visa Nation Code Issue

This field specifies the nation code for the issued Visa.

Source: Health Banner Table: GORVISA

Visa Nation Issue

This field specifies the nation/country associated with the nation code.

Source: Health Banner Table: GORVISA

Visa Type

This field specifies the visa type (e.g. student visa, resident alien, exchange scholar) associated with the visa type code.

Source: Health Banner Table: STVVTYP

Visa Type Code

This field identifies the visa type code referenced on the International Information Form (GOAINTL).

Source: Health Banner Table: STVVTYP

Course Grade Information

Credit Hours

Institutional Course Credit Hours. Credit hours associated with grade of the course.

Source: Health Banner Table: SHRTCKG

Contact Hours

Institutional Course Credit Hours. Credit hours associated with grade of the course.

Source: Health Banner Table: SHRTCKG

Course Grade Abbrev Final

Grade Code Abbreviation.

Source: Health Banner Table: SHRGRDE

Course Grade Change

This field specifies the reason for grade change associated with the grade change reason code.

Source: Health Banner Table: STCGCHG

Course Grade Code Final

Institutional Course Final Grade Code. Grade code associated with the course.

Source: Health Banner Table: SHRTCKG

Course Seq No

Institutional Course Sequence Number. Internal sequence number of the course associated with the grade.

Source: Health Banner Table: SHRTCKG

Grade Seq No

Institutional Course Grade Sequence Number. Sequence number of the grade for the course with highest sequence number being most recent grade.

Source: Health Banner Table: SHRTCKG

Record Refresh Date

Date when data was last updated.

Schedule Type

This field defines the schedule type codes which can be authorized for a course. Each course must be authorized to be offered for at least one schedule type. An unlimited number of schedule types can be authorized for a course.

Source: Health Banner Table: SCRSCHD

Disclaimer

This universe only displays values as they were in USF Health Banner at the last refresh date. Those values are subject to change over time. Unauthorized use of this universe is prohibited. If you log on to this computer system, you acknowledge your awareness of and concurrence with the University of South Florida policies. The University will prosecute violators to the full extent of the law.

  • No labels