Historical Changes to the Student Data Warehouse Model

June 2003

New objects for Holds and Meeting Times. Meeting time attributes are removed from the Schedule object and many canned queries are updated

January 2003

Added attribute Registration Status Date to all Student objects

Added New Object: Veterans (limited access to this)

Added Credit Dept Code and Credit College Code to Schedule objects

Added International Student Flag to Person objects. Note: Flag is 'Y' if student is an International Student (Admit Type Code = 'IN' or 'GI'); otherwise Null

Added attributes for Application Date, Admit Decision Code, Admit Decision Date and Registration Flag to the recruit object

Added attribute Recruit Flag to the Applicants object. Note: Indicates if this student is/was also a recruit

October 2002

Added attributes SORG Code and SORG Description to Student objects. Social Organization Codes are now maintained by term dates.

Removed attributes SORG Code and SORG Description from person objects.

Added attributes Rating Code, Rating and Rating User to applicant object. The Rating User will be the username of the person changing/setting the rating.

September 2002

Added attributes to student objects: Learning Community Flag, Learning Community CRN, and Learning Community Title. These new attributes will have FIGs, TRIGs, Pathways info.

Renamed Attributes: FIG Code to Block Code(NOT restricted to 'F' value anymore) and FIG Description to Block Description

Added attribute to student objects: Bend Only. 'Y' if all courses affiliated with Bend Cascade campus. 'N' if 'not' all courses affilitated with Bend Cascade campus. Bend Only students do not count in official UO enrollment. To get the official enrollment, qualify the Bend Only as 'N'.

Changed attribute EOP Code Note: Includes 'EOPR' value, code entered most recently.

Added attributes to Address objects: MA PR Address, PR MA Address, MA PR RD Address and RD PR MA Address . If the attribute value is 'Y', then the address returned corresponds to the address code type in the order listed. For example, if MA PR Address is 'Y' then the address returned is a mailing (MA) address unless there is none, in which case the address is the permanent (PR) address. Similarly, if RD PR MA Address is 'Y', then the address returned will be either RD, or PR if RD does not exist, or MA if RD and PR do not exist.

Added attribute Ind Study Flag to Schedule objects. Value is 'Y' if Individual Study Course

Added attributes Section Prereq and Section Notes to schedule objects.

Degree object: Repositioned Degree Term attribute to second position in object and added attribute Postbac Flag, value is 'Y' if student is post-bac.

Added attribute International Student to Admission Applicants object. Value is 'Y' if international student

Added attribute Discontinued Program to Major Minor Val table. Value is 'Y' if major-minor discontinued

In addition to the model changes, a new standard query for Latin Honors was incorporated into the model.

March 1999

Canned Queries

When you download the Student model, a set of "canned" queries will be installed and available when you choose "Load Query" from the Query menu item. These queries are identified in the list by a leading underscore character.

Validation Table Names

The Val(idation) Tables have been given descriptive names instead of the actual BANNER table name.

Current Recruit and Summary Objects

TOFEL Computer Based scores and subscores have been added.

January 1999

Person Object

Email Address data is now being stored in the Email Addrs field of the Person Object.

April 1998

New Object

Check List: This object enables the user to associate specific Check List items with the respective Applicant.

New Fields to existing objects:

Admissions Applicant

Registration Flag
PGPA
High School GPA
High School Percentile
High school class size
High school class rank

Summary and Current Recruit

TOEFL Score
TOEFL Date
Higest GREA Score
Highest GREV Score
Highest GREQ Score
Highest GREA Percentile
Highest GREV Percentile
Highest GREQ Percentile
Highest GREA Date
Highest GREV Date
Highest GREQ Date
Current GREA Score
Current GREV Score
Current GREQ Score
Current GREA Percentile
Current GREV Percentile
Current GREQ Percentile
Current GRE Date
GRE Subject Codes
GRE Subject Descs
GRE Subject Scores
GRE Subject Dates

Schedule

Schedule Link Code

Current/Past/Future Student

Activity Codes
Self Supporting

Validation Tables

These are the tables which contain the code and corresponding description for the numnerous types of data which pervade the Banner system (for example Student Level Codes, Nation Codes, Ethnic Codes, and so forth). Previously, a terse description of the individual Validation Table was provided. Now the actual Banner Table name is listed below the object (eg. STVACAT).
 

---

 This document was last updated on March 31, 1999.