- DATA VIEW NAME
- STDNT_ID_CROSSWALK_MULTITERM
- OVERVIEW
- This view contains ID, Campus ID and SSN for all students enrolled in either the prior two terms, the current term or up to two future terms. It will be used in conjunction with other data views by administrative offices when the SSN or Campus ID is necessary.
- LOAD FREQUENCY
- Data will be refreshed nightly (Monday through Friday).
- 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
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 09/2001 – New view created.
02/2012 – c4j Custodian Change. - DATA FORMAT
- 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 | Varchar (4) | The ISIS code for the academic year and semester. |
| *ID | Varchar (11) | ISIS personal Identifier. The ID 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 | Varchar (16) | ID number assigned to ISIS to be used by student. Only ten characters are used. |
| SSN | Varchar (15) | Student’s social security number. In ISIS this is known as the National ID (NID). Only 9 characters are in use |
| Extract_Date_Time | Date | The date and time these data were extracted. Format: YYYYMMDD HH24:MI:S |