- DATA VIEW NAME
- STDNT_DIRECTORY_MULTITERM
- OVERVIEW
- This view contains the “public” student directory information for each student registered for the two prior terms, the current term and up to two future terms. Students who have withdrawn are also included but have been identified accordingly. Deceased students are excluded.
A FERPA indicator is provided in this view and it is the users responsibility to check this indicator if the information is being considered for release.
- LOAD FREQUENCY
- Data is refreshed nightly (Monday through Saturday).
- DATA CUSTODIAN
- Registrar’s Office
Contact: Phil Hull - 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 InfoAccess Home Page
- SPECIAL
CONSIDERATIONS - QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 09/2001 – New view created.
03/2003 – Two new fields were added:
Hold_Postal_Ind
Hold_Email_Ind
The length of all address line fields has been increased from 35 characters to 55 characters. ISIS has allowed address lines to be 55 characters since the upgrade to PeopleSoft 8. On the data view there are four HOME address lines and four MAIL address lines where the field length has been changed.
02/2012 Custodian Change
03/2013 Add new field Hold_Email_Stdnt_Org_Ind
08/2014 Modified Email address decription ABM
11/2014 Preferred name policy s8w.
07/2019 FERPA 3rd party hold customization was removed as part of the 9.2 SIS upgrade. These fields will remain on the view but will no longer be populated:
Hold_Postal_Ind
Hold_Email_Ind
Hold_Email_Stdnt_Org_Ind - 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 |
|---|---|---|
| *TERM | VARCHAR2 4 | The ISIS code for the academic year and semester. |
| *ID | VARCHAR2 11 | ISIS personal Identifier. The ID 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. Only ten characters are used. |
| NAME | VARCHAR2 50 | Student’s preferred name (last, first, middle with no space between last and first names). |
| NAME_LAST_PREFERRED | VARCHAR2 30 | Student’s legal last name stored in the “preferred” name fields in ISIS. |
| NAME_FIRST_PREFERRED | VARCHAR2 30 | Student’s preferred first name. |
| NAME_MIDDLE_ PREFERRED |
VARCHAR2 30 | Student’s preferred middle name. |
| FERPA_FLAG | VARCHAR2 1 | Restricted information indicator. Y = information restricted. |
| HOLD_POSTAL_IND | VARCHAR2 1 | No longer populated |
| HOLD_EMAIL_IND | VARCHAR2 1 | No longer populated |
| HOLD_EMAIL_STDNT_ORG_IND | VARCHAR2 1 | No longer populated |
| WITHDREW_IND | VARCHAR2 1 | Indicates if a student has withdrawn in the given term. Y = Student withdrew; otherwise null. |
| HOME_ADDRESS_LINE1 | VARCHAR2 55 | First line of home address. |
| HOME_ADDRESS_LINE2 | VARCHAR2 55 | Second line of home address. |
| HOME_ADDRESS_LINE3 | VARCHAR2 55 | Third line of home address. |
| HOME_ADDRESS_LINE4 | VARCHAR2 55 | Fourth line of home address. |
| HOME_CITY | VARCHAR2 30 | City of home address. |
| HOME_STATE | VARCHAR2 6 | State of home address. |
| HOME_COUNTY | VARCHAR2 30 | County of home addresses in Wisconsin. |
| HOME_ZIP_CODE | VARCHAR2 12 | Zip code of home address. |
| HOME_COUNTRY_CODE | VARCHAR2 3 | Country of home address. |
| HOME_COUNTRY_DESCR | VARCHAR2 30 | Full name of home country. |
| HOME_PHONE1 | VARCHAR2 24 | Telephone number at student’s home address. |
| HOME_EXTENSION1 | VARCHAR2 6 | The number of the phone extention (if present) for the principal telephone number associated with the home address. |
| HOME_PHONE2 | VARCHAR2 24 | Telephone number of the second phone number associated with the home address. |
| HOME_EXTENSION2 | VARCHAR2 6 | The number of the phone extension for the second phone (if present) associated with the home address. |
| HOME_FAX | VARCHAR2 24 | The fax number associated with the student’s home address. |
| MAIL_ADDRESS_LINE1 | VARCHAR2 55 | First line of mailing address. |
| MAIL_ADDRESS_LINE2 | VARCHAR2 55 | Second line of mailing address. |
| MAIL_ADDRESS_LINE3 | VARCHAR2 55 | Third line of mailing address. |
| MAIL_ADDRESS_LINE4 | VARCHAR2 55 | Fourth line of mailing address. |
| MAIL_CITY | VARCHAR2 30 | City of mailing address. |
| MAIL_STATE | VARCHAR2 6 | State of mailing address. |
| MAIL_COUNTY | VARCHAR2 30 | County of mailing address for Wisconsin addresses. |
| MAIL_ZIP_CODE | VARCHAR2 12 | Zip code of mailing address. |
| MAIL_COUNTRY_CODE | VARCHAR2 3 | Country of mailing address. |
| MAIL_COUNTRY_DESCR | VARCHAR2 30 | Full name of the mailing address country. |
| MAIL_PHONE1 | VARCHAR2 24 | Telephone number at student’s mailing address. |
| MAIL_EXTENSION1 | VARCHAR2 6 | The number of the phone extension (if present) for the principal telephone number associated with the mailing address. |
| MAIL_PHONE2 | VARCHAR2 24 | Telephone number of the second phone number associated with the mailing address. |
| MAIL_EXTENSION2 | VARCHAR2 6 | The number of the phone extension for the second phone (if present) associated with the mailing address. |
| MAIL_FAX | VARCHAR2 24 | The fax number associated with the student’s mailing address if present. |
| PREFERRED_PHONE | VARCHAR2 24 | The preferred contact phone number as indicated by the student. In many cases this is a cell-phone number. |
| EMAIL_ADDRESS | VARCHAR2 70 | The student email address displayed is based on the ISIS email address identified as ‘preferred’ by the student. |
| BIRTHDATE | VARCHAR2 8 | Student’s date of birth. |
| AGE | VARCHAR2 2 | Student age as of August 31 in Fall, January 31st in Spring, and May 31 in summer. |
| EXTRACT_DATE_TIME | VARCHAR2 17 | The date and time these data were extracted from ISIS. Format: YYYYMMDD HH24:MI:SS. |