| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
|
ACADEMIC_PERIOD
|
Academic period or time frame associated with the information on the student record.
|
VARCHAR2(85)
|
|
|
|
ACADEMIC_PERIOD_DESC
|
Academic period description.
|
VARCHAR2(29)
|
|
|
|
AGE
|
Age of the person as of the census date for the academic period.
|
VARCHAR2(64)
|
|
|
|
BANNER_GEO_ORG
|
Banner geographic origin; Fall 2009 and forward
|
VARCHAR2(47)
|
|
|
|
CAMPUS
|
Campus of dominant enrollment.
|
VARCHAR2(30)
|
|
|
|
CHINA_CAMPUS
|
Yes or No indicator that the student is taking courses primarily at the Dalian China campus in first term measured
|
VARCHAR2(114)
|
|
|
|
COLLEGE
|
College, faculty or school to which the academic study for the student is associated.
|
VARCHAR2(86)
|
|
|
|
DAY_EVE_IND
|
An additional dimension used to assign students to a "campus" based on the dominance of their course enrollment.
|
VARCHAR2(114)
|
|
|
|
DEPARTMENT
|
Department responsible for the student's academic study.
|
VARCHAR2(57)
|
|
|
|
ENROLLMENT_STATUS
|
Student's current enrollment status (e.g. full-time, part-time) for this academic period.
|
VARCHAR2(90)
|
|
|
|
GENDER
|
Gender of the person.
|
VARCHAR2(22)
|
|
|
|
GEOGRAPHIC_ORIGIN
|
Characterizes from where students come originally. There are four categories: International, Missouri, Out of State, Unknown
|
VARCHAR2(126)
|
|
|
|
ID
|
Person's or organization's current identification number.
|
VARCHAR2(58)
|
|
|
|
NAME
|
Name of the person (last name, first name middle initial).
|
VARCHAR2(59)
|
|
|
|
PHOENIX_GEO_ORG
|
Phoenix geographic origin codes; prior to Fall 2009
|
VARCHAR2(51)
|
|
|
|
PIDM
|
System generated, unique, internal identification number assigned to the person.
|
VARCHAR2(81)
|
|
|
|
PRIMARY_PROGRAM_IND
|
An indicator used to designate a student’s primary program of study or first major. A value of ‘Y’ designates the student’s primary program of study and a value of ‘N’ designates any secondary programs of study for this individual.
|
VARCHAR2(235)
|
|
|
|
PROGRAM_CODE
|
Program or course of study for the student.
|
VARCHAR2(43)
|
|
|
|
RACE_ETHNICITY
|
Characterizes students in such a way that each student is counted only once. In addition to identifying students attending classes at the China Campus, the categories for this dimension mirror the federal reporting classifications. In order to standardize race/ethnicity reporting with federal requirements additional categories were added in Fall 2009. These new categories are Native Hawaiian or Other Pacific Islander, and More than one race. Prior to Fall 2009 only one primary race/ethnicity was reported, and Native Hawaiian or Other Pacific Islander was included in the ‘Asian’ category. The specific categories are: China Campus, Non-Resident Alien, Hispanic OR Latino, American Indian or Alaskan Native, Asian, Black or African American, Native Hawaiian or Other Pacific Islander, White or Caucasian, More than one race, and Unknown.
|
VARCHAR2(849)
|
|
|
|
STUDENT_CLASS
|
Identifies the student classification (i.e. year in school) after grades have been processed for this academic period. For example, freshman, sophomore, etc.
|
VARCHAR2(157)
|
|
|
|
STUDENT_LEVEL
|
Student level associated with the coursework in the academic outcome. Examples, include undergraduate and graduate, etc.
|
VARCHAR2(121)
|
|
|
|
STUDENT_POPULATION
|
Student population or type for reporting. May include populations like new freshman, transfer, continuing, etc.
|
VARCHAR2(112)
|
|
|
|
TOTAL_CREDIT_HOURS
|
Sum of the registered credits for the student for this academic period.
|
VARCHAR2(72)
|
|
|