- DATA VIEW NAME
- STDNT_SELF_REPORT_ACTIVITY
- OVERVIEW
- This view lists the self reported activity information from the ACT and SATI exams. This information is optional for the student to complete. This view contains all activities reported on all ACT and SATI exams submitted to UW Madison. The ACTIVITY_LEVEL field reports if the activity was participated in while in high school or if it is an activity that the student desires to participate in at the university.
- 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 - None.
- 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_ACTIVITY_KEY | NUMBER(15) | A unique identifier that is system generated. A surrogate key. It is based on ID, Test_Date, and Activity_Code, Activity_Level 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 | VARCHAR2(11) | ISIS EmplID |
| TEST_DATE | DATE | Date of the ACT or SATI exam. |
| ACTIVITY_CODE | VARCHAR2(2) | ACT or SATI Activity Code. |
| ACTIVITY_DESCR | VARCHAR2(50) | Description of the ACT or SATI Activity. |
| ACTIVITY_LEVEL | VARCHAR2(3) | Code indicating if the activity was participated in while in high school or if the student desires to participate in the activity at the university. Valid values: COL = College HS = High School |
| DATA_SOURCE | VARCHAR2(3) | Code indicating the test the activity was reported on. Valid values: ACT SAT |
| SAT_HS_OFFICER_AWARD_IND | VARCHAR2(1) | The SATI exam allows students to report if they held an office or received an award for their high school activities. Valid Values: Y = held an office or received an award C = |
| EXTRACT_DATE_TIME | DATE | The date and time these data were extracted. Format : YYYYMMDD HH24:MI:SS |