- DATA VIEW NAME
- RETENTION_DROP_HISTORY
- OVERVIEW
- This view contains drop information for all students in all UW-Madison courses in all terms since the summer term of the 1995-96 academic year (Term 0996). Every section a student dropped after the drop/withdraw deadline (DRW_Date) will be present in this view. The drops in this view are those that will show as notations on the transcripts.
- NOTE: A student can drop a course section and complete another section in the same course. Dropping one course section does not necessarily mean the student dropped the entire course.
- LOAD FREQUENCY
- Information is completely replaced the 3rd of each month.
- DATA CUSTODIAN
- Office of the Registrar
Contact: 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
- SPECIAL
CONSIDERATIONS - When using this view with the Course History view, please note for example, that while lecture, lab, and discussion sections for a given course and student are all listed on the same row in the Course History view, they will be listed on three separate rows in this view.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 12/2001– New view created.
11/2002 – Changed Load Frequency.
11/2007 – Corrected a number of problems.- Change the Census_Date to the DRW_Date.
- Correct data view to show only drops after the DRW deadline.
- Pad course_number and course_section with leading zeros.
- Populate the Academic_Level field.
- Correct documentation errors
09/2012 – Data Custodian Contact changed from Karen Hanon to Kim Alling
11/2014 – Preferred name policy s8w. - 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 |
|---|---|---|
| *TERM | varchar2 (4) | The code for the academic year and semester. |
| TERM_DESCR | varchar2 (30) | Description of the code for the academic year and semester. |
| *ID | varchar2 (11) | A personal Identifier. 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. |
| CAMPUS_ID | varchar2 (16) | A unique student identifier (10 digits). Campus_ID may change at the student’s request. |
| ACADEMIC_LEVEL | varchar2(3) | The student’s academic level at the beginning of the given term. Values are: 05 = Spcl, Guest 10 = Freshman 20 = Sophomore 30 = Junior 40 = Senior CRT = Certification Special GR = Graduate NDG = Non-Degree Student (discontinued Fall 1999) P1 = Professional Year 1 P2 = Professional Year 2 P3 = Professional Year 3 P4 = Professional Year 4 SH = High School Specials (discontinued Fall 1999) |
| CURRICULAR_GROUP | varchar2 (5) | The Curricular Group (College or School) associated to the department offering the course. Note: the code values for this field are the same as that for a student’s Academic Group (the School or college associated to the student’s Academic Program). Join to the data view ACADEMIC_GROUP_CODES for descriptions. Values are: ALS = Agricultural and Life Sciences BUS = School of Business DCS = Division of Continuing Studies EDU = School of Education EGR = College of Engineering IES = Institute for Environmental Studies L&S = College of Letters & Science LAW = School of Law MED = School of Medicine NUR = School of Nursinng PHM = School of Pharmacy VET = School of Veterinary Medicine CIC = Committee on Institutional Cooperation HEC = School of Human Ecology MSN = UW-Madison (This value indicates that the student’s Plan is linked to a career rather than a program.) |
| COURSE_ID | varchar2 (6) | A unique identifier that links each course offered in a given semester to an entry in the Course Catalog table. The COURSE_ID is the same for cross-listed courses. |
| *CLASS_NUMBER | varchar2 (5) | Uniquely identifies each section of a course within a given term. |
| COURSE_OFFER_NUMBER | varchar2 (2) | Uniquely identify the course in the particular session. |
| SUBJECT_DESCR | varchar2 (30) | The name of the department offering the course. |
| SUBJECT_CODE | varchar2 (8) | The code for the department offering the course. |
| COURSE_TITLE | varchar2 (30) | The title of the course. |
| CATALOG_NUMBER | varchar2 (10) | The number assigned to the course in the course catalog. Also known as the Course number. |
| ENROLL_ADD_DATE | date | The date the student enrolled in the course. |
| ENROLL_DROP_DATE | date | The date the student dropped the course. |
| DRW_DATE | date | This is the last day to drop courses or withdraw without notations on the transcript. This date can be different for different sessions. |
| *SESSION_CODE | varchar2 (3) | Indicates the type of session, such as A1= Regular session, 6W1= The first 6 week session of a term, etc. |
| SESSION_START_DATE | date | The date the session started. |
| SESSION_END_DATE | date | The date the session ended.. |
| CREDITS_TAKEN | Number (8,3) | The number of credits the student receives for taking the course. |
| GRADING_BASIS | varchar2 (3) | The basis on which the student is graded in this course. Values are: GRD = Regular letter grade A, AB, B etc. GRN = Graded/no GPA calculated PF = Pass/Fail AUD = Audit CNC = Credit/No Credit SUS = Satisfactory/Unsatisfactory ADM = Administrative grading NCA = No Credit Associated NOG = No Grade Associated NON = Non-Graded Component NUM = Numeric Grading TRN = Transfer Grading WDR = Withdrawal-Retroactive OPT = Student Option. |
| INCLUDE_IN_GPA_IND | varchar2 (1) | Indicates if the grade points are included in the student’s GPA. Values are: Y = Yes; other wise not populated. |
| COURSE_SECTION_TYPE | varchar2 (3) | Values are: LEC = Lecture LAB = Lab DIS = Discussion IND = Independent Study SEM = Seminar FLD = Field Study CON = Continuance THE = Thesis Research SUP = Supervision CLN = Clinical RG1 = Range 1 section (only for courses prior to 0996–typically, RG1 denoted the Lecture section) RG2 = Range 2 section (only for courses prior to 0996–typically, RG2 denoted the Discussion section) RG3 = Range 3 section (only for to courses prior to 0996–typically, RG3 denoted the Lab section) |
| COURSE_SECTION | varchar2 (4) | The course section number. |
| INSTRUCTOR_ID | varchar2 (11) | The ID of the instructor for the section. In the case of multiple instructors, the one listed is the “primary” instructor. |
| INSTRUCTOR_NAME | varchar2 (50) | The preferred name of the instructor for the section, starting in term 1142. Prior to the fall of 2014 it shows the primary/legal name. In the case of multiple instructors the one listed is the “primary” instructor. |
| EXTRACT_DATE_TIME | date | The date and time these data were extracted. |