[Home |
Announcements |
Access |
Installation |
User Notes |
Data Dictionary |
Mailing List |
Contact]
Data Dictionary
This dictionary contains information describing the content of the University
of Oregon's Student Data Warehouse.
This page is an index into the dictionary. There are two sections here.
The first consists of links into the various objects
in the Warehouse. The second consists of an alphabetized
list of all the data elements that exist in the system.
Student Data Warehouse Objects
Student Data Warehouse Attributes
[A]
[B]
[C]
[D]
[E]
[F]
[G]
[H]
[I]
[L]
[M]
[N]
[O]
[P]
[R]
[S]
[T]
[U]
[V]
[W]
[Z]
A
ACAT Code (Degree)
ACAT Desc (Degree)
ACT Composite Date (Current Recruit)
ACT Composite Date (Summary)
ACT Composite Score (Current Recruit)
ACT Composite Score (Summary)
ACT English Date (Current Recruit)
ACT English Date (Summary)
ACT English Score (Current Recruit)
ACT English Score (Summary)
ACT Math Date (Current Recruit)
ACT Math Date (Summary)
ACT Math Score (Current Recruit)
ACT Math Score (Summary)
Acad Stand Code (Term Summary)
Acad Stand Code (Current/Past/Future Student)
Acad Stand Desc (Term Summary)
Acad Stand Desc (Current/Past/Future Student)
Accum Overall Attempt Hours (Summary)
Accum Overall Earn Hours (Summary)
Accum Overall GPA (Summary)
Accum Overall GPA Hours (Summary)
Accum Overall Quality Points (Summary)
Accum Transfer Attempt Hours (Summary)
Accum Transfer Earn Hours (Summary)
Accum Transfer GPA (Summary)
Accum Transfer GPA Hours (Summary)
Accum Transfer Quality Points (Summary)
Accum UO Attempt Hours (Summary)
Accum UO Earn Hours (Summary)
Accum UO GPA (Summary)
Accum UO GPA Hours (Summary)
Accum UO Quality Points (Summary)
Activity Codes (Current/Past/Future Student)
Activity Date (Holds)
Activity Date (Meeting Times)
Address Code (Address)
Address Desc (Address)
Admit Attrib Codes (Admission Applicant)
Admit College (Admission Applicant)
Admit College (Current/Past/Future Student)
Admit Decision Code (Admission Applicant)
Admit Decision Code (Current Recruit)
Admit Decision Date (Admission Applicant)
Admit Decision Date (Current Recruit)
Admit Decision Desc (Admission Applicant)
Admit Flag (Admission Applicant)
Admit Level (Admission Applicant)
Admit Major (Current/Past/Future Student)
Admit Major Code (Admission Applicant)
Admit Residency (Admission Applicant)
Admit Student Type Code (Admission Applicant)
Admit Student Type Desc (Admission Applicant)
Admit Term Code (Current/Past/Future Student)
Admit Type Code (Admission Applicant)
Admit Type Desc (Admission Applicant)
Age (Person)
All Degree Major Colleges (Degree)
All Degree Majors (Degree)
All Degree Minor Colleges (Degree)
All Degree Minors (Degree)
All Major Colleges (Current/Past/Future Student)
All Majors (Current/Past/Future Student)
All Minor Colleges (Current/Past/Future Student)
All Minors (Current/Past/Future Student)
Amount Owed (Holds)
Applic Date (Current Recruit)
Applic Date (Admission Applicant)
Applic Status Code (Admission Applicant)
Applic Status Date (Admission Applicant)
Applic Status Desc (Admission Applicant)
Application fee deferred flag (Admission Applicant)
Area Code (Address)
B
Begin Time (Meeting Times)
Bend Only (Current/Past/Future Student)
Birth Date (Summary)
Birth Date (Person)
Birth Date (Recruit Person)
Block Code (Current/Past/Future Student)
Block Desc (Current/Past/Future Student)
Building Code (Meeting Times)
Building Description (Meeting Times)
C
CIP Code (Schedule)
CRN (Transcript)
CRN (Registration)
CRN (Meeting Times)
CRN (Schedule)
CSZ (Address)
Cert Date (Veterans)
Cert Hours (Veterans)
Check List Code (Check List)
Check List Desc (Check List)
Check List Manditory Ind (Check List)
Check List Print Ind (Check List)
Check List Receive Date (Check List)
Citizenship Nation Code (Summary)
Citizenship Nation Code (Person)
Citizenship Nation Desc (Summary)
Citizenship Nation Desc (Person)
City (Address)
Class Standing (Current/Past/Future Student)
Class Standing Desc (Current/Past/Future Student)
College (Registration)
College Code (Transcript)
College Code (Schedule)
Combined SAT Date (Current Recruit)
Combined SAT Date (Summary)
Combined SAT Math Score (Current Recruit)
Combined SAT Math Score (Summary)
Combined SAT Verbal Score (Current Recruit)
Combined SAT Verbal Score (Summary)
Confidentiality Flag (Person)
Contact Code (Recruit Contact)
Contact Code (Address)
Contact Date (Recruit Contact)
Contact Desc (Recruit Contact)
Contact Desc (Address)
Contact Name 1 (Person)
Contact Name 2 (Person)
Count In GPA Flag (Transcript)
Course Attribute Codes (Schedule)
Course Attribute Descs (Schedule)
Course Attributes (Transcript)
Course Level (Transcript)
Course Level (Schedule)
Course Level (Registration)
Course Numb (Transcript)
Course Numb (Registration)
Course Numb (Schedule)
Credit Coll Code (Schedule)
Credit Dept Code (Schedule)
Credit Hours (Transcript)
Credit Hours (Registration)
Credit Hours Connector (Schedule)
Credit Hours Max (Schedule)
Credit Hours Min (Schedule)
Credit Subj Code (Schedule)
Cross List Code (Schedule)
Current GRE Date (Current Recruit)
Current GREA Percentile (Current Recruit)
Current GREA Score (Current Recruit)
Current GREQ Percentile (Current Recruit)
Current GREQ Score (Current Recruit)
Current GREV Percentile (Current Recruit)
Current GREV Score (Current Recruit)
D
Dean's List Flag (Term Summary)
Deceased Flag (Person)
Degree Application Date (Degree)
Degree Code (Degree)
Degree Date (Degree)
Degree Dept Honor Codes (Degree)
Degree Dept Honor Descs (Degree)
Degree Desc (Degree)
Degree Inst Honor Codes (Degree)
Degree Inst Honor Descs (Degree)
Degree Level (Degree)
Degree Major 1 (Degree)
Degree Major 1 College (Degree)
Degree Major 2 (Degree)
Degree Major 2 College (Degree)
Degree Major 3 (Degree)
Degree Major 3 College (Degree)
Degree Major 4 (Degree)
Degree Major 4 College (Degree)
Degree Minor 1 (Degree)
Degree Minor 1 College (Degree)
Degree Minor 2 (Degree)
Degree Minor 2 College (Degree)
Degree Minor 3 (Degree)
Degree Minor 3 College (Degree)
Degree Minor 4 (Degree)
Degree Minor 4 College (Degree)
Degree Status (Degree)
Degree Status Desc (Degree)
Degree Term (Degree)
Dept Code (Transcript)
Dept Code (Schedule)
Dept Code (Registration)
E
EOP Code (Current/Past/Future Student)
EOP Desc (Current/Past/Future Student)
ETCT Code (Recruit Person)
ETCT Code (Person)
ETCT Desc (Person)
ETCT Desc (Recruit Person)
Email Addrs (Person)
End Date (Meeting Times)
End Time (Meeting Times)
Enroll Actual (Schedule)
Enroll Max (Schedule)
Enroll Proj (Schedule)
Enrolled Credit Hours (Schedule)
Enrollment Status (Current/Past/Future Student)
Ethnic Code (Recruit Person)
Ethnic Code (Summary)
Ethnic Code (Person)
Ethnic Desc (Person)
Ethnic Desc (Summary)
Ethnic Desc (Recruit Person)
Ethnic Type Code (Summary)
Ethnic Type Desc (Summary)
F
FML Name (Address)
FML Name (Recruit Person)
FML Name (Person)
Fee Amounts (Schedule)
Fee Detail Codes (Schedule)
Fee Detail Descs (Schedule)
Fee Indicators (Schedule)
First Name (Person)
First Name (Recruit Person)
First Term Of Attendance (Current/Past/Future Student)
Friday Flag (Meeting Times)
From Date (Holds)
Full Telephone (Address)
G
GED Score (Summary)
GPA Hours (Transcript)
GRE Subject Codes (Current Recruit)
GRE Subject Dates (Current Recruit)
GRE Subject Descs (Current Recruit)
GRE Subject Scores (Current Recruit)
Gender (Summary)
Gender (Recruit Person)
Gender (Person)
Geographic Origin Code (Admission Applicant)
Geographic Origin Code (Current/Past/Future Student)
Geographic Origin Desc (Current/Past/Future Student)
Geographic Origin Desc (Admission Applicant)
Grade (Transcript)
Grade (Registration)
Grade Numeric Value (Transcript)
Grade Points (Transcript)
Grading Mode (Transcript)
Grading Option (Registration)
H
Higest GREA Score (Current Recruit)
High School Code (Admission Applicant)
High School Code (Current Recruit)
High School Code (Summary)
High School Desc (Admission Applicant)
High School Desc (Current Recruit)
High School Desc (Summary)
High School GPA (Admission Applicant)
High School GPA (Summary)
High School Grad Date (Summary)
High School Grad Date (Admission Applicant)
High School Grad Date (Current Recruit)
High School Percentile (Admission Applicant)
High School Subj Code (High School Subject)
High School Subj Desc (High School Subject)
High School Subj Years (High School Subject)
High school class rank (Admission Applicant)
High school class size (Admission Applicant)
Highest GREA Date (Current Recruit)
Highest GREA Percentile (Current Recruit)
Highest GREQ Date (Current Recruit)
Highest GREQ Percentile (Current Recruit)
Highest GREQ Score (Current Recruit)
Highest GREV Date (Current Recruit)
Highest GREV Percentile (Current Recruit)
Highest GREV Score (Current Recruit)
Hold Code (Holds)
Honors Track (Current/Past/Future Student)
Hours Registered (Current/Past/Future Student)
I
Include in Enrollment (Registration)
Ind Study Flag (Schedule)
Inst Transfer Flag (Transcript)
Inst Transfer Flag (Degree)
Institution Attended (Admission Applicant)
Institution Code (Transcript)
Institution Code (Degree)
Institution Desc (Degree)
Institution Desc (Transcript)
Instructor Dept Codes (Schedule)
Instructor ID (Transcript)
Instructor IDs (Schedule)
Instructor Name (Transcript)
Instructor Names (Schedule)
Interest Codes (recruit/applicant)
Interest Descs (recruit/applicant)
International Student (Person)
International Student (Admission Applicant)
Introducktion Flag (Admission Applicant)
L
LFM Name (Person)
LFM Name (Recruit Person)
LGPA Score (Summary)
LST1 Score (Summary)
LST2 Score (Summary)
Last Name (Recruit Person)
Last Name (Person)
Learning Community CRN (Current/Past/Future Student)
Learning Community Flag (Current/Past/Future Student)
Learning Community Title (Current/Past/Future Student)
M
MA PR Address (Address)
MA PR RD Address (Address)
MATH Score (Summary)
Mail Addr Area Code (Recruit Person)
Mail Addr CSZ (Recruit Person)
Mail Addr City (Recruit Person)
Mail Addr Nation (Recruit Person)
Mail Addr Phone (Recruit Person)
Mail Addr State (Recruit Person)
Mail Addr Str 1 (Recruit Person)
Mail Addr Str 2 (Recruit Person)
Mail Addr Zip Code (Recruit Person)
Major Code (Current Recruit)
Major Grading Mode Code (Schedule)
Major Grading Mode Desc (Schedule)
Major1 (Current/Past/Future Student)
Major1 College (Current/Past/Future Student)
Major2 (Current/Past/Future Student)
Major2 College (Current/Past/Future Student)
Major3 (Current/Past/Future Student)
Major3 College (Current/Past/Future Student)
Major4 (Current/Past/Future Student)
Major4 College (Current/Past/Future Student)
Middle Name (Recruit Person)
Middle Name (Person)
Minor1 (Current/Past/Future Student)
Minor1 College (Current/Past/Future Student)
Minor2 (Current/Past/Future Student)
Minor2 College (Current/Past/Future Student)
Minor3 (Current/Past/Future Student)
Minor3 College (Current/Past/Future Student)
Minor4 (Current/Past/Future Student)
Minor4 College (Current/Past/Future Student)
Monday Flag (Meeting Times)
N
Nation (Address)
O
Orientation Session Code (Current/Past/Future Student)
Orientation Session Desc (Current/Past/Future Student)
Orig Code (Holds)
Original Grade (Transcript)
P
PGPA (Admission Applicant)
PIDM (Recruit Contact)
PIDM (Admission Applicant)
PIDM (Current Recruit)
PIDM (Registration)
PIDM (Current/Past/Future Student)
PIDM (Sport Code)
PIDM (Transcript)
PIDM (Veterans)
PIDM (Person)
PIDM (Term Summary)
PIDM (Holds)
PIDM (High School Subject)
PIDM (Recruit Person)
PIDM (Summary)
PIDM (Degree)
PIDM (Address)
PR MA Address (Address)
Postbac Flag (Degree)
Preferred Email (Person)
Prev Course Numb (Schedule)
Prev Subj Code (Schedule)
Primary Advisor ID (Current/Past/Future Student)
Primary Advisor Name (Current/Past/Future Student)
Prior College Codes (Admission Applicant)
Prior College Codes (Current Recruit)
Prior College Degrees (Admission Applicant)
Prior College Descs (Admission Applicant)
Prior College Descs (Current Recruit)
Prior College Grad Dates (Admission Applicant)
Professional Objective Code (Admission Applicant)
Professional Objective Codes (Current/Past/Future Student)
Professional Objective Desc (Admission Applicant)
Professional Objective Descs (Current/Past/Future Student)
R
RD PR MA Address (Address)
Rating (Admission Applicant)
Rating Code (Admission Applicant)
Rating User (Admission Applicant)
Reason (Holds)
Recruit Activity Date (Current Recruit)
Recruit Flag (Admission Applicant)
Recruit GPA (Current Recruit)
Recruit Level (Current Recruit)
Recruit Type Code (Current Recruit)
Recruit Type Desc (Current Recruit)
Registration Flag (Admission Applicant)
Registration Flag (Current Recruit)
Registration Priority Code (Current/Past/Future Student)
Registration Priority Date (Current/Past/Future Student)
Registration Priority Desc (Current/Past/Future Student)
Registration Priority Time (Current/Past/Future Student)
Registration Status Code (Registration)
Registration Status Code (Current/Past/Future Student)
Registration Status Date (Current/Past/Future Student)
Registration Status Desc (Registration)
Registration Status Desc (Current/Past/Future Student)
Release Ind (Holds)
Repeat Flag (Transcript)
Residency (Current/Past/Future Student)
Residency Tracking Code (Admission Applicant)
Room Code (Meeting Times)
S
SAT Math Date (Current Recruit)
SAT Math Date (Summary)
SAT Math Score (Current Recruit)
SAT Math Score (Summary)
SAT Verbal Date (Current Recruit)
SAT Verbal Date (Summary)
SAT Verbal Score (Current Recruit)
SAT Verbal Score (Summary)
SAT2 Codes (Summary)
SAT2 Dates (Summary)
SAT2 Scores (Summary)
Saturday Flag (Meeting Times)
SCID (Schedule)
Seats Available (Schedule)
Section Campus Code (Schedule)
Section Campus Desc (Schedule)
Section Codes (Schedule)
Section Descs (Schedule)
Section Link Code (Schedule)
Section Notes (Schedule)
Section Prereq (Schedule)
Section Status Code (Schedule)
Section Status Desc (Schedule)
Section Type Code (Schedule)
Section Type Desc (Schedule)
Self Support Flag (Schedule)
Self Supporting (Current/Past/Future Student)
Session Type (Meeting Times)
Sorg Code (Current/Past/Future Student)
Sorg Description (Current/Past/Future Student)
Spec Approval Code (Schedule)
Spec Approval Desc (Schedule)
Sport Atheletic Aid Ind (Sport Code)
Sport Code (Sport Code)
Sport Code Desc (Sport Code)
Sport Eligibility Code (Sport Code)
Sport Status Code (Sport Code)
Start Date (Meeting Times)
State (Address)
Street 1 (Address)
Street 2 (Address)
Student ID (Recruit Person)
Student ID (Person)
Student Level Code (Current/Past/Future Student)
Student Level Desc (Current/Past/Future Student)
Student Rate Code (Current/Past/Future Student)
Student Rate Desc (Current/Past/Future Student)
Student Status Code (Current/Past/Future Student)
Student Status Desc (Current/Past/Future Student)
Student Type Code (Current/Past/Future Student)
Student Type Desc (Current/Past/Future Student)
Subj Code (Registration)
Subj Code (Transcript)
Subj Code (Schedule)
Summary Course Level (Term Summary)
Summary Course Level (Summary)
Summary Term (Term Summary)
Sunday Flag (Meeting Times)
T
TERM (Meeting Times)
TOEFL Date (Summary)
TOEFL Date (Current Recruit)
TOEFL Score (Summary)
TOEFL Score (Current Recruit)
TSWE Score (Summary)
Telephone (Address)
Term (Registration)
Term (Admission Applicant)
Term (Current/Past/Future Student)
Term (Veterans)
Term (Current Recruit)
Term (Schedule)
Term (Sport Code)
Term (Check List)
Term Abbrev (Registration)
Term Abbrev (Admission Applicant)
Term Abbrev (Current/Past/Future Student)
Thursday Flag (Meeting Times)
Title (Transcript)
Title (Schedule)
Title (Registration)
To Date (Holds)
Transcript Term (Transcript)
Transfer Attempt Hours (Term Summary)
Transfer Course Numb (Transcript)
Transfer Earn Hours (Term Summary)
Transfer GPA (Term Summary)
Transfer GPA Hours (Term Summary)
Transfer Grade (Transcript)
Transfer Hours (Transcript)
Transfer Quality Points (Term Summary)
Transfer Subj Code (Transcript)
Transfer Term (Transcript)
Transfer Title (Transcript)
Tuesday Flag (Meeting Times)
U
UO Attempt Hours (Term Summary)
UO Earn Hours (Term Summary)
UO GPA (Term Summary)
UO GPA Hours (Term Summary)
UO Grading Mode Code (Schedule)
UO Grading Mode Desc (Schedule)
UO Quality Points (Term Summary)
US Citizen Flag (Person)
Username (Holds)
V
Vetc Code (Veterans)
Visa Birth Nation Code (Person)
Visa Birth Nation Desc (Person)
Visa Expiration Date (Person)
Visa Num Children (Person)
Visa Spouse Ind (Person)
Visa Type (Person)
W
Waitlist Count (Schedule)
Warehouse ID (Registration)
Warehouse ID (Current/Past/Future Student)
Warehouse ID (Sport Code)
Warehouse ID (Transcript)
Warehouse ID (Veterans)
Warehouse ID (Person)
Warehouse ID (Term Summary)
Warehouse ID (Holds)
Warehouse ID (Recruit Person)
Warehouse ID (Summary)
Warehouse ID (Degree)
Warehouse ID (Address)
Wednesday Flag (Meeting Times)
Weekdays (Meeting Times)
Withdrawal Reason (Admission Applicant)
Z
Zip Code (Address)
This page was last updated on May 20, 2003.
[Home |
Announcements |
Access |
Installation |
User Notes |
Data Dictionary |
Mailing List |
Contact]
|