Admission Applicant Object

The Admission Applicant object contains applicant admission data. This object contains one or more records per applicant in the Student Data Warehouse for the time spanning from the current term to one year in the future.

---

PIDM

Identification number. A unique identifying value for all persons in the Student Data Warehouse.

Data Type: 8 Digit number

Example: 123456

Source: spriden_pidm

Term

Term Code representing term of intended entry. Format YYYYTT, where YYYY = academic year and TT = term, 01 = Fall, 02 = Winter, 03 = Spring,04=Summer, 05=Fall(semester),06=Winter(semester).

Data Type: 6 Characters

Example: 199502

Source: saradap_term_code_entry

Val Table: Term

Term Abbrev

Normalized version of term code intended for use in printing. Format is alphabetic term code (F = Fall, W = Winter, S = Spring, U = Summer) and the terminal calendar year digits.

Data Type: 4 Characters

Example: 95W

Source: stvterm_short_desc

Val Table: Term

Applic Date

Date when original application material was entered in Banner.

Data Type: Date

Example: 15-MAR-95

Source: saradap_appl_date

Applic Status Code

The status of the admissions application: 'C' for complete and ready for review, 'D' for decision made, 'I' for Incomplete, 'M', 'N', 'P' for Not Coming with different reasons.

Data Type: 1 Character

Val Table: Applic Status

Applic Status Desc

Description of Application Status.

Data Type: 30 Characters

Example: Decision Made.

Source: stvapst_desc

Val Table: Applic Status

Applic Status Date

Date application status was entered or last changed.

Data Type: Date

Example: 04/21/95

Source: saradap_apst_date

Admit Flag

Indicates that the applicant has the decision made and is going or attempting to attend the U of O.

Data Type: 1 Character

Example: Y

Source: derived

Notes: The value is 'Y' when saradap_apst_code = 'D' and sarappd_apdc_code starts with an 'A' or a 'T'.

Withdrawal Reason

The reason that the applicant withdrew the application.

Data Type: 30 Characters

Example: AE Accepted Elsewhere

Source: saradap_wrsn_code, stvwrsn_desc

Val Table: Applic Withdrawal

Institution Attended

The institution that the withdrawn the applicant will attend instead of UO.

Data Type: 30 Characters

Example: Univ of Sacred Heart

Source: saradap_sbgi_code, stvsbgi_desc

Val Table: Educational Institution

Admit Type Code

Admission Type of Applicant, such as 'IN' for International Student. This element may be empty, representing 'none of the above'.

Data Type: 2 Characters

Example: DS

Source: saradap_admt_code

Val Table: Admit Type

Admit Type Desc

Description of Applicant Admission Type Code.

Data Type: 30 Characters

Example: Disabled Student

Source: stvadmt_desc

Val Table: Admit Type

International Student

This indicator will be Y if the student is an International Student, i.e. has admit type code in (IN,GI). Otherwise, will be null.

Data Type: 1 Character

Example: DS

Source: saradap_admt_code

Val Table: Admit Type

Admit Level

Level for which the student applied for admission: 'UG' for Undergraduate, 'GR' for Graduate, 'NU' for Non_admit Undergraduate, 'NG' for Non_admit Graduate, 'LW' for Law student, & '00' for Unclassified.

Data Type: 2 Characters

Example: UG

Source: saradap_levl_code

Val Table: Level

Admit Residency

Identifies the residency classification of the applicant or student for term indicated, i.e. R (resident), N (non-resident).

Data Type: 1 Character

Example: R

Source: saradap_resd_code

Admit Student Type Code

Code representing the student type, such as Freshman From HS, Master, Doctor.

Data Type: 2 Characters

Example: 1

Source: saradap_styp_code

Val Table: Student Type

Admit Student Type Desc

Description of Student Type Code

Data Type: 30 Characters

Example: From High Scool 0 Transfer Hr

Source: stvstyp_desc

Val Table: Student Type

Admit College

College of the applicant's intended major.

Data Type: 2 Characters

Example: AS

Source: saradap_coll_code_1

Val Table: College

Admit Major Code

Identifies the applicant's intended major.

Data Type: 4 Characters

Example: ARCH

Source: saradap_majr_code_1

Val Table: Major-Minor

Professional Objective Code

The applicant's professional objective.

Data Type: 4 Characters

Example: PTCF

Source: saradap_pfob_code

Val Table: Professional Objective

Professional Objective Desc

Description of Professional Objective Code.

Data Type: 30 Characters

Example: Telecommunication & Film

Source: stvpfob_desc

Val Table: Professional Objective

Admit Decision Code

Most recent application decision for the term and level, i.e., Admitted, Pending, Rejected.

Data Type: 2 Characters

Example: A1

Source: sarappd_apdc_code

Val Table: Admit Decision

Admit Decision Desc

Description of Admit Decision Code

