InfoAccess

 

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

Margaret Harrigan, 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 the 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) = length. Field contains letters and/or numbers.
Example: VARCHAR2 (5) could contain ‘ABC’ or  ‘1234’ or ‘ABCDEF’

Numeric Data

NUM (N) (N) = length. Field contains only numbers.
NUM (X,Y) =  format for numbers with decimal positions
X = total number of digits Y = the number of digits after the decimal
Examples: NUM (6) represents 250012 NUM (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).