- DATA VIEW NAME
- DEPT_PROFILE_CREDIT_GEN
- OVERVIEW
- This data view provides department profile information for credit-generating departments to support budget-making decisions and program review. For selected academic departments, it contains summary credit, enrollment, research award, and payroll FTE data by department over time. Selected non-credit-generating departments are summarized in a separate view: (DEPT_PROFILE_NON_CREDIT_GEN).
Data is organized by UDDS, fiscal year, semester, and level of summary. Level of summary must always be included as a field in the query to obtain appropriate results. For analysis at the individual department level, include only those rows with level_of_summary=1. For analysis at the school or college level, level_of_summary=3 will provide a summary at the school/college level for all departments contained in the view. Level_of_summary=2 provides summary data for all departments within a discipline and school/college (for example, Humanities within the School of Education).
Data is included beginning with fiscal year 1990. (For some fields, data is available since 1993-94. See field descriptions below.)
In most cases, data for obsolete departements is reported with the department where they are currently affiliated. For example, Wildlife Ecology (A0769) was merged with Forestry(A0764) in 2009. All credits, degrees, enrollments, FTE’s, etc. for both Forestry and Wildlife Ecology for all years are reported in the new department of Forest and Wildlife Ecology (A0764).
Additional information about the fields contained in this view is available on the Academic Planning and Institutional Research website at: http://apir.wisc.edu/deptplanningprof.htm.
- LOAD FREQUENCY
- This data is reloaded each time the Department Profile is run for credit-generating departments, toward the end of each semester and summer session. Typically this occurs 5/1, 8/2, and 12/1. The data is replaced each time
- DATA CUSTODIAN
- Allison La Tarte, Office of Academic Planning and Institutional Research.
- 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 InfoAccess Home Page
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 12/01 – New view created.
09/14 – Revised to include 101 funds separately and to exclude reporting of Honors and General education credits. - 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 |
|---|---|---|
| *LEVEL_OF_SUMMARY | varchar2(1) | Valid values: 1 = department 2 = discipline 3 = division (school/college) |
| *DISCIPLINE | varchar2(1) | Valid values for L&S departments: H = Humanities N = Natural Sciences O = Other S = Social Sciences. Valid values for non-L&S departments: 1 = Social & Behavioral Sciences 2 = Humanities 3 = Engineering & Physical Sciences 4 = Agriculture & Life Sciences 5 = Health Sciences P = Professional schools. |
| *FISCAL_YEAR | varchar2(4) | Includes century (e.g., 1999) |
| *SEMESTER | varchar2(1) | Valid values: 1 = fall 2 = spring 3 = summer |
| *UDDS | varchar2(7) | A code for the combined codes for Unit, Division, Department, and Subdepartment. |
| *DIVISION | varchar2(2) | The second and third characters of the UDDS code. They define the college or division within the institution. |
| *DEPARTMENT | varchar2(2) | The fourth and fifth characters of the UDDS code. They define the department within the division |
| *SUBDEPARTMENT | varchar2(2) | The sixth and seventh characters of the UDDS code. They define the subdepartment within the department |
| TOTAL_FACULTY_ROSTER | num(12,2) | FTE total of all tenure/tenure-track faculty commitments within department |
| TENURED_FACULTY | num(12,2) | FTE total of all tenured faculty commitments within department |
| PROBATIONARY_FACULTY | num(12,2) | FTE total of all probationary faculty commitments within department |
| PRCNT_ROSTER_WITH_TENURE | num(12,2) | Percent of total faculty roster who are tenured. Calculation = (tenured faculty/total faculty roster) * 100 |
| FTE_AGE_70_OR_OLDER | num(12,2) | FTE total of all tenured and probationary faculty whose tenure home is within department and who are age 70 or older |
| FTE_AGE_65_69 | num(12,2) | FTE total of all tenured and probationary faculty whose tenure home is within department and who are age 65-69 |
| FTE_AGE_60_64 | num(12,2) | FTE total of all tenured and probationary faculty whose tenure home is within department and who are age 60-64 |
| PRCNT_DEPT_ROSTER_COLL_ROSTER | num(12,2) | Faculty roster for this department as a percentage of total faculty roster for college. Calculation = (Total Faculty Roster/sum of all Total Faculty Roster in division) * 100. |
| INDEFINITE_APPTS_HEAD_CT | num(12,2) | Head count of all academic staff with indefinite appointments in department |
| ROLLING_HORIZON_HEAD_CT | num(12,2) | Head count of all academic staff with rolling horizon appointments in department |
| FACULTY_ALL_FUNDS | num(12,2) | FTE total of all funded splits within department of tenure/tenure-track faculty titles |
| FACULTY_101 | num(12,2) | FTE total of all 101-funded splits within department of tenure/tenure-track faculty titles . |
| FACULTY_101_2 | num(12,2) | FTE total of all 101-funded, Activity 2 (instructional) splits within department of tenure/tenure-track faculty titles . |
| FACULTY_AFFILIATES_101 | num(12,2) | FTE total of all 101-funded splits of tenure/tenure-track faculty titles without tenure home in department, including any with payroll FTE in excess of tenure FTE. |
| PRCNT_ROSTER_NOT_ON_101 | num(12,2) | Percent of faculty roster not paid on 101 funds. Calculation = ((Total Faculty Roster-(Faculty on 101-Faculty Affiliates on 101)) / Total Faculty Roster) * 100. |
| INSTR_ACAD_STAFF_PERM_101_2 | num(12,2) | FTE total of all 101-funded, Activity 2 (instructional) splits within department of instructional academic staff titles (EEO category 2-2) in which the appointment is not of short-term duration (not fixed-term terminal). Note: Information available beginning in 1993-94. |
| INSTR_ACAD_STAFF_TEMP_101_2 | num(12,2) | FTE total of all 101-funded, Activity 2 (instructional) splits within department of instructional academic staff titles (EEO category 2-2) in which the appointment is of short-term duration (fixed-term terminal). NOTE: Prior to 1993-94, includes all instructional academic staff, regardless of appointment duration. |
| INSTR_ACAD_STAFF_101 | num(12,2) | FTE total of all 101-funded splits within department (on all activities) of instructional academic staff titles (EEO category 2-2), regardless of the duration of the appointment. |
| FAC_AND_INSTR_AS_EXCL_TA_101 | num(12,2) | FTE total of faculty and instructional academic staff on 101 funds (excludes teaching assistants). Calculation = Faculty 101 + Instr Acad Staff 101. |
| TA_101 | num(12,2) | FTE total of all 101-funded splits within department for teaching assistant titles (titles beginning with Y30, Y32 or Y33). |
| TA_HEAD_COUNT_101 | num(12,2) | Head count (appointment count) of all 101-funded appointments within department for teaching assistant titles (titles beginning with Y30, Y32 or Y33). |
| INSTR_AS_AND_TA_ALL_FUNDS | num(12,2) | FTE total of all funded splits within department of instructional academic staff titles (EEO category 2-2) plus teaching assistants (titles beginning with Y30, Y32 or Y33) |
| TOTAL_FAC_INSTR_AS_TA_101 | num(12,2) | Total faculty, instructional academic staff, and teaching assistants on 101 funds. Calculation = Fac & Instr AS Excl TA 101 + TA 101. |
| UNCLASS_101_ADMIN_DOCT_OTHER | num(12,2) | FTE total of all 101-funded splits within department of unclassified titles defined as “executive, managerial, administrative” (EEO category 1-1), “doctoral” (EEO category 3-1), and “other” (EEO category 3-3). |
| UNCLASS_101_EIT_PA_RA | num(12,2) | FTE total of all 101-funded splits within department of unclassified titles defined as “employees in training” (EEO category 3-2) and “student staff” (EEO category 3-4, excluding teaching assistants). |
| TOTAL_UNCLASS_SUPPORT_101 | num(12,2) | FTE total of all 101-funded splits within department of unclassified titles defined as “executive, managerial, administrative” (EEO category 1-1), “doctoral” (EEO category 3-1), “other” (EEO category 3-3), “employees in training” (EEO category 3-2) and “student staff” (EEO category 3-4, excluding teaching assistants). |
| TOTAL_UNCL_SUPPORT_ALL_FUNDS | num(12,2) | FTE total of all funded splits within department of unclassified titles defined as “executive, managerial, administrative” (EEO category 1-1), “doctoral” (EEO category 3-1), “other” (EEO category 3-3), “employees in training” (EEO category 3-2) and “student staff” (EEO category 3-4, excluding teaching assistants). |
| CLASSIFIED_101_ADMIN_PROF | num(12,2) | FTE total of all 101-funded splits within department of classified titles defined as “executive, managerial, administrative” (EEO category 1-2) and “professional” (EEO category 3-5). |
| CLASSIFIED_101_CLERICAL | num(12,2) | FTE total of all 101-funded splits within department of classified titles defined as “secretarial/clerical” (EEO category 4). |
| CLASSIFIED_101_TECH_PARAPROF | num(12,2) | FTE total of all 101-funded splits within department of classified titles defined as “technical/paraprofessional” (EEO category 5). |
| CLASS_101_CRAFTS_SERV_MAINT | num(12,2) | FTE total of all 101-funded splits within department of classified titles defined as “skilled crafts” (EEO category 6) and “service/maintenance” (EEO category 7). |
| TOTAL_CLASSIFIED_101 | num(12,2) | FTE total of all 101-funded splits within department of classified titles defined as “executive, managerial, administrative” (EEO category 1-2), “professional” (EEO category 3-5), “secretarial/clerical” (EEO category 4), “technical/paraprofessional” (EEO category 5), “skilled crafts” (EEO category 6) and “service/maintenance” (EEO category 7). |
| TOTAL_CLASSIFIED_ALL_FUNDS | num(12,2) | FTE total of all funded splits within department of classified titles defined as “executive, managerial, administrative” (EEO category 1-2), “professional” (EEO category 3-5), “secretarial/clerical” (EEO category 4), “technical/paraprofessional” (EEO category 5), “skilled crafts” (EEO category 6) and “service/maintenance” (EEO category 7) |
| LTE_101 | num(12,2) | FTE total of all 101-funded splits within department for limited term employees (appointment type CL, classified-limited). NOTE: Information available beginning in 1993-94. |
| LTE_ALL_FUNDS | num(12,2) | FTE total of all funded splits within department for limited term employees (appointment type CL, classified-limited). Information available beginning in 1993-94. |
| TOTAL_INSTR_AND_NON_INSTR_101 | num(12,2) | Total instructional and non-instructional staff FTE on 101 funds. Calculation = Faculty 101 + Instr Acad Staff 101 + TA 101 + Tot Unclass Support 101 + Tot Classified 101 + LTE 101. |
| TOTAL_INSTR_AND_NON_INSTR_ALL | num(12,2) | Total instructional and non-instructional staff FTE on all funds. Calculation = Faculty FTE All Funds + Instr AS & TA All Funds + Tot Uncl Support All Funds + Tot Classified All Funds + LTE All Funds. |
| FACULTY_GPR | num(12,2) | FTE total of all GPR-funded splits within department of tenure/tenure-track faculty titles. |
| FACULTY_GPR_2 | num(12,2) | FTE total of all GPR-funded, Activity 2 (instructional) splits within department of tenure/tenure-track faculty titles. |
| FACULTY_AFFILIATES_GPR | num(12,2) | FTE total of all GPR-funded splits of tenure/tenure-track faculty titles without tenure home in department, including any with payroll FTE in excess of tenure FTE. |
| PRCNT_ROSTER_NOT_ON_GPR | num(12,2) | Percent of faculty roster not paid on GPR funds. Calculation = ((Total Faculty Roster-(Faculty on GPR-Faculty Affiliates on GPR)) / Total Faculty Roster) * 100. |
| INSTR_ACAD_STAFF_PERM_GPR_2 | num(12,2) | FTE total of all GPR-funded, Activity 2 (instructional) splits within department of instructional academic staff titles (EEO category 2-2) in which the appointment is not of short-term duration (not fixed-term terminal). NOTE: Information available beginning in 1993-94. |
| INSTR_ACAD_STAFF_TEMP_GPR_2 | num(12,2) | FTE total of all GPR-funded, Activity 2 (instructional) splits within department of instructional academic staff titles (EEO category 2-2) in which the appointment is of short-term duration (fixed-term terminal). NOTE: . Prior to 1993-94, includes all instructional academic staff, regardless of appointment duration. |
| INSTR_ACAD_STAFF_GPR | num(12,2) | FTE total of all GPR-funded splits within department (on all activities) of instructional academic staff titles (EEO category 2-2), regardless of the duration of the appointment. |
| FAC_AND_INSTR_AS_EXCL_TA_GPR | num(12,2) | FTE total of faculty and instructional academic staff on GPR funds (excludes teaching assistants). Calculation = Faculty GPR + Instr Acad Staff GPR. |
| TA_GPR | num(12,2) | FTE total of all GPR-funded splits within department for teaching assistant titles (titles beginning with Y30, Y32 or Y33). |
| TA_HEAD_COUNT_GPR | num(12,2) | Head count (appointment count) of all GPR-funded appointments within department for teaching assistant titles (titles beginning with Y30, Y32 or Y33). |
| TOTAL_FAC_INSTR_AS_TA_GPR | num(12,2) | Total faculty, instructional academic staff, and teaching assistants on GPR funds. Calculation = Fac & Instr AS Excl TA GPR + TA GPR. |
| UNCLASS_GPR_ADMIN_DOCT_OTHER | num(12,2) | FTE total of all GPR-funded splits within department of unclassified titles defined as “executive, managerial, administrative” (EEO category 1-1), “doctoral” (EEO category 3-1), and “other” (EEO category 3-3). |
| UNCLASS_GPR_EIT_PA_RA | num(12,2) | FTE total of all GPR-funded splits within department of unclassified titles defined as “employees in training” (EEO category 3-2) and “student staff” (EEO category 3-4, excluding teaching assistants). |
| TOTAL_UNCLASS_SUPPORT_GPR | num(12,2) | FTE total of all GPR-funded splits within department of unclassified titles defined as “executive, managerial, administrative” (EEO category 1-1), “doctoral” (EEO category 3-1), “other” (EEO category 3-3), “employees in training” (EEO category 3-2) and “student staff” (EEO category 3-4, excluding teaching assistants). |
| CLASSIFIED_GPR_ADMIN_PROF | num(12,2) | FTE total of all GPR-funded splits within department of classified titles defined as “executive, managerial, administrative” (EEO category 1-2) and “professional” (EEO category 3-5). |
| CLASSIFIED_GPR_CLERICAL | num(12,2) | FTE total of all GPR-funded splits within department of classified titles defined as “secretarial/clerical” (EEO category 4). |
| CLASSIFIED_GPR_TECH_PARAPROF | num(12,2) | FTE total of all GPR-funded splits within department of classified titles defined as “technical/paraprofessional” (EEO category 5). |
| CLASS_GPR_CRAFTS_SERV_MAINT | num(12,2) | FTE total of all GPR-funded splits within department of classified titles defined as “skilled crafts” (EEO category 6) and “service/maintenance” (EEO category 7). |
| TOTAL_CLASSIFIED_GPR | num(12,2) | FTE total of all GPR-funded splits within department of classified titles defined as “executive, managerial, administrative” (EEO category 1-2), “professional” (EEO category 3-5), “secretarial/clerical” (EEO category 4), “technical/paraprofessional” (EEO category 5), “skilled crafts” (EEO category 6) and “service/maintenance” (EEO category 7). |
| LTE_GPR | num(12,2) | FTE total of all GPR-funded splits within department for limited term employees (appointment type CL, classified-limited). NOTE: Information available beginning in 1993-94. |
| TOTAL_INSTR_AND_NON_INSTR_GPR | num(12,2) | Total instructional and non-instructional staff FTE on GPR funds. Calculation = Faculty GPR + Instr Acad Staff GPR + TA GPR + Tot Unclass Support GPR + Tot Classified GPR + LTE GPR. |
| UGRAD_CREDITS | num(12,2) | Total of all credits generated within department by undergraduates (freshman, sophomore, junior or senior) |
| PRCNT_COLLEGE_UGRAD_CREDITS | num(12,2) | Total of all undergraduate credits generated within department as a percentage of all undergraduate credits generated within school/college. Calculation = (Ugrad credits/sum of all Ugrad credits in division) * 100. |
| MASTERS_CREDITS | num(12,2) | Total of all credits generated within department by masters-level students |
| PHD_CREDITS | num(12,2) | Total of all credits generated within department by Ph.D. students |
| TOTAL_GRADUATE_CREDITS | num(12,2) | Total of all credits generated within department by masters-level and Ph.D. students. Calculation = Masters Credits + PhD Credits. |
| PRCNT_COLLEGE_GRAD_CREDITS | num(12,2) | Total of all credits generated within department by masters-level and Ph.D. students as a percentage of all credits generated by masters-level and Ph.D. students in school/college. Calculation = (Total Graduate Credits/sum of all Total Graduate Credits in division) * 100. |
| PROFESSIONAL_CREDITS | num(12,2) | Total of all credits generated within department by professional students. |
| SPECIAL_CREDITS | num(12,2) | Total of all credits generated within department by special students |
| TOTAL_CREDITS | num(12,2) | Total of all credits generated within department by undergraduate, graduate, professional and special students. Calculation = Undergrad Credits + Total Graduate Credits + Professional Credits + Special Credits. |
| PRCNT_COLLEGE_TOTAL_CREDITS | num(12,2) | Total of all credits (undergraduate, graduate, professional and special) generated within department as a percentage of all credits (undergraduate, graduate, professional and special) generated in school/college. Calculation = (Total Credits/sum of all Total Credits in division) * 100. |
| UGRAD_MAJORS_HC_COLLEGE | num(12,2) | Head count of all undergraduate students having declared a major within department – includes only those students within this school or college |
| UGRAD_MAJORS_HC_CAMPUS | num(12,2) | Head count of all undergraduate students having declared a major within department – includes all students, regardless of school or college affiliation |
| PRCNT_UGRAD_MAJORS_COLL_HC | num(12,2) | Head count of all undergraduate students having declared a major within department as a percentage of all undergraduate students having declared a major in this school/college. Calculation = (Ugrad Majors HC College / sum of all Ugrad Majors HC College for division) * 100. |
| GRAD_MAJORS_HC_COLLEGE | num(12,2) | Head count of all graduate students (masters or doctoral) having declared a major within department – includes only those students within this school or college |
| GRAD_MAJORS_HC_CAMPUS | num(12,2) | Head count of all graduate students (masters or doctoral) having declared a major within department – includes all students, regardless of school or college affiliation |
| PRCNT_GRAD_MAJORS_COLLEGE_HC | num(12,2) | Head count of all graduate students (masters or doctoral) having declared a major within department as a percentage of all graduate students having declared a major in school/college. Calculation = (Grad Majors HC College / sum of all Grad Majors HC College for division) * 100. |
| PROFESSIONAL_MAJORS_HC | num(12,2) | Head count of all professional students having declared a major within department. NOTE: effective 2000-01, for L&S departments only, includes students in L&S professional programs. |
| PRCNT_PROF_MAJORS_COLLEGE_HC | num(12,2) | Head count of all professional students having declared a major within department as a percentage of all professional students having declared a major in school/college. Calculation = (Professional Majors HC / sum of all Professional Majors HC for division) * 100. |
| UGRAD_MAJORS_FTE_COLLEGE | num(12,2) | FTE of all undergraduate students having declared a major within department – includes only those students within school or college |
| UGRAD_MAJORS_FTE_CAMPUS | num(12,2) | FTE of all undergraduate students having declared a major within department – includes students within this school/college and those students with this major whose primary school/college does not offer the major. |
| PRCNT_UGRAD_MAJORS_COLL_FTE | num(12,2) | FTE of all undergraduate students having declared a major within department as a percentage of all undergraduate students having declared a major in this school/college. Calculation = (Ugrad Majors FTE College / sum of all Ugrad Majors FTE College for division) * 100. |
| GRAD_MAJORS_FTE_COLLEGE | num(12,2) | FTE of all graduate students (masters or doctoral) having declared a major within department – includes only those students within this school or college |
| GRAD_MAJORS_FTE_CAMPUS | num(12,2) | FTE of all graduate students (masters or doctoral) having declared a major within department – includes students within this school/college and those students with this major whose primary school/college does not offer the major. |
| PRCNT_GRAD_MAJ_COLL_FTE | num(12,2) | FTE of all graduate students (masters or doctoral) having declared a major within department as a percentage of all graduate students having declared a major in school/college. Calculation = (Grad Majors FTE College / sum of all Grad Majors FTE College for division) * 100. |
| PROFESSIONAL_MAJORS_FTE | num(12,2) | FTE of all professional students having declared a major within department. NOTE: effective 2000-01, for L&S departments only, includes students in L&S professional programs. |
| PRCNT_PROF_MAJORS_COLL_FTE | num(12,2) | FTE of all professional students having declared a major within department as a percentage of all professional students having declared a major in school/college. Calculation = (Professional Majors FTE / sum of all Professional Majors FTE for division) * 100. |
| UNDERGRAD_HONORS_DEGREES | num(12,2) | Total degrees conferred within department to undergraduates having fulfilled Honors requirements. Includes Honors, Comprehensive Honors (L&S), Honors in the Major (L&S), Honors in the Liberal Arts (L&S, Business), Honors in Research (Engineering) |
| TOTAL_UGRAD_DEGREES_COLLEGE | num(12,2) | Undergraduate degrees conferred within majors that are associated with the department, for this school/college |
| TOTAL_UGRAD_DEGREES_CAMPUS | num(12,2) | Total undergraduate degrees conferred within majors that are associated with the department, for all schools and colleges |
| PRCNT_COLL_UNDERGRAD_DEGREES | num(12,2) | Undergraduate degrees conferred through this department, for this school/college, as a percentage of all undergraduate degrees conferred through this school/college. Calculation = Total Ugrad Degrees College / sum of all Total Ugrad Degrees College for division) * 100. |
| MASTERS_DEGREES_COLLEGE | num(12,2) | Masters-level degrees conferred within majors that are associated with the department, for this school/college |
| PHD_DEGREES_COLLEGE | num(12,2) | Ph.D. degrees conferred within majors that are associated with the department, for this school/college |
| TOTAL_GRAD_DEGREES_COLLEGE | num(12,2) | Total graduate degrees (masters-level and Ph.D.) conferred within majors that are associated with the department, for this school/college. Calculation = (Masters Degrees + PhD Degrees). |
| TOTAL_GRAD_DEGREES_CAMPUS | num(12,2) | Total graduate degrees (masters-level and Ph.D.) conferred within majors that are associated with this department, for all schools and colleges |
| PRCNT_COLL_GRADUATE_DEGREES | num(12,2) | Graduate degrees (masters-level and Ph.D.) conferred through this department, for this school/college, as a percentage of all graduate degrees conferred through this school/college. Calculation = (Tot Grad Degrees College / sum of all Tot Grad Degrees College for this division) * 100. |
| PROFESSIONAL_DEGREES | num(12,2) | Professional degrees conferred within majors that are associated with the department, for this school/college. (Professional degrees include Law, Medicine (MD), Pharmacy (Pharm. D. ), Veterinary Medicine (DVM), Master of Physical Therapy (MPT). NOTE: effective 2000-01, for L&S departments only, includes students in L&S professional programs. |
| PRCNT_COLLEGE_PROF_DEGREES | num(12,2) | Professional degrees conferred through this department, for this school/college, as a percentage of all professional degrees conferred through this school/college. Calculation = (Professional Degrees / sum of all Professional Degrees for division) * 100. |
| TOTAL_DEGREES_COLLEGE | num(12,2) | Total undergraduate, graduate, and professional degrees conferred within majors that are associated with this department, in this school/college. Calculation = (Tot Ugrad Degrees College + Tot Grad Degrees College + Professional Degrees). |
| PRCNT_TOTAL_DEGREES_COLLEGE | num(12,2) | Total undergraduate, graduate, and professional degrees conferred through this department, in this school/college, as a percentage of all undergraduate, graduate, and professional degrees conferred through this school/college. Calculation = (Total Degrees College / sum of all Total Degrees College for division) * 100. |
| TOTAL_DEGREES_CAMPUS | num(12,2) | Total of all undergraduate, graduate, and professional degrees conferred within majors that are associated with this department, for all schools and colleges. Calculation = (Tot Ugrad Degrees Campus + Tot Grad Degrees Campus + Professional Degrees). |
| PRCNT_TOTAL_DEGREES_CAMPUS | num(12,2) | Total of all undergraduate, graduate, and professional degrees conferred within majors that are associated with this department, in all schools and colleges, as a percentage of all undergraduate, graduate, and professional degrees conferred. Calculation = (Total Degrees Campus / sum of all Total Degrees Campus for division) * 100. |
| EXTRAM_ AWARDS_FEDERAL | num(12,2) | Extramural Awards – Federal. Federal awards from August through July of each year on all activities; includes funds 144, 145, 146, 147, 148. |
| PRCNT_COLL_EXTRAM_AWRDS_FED | num(12,2) | Federal extramural awards for this department as a percentage of total federal extramural awards for school/college. Calculation = (Extram Awards Federal / sum of all Extram Awards Federal for division) / 100. |
| EXTRAM_AWARDS_NON_FEDERAL | num(12,2) | Extramural Awards – Non-Federal. Non-federal awards from August through July of each year on all activities; includes funds 133,134,135,161,162. |
| PRCNT_COLL_EXTR_AWRDS_NON_FED | num(12,2) | Non-federal extramural awards for this department as a percentage of total non-federal extramural awards for school/college. Calculation = (Extram Awards Non-Federal / sum of all Extram Awards Non-Federal for division) * 100. |
| EXTRACT_DATE_TIME | Date | Date and Time the data was extracted from the source system(s). |