- DATA VIEW NAME
- STDNT_RESTRICTED
- OVERVIEW
- This view contains the “restricted” student information(primary/legal name) for each student registered from Summer 1986 and beyond. There will be one row for each student registered in the term.
A FERPA indicator is provided in this view and it is the user’s responsibility to check this indicator if the information is being considered for release.
- LOAD FREQUENCY
- Data will be refreshed every morning.
- DATA CUSTODIAN
- Office of the Registrar
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 the InfoAccess Home Page
- SPECIAL
CONSIDERATIONS - Authorization for this view will be limited to individuals who can demonstrate a university business or legal need that requireds the use of primary/legal name in a manner consistent with the campus preferred name policy.
Specifically, it is the policy of the University of Wisconsin-Madison that any faculty, staff, or student may choose to identify themselves within the university community with a preferred first and/or middle name that differs from their legal name.
As long as the use of the preferred first and/or middle name is not for the purpose of misrepresentation, it will appeaar ionstead of the person’s legal name in university related systems and documents except where the user of the legal name is required by university busniess or legal need.
Preferred name will be used in cases where legal name is not absolutely necessary.
For information see https://registrar.wisc.edu/preferred_name.htm or contact the data custodian.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 02/2016 – 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 |
|---|---|---|
| *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) | 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. |
| NAME | VARCHAR2(50) | Student’s primary name (last, first, middle with no space between last and first names). |
| NAME_LAST | VARCHAR2(30) | Student’s primary/legal last name. |
| NAME_FIRST | VARCHAR2 30 | Student’s primary/legal first name. |
| NAME_MIDDLE_LEGAL | VARCHAR2 30 | Student’s primary/legal middle name. |
| EFFECTIVE_DATE | DATE | |
| FERPA_FLAG | VARCHAR2(1) | Restricted information indicator. Y = information restricted. |
| EXTRACT_DATE_TIME | VARCHAR2(17) | The date and time these data were extracted from ISIS. Format: YYYYMMDD HH24:MI:SS. |