Current Recruit Object

The Recruit object contains data concerning the background and interests of university recruits. This object contains one record per recruit for the time spanning 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

Code representing term data was recorded. 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: 199601

Source: srbrecr_term_code

Val Table: Term

Recruit Level

Recruit Level

Data Type: 2 Characters

Example: 'GR','UG'.

Source: srbrecr_levl_code

Recruit Type Code

Identifies the type of recruit - Freshman, International, Transfer.

Data Type: 2 Characters

Example: TR

Source: srbrecr_rtyp_code

Val Table: Recruit Type

Recruit Type Desc

Description of the recruit type.

Data Type: 30 Characters

Example: Transfer Recruit

Source: stvrtyp_desc

Val Table: Recruit Type

Recruit Activity Date

The most recent date any activity occurred with this recruiting record.

Data Type: Date

Example: 04-APR-95

Source: srbrecr_activity_date

Recruit GPA

The values are A+, A, B+, B, C & NULL.

Data Type: 2 Characters

Source: derived from srbrecr_rsta_code.

Interest Codes

Outside Interest Codes separated by '|' (pipe characters).

Data Type: 40 Characters

Example: |AT|CM|

Source: sorints_ints_code

Val Table: Recruit Interest

Interest Descs

Outside interest code descriptions, separated by '|' (pipe characters).

Data Type: 300 Characters

Example: |Intercollegiate Athletics|Multicultural Affairs|

Source: stvints_desc

Val Table: Recruit Interest

Major Code

Area of academic interest of the prospective student.

Data Type: 5 Characters

Example: ANTH

Source: srbrecr_majr_code

Val Table: Major-Minor

High School Code

The high school from which the student graduated.

Data Type: 7 Characters

Example: 380795

Source: sorhsch_sbgi_code

Val Table: Educational Institution

High School Desc

Description of 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

Prior College Codes

Source/Background Institution (SBGI) Codes that identifies the attended non-high school institutions, separated by '|' (pipe characters).

Data Type: 100 Characters

Example: |006938|

Source: sorpcol_sbgi_code

Val Table: Educational Institution

Prior College Descs

Description of Prior College Codes, separated by '|' (pipe characters).

Data Type: 300 Characters

Example: |Linn Benton Comm. College|

Source: stvsbgi_desc

Val Table: Educational Institution

SAT Verbal Score

Highest SAT verbal score.

Data Type: Number

Example: 700

Source: sortest_test_score

SAT Verbal Date

Date the highest SAT verbal score was achieved.

Data Type: Date

Example: 06/01/94

Source: sortest_test_date

SAT Math Score

Highest SAT math score.

Data Type: Number

Example: 600

Source: sortest_test_score

SAT Math Date

Date the highest SAT math score was achieved.

Data Type: Date

Example: 600

Source: sortest_test_date

Combined SAT Verbal Score

SAT verbal score from the highest composite SAT score.

Data Type: Number

Example: 700

Source: sortest_test_score

Combined SAT Math Score

SAT math score from the highest composite SAT score.

Data Type: Number

Example: 600

Source: sortest_test_score

Combined SAT Date

Date the highest composite SAT scores were achieved.

Data Type: Date

Example: 06/01/94

Source: sortest_test_date

ACT English Score

Highest ACT English score.

Data Type: Number

Example: 25

Source: sortest_test_score

ACT English Date

Date the highest ACT English score was achieved.

Data Type: Date

Example: 06/01/94

Source: sortest_test_date

ACT Math Score

Highest ACT math score.

Data Type: Number

Example: 30

Source: sortest_test_score

ACT Math Date

Date the highest ACT math score was achieved.

Data Type: Date

Example: 06/01/94

Source: sortest_test_date

ACT Composite Score

Highest ACT composite score.

Data Type: Number

Example: 30

Source: sortest_test_score

ACT Composite Date

Date highest ACT composite score was achieved.

Data Type: Date

Example: 06/01/94

Source: sortest_test_date

TOEFL Score

Highest TOEFL (Test of English as a Foreign Language) score.

Data Type: Number

Example: 833

Source: sortest_test_score

TOEFL Date

Date of highest TOEFL score.

Data Type: Date

Example: 06/01/94

Source: sortest_test_date

Higest GREA Score

Highest GREA score.

Data Type: Number

Example: 780

Source: SORTEST

Highest GREV Score

Highest GREV Score

Data Type: Number

Example: 780

Source:SORTEST

Highest GREQ Score

Highest GREQ Score

Data Type: Number

Example: 780

Source: SORTEST

Highest GREA Percentile

Highest GREA Percentile

Data Type: Number

Example: 70

Source: SORTEST

Highest GREV Percentile

Highest GREV Percentile

Data Type: Number

Source: SORTEST

Example: 70

Highest GREQ Percentile

Highest GREQ Percentile

Data Type: Number

Source: SORTEST

Example: 70

Highest GREA Date

Highest GREA Date

Data Type: Date

Source: SORTEST

Highest GREV Date

Highest GREV Date

Data Type: Date

Source: SORTEST

Highest GREQ Date

Highest GREQ Date

Data Type: Date

Source: SORTEST

Current GREA Score

Most current GREA Score

Data Type: Number

Source: SORTEST

Current GREV Score

Most current GREV Score

Data Type: Number

Source: SORTEST

Current GREQ Score

Most current GREQ Score

Data Type: Number

Source: SORTEST

Current GREA Percentile

Most current GREA Percentile

Data Type: Number

Source: SORTEST

Example: 70

Current GREV Percentile

Most current GREV Percentile

Data Type: Number

Source: SORTEST

Example: 70

Current GREQ Percentile

Most current GREQ Percentile

Data Type: Number

Source: SORTEST

Example: 70

Current GRE Date

Most current GRE Date

Data Type: Date

Source: SORTEST

GRE Subject Codes

All subject related codes including the codes for: subject total, subject subscore 1, subject subscore 2, subject subscore 3, and subject percentile.

Data Type: 52 Characters

Example: |G81|G81%|G811|G812|

Source: SORTEST

GRE Subject Descs

All the descriptions for GRE Subject Codes.

Data Type: 302 Characters

Example: |Psychology|GRE Psychology Percentile|Psychology Subscore 1|Psychology Subscore 2|

Source: SORTEST

GRE Subject Scores

All the scores for above codes.

Data Type: 40 Characters

Example: |750|98|75|71|

Source: SORTEST

GRE Subject Dates

All the dates for above codes.

Data Type: 102 Characters

Example: |01-DEC-96|01-DEC-96|01-DEC-96|

Source: SORTEST

Applic Date

Application date

Data Type: Date

above codes.

Example: |01-DEC-96|01-DEC-96|01-DEC-96|

Source: SORTEST

Admit Decision Code

Admit decision code

Data Type: 2 Characters

ove codes.

Example: |01-DEC-96|01-DEC-96|01-DEC-96|

Source: SORTEST

Admit Decision Date

Admit decision date

Data Type: Date

ove codes.

Example: |01-DEC-96|01-DEC-96|01-DEC-96|

Source: SORTEST

Registration Flag

To check if the applicant registers in the admit term.

Data Type: 1 Character

Examples: 'Y' or NULL

Source: SFRSTCR