- DATA VIEW NAME
- CDR_POST_TERM
- OVERVIEW
- Provides the degree and awards data submitted by UW-Madison for purposes of the CDR (Central Data Request) requested by UW System Administration. The dataview contains data for each of the four (4) most recent terms (since Fall 1999). For many of the data elements, UW-Madison data has been re-coded and/or re-defined to conform to the CDR specifications.
- LOAD FREQUENCY
- This view is updated on request by the Registrar’s Office. New terms are typically added 8 to 12 weeks AFTER the end of the term. Sometimes, preliminary versions may be loaded before that time.
- DATA CUSTODIAN
- Contact: Phillip Hull, Registrar’s Office
- 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 - QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 5/2000 – New view crested.
5/2002 – Added Extract_Dtae_Time filed.
10/2012 – Added First Name, Middle Name, and Last Name - 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 |
|---|---|---|
| * CDR_YEAR_SEM | VARCHAR2(4) | The starting year, ending year and semester a student is enrolled at UW-Madison the first 2 digit ‘YY’ is the starting year the third ‘Y’ is the ending year the semester value are: 1 = Fall semester 2 = Spring semester S = Summer sessionExamples: Summer 1999-2000 value is ‘990S’ Fall 2000-2001 value is ‘0011’ |
| UNIT | VARCHAR2(1) | A one-character code indicating one of the fourteen possible institutions. “A” always submitted for Madison campus |
| DIVISION | VARCHAR2(2) | The level of organization immediately under that of Unit for the UW-centers. Blank for Madison Campus as this is for UW-centers only. |
| * EMPLID | VARCHAR2(11) | Emplid for this entity |
| SSN | VARCHAR2(9) | A nine-digit unique number assigned by the Social Security Administration or other proper authorities. Contains the first 9 digits of the CampusID in the event a student does not have a valid Social Security Number. |
| FIRST_NAME | VARCHAR2(30) | Student’s first name |
| MIDDLE_NAME | VARCHAR2(30) | Student’s middle name |
| LAST_NAME | VARCHAR2(30) | Student’s last name |
| BIRTHDATE | VARCHAR2(6) | |
| DEGREE1 | VARCHAR2(5) | |
| DEGREE2 | VARCHAR2(5) | |
| TEACHER_CERT | VARCHAR2(1) | Indicates whether or not a student has completed a teacher education program which meets teacher certification requirements in the current term being reported. “Y” = Yes “N” = No (blank) is set for students with a CLASSIFICATION of “S” or “T” |
| WITHDRAWAL_DATE | VARCHAR2(4) | The first two digits of the code represent the month (01 thru 12) and the last two digits of the code represent the day of the month. |
| MAJOR1 | VARCHAR2(5) | |
| MAJOR2 | VARCHAR2(5) | |
| GENDER | VARCHAR2(1) | |
| RACE | VARCHAR2(1) | |
| TUITION_RESIDENCY | VARCHAR2(1) | |
| CITIZENSHIP | VARCHAR2(1) | |
| MATH_REMEDIAL_COMP | VARCHAR2(1) | Indicates whether or not a student who was identified as needing a remedial math course, successfully completed all their remedial math requirements. “Y” = Yes “N” = No |
| ENGL_REMEDIAL_COMP | VARCHAR2(1) | Indicates whether or not a student who was identified as needing a remedial English course, successfully completed all their remedial English requirements. “Y” = Yes “N” = No |
| ETHNIC_SUB_CODE | VARCHAR2(1) | |
| EXTRACT_DATE_TIME | DATE | The date and time the data was last extracted from the source system. |
| LOAD_DATE | DATE | System generated date representing when the data was lasts loaded into the data warehouse. |