- DATA VIEW NAME
- RETENTION_AWARDS_SUBPLAN
- LOAD FREQUENCY
- Data is completely replaced each weekend.
- DATA CUSTODIAN
- Office of the Registrar – 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 the InfoAccess Home Page
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- O4/2001 – New view created.
11/2002 – Changed Load Frequency Information
02/2012 – c4j Custodian Change - COLUMN DEFINITIONS
- Primary Key columns are identified with an asterisk(*)
Column Formats describe the data type and length.VARCHAR2( N) – Alphanumeric data. (N) = length. Contains letters and/or numbers.
Example: VARCHAR2 (5) could contain ‘ABC12’ or ‘12345’ or ‘ABCDEF’NUMBER(N) – Numeric data. (N) = length. Contains only numbers. Numbers with decimal points are represented as NUM (X,Y) X = total number of digits Y = the number of digits after the decimal
Examples: NUMBER (6,2) could contain 2500.12 NUMBER (6) could contain 000005 or 550000DATE (XXXX) – Date can be in various formats and date functions available based on your query tool can be used against the date..
Examples: DATE (YYMMDD); DATE (YYDDD); DATE (DD-MM-YY)
| Column Name | Format | Description |
|---|---|---|
| *ID | Varchar2 (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.
Note: Some Award recipients in this view may not appear in the other Retention data views if they have not been enrolled in a course at UW-Madison since 1985. |
| *AWARD_NUMBER | Varchar2 (2) | A number indicating the particular award in sequence of UW-Madison awards conferred on the student. |
| *AWARD_PLAN_CODE | Varchar2 (10) | The Academic Plan associated to the award. For Plans of type MAJ this represents the student’s Major field of study. |
| *AWARD_SUBPLAN_CODE | Varchar2 (10) | Students may have one or more Subplan associated to their Plan. Only Plans of type MAJ or MIN will have Subplans. |
| AWARD_SUBPLAN_DESCRSHORT | Varchar2 (10) | Short Description of Subplan |
| AWARD_SUBPLAN_DESCR | Varchar2 (30) | Long Description of Subplan |
| AWARD_SUBPLAN_TYPE | Varchar2 (3) | Subplans are grouped by their relation to the Plan. Values are: OPT = Option HON = Honors |
| EXTRACT_DATE_TIME | Date | The date and time these data were extracted from ISIS. Format : YYYYMMDD HH24:MI:SS |