Data Type: 30 Characters

Example: Admit-Meets All Requirements

Source: stvapdc_desc

Val Table: Admit Decision

Admit Decision Date

Date application decision was entered or last changed.

Data Type: Date

Example: 04/21/05

Source: sarappd_apde_date

Admit Date

It will be the date for the 'T' decision unless the student only has an 'A' decision.

Data Type: Date

Example: 04/21/05

Source: sarappd_apdc_code and sarappd_apde_date

Rating Code

Rating Code, please call the admissions office for more info

Data Type: 5 Characters

le: 04/21/95

Source: sarappd_apde_date

Rating

Rating, please call the admissions office for more info

Data Type: 4 Digit number plus 2 decimal places

info

le: 04/21/95

Source: sarappd_apde_date

Rating User

Username of person changing/setting rating

Data Type: 30 Characters

or more info

info

le: 04/21/95

Source: sarappd_apde_date

Introducktion Flag

The flag indicates the applicant is registered to participate in IntroDucktion.

Data Type: 1 Character

Example: O

Source: saradap_sess_code

Admit Attrib Codes

Additional admission codes to indicate applicant intent to apply for other UO programs, i.e., Honors College & Scholarships.

Data Type: 30 Characters

Example: HCAP/SCHL

Source: saraatt_atts_code

Val Table: Admit Attribute

Application fee deferred flag

Values are 'Y' or NULL. 'Y' indicates that the application fee has been deferred.

Data Type: 1 Character

Source: saradap_rstr_code

e & Scholarships.

Example: HCAP/SCHL

Source: saraatt_atts_code

Val Table: Admit Attribute

Registration Flag

To check if the applicant registers in the admit term.

Data Type: 1 Character

Examples: 'Y' or NULL

Source: SFRSTCR

dap_rstr_code

e & Scholarships.

Example: HCAP/SCHL

Source: saraatt_atts_code

Val Table: Admit Attribute

PGPA

Calculated based on high school gpa and SAT verbal and math scores.

Data Type: 4 Digit number plus 6 decimal places

Example: 3.2

Source: derived

rstr_code

e & Scholarships.

Example: HCAP/SCHL

Source: saraatt_atts_code

Val Table: Admit Attribute

Residency Tracking Code

To track the status of residency decisions for applicants petitioning for Oregon resident status.

Data Type: 2 Characters

Example: EA

Source: SARADAP_RSTR_CODE

Geographic Origin Code

County or State or Foreign country code based on permanent address at the time of application.

Data Type: 3 Characters

Example: 020

Source: saradap_gorg_code

Val Table: Geographic Origin

Geographic Origin Desc

Description of Geographic Origin Code.

Data Type: 30 Characters

Example: Lane County

Source: stvgorg_desc

Val Table: Geographic Origin

Prior College Descs

Description of Prior College Codes. Separated by a '|' (pipe character).

Data Type: 300 Characters

Example: |Linn Benton Comm. College|

Source: stvsbgi_desc

Val Table: Educational Institution

Prior College Codes

Source/Background Institution (SBGI) Codes that identify attended colleges and universities. Separated by '|' (pipe characters).

Data Type: 100 Characters

Example: |006938|

Source: sorpcol_sbgi_code

Val Table: Educational Institution

Prior College Degrees

Degrees awarded by previously attended colleges and universities. Separated by '|' (pipe characters).

Data Type: 80 Characters

Example: |BS|BA|

Source: sordegr_degc_code

Val Table: Degree Type

Prior College Grad Dates

Date of prior college degrees awarded. Separated by '|' (pipe characters).

Data Type: 96 Characters

Example: |18-DEC-93|15-JUN-95|

Source: sordegr_degc_date

High School Code

Most recent high school input for the student.

Data Type: 7 Characters

Example: 380795

Source: sorhsch_sbgi_code

Val Table: Educational Institution

High School Desc

Description of the High School Code.

Data Type: 30 Characters

Example: Lake Oswego High School

Source: stvsbgi_desc

Val Table: Educational Institution

High School Grad Date

Graduation date of the most recently attended high school.

Data Type: Date

Example: 15-JUN-95

Source: sorhsch_graduation_date

High School GPA

GPA for the most recently attended high school

Data Type: 4 Digit number plus 6 decimal places

Example: 3.75

Source: sorhsch_gpa

High School Percentile

The applicant's high school class percentile.

Data Type: 3 Digit number plus 2 decimal places

Example: 0.98

Source: sorhsch_class_percentile

High school class size

High school class size.

Data Type: Number

Example: 330

Source: sorhsch_class_size

urce: sorhsch_class_percentile

High school class rank

High School class ranking.

Data Type: Number

Example: 3

Source: sorhsch_class_rank.

Recruit Flag

Does this person have a recruit (srbrecr) record (Y or null).

Data Type: 1 Character