- DATA VIEW NAME
- UGRD_PROSPECT
- OVERVIEW
- This data view contains basic information for all of the undergraduate prospective students entered in ISIS. All undergraduate applicants are included in this view; however, not all prospective students are undergraduate applicants. The APPLICATION_CURRENT_IND and APPLICATION_ANY_TERM_IND fields can be used to distinguish a prospect who has applied for admissions and those who have not applied. The STDNT_UGRD_APPLICANT view can also be used to gather information for those prospects who have applied for admission. Since applicants are also considered in this view, it is important when using this data for recruitment to exclude those who may have received a deny decision or have withdrawn their application.
- LOAD FREQUENCY
- The data in this view is refreshed daily.
- DATA CUSTODIAN
- Undergraduate Admissions Office
Contact: David Leszczynski - AUTHORIZATION
- You must receive approval to access data from the data custodian. For information about how to get authorized for InfoAccess data views, connect to the InfoAccess Home Page
- SPECIAL
CONSIDERATIONS - None.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 04/2005 – New view created.
9/11/2009 – Updated ethnic_group_code. c4j
12/2014 – Preferred name policy s8w.
04/2020 – Remove fields:
Ethnic_Group_Code
Ethnic_Group_Descr10
Targeted_Minority_Ind - 12/2024 – Updated legal sex values
- DATA FORMATS
- Primary Key Columns are identified with an asterisk(*)
- Alphanumeric Data
- VARCHAR2( N) (N) = maximum length. Field contains letters and/or numbers. Trailing blanks are eliminated.
Example: VARCHAR2 (5) could contain ‘ABC12’ or ‘ABC’ or ‘A’ - Numeric Data
- NUMBER (N) (N) = length. Field contains only numbers.
NUMBER (X,Y) = format for numbers with decimal positions.
X = total number of digits
Y = the number of digits after the decimal
Examples: NUMBER (6) represents 250012 NUMBER (6,2) represents 2500.12 - Date
- DATE – Date can be in various formats. Date functions available with your query tool can be used to format the date.
Examples: DATE (YYYYMMDD), DATE (YYDDD), DATE (DD-MM-YY)
| Column Name | Format | Description |
|---|---|---|
| *PROSPECT_KEY | NUMBER(15) | A unique identifier that is system generated. A surrogate key. It is based on ID. |
| ID | VARCHAR2(11) | ISIS personal Identifier. It will never be changed throughout the individual’s relationship with the University. This is not the same as Campus_ID. Only 10 characters are in use. |
| CAMPUS_ID | VARCHAR2(16) | ID number assigned to ISIS to be used by student (formerly Student ID) |
| NAME | VARCHAR2(50) | Person’s preferred full name in the format: last, first middle. |
| NAME_LAST | VARCHAR2(30) | Person’s preferred last name. |
| NAME_FIRST | VARCHAR2(30) | Person’s preferred first name. |
| NAME_MIDDLE | VARCHAR2(30) | Person’s preferred middle name. |
| GENDER_CODE | VARCHAR2(1) | Person’s legal sex. F = Female M = Male X = Another Legal Sex U = Unknown |
| BIRTHDATE | DATE | Person’s date of birth. |
| COUNTRY_OF_BIRTH_CODE | VARCHAR2(3) | The code for the country of birth. |
| COUNTRY_OF_BIRTH_DESCR | VARCHAR2(30) | Description of the country of birth. |
| CITIZENSHIP | VARCHAR2(1) | Indicates citizenship in the United States. Valid values: Y = Citizen N = Not Citizen U = Unknown |
| CITIZEN_STATUS_CODE | VARCHAR2(1) | The status of citizenship. Valid Values: 1 = Native 2 = Naturalized 3 = Alien Permanent 4 = Alien Temporary 5 = Alien 6 = Refugee 7 = Domestic, Status pending U = Unknown |
| CITIZEN_STATUS_DESCR | VARCHAR2(30) | The description for the citizen status. |
| COUNTRY_CITIZENSHIP_CODE | VARCHAR2(3) | The code for the Person’s country of citizenship. |
| COUNTRY_CITIZENSHIP_DESCR | VARCHAR2(30) | The description of the country of citizenship. |
| VETERAN_STATUS_IND | VARCHAR2(1) | Indicates Person’s veteran status. Y = Yes N = No |
| CREATION_DATE | DATE | Date the prospect record was created in ISIS. |
| INTENDED_ADMIT_TERM | VARCHAR2(4) | The term for which the prospect is considering applying for admission. Note: If a prospective student submits an application for admission, this term value does not change or represent the actual admission application. |
| INTENDED_ADMIT_TERM_DESCR | VARCHAR2(30) | Full description of the term for which the prospect is considering applying for admission. |
| INTENDED_ADMIT_TYPE_CODE | VARCHAR2(3) | A code for the type of admission. Valid Values: CON = Continuing EOR = Engineering Outreach Student FYR = First Year Student NEW = New Student RAD = Readmit RET = Reentry Transfer TRF = Transfer |
| INTENDED_ADMIT_TYPE_DESCR | VARCHAR2(30) | Full description of admit type. |
| PREVIOUS_INSTITUTION_CODE | VARCHAR2(11) | Last institution attended by the prospect. |
| PREVIOUS_INSTITUTION_DESCR50 | VARCHAR2(50) | Description of the last institution attended by the prospect. |
| PREV_INSTITUTION_SCHOOL_TYPE | VARCHAR2(3) | A code for the school type of the previous institution attended. Valid Values: SCD = Secondary School/High School PHS = Postsecondary ELM = Elementary School HSC = Secondary-Closed JRH = Junior High School MDL = Middle School NA = Not applicable |
| HS_GRAD_DATE | DATE | The date of Prospect’s high school graduation. |
| REFERRAL_SOURCE_CODE | VARCHAR2(4) | A code indicating the source that prompted the creation of the prospect record. |
| REFERRAL_SOURCE_DESCR | VARCHAR2(30) | A full description of the referral source code. |
| REFERRAL_SOURCE_DATE | DATE | Date that the referral source was entered |
| RECRUITER_ID | VARCHAR2(11) | EmplID of Admissions Recruiter assigned to applicant. |
| RECRUITER_NAME | VARCHAR2(50) | Name of Admissions Recruiter assigned to applicant. |
| RECRUITING_STATUS_CODE | VARCHAR2(4) | A code indicating the Prospect’s status: INAC = Inactive SUSP = Suspect INQR = Inquiry PROS = Prospect APPL = Applicant |
| RECRUITING_STATUS_DESCR10 | VARCHAR2(10) | A short description of the recruiting status code. |
| RECRUITING_STATUS_DATE | DATE | The date the recruiting status was entered. |
| APPLICATION_CURRENT_IND | VARCHAR2(1) | Indicates if the prospect has an application on file for a future term. Valid values are: N = No Y = Yes |
| APPLICATION_ANY_TERM_IND | VARCHAR2(1) | Indicates if the prospect has ever applied for undergraduate admissions. Valid values are: N = No Y = Yes |
| FIN_AID_INTEREST_IND | VARCHAR2(1) | Indicates if the prospect is interested in receiving Financial Aid information. Initiates action from the Office of Student Financial Services (OSFS). Valid values are: N = No Y = Yes |
| HOUSING_INTEREST_IND | VARCHAR2(1) | Indicates if the prospect is interested in University Housing information. Valid values are: N = No Y = Yes |
| PRECOLLEGE_PROSPECT_IND | VARCHAR2(1) | Indicates if the prospect participated in a Precollege Program. Valid values are: N = No Y = Yes |
| EXTRACT_DATE_TIME | DATE | The date and time these data were extracted. Format : YYYYMMDD HH24:MI:SS |