ALUMNI DEGREE PLAN

DATA VIEW NAME: ALUMNI_DEGREE_PLAN
OVERVIEW: This view contains academic plan information for each individual who received a degree of the University and who has a constituent type of 1 or 2. This includes all those who have an electronic student record as well as many who graduated prior to 1970 and have a paper student record. Deceased individuals are identified in the UW-ALUMNI_DEMOGRAPHIC data view.
LOAD FREQUENCY: Data is loaded each weekend.
DATA CUSTODIAN: Registrar’s Office
Contact: Phill 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: There are no special considerations.
QUESTIONS: Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357)
LAST UPDATED: 01/2001 New Data 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
*EMPLID	VARCHAR2 (11)	The EMPLID (also known as ISIS ID) is generated by the ISIS system. EMPLID is a unique identifier for an individual and will never be changed throughout the individual’s relationship with the University. This is not the same as Campus_ID or RARS_ID.
DEGREE	VARCHAR2 (8)	UW-Madison offers over 300 unique degrees. This is the code associated with the individual’s specific degree(s). An individual may have more than one degree. A list of degree codes is attached in the appendix of the documentation for data view uw.alumni_degree.
STDNT_DEGR	VARCHAR2 (2)	This is the number of the degree. The degrees are numbered sequentially, so that 01 is generally the first degree received. This field is used primarily to link to the UW-Alumni_Degree data view.
ACAD_PLAN	VARCHAR2 (10)	In this data view, only three of the ten characters of the ISIS Academic Plan are being used. For alumni with an electronic student record, this field is not the actual the ACAD_PLAN recorded in ISIS, but rather reflects the major code embedded in the academic plan code. Thus, it is also the major code for those alumni who do not have an electronic record. A list of codes is in the appendix.
DESCR	VARCHAR2(100)	This is the description of the academic plan/major that appears on the transcript; In most instances this description will include only the subject area, but in some cases may have the degree embedded in the description.
ACAD_PLAN_TYPE	VARCHAR2 (3)	Valid Values are: CON = Concentration CRT = Certificate HON = Honors MAJ = Major MIN = Minor NON = No Plan Associated PRP = Preparation RTC = ROTC SP = Specialization Certificate
EXTRACT_DATE_TIME	DATE	Date and time of the most recently extracted data from the ISIS database.

APPENDIX:

Major codes sorted alphabetically

Major Code Descr

