- DATA VIEW NAME
- UGRD_RECRUITMENT_CATEGORY
- OVERVIEW
- This data view contains recruitment category information for prospective undergraduate students and undergraduate applicants.
- LOAD FREQUENCY
- 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 - This data view is intended to be joined with the UGRD_PROSPECT or STDNT_UGRD_APPLICANT data views. Undergraduate recruitment categories can be associated with the individual’s prospect record or their application record. Some recruitment categories will appear both on the application record and prospect record while others may exclusively be a prospect recruiting category or an applicant recruiting category.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 04/2005 – New view created.
- 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 |
|---|---|---|
| *Recruitment_Cat_Key | NUMBER(15) | A unique identifier that is system generated. A surrogate key. It is based on ID, Application Number, Recruitment Category Code and Recruitment Category Source. |
| Prospect_Key | NUMBER(15) | Surrogate key of prospect table. Match this key on this table to same key on Ugrd_Prospect view. |
| ID | VARCHAR(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. |
| Application_Number | VARCHAR(8) | Only populated if the person has applied for undergraduate admission. A recruitmentcategory is application specific, so if an applicant reapplied for another term they may not have the same recruitment categories on both applications. |
| Recruitment_Category_Code | VARCHAR(4) | Specifies the recruitment category. Examples are: CNCT – UW-Madison connections program FGEN – first generation univ student PALM – parent alumni POSS – UW-Madison POSSE WBBL – Women’s Basketball |
| Recruitment_Category_Descr | VARCHAR(30) | Description of the Recruitment Category Code. |
| Recruitment_Category_Source | VARCHAR(1) | Code indicating on which record the Recruitment Category was entered. Valid values: A = Application Record P = Prospect Record |
| Recruitment_Group_Code | VARCHAR(4) | Recruiting categories are grouped together under Recruitment Group. Examples are: ACAD = Academic ATHL = Athletics REGN = Geographic Region SPEC = Special |
| Recruitment_Group_Descr | VARCHAR(30) | Description of the Recruitment Group Code |
| EXTRACT_DATE_TIME | DATE | The date and time these data were extracted. Format : YYYYMMDD HH24:MI:SS |