New OBR logo
OHIO BOARD OF REGENTS 
horizontal red line

HEI Faculty-Staff Data Submissions

All Employee (AM) File
Revised May 15, 1998

File Description

The All Employee (AM) file contains one record for each person who was employed on October 1 when the "snapshot" was taken, corresponding to IPEDS data reporting. There will be more than one record for employees who are employed by more than one campus.

Submission Schedule

An annual December submission reflects activity during the current fiscal year. For example, a file submitted in December 1998 is for fiscal 1999. The header record and submission year must indicate 1999.

Capture Date

The capture date is December 1.

Relationship to Other File Submissions

Submission of this file is not dependent upon the prior submission of other files.

Data Fields

Field Name Field Attributes and Procedures Data Format
Campus  Enter a campus code from Institution/Campus Codes Alphabetic 
4 characters 
Columns 1-4
Employee Identifier Enter the federally assigned Social Security Number (SSN) or institution-assigned identifier. Alphanumeric 
9 characters 
Columns 5-13
Institution Assigned Identifier Switch Enter Y if the identifier is assigned by the institution, and is not a federally assigned SSN. 

Enter N if the identifier is an SSN assigned by the federal government.

Alphabetic 
1 character 
Column 14
Major Fund Group Enter a code from Major Fund Group Codes. Alphabetic 
2 characters 
Columns 15-16
Work Category Enter a code from Work Category Codes Alphabetic 
2 characters 
Columns 17-18
Appointment Status  Enter a code from Appointment Status Codes Alphanumeric 
2 characters 
Columns 19-20
Pay Type Enter a code from Pay Type Codes. Alphabetic 
1 character 
Column 21
Salary/Wages Enter salary or hourly wage. Numeric 
9 characters 
Columns 
22-30
Sex Enter a code from Sex Codes Alphabetic 
1 character 
Column 31
Race/Ethnicity Enter a code from Racial/Ethnic Codes. Alphabetic 
2 characters 
Columns 32-33
Delete Switch Enter Y if the record is to be deleted from the database. Otherwise, enter N. Alphabetic 
1 character 
Column 34

Definitions and Descriptions of Data Fields

Campus: This four-character Regents-assigned abbreviation uniquely identifies the campus (or branch) within an institution.

Employee Identifier: This nine-digit alphanumeric field can be either the employee's SSN or an institution-assigned identifier.

Institution Assigned Identifier Switch: Enter Y if the identifier is assigned by the institution, and is not a federally assigned SSN. Enter N if the identifier is an SSN assigned by the federal government.

Major Fund Group: Includes Instruction and General funds, Separately Budgeted Research (SB), Public Service (PS), Auxiliary (AU), and Hospital (HO). Select the primary fund group that indicates the budget category from which the employee's salary or wages come. If an individual is paid from more than one fund group, select and report a primary fund group. If the major fund group is Instruction and General, select and report one primary component within the fund group.

Instruction and General: Includes Departmental Instruction (DI), Academic Support (AS), Student Services (SS), Plant Operation (PO), and Institutional Support (IS).

Departmental Instruction (DI): Includes department chairs and support staff, including secretarial/clerical personnel.

Academic Support (AS): Includes deans, assistant deans, and associate deans.

Student Services (SS): This category includes funds expended for the administration and operation of offices of admission and registration and those activities whose primary purpose is to contribute to the student's emotional and physical well-being, as well as his or her cultural and social development outside the context of the formal instruction program.

Plant Operation (PO): The operation and maintenance of plant, in addition to maintenance of campus grounds and facilities; also includes utilities, property insurance, fire protection, and rented space.

Institutional Support (IS): The category contains expenditures for operation that provide support services to the total university or college. Includes chief academic officers.

Separately Budgeted Research (SB): This category includes all expenditures (internal as well as external funds) for activities specifically organized to produce research outcomes, whether commissioned by an agency external to the institution (restricted) or the institution (unrestricted), and includes matching funds applicable to the conditions set forth by the grant or contract from an external agency.

Public Service (PS): This category includes all funds expended for activities that are established primarily to provide noncredit designated course offerings and services beneficial to individuals and groups external to the institution.

Auxiliary (AU): This category includes student health centers and two-year intercollegiate athletics. This category includes executive management, fiscal operations, personnel, logistical services, and community relations.

Hospital (HO): This category includes all expenditures and transfers associated with the patient care operations of the hospital, including nursing and other professional services, general services, administrative services, fiscal services, and charges for physical plant expenditures and institutional support.

 Work Category: Select the one work category which indicates the employee's primary responsibility. Executive, Administrative, and Managerial (EA): Report all persons whose assignments require primary (and major) responsibility for management of the institution, or a customarily recognized department or subdivision thereof. Assignments require the performance of work directly related to management policies or general business operations of the institution, department, or subdivision, etc. It is assumed that assignments in this category customarily and regularly require the incumbent to exercise discretion and independent judgment and to direct the work of others. Report in this category all officers holding titles such as president, vice president, dean, director, or the equivalent, as well as officers subordinate to any of these administrators with such titles as associate dean, assistant dean, executive officer of academic departments (department heads, or the equivalent) if their principal activity is administrative.