004 Accounting
009 Actuarial Science
013 Adult Education
015 Advertising
018 African Languages & Lit
020 Afro-American Studies
022 Agricultural Business Mgmt
029 Agricultural Chemistry
027 Agricultural Economics
031 Agricultural Education
036 Agricultural Engineering
040 Agricultural Extension
045 Agricultural Journalism
047 Agricultural Mech & Mgmt
054 Agronomy
056 American Civilization
058 American Institutions
061 Analytical Clinical Chem
063 Anatomy
067 Anthropology
069 Apparel Design
072 Applied Math, Engr & Physics
074 Appraisal
076 Arabic
081 Art
085 Art Education
090 Art History
091 Arts Administration
092 Asian Studies
094 Astronomy
097 Astronomy – Physics
099 Bacteriology
100 Behavioral Cybernetics
101 Behavioral Disabilities
102 Behavioral Science & Law
106 Biochemical Engineering
103 Biochemistry
108 Biological Aspects of Cons
112 Biology
115 Biomedical Engineering
117 Biophysics
121 Botany
126 Botany & Zoology
130 Buddhist Studies
133 Business
132 Business & Engineering
135 Business Construction Admin
136 Business Diversified
140 Business Statistics
144 Business Teacher Education
146 Cartography
148 Chemical Engineering
153 Chemistry
157 Chemistry Course
162 Chemistry Course & Educ
168 Child Dvlpmnt & Pre-School
166 Child Dvlpmnt-Family Rel
171 Chinese
185 Civil & EnvEngr & ConstrAdm
175 Civil Engineering
180 Civil Engr & City Planning
189 Classics
193 Commerce
211 Communic & Public Address
203 Communic Arts – Com&PA
204 Communic Arts – Educ
205 Communic Arts – R&TV&F
207 Communic Arts – Theatre
201 Communication Arts
216 Communicative Disorders
225 Comparative Literature
227 Computational Meth & Stat
229 Computer Sciences
231 Conservation
998 Construction Technology
230 Construction Technology-Ag
232 Consumer Services in Foods
233 Continuing & Vocational Educ
238 Cooperative Extension-Adm
240 Cooperative Extension-Edu
234 Cooperative Extension-HomeEc
235 Correctional Administration
241 Counseling & Behavioral St
940 Counseling & Behavioral St
239 Counseling & Guidance
242 Curriculum & Instruction
172 Dairy & Food Industry
251 Dairy & Food Industry
246 Dairy Husbandry
249 Dairy Industry
247 Dairy Science
248 Dance
243 Dance – Applied
245 Dance – Therapy
244 Dance Teaching
250 Development
253 Dietetics
255 Distributive Education
258 Earth Science
259 East Asian Lang & Lit
261 Economics
292 Education & Biology
297 Education & Botany
306 Education & Business
301 Education & Chemistry
305 Education & Com Arts
369 Education & Com Arts
308 Education & Economics
310 Education & English
315 Education & French
319 Education & Geography
324 Education & Geology
328 Education & German
333 Education & History
337 Education & Home Economics
339 Education & Journalism
340 Education & Latin
342 Education & Library Sci
346 Education & Mathematics
348 Education & Music
355 Education & Physical Therapy
351 Education & Physics
357 Education & Political Sci
360 Education & Rural Sociology
362 Education & Sociology
364 Education & Spanish
265 Education & Speech
373 Education & Zoology
378 Education Curric & Instruc
270 Educational Administration
279 Educational Policy Studies
283 Educational Psychology
382 Electrical Engineering
387 Elementary Education
391 Endocrinology
400 Engineering Mechanics
396 Engineering w/o Designation
405 English
409 Entomology
411 Environmental Design
413 Environmental Monitoring
414 Experimental Foods
416 Family & Consumer Econ
418 Family Economics
423 Finance, Invest & Banking
427 Floriculture
430 Food Administration
436 Food Science
432 Foods & Nutrition
443 Forest Science
441 Forestry
445 French
450 French Area Studies
454 General Home Economics
459 Genetics
461 Genetics – Medical(L&S)
463 Geography
468 Geology
470 Geology & Geophysics
472 Geophysics
477 German
480 Grain Market & Proc Indust
481 Greek
486 Guidance & Counseling
489 Health Services Admin
488 Health Services Fiscal Mgmt
490 Hebrew
497 Hebrew & Semitic Studies
495 Hebrew Studies
499 History
504 History & History of Sci
513 History & Soc St of Pharm
508 History of Culture
517 History of Science
524 Home Economics – Gen Prof
522 Home Economics Education
526 Home Economics Journalism
531 Horticulture
536 Hospital Pharmacy
540 Housing
546 Human Biology
544 Humanities
542 Humanities Classical
543 Humanities Modern
551 Hydraulics
553 Ibero-American Studies
556 Indian Languages & Lit
558 Indian Studies
560 Individual Major
562 Industrial Education
564 Industrial Engineering
567 Industrial Relations
569 Information Systems
571 Institution Management
570 Institutional Admin
572 Intelligent Systems
574 Interior Design
575 International Business
576 International Relations
580 Italian
583 Japanese
585 Journalism
589 Journalism & Education
591 Journalism Education
593 Land Resources
594 Landscape Architecture
598 Latin
603 Law
605 Law Enforcement
607 Legal Institutions
612 Library Science
621 Linguistics
999 Major Unknown
623 Management
625 Marketing
630 Mass Communications
632 Materials Science
634 Mathematics
639 Meat & Animal Science
643 Mechanical Engineering
647 Medical Bacteriology
648 Medical Genetics-L&S only
652 Medical Microbiology
657 Medical Science
661 Medical Technology
666 Medicine
670 Metallurgical Engineering
675 Meteorology
679 Mining Engineering
684 Molecular Biology
690 Music
688 Music – Applied
696 Music – Ethnomusicology
691 Music – History
698 Music – History & Theory
700 Music – M.A.
692 Music – Theory
693 Music & Education
694 Music Composition
695 Music Conducting
697 Music Education
699 Musicology
701 Natural Resources
702 Natural Science
706 Naval Science
709 Neurophysiology
710 Neurosciences
000 No Major Code
711 Nuclear Engineering
718 Numerical Analysis
712 Nursing
715 Nursing
716 Nutrition
717 Nutritional Sciences
720 Occupational Therapy
721 Ocean Engineering
722 Oceanography & Limnology
724 Oncology
729 Operations Research
731 Organization & Management
733 Pathology
737 Pharmaceutical Biochemistry
742 Pharmaceutical Chemistry
746 Pharmaceutics
749 Pharmacology – Med
751 Pharmacology – Pharmacy
756 Pharmacy
758 Pharmacy (Continuing Ed)
760 Pharmacy Administration
765 Philosophy
772 Physical Educ Men Non-cert
768 Physical Education
769 Physical Education Men
774 Physical Education Women
778 Physical Medicine – Therapy
780 Physician Assistant
783 Physics
787 Physiological Chemistry
792 Physiology
794 Plant Breeding & Plant Gen
796 Plant Pathology
801 Polish
805 Political Science
810 Portuguese
814 Poultry Science
819 Pre-School Kindergarten Ed
826 Pre-veterinary
816 Production
817 Program Administration
829 Program Administration
832 Psychology
834 Public Management
836 Public Policy & Admin
841 Public Utilities & Trans
846 Quantitative Analysis
850 Radio & Television & Film
855 Radiology
858 Real Estate
859 Real Estate & Urb Land Econ
864 Recreation Leadership
861 Recreation Resources Mgmt
860 Recreational Resrch & Mgmt
866 Regional Planing & Envir
868 Rehabilitation Counseling
873 Related Art
877 Retailing
882 Risk & Insurance
886 Rural Sociology
891 Russian
900 Scandinavian Studies
904 Science Education
913 Slavic Languages
915 Social Studies
914 Social Studies in Pharmacy
916 Social Welfare
918 Social Work
922 Sociology
927 Sociology-Correctional Adm
931 Soil Science
932 South Asian Language & Lit
934 South Asian Studies
933 Space Engineering & Sci
936 Spanish
942 Special Committee Major
945 Speech
949 Statistics
953 Statistics – Ugrad
956 Systems Research
958 Textile Science
963 Textiles & Clothing
968 Theatre
971 Theatre & Drama
974 Transportation & Publ Util
979 Urban & Regional Planning
983 Veterinary Science
987 Water Chemistry
989 Water Resources Management
991 Wildlife Ecology
990 Wildlife Management
995 Zoology