|
[Home |
Announcements |
Access |
Installation |
User Notes |
Data Dictionary |
Mailing List |
Contact]
D a t a D i c t i o n a r y
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
This page was last updated on February 15, 2000.
[Home |
Announcements |
Access |
Installation |
User Notes |
Data Dictionary |
Mailing List |
Contact]
|
|
