Overview
The Business Objects IPEDS reports published by the Enterprise Data Warehouse are the recommended source of IPEDS HR Reporting data by the Texas A&M University System Office of Information Technology. The IPEDS HR Report (EDW00028 – PEDS HR Reporting) is located in BusinessObjects, in the TAMUS Publications folder. Security access to the HR/Payroll universes in BusinessObjects is required to run this report. The report includes summary tables mirroring the IPEDS reporting format to assist with data entry. Detail information is provided for export into Excel.
Population
The population included in IPEDS HR Reporting is identified based on Employee Type and Status. An employee’s primary position must be classified as Faculty, Graduate Assistant or Staff to be included, and they must be an active employee or working retiree. The member for each employee is identified based on the supervisory organization of the employee’s primary position.
Position Attributes
Information returned on this report is specific to the primary position of each employee in the A&M System. Attributes related to secondary positions, such as Faculty Rank or Monthly Salary are not included. This ensures each worker is only counted once toward IPEDS reporting, system-wide.
Effective Date
Information is as-of October 31 of each year, because the Enterprise Data Warehouse (EDW) maintains monthly data snapshots on the last day of each month. Note that this differs from the IPEDS November 1 as-of date specified in the survey documentation.
Worker attributes such as Race/Ethnicity and Gender are relatively static, however a worker’s citizenship and tenure status are subject to change. Note that the worker attributes on this report are as-of the date the report is run, and are not back-dated to October 31 of a given year.
Gender and Race/Ethnicity
To manage ambiguity and accommodate workers who declined to specify or have not yet specified gender, we calculate gender as follows: if Gender = Male, then count the employee as Male; Else, count the employee as Female.
IPEDS requires “Nonresident alien” workers to be counted separately alongside gender. For this reason, we first identify any employee whose Citizenship Status = “Non-Immigrant” as “Nonresident alien”. Then, per federal reporting standards, we identify any employee (regardless of race) whose ethnicity is Hispanic/Latino as “Hispanic/Latino”. Then for all other employees, we categorize based on race, including those who declined to specify as “Race and ethnicity unknown”.
Academic Rank
Employees are grouped into Faculty Status and Academic Rank based on the Faculty Rank of the job profile in Workday associated with the employee’s primary position. Graduate Assistants, Students, and Staff are not counted as Faculty; otherwise, the Faculty Rank maps directly to the IPEDS Academic Rank categories.
Full vs. Part-Time
This is determined based on the employee’s primary position. If that position is scheduled to work 40 hours per week, then the employee is full time. If the position is scheduled to work less than 40 hours per week, then the employee is part time.
Primary Activity Code
This comes from the Primary Activity Code Job Classification on the Job Profile associated with the employee’s primary position, and is used to identify an employee as Primarily Instruction, Research, Public Service, or all of the above. If an employee is “I” (Instructional) or “A” (All of the above), they are classified “Instructional” within IPEDS reporting.
Medical School Employees
Employees whose primary position is associated with the Texas A&M Health Science Center are considered medical school employees. All other employees are considered non-medical school.
Omissions
The sub-categories (e.g. Exclusively Credit, Exclusively not-for-credit, etc.) for “Primarily Instruction” employees are omitted in the IPEDS HR Report provided via Business Objects. Detail regarding the contract length (e.g. Multi-year, Annual contract, Less-than-annual contract, etc.) was also omitted. We encourage members to utilize their academic record of source to fill-in this detail.
Occupational Categories
Occupational Category is identified for each employee based on their job profile attributes, e.g. SOC Code, Faculty Rank, Primary Activity Code, and Job Profile ID. We first identify the Graduate Assistants, then Instructional/Research/Public Service, and then everyone else. The distinction between teaching, research, and non-teaching graduate assistants is currently calculated using a list provided by the A&M System Pay Plan Administrator.
- Part-Time employees whose SOC Code is “25-1191” or “25-6044” are categorized “Graduate Assistants – Teaching”.
- Then, Part-Time employees whose Title Code is 9004-9006, or 9010-9011 are categorized “Graduate Assistants – Research”
- Then, all other Part-Time employees with Faculty Rank 0 (Graduate Assistants) are categorized “Graduate Assistants – Other”
- Then, Employees whose Primary Activity Code is “I” or “A” are categorized “Primarily Instruction”
- Then, Employees whose Primary Activity Code is “R” are categorized “Research”
- Then, Employees whose Primary Activity Code is “P” are categorized “Public Service”
- Finally, for all employees not captured in an above category, SOC Code is used to categorize per IPEDS specifications.