- DATA VIEW NAME
- STDNT_SELF_REPORT_STUDY
- OVERVIEW
- This data view details the self reported high school course work that will be completed through a students senior year from the ACT or SATI exam. This information is optional when completing the ACT or SATI exams. This view reports data by exam type (ACT or SAT) and by exam date. Students can update/modify their self reported data each time the take the ACT or SATI exam.
- LOAD FREQUENCY
- The data in this view is refreshed daily.
- DATA CUSTODIAN
- Undergraduate Admissions Office
Contact: David Leszczynski - 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 - Please note the high school course work has different values depending on which exam the information came from.
Valid values: -
Data Source Subject Code Subject Descr ACT EN English ACT MA Mathematics ACT SS Social Studies ACT NS Natural Sciences ACT FS Foreign Language (Spanish) ACT FG Foreign Language (German) ACT FF Foreign Language (French) ACT FO Foreign Language (Other) ACT BC Business or Commercial ACT VO Vocational-Occupational SAT Arts and Music SAT English SAT Foreign and Classical Languages SAT Mathematics SAT Natural Sciences SAT Social Sciences and History - QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 04/2005 – 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 |
|---|---|---|
| *SELF_REPORT_STUDY_KEY | NUMBER(15) | A unique identifier that is system generated. A surrogate key. It is based on ID, Test_Date and Subject_Descr and Data_Source. |
| PROSPECT_KEY | NUMBER(15) | Surrogate key of prospect table. Match this key on this table to same key on Ugrd_Prospect view. |
| ID | VARCHAR(11) | ISIS personal Identifier. It 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. |
| TEST_DATE | DATE | The date the student took the ACT or SATI. |
| SUBJECT_CODE | VARCHAR(2) | Code for the ACT high school subject. This field will be null for SAT reported high school courses. Valid values: Blank = Arts & Music, English, Foreign & Classical Languages, Mathematics, Natural Sciences, Social Sciences & History BC = Business or Commercial EN = English FF = Foreign Language (French) FG = Foreign Language (French) FO = Foreign Language (French) FS = Foreign Language (French) MA = Mathematics NS = Natural Sciences SS = Social Studies VO = Vocational-Occupational |
| SUBJECT_DESCR | VARCHAR(50) | Description of the high school course. |
| DATA_SOURCE | VARCHAR(3) | Code indicating on which exam the high school course information was reported. Valid values: ACT SAT |
| YEARS_STUDIED_CODE | VARCHAR(1) | Projected number of years studied through high school graduation. ACT and SAT have different coding for the number of years studied. Valid values: 0 = blank 1 = Half year 2 = One year 3 = 1 1/2 years 4 = 2 years 5 = 2 1/2 years 6 = 3 years 7 = 3 1/2 years 8 = 4 or more years 9 = Did not take any course in the subject A = 1/2 year B = 1 year C = 2 years D = 3 years E = 4 years F = More than 4 years N = None Y = blank |
| YEARS_STUDIED_DESCR | VARCHAR(50) | Description of the number of years studied through high school graduation. ACT and SAT have different descriptions for the number of years studied. |
| SAT_HONORS | VARCHAR(1) | The SAT questionnaire allows students to report if they attained an honors level in the high school subject area. All ACT self reported information will be null for this field. Valid values: null B C D E F N Y |
| EXTRACT_DATE_TIME | DATE | The date and time these data were extracted. Format : YYYYMMDD HH24:MI:SS |