Faculty (Instruction/Research/Public Service): Report all persons whose specific assignments customarily are made for the purpose of conducting instruction, research, or public service as a principal activity (or activities), and who hold academic-rank titles of professor, associate professor, assistant professor, instructor, lecturer, or the equivalent of any of these academic ranks. If their principal activity is instructional, report in this category deans, directors, or the equivalent, as well as associate deans, assistant deans, and executive officers of academic departments (chairpersons, heads, or the equivalent). Do not include student teachers or research assistants here, but report them in Instruction/Research Assistants.

Instruction/Research Assistants: Report all students employed on a part-time basis for the primary purpose of assisting in classroom or laboratory instruction or in the conduct of research. These positions are typically held by graduate students having titles such as teaching assistant, teaching associate, teaching fellow, or research assistant. Exclude any student in the College Work-Study Program. Employees hired on a full-time basis (not students) are to be reported as "other professionals."

Other Professionals (Support/Service) (OP): Report all persons employed for the primary purpose of performing academic support, student service, and institutional support activities, whose assignments would require either college graduation or experience of such kind and amount as to provide a comparable background. Include employees such as librarians, accountants, systems analysts, computer programmers, and coaches.

Technical and Paraprofessionals (TP): Report all persons whose assignments require specialized knowledge or skills which may be acquired through experience or academic work, such as offered in many two-year technical institutes, junior colleges, or through equivalent on-the-job training. Include computer programmers (with less than a bachelor's degree) and operators, drafters, engineering aides, junior engineers, mathematical aides, licensed practical or vocational nurses, dieticians, photographers, radio operators, scientific assistants, technical illustrators, technicians (medical, dental, electronic, physical sciences), and similar occupational activity categories which are institutionally defined as technical assignments.

Clerical and Secretarial (CS): Report all persons whose assignments typically are associated with clerical activities or are specifically of a secretarial nature. Include personnel who are responsible for internal and external communications, recording and retrieval of data (other than computer programmers) and/or information and other paperwork required in an office, such as bookkeepers, stenographers, clerk-typists, office-machine operators, statistical clerks, payroll clerks, etc. Include also sales clerks such as those employed full time in the bookstore and library clerks who are not recognized as librarian.

Skilled Crafts (SC): Report all persons whose assignments typically require special manual skills and a thorough and comprehensive knowledge of the processes involved in the work, acquired through on-the-job training and experience or through apprenticeship or other formal training programs. Include mechanics and repairers, electricians, stationary engineers, skilled machinists, upholsterers, carpenters, compositors, and typesetters.

Service/Maintenance (SM): Report all persons whose assignments require limited degrees of previously acquired skills and knowledge and in which workers perform duties which result in or contribute to the comfort, convenience, and hygiene of personnel and the student body or which contribute to the upkeep and care of buildings, facilities, or grounds of the institutional property. Include chauffeurs, laundry and dry cleaning operatives, cafeteria and restaurant workers, truck drivers, bus drivers, garage laborers, custodial personnel, gardeners and groundskeepers, refuse collectors, construction laborers, and security personnel.

Appointment Status: The length of employment indicated in the faculty contract or formal agreement as opposed to the schedule according to which salary checks might be issued. Use the two-character code to indicate Full Time (9/10 month) (09), Full Time (11/12 month) (11),  Part Time (PT), or Graduate Assistant (GA).

Pay Type: Enter S (salary) or W (wages).

Salary/Wages: The two right-most positions of this nine-character field are the two decimal positions (i.e., cents). For an hourly wage amount, please indicate amount to the nearest penny. For a salary amount, please use two zeroes for the cents. Fill with zeroes the unused positions to the left of the value entered. For example, a salary of $15,750 will be reported as 001575000. An hourly wage of $7.45 will be reported as 000000745. All nine characters of the field must contain a value. The decimal points are implied and not actually entered in the submission. Do not provide total wages or total salaries. The period covered by wages is the hour; the period covered by salary will vary according to the work assignment.

Race/Ethnicity: Enter the two-character code according to the following IPEDS definitions:

Black, non-Hispanic (BL): A person having origins in any of the black racial groups of Africa (except those of Hispanic origin).

American Indian or Alaskan Native (AI): A person having origins in any of the original peoples of North America or who maintains cultural identification through tribal affiliation or community recognition.

Asian or Pacific Islander (AS): A person having origins in any of the original peoples of the Far East, Southeast Asia, the Indian Subcontinent or Pacific Islands. This includes people from China, Japan, Korea, the Philippine Islands, American Samoa, India, and Vietnam.

Hispanic (HS): A person of Mexican, Puerto Rican, Cuban, Central or South American, or other Spanish culture or origin, regardless of race.

White, non-Hispanic (WH): A person having origins in any of the original peoples of Europe, North Africa, or the Middle East (except those of Hispanic origin).

Nonresident Alien (NR): A person who is not a citizen or national of the United States and who is in this country on a visa or temporary basis and does not have the right to remain indefinitely. Resident aliens who are not citizens or nationals of the United States and who have been lawfully admitted for permanent residence are to be reported in the appropriate racial/ethnic categories described above.

Unknown (UK): This category is used only if the employee did not select a racial/ethnic designation, and the postsecondary institution finds it impossible to place the employee in one of the aforementioned racial/ethnic categories.

horizontal red line

Return to Faculty-Staff Files

http://regents.ohio.gov/hei/datasubdoc/faculty/archive/amfile.html
Last updated May 15, 1998