|
[Home |
Announcements |
Access |
Installation |
User Notes |
Data Dictionary |
Mailing List |
Contact]
D a t a D i c t i o n a r y
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
This page was last updated on May 20, 2003.
[Home |
Announcements |
Access |
Installation |
User Notes |
Data Dictionary |
Mailing List |
Contact]
|
|
