- DATA VIEW NAME
- STDNT_HIGH_SCHOOL_CODES
- OVERVIEW
- This view contains all high school codes and is maintained by the Admissions Office. This view can be used to look up valid high school codes. It can also be joined with other views to get high school name or address.
- LOAD FREQUENCY
- The data is refreshed every Saturday.
- 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 the InfoAccess Home Page - SPECIAL
CONSIDERATIONS - None
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 09/1999 Data view created.
10/2001 View create to use varchar2 data types and conformed data element names.
06/2003 Data Custodian change. - 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 |
|---|---|---|
| *HIGH_SCHOOL_CODE | VARCHAR2 (11) | Identification number assigned to a high school |
| HS_LONG_DESCR | VARCHAR2 (50) | Name of High School. |
| HS_SHORT_DESCR | VARCHAR2 (10) | First 10 characters of the High School name. |
| HS_ADDRESS1 | VARCHAR2 (35) | First line of High School address. |
| HS_ADDRESS2 | VARCHAR2 (35) | Second line of High School address. |
| HS_ADDRESS3 | VARCHAR2 (35) | Third line of High School address |
| HS_ADDRESS4 | VARCHAR2 (35) | Fourth line of High School address |
| HS_CITY | VARCHAR2 (30) | City of High School |
| HS_COUNTY | VARCHAR2 (30) | County of High School |
| HS_STATE | VARCHAR2 (6) | State of High School |
| HS_POSTAL | VARCHAR2 (12) | Zip Code of High School |
| HS_COUNTRY | VARCHAR2 (3) | Country code of High School |
| EXTRACT_DATE_TIME | DATE | The System generated date when the data was last refreshed. Format: mm/dd/ccyy. |