All Students Object

The Students objects contain student data. These objects contain one record per term or semester included in the Student Data Warehouse for every student with any enrollment activity in that term or semester.

---

Warehouse ID

Warehouse identification code. A unique identifying value for all persons in the Student Data Warehouse. Used for COUNT and DISTINCT queries.

Data Type: Number

Example: 123456

Source: derived

Term

Code representing enrollment term. Format YYYYTT, where YYYY = the first year of the academic year pair (e.g. 1993 for the 1993-1994 academic year) and TT = term or semester, 01=Fall, 02=Winter, 03=Spring, 04= Summer, 05 = Fall Semester, 06 = Spring Semester and 07 = Summer Semester.

Data Type: 6 Characters

Example: 199501

Source: sfbetrm_term_code

Val Table: Term

Term Abbrev

Term abbreviation. Format is the terminal calendar year digits and the alphabetic term code (F=Fall, W=Winter, S=Spring, U=Summer) and an additional trailing S for Semester.

Data Type: 4 Characters

Example: 95F (Fall Term) 95FS (Fall Semester)

Source: stvterm_short_desc

Student Level Code

Identifies the level of the student for the effective term. 'UG' for Undergraduate, 'GR' for Graduate/Professional, 'NU' or 'NG' for Non-Degree & 'LW' for Law.

Data Type: 2 Characters

Example: 1

Source: sgbstdn_levl_code

Val Table: Level

Student Level Desc

Text Description of Student Level Code.

Data Type: 30 Characters

Example: Undergraduate

Source: stvlevl_desc

Val Table: Level

Class Standing

Class standing based on student level and credit hours earned. (Only applies for 'UG' and 'LW" Level students.) 'FR','SO','JR','SR','L1','L2' and 'L3'. See Student Type Code for distinctions of 'GR' students.

Data Type: 2 Characters

Example: SR

Source: derived from class standing rules in sgrclsr

Class Standing Desc

Description of Class Standing Code.

Data Type: 30 Characters

Example: Senior

Source: derived

Student Type Code

Identifies the student type at admission for student's current program or level. For the 'UG' student level, indicates the number of transfer hours the student had earned at the point of initial admission to UO. For the 'GR' student level, defines gradudate degree program to which the student is admitted. 'NG' and 'NU' students are generally unclassified.

Data Type: 2 Characters

Example: D

Source: sgbstdn_styp_code

Val Table: Student-Type

Student Type Desc

Text Description of Student Type Code.

Data Type: 30 Characters

Example: Doctoral

Source: stvstyp_desc

Val Table: Student-Type

Student Status Code

Identifies the students status for effective term.

Data Type: 2 Characters

Example: S

Source: sgbstdn_stst_code

Val Table: Student Status

Student Status Desc

Text Description of Student Status Code.

Data Type: 30 Characters

Example: Undergraduate

Source: stvstst_desc

Val Table: Student Status

Honors Track

Denotes student's participation in Honors Track program. 1 = Humanities, 2 = Social Sciences, 3 = Sciences.

Data Type: 1 Character

Example: 1

Source: sgbstdn_sess_code

EOP Code

Denotes student's participation in the Educational Opportunities Program (EOP), This field contains the student's EOP or EOPR Code, the code entered most recently.

Data Type: 8 Characters

Example: EOP

Source: sgrsact_actc_code

EOP Desc

Description of EOP Code.

Data Type: 30 Characters

Example: EOP

Source: stvactc_desc

Enrollment Status

Enrollment status of the student. 'FT' for Full-Time, 'HT' for Half-Time and 'LT' for Less than Half-Time

Data Type: 2 Characters

Example: F

Source: sfrtmst_tmst_code

Registration Status Code

Identifies the student's registration eligibility for the effective term/semster. Primary codes used to identify registered students are 'EL' and 'RR'. Codes 'CD', 'CW', or 'CN' indicate the the student has completely withdrawn for the requested term.

Data Type: 2 Characters

Example: EL

Source: sfbetrm_ests_code

Val Table: Registration Status

Registration Status Desc

Text Description of Registration Status Code.

Data Type: 30 Characters

Example: Eligible to Register

Source: stvests_desc

Val Table: Registration Status

Registration Priority Code

Defines the student's DUCK CALL registration priority group.

Data Type: 4 Characters

Example: NORM

Source: sgbstdn_regp_code

Val Table: Registration Priority

Registration Status Date

Effective date of corresponding Registration Status Code.

Data Type: Date

p.

Example: NORM

Source: sgbstdn_regp_code

Val Table: Registration Priority

Registration Priority Desc

Description of Registration Priority Code.

Data Type: 50 Characters

Example: NORMAL REGISTRATION

Source: stvregp_desc

Val Table: Registration Priority

Registration Priority Date

The earliest date the student may register. This is determined by registration priority code, class standing, student level and last three digits of student ID.

Data Type: Date

Example: 4/15/96

Source: sgbstdn_rfrom_date

Registration Priority Time

The earliest time the student may register. Determined by Registration Priority Code, Class Standing Code, Student Level Code, and the last three digits of Student ID.

Data Type: 5 Characters

Example: 09:00

Source: sgbstdn_rfrom_time

Student Rate Code

Identifies student tuition rate code for the term. A 'GTF' rate code identifies students with a graduate teaching fellowship appointment for the requested term.

Data Type: 5 Characters

Example: UGED

Source: sgbstdn_rate_code

Val Table: Student Rate

Student Rate Desc

Text Description of Student Rate Code.

Data Type: 30 Characters

Example: Undergrad Education Program

Source: stvrate_desc

Val Table: Student Rate

Residency

Student residency for term indicated, i.e., R (resident) or N (non-resident).

Data Type: 1 Character

Example: R

Source: sgbstdn_resd_code

Hours Registered

Number of credit hours for which the student is registered. Includes credits for courses in which student has withdrawn with a 'W' grade and no refund of tuition/course fees.

Data Type: 3 Digit number plus 2 decimal places

Example: 12.0

Source: Derived from sum or registration hours

Orientation Session Code

Identifies students attending IntroDUCKtion (codes 1- 7), re-enrolling undergrads (code 'U'), re-registering grad students (code 'G') or on-leave returning grad students (code 'O').

Data Type: 1 Character

Example: U

Source: sgbstdn_orsn_code

Val Table: Orientation Session

Orientation Session Desc

Text Description of Orientation Code.

Data Type: 30 Characters

Example: Re-Enrolling Undergraduate

Source: stvorsn_desc

Val Table: Orientation Session

Major1

Identifies a student's first major.

Data Type: 4 Characters

Example: MATH

Source: sgbstdn_majr_code_1

Val Table: Major-Minor

Notes: The Banner major codes are 'compressed'. There is not a mapping of sgbstdn_majr_code_1 equals major1.

Major1 College

Identifies the college associated with Major1 for the effective term.

Data Type: 2 Characters

Example: AS

Source: stvdept_coll_code

Val Table: College

Major2

Identifies any other major for the student.

Data Type: 4 Characters

Example: MATH

Source: sgbstdn_majr_code(s)

Val Table: Major-Minor

Major2 College

Identifies the college associated with Major2 for the effective term.

Data Type: 2 Characters

Example: AS

Source: stvdept_coll_code

Val Table: College

Major3

Identifies any other major for the student.

Data Type: 4 Characters

Example: MATH

Source: sgbstdn_majr_code(s)

Val Table: Major-Minor

Major3 College

Identifies the college associated with Major3 for the effective term.

Data Type: 2 Characters

Example: AS

Source: stvdept_coll_code

Val Table: College

Major4

Identifies any other major for the student.

Data Type: 4 Characters

Example: MATH

Source: sgbstdn_majr_code(s)

Val Table: Major-Minor

Major4 College

Identifies the college associated with Major4 for the effective term.

Data Type: 2 Characters

Example: AS

Source: stvdept_coll_code

Val Table: College

Minor1

Identifies a student's minor.

Data Type: 4 Characters

Example: MATH

Source: sgbstdn_majr_code_minr(s)

Val Table: Major-Minor

Notes: Minor codes are processed in the same manner as major codes.

Minor1 College

Identifies the college associated with Minor1 for the effective term.

Data Type: 2 Characters

Example: AS

Source: stvdept_coll_code

Val Table: College

Minor2

Identifies any other minor for the student.

Data Type: 4 Characters

Example: 321

Source: sgbstdn_majr_code_minr(s)

Val Table: Major-Minor

Minor2 College

Identifies the college associated with Minor2 for the effective term.

Data Type: 2 Characters

Example: 16

Source: stvdept_coll_code

Val Table: College

Minor3

Identifies any other minor for the student.

Data Type: 4 Characters

Example: 321

Source: sgbstdn_majr_code_minr(s)

Val Table: Major-Minor

Minor3 College

Identifies the college associated with Minor3 for the effective term.

Data Type: 2 Characters

Example: 16

Source: stvdept_coll_code

Val Table: College

Minor4

Identifies any other minor for the student.

Data Type: 4 Characters

Example: 321

Source: sgbstdn_majr_code_minr(s)

Val Table: Major-Minor

Minor4 College

Identifies the college associated with Minor4 for the effective term.

Data Type: 2 Characters

Example: 16

Source: stvdept_coll_code

Val Table: College

All Majors

All major codes joined together and separated by '|' (pipe characters)

Data Type: 21 Characters

Example: |MATH|CIS|

Source: derived

Val Table: Major-Minor

All Major Colleges

Identifies all of the colleges associated with the student's majors, separated by '|' (pipe characters).

Data Type: 21 Characters

Example: |AA|JO|

Source: derived

Val Table: College

All Minors

All minor codes joined together and separated by '|' (pipe characters)

Data Type: 21 Characters

Example: |ENG|PSY|

Source: derived

Val Table: Major-Minor

All Minor Colleges

Identifies all of the colleges associated with the student's minors, separated by '|' (pipe characters).

Data Type: 21 Characters

Example: |AA|JO|

Source: derived

Val Table: College

Primary Advisor ID

The Banner ID of the student's primary advisor. This is the adviser associated in Banner with the student's first major, primary cirriculum.

Data Type: 9 Characters

Example: 123456789

Source: spriden_id (from sgradvr)

Primary Advisor Name

Last name, comma, first name of primary advisor.

Data Type: 30 Characters

Example: Smith, John

Source: derived

Professional Objective Codes

The first eight professional objective codes found for a student joined together and separated by '|' (pipe characters). These codes identify professional objectives which do not correspond to a University major, for example Pre-Law, Pre-Dentistry or Pre-Med.

Data Type: 41 Characters

Example: |PJOU|PMUS|

Source: derived from sgrpfob

Val Table: Proffessional Objective

Professional Objective Descs

All professional objective code descriptions joined together and separated by '|' (pipe characters).

Data Type: 249 Characters

Example: |Journalism|Music|

Source: stvpfob_desc

Val Table: Professional Objective*

Acad Stand Code

Identifies the student's academic standing in affect during the term. Calculated based on the academic standing rules and based on the student's past performance. After grades are processed for the term, the student's academic standing is recalculated and will be stored in the term summary object with term GPA information. Only students with a Student Level of 'UG' or 'NU' have Acad Stand Code, all others are null.

Data Type: 2 Characters

Example: 00

Source: shrttrm_astd_code_end_of_term, sgbstdn_astd_code

Notes: Academic Standing is taken from the term header record *unless* an override has been set in the general student record for the requested term, in which case that code is used.

Acad Stand Desc

Text description of Academic Standing Code.

Data Type: 30 Characters

Example: Good Standing

Source: stvastd_desc

First Term Of Attendance

Identifies the first term of attendance.

Data Type: 6 Characters

Example: 199502

Source: sgbstdn_term_code_matric

Admit Term Code

Term student was admitted to U of O at his or her current student level.

Data Type: 6 Characters

Example: 198901

Source: sgbstdn_term_code_admit

Admit College

Identifies the primary curriculum college to which applicant is applying.

Data Type: 2 Characters

Example: 2

Source: saradap_coll_code_1

Val Table: College

Admit Major

Identifies the primary curriculum major to which applicant is applying.

Data Type: 4 Characters

Example: 2050

Source: saradap_majr_code_1

Val Table: Major-Minor

Block Code

Block code. If this field is not null, then the student was a participant in a FIG or other block for the term selected. The codes correspond to courses offered that term, and can be used in conjunction with handouts from the Office of Academic Advising and Student Services. For example, for 199501, F1 identified FIG#1 Psychology/Humanities FIG.

Data Type: 10 Characters

Example: FS

Block Desc

Text description of the block code.

Data Type: 30 Characters

Example: FIG S Sci

Source: stvblck_desc

Geographic Origin Code

Geographic origin of student at time of admission to current student level.

Data Type: 3 Characters

Example: PBD

Source: sgbstdn_gorg_code

Geographic Origin Desc

Text description of the geographic origin code.

Data Type: 30 Characters

Example: Bangladesh

Source: stvgorg_desc

Self Supporting

"Y" if all of the students classes are Self Supporting, otherwise is "N"

Data Type: 1 Character

Example: "Y"

Source: derived

Activity Codes

A piped field indicating all Activity Codes for this person.

Data Type: 20 Characters

Example: |MIL|JAZ|

Source: derived

Learning Community CRN

FIG, TRG, or Pathway CRN

Data Type: 5 Characters

Learning Community Flag

F, T, or P based on whether the student was registered for any CRN whose corresponding SSBSECT subject code is FIG, TRIG, or PATH.

Data Type: 1 Character

Learning Community Title

FIG, TRIG, or Pathway course title

Data Type: 30 Characters

Bend Only

"Y" if all of the students classes are at the Cascade campus, otherwise is "N".Bend Only students do not count in official UO enrollment.

Data Type: 1 Character

Sorg Code

Social Organization code indicating where the student lived during a term

Data Type: 3 Characters

Sorg Description

Description of the Sorg Code

Data Type: 25 Characters