- DATA VIEW NAME
- STDNT_PREV_INSTITUTIONS_CODES
- OVERVIEW
- This view contains current valid codes for high school and post-secondary institution students who may have previously attended. Use this view to look up valid institution codes and to join with other admissions data views to retrieve an institution’s descriptive name or address.
- LOAD FREQUENCY
- This data is refreshed once a week.
- DATA CUSTODIAN
- Undergraduate Admissions Office
Contact: David Leszczynski - AUTHORIZATION
- No approval signature is required by the Data Custodian to receive
authorization to access this data view. For information about how to get authorized for InfoAccess data views, connect to InfoAccess Home Page - SPECIAL
CONSIDERATIONS - None.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 01/2001 New view created.
10/2001 View create to use varchar2 data type and conformed data element names(c4j)
06/2003 Data 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 |
|---|---|---|
| *PREV_INSTITUTION_CODE | VARCHAR2(11) | dentification code assigned to an institution previously attended. |
| PREV_INSTITUTION_LONG_DESCR | VARCHAR2(50) | Name of the institution. |
| PREV_INSTITUTION_SHORT_DESCR | VARCHAR2(10) | First 10 characters of the institution name. |
| ADDRESS1 | VARCHAR2(35) | First line of the institution address. |
| ADDRESS2 | VARCHAR2(35) | Second line of the institution address. |
| ADDRESS3 | VARCHAR2(35 | Third line of the institution address. |
| ADDRESS4 | VARCHAR2(35 | Fourth line of the institution address. |
| CITY | VARCHAR2(30 | City where the institution is located. |
| COUNTY | VARCHAR2(30 | County where the institution is located. |
| STATE | VARCHAR2(6 | State where the institution is located. |
| POSTAL | VARCHAR2(12 | Zip Code of the institution. |
| COUNTRY | VARCHAR2(3) | County code where the institution is located. |
| EXTRACT_DATE_TIME | DATE | The System generated date when the data was last refreshed. Format: mm/dd/ccyy. |