AACSB TABLE 3-2: Deployment of Faculty by Qualification Status in Support of Degree Programs for the Most Recently Completed Regular Academic Year1
[Select additional filters to use: Heading]: [list of [Select additional filters to use: Selected value] separated by ", "]
Date Range: [Report Start Date] - [Report End Date]
For faculty to be included in this report they must meet the following criteria:

Screen: Yearly Data
Items:  All records
Criteria:
1.Record Start Date to Record End Date overlaps with Report End Date and AACSB: Sufficiency, College/Department > AACSB: Percent of Time Dedicated to the School's Mission, AACSB: Normal Professional Responsibility (check all that apply), AACSB: Qualification (2013 Standards), Brief Description for Basis of Qualification at least one has a value

	Faculty percent of teaching by program and degree level (measured by student credit hours)	
Degree Program	Scholarly Academic (SA) %	Practice Academic (PA) %	Scholarly Practitioner (SP) %	Instructional Practitioner (IP) %	Additional (A) %	Total %	
Degree Program	[See Below]	[See Below]	[See Below]	[See Below]	[See Below]	[See Below]	
	[AACSB: Qualification (2013 Standards)] ([0] Student Credit Hours)	
	[Last Name], [First Name] ([Sum of] Student Credit Hours) 1	
	[Term and Year: Term] [Term and Year: Year] [Course Prefix] [Course Number][Course Number Suffix]-[Section Number], [Course Name], [Official Enrollment Number] enrolled, [Number of Credit Hours] credit hours, [Contact Hours] contact hours	
Table Criteria
Qualification Group
Screen: Yearly Data
Items:  All records
Criteria:
1.Record Start Date to Record End Date overlaps with Report End Date
Scholarly Academic (SA)
[AACSB: Qualification (2013 Standards) contains one of the substrings: "Scholarly Academic"]
Practice Academic (PA)
[AACSB: Qualification (2013 Standards) contains one of the substrings: "Practice Academic"]
Scholarly Practitioner (SP)
[AACSB: Qualification (2013 Standards) contains one of the substrings: "Scholarly Practitioner"]
Instructional Practitioner (IP)
[AACSB: Qualification (2013 Standards) contains one of the substrings: "Instructional Practitioner"]
Additional (A)
[AACSB: Qualification (2013 Standards) does not contain any of the substrings: "Scholarly Academic", "Practice Academic", "Scholarly Practitioner", "Instructional Practitioner"] and ([AACSB: Qualification (2013 Standards) has a value] or [AACSB: Percent of Time Dedicated to the School's Mission has a value]
Degree Program
Screen: Scheduled Teaching
Items:  All records
Criteria:
1.Degree Program has a value
[Degree Program]
Teaching Productivity
Screen: Scheduled Teaching
Items:  All records
Criteria:
1.Course Prefix, Course Number all have a value and Number of Credit Hours has a value and Number of Credit Hours is greater than 0.0 and Official Enrollment Number has a value and Official Enrollment Number is greater than 0.0
[Sum of "Official Enrollment Number multiplied by Number of Credit Hours"]

Footnote Criteria
Note: In [Academic Year], [less than 20% of users have administrative data records. Some footnotes for this year have been suppressed.]

 1 [Last Name], [First Name]
[Note: AACSB's Maintenance of Accreditation handbook specifies that academic qualification is lost if three years have elapsed since a person completed their most recent graduate comprehensive examination. The person noted here has been included as "Scholarly Academic" on this report as they are marked as such in the system, even though it is indicated in the system that three years have elapsed since this person completed their most recent graduate comprehensive examination and does not have a doctoral degree. Consequently, you might consider changing this person to no longer have a qualification of "Scholarly Academic".]
Screen: Yearly Data
Items:  All records
Criteria:
1.AACSB: Qualification (2013 Standards) contains one of the substrings: "Scholarly Academic"

Screen: Education
Items:  All records
Criteria:
1.Degree is not one of: "DBA", "EDD", "JD", "PHD", "MD" (ignoring case and punctuation)

Screen: Permanent Data
Items:  All records
Criteria (is one of):
1.If currently a Ph.D student, year of most recently completed graduate comprehensive examination does not have a value
2.Difference (in years) from If currently a Ph.D student, date of most recently completed graduate comprehensive examination to Report End Date is greater than 3.0
[Note: In [Academic Year], [had a joint appointment] [and] had interdisciplinary responsibilities in [list of [Discipline] separated by ", "] [and] had interdisciplinary responsibilities in [list of [College (Discipline)] separated by ", "].]
Screen: Yearly Data
Items:  All records
Criteria:
1.AACSB: Does this faculty member have a joint appointment with another discipline or with another institution? is one of: "Yes"

Screen: Yearly Data > College/Department
Items:  All rows
Criteria:
1.College contains one of the substrings: "Business" and Discipline has a value and position of the item is greater than 1.0

Screen: Yearly Data > College/Department
Items:  All rows
Criteria:
1.College does not contain any of the substrings: "Business" and College has a value
Note: In [Academic Year], [has no administrative data record] [was [On Leave?]] [was [AACSB: Qualification (2013 Standards)]].
This will appear if [the user is missing an administrative data record], [the user was on leave during the report date range], [a course has unusually high credit hours], [and/or] the user's current data displayed in the report differs in a prior academic year.