OHIOBOARD OFREGENTS

HEI Enrollment Data Submissions

All Employee (AM) File
Revised October 15, 2008

File Description

The All Employee (AM) file contains one record for each person who was employed on November 1. There will be more than one record for employees who are employed by more than one campus.

Submission Schedule

The All Employee (AM) file is an annual submission reflecting activity on November 1st during the current calendar year. The header year should reflect the calendar date of the file. For example, if a file is submitted in December 2000 that reflects activity on November 1, 2000, the header record and submission year must indicate 2000. The window for this file is December 1 through February 3.

Capture Date

The capture date is November 1.

Relationship to Other File Submissions

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

Data Fields

Field Names

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.

Alphanumeric 
9 characters 
Columns 22-30

Annualized Base Salary

Enter annualized salary to the nearest dollar (no decimals) for salaried employees.

Alphanumeric 
7 characters 
Columns  31-37

Sex

Enter a code from Sex Codes.

Alphabetic 
1 character 
Column 38

Hispanic/Latino Ethnicity

Enter Y if the employee is a person of Cuban, Mexican, Puerto Rican, South or Central American, or other Spanish culture or origin, regardless of race. Otherwise, enter N

Alphabetic 
1 character
Column 39

American Indian or Alaska Native Race

Enter Y if the employee is a person having origins in any of the original peoples of North and South America (including Central America), and who maintains a tribal affiliation or community attachment. Otherwise, enter N

Alphabetic 
1 character
Column 40

Asian Race

Enter Y if the employee is a person having origins in any of the original peoples of the Far East, Southeast Asia, or the Indian subcontinent including, for example, Cambodia, China, India, Japan, Korea, Malaysia, Pakistan, the Philippine Islands, Thailand, and Vietnam. Otherwise, enter N

Alphabetic 
1 character
Column 41

Black or African American Race

Enter Y if the employee is a person having origins in any of the Black racial groups of Africa. Otherwise, enter N

Alphabetic 
1 character
Column 42

Native Hawaiian or Other Pacific Islander Race

Enter Y if the employee is a person having origins in any of the original peoples of Hawaii, Guam, Samoa, or other Pacific Islands. Otherwise, enter N

Alphabetic 
1 character
Column 43

White Race

Enter Y if the employee is a person having origins in any of the original peoples of Europe, the Middle East, or North Africa. Otherwise, enter N

Alphabetic 
1 character
Column 44

Unknown Race

Enter Y if the employee’s race and ethnicity is unknown. Otherwise, enter N. 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.

Alphabetic 
1 character
Column 45

Nonresident Alien

Enter Y if the employee is a nonresident alien. Otherwise, enter N

Alphabetic 
1 character
Column 46

Country of Origin

For all employees reported as Nonresident Aliens, enter the employee's country of origin or citizenship (not the employee's birth country) as reported on their passport. Use the SEVIS codes. If country is unknown use 99. If the student is not a nonresident alien, use 98.
Here is the list of codes:
http://regents.ohio.gov/hei/datasubdoc/vertables/ countrycodes.txt

Alphabetic 
2 characters 
Columns 47-48

Delete Switch

Enter Y if the record is to be deleted from the database. Otherwise, enter N

Alphabetic 
1 character 
Column 49

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, Separately Budgeted Research (SB), Public Service (PS), Auxiliary (AU), and Hospital (HO) funds. Select the primary expenditure category from which the employee's salary or wages come. If an individual is paid from more than one fund group, select and report one primary fund group. If the major fund group is Instruction and General, select and report one primary component within the fund group.

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).

Racial/Ethnic Code: Colleges and universities are strongly encouraged to collect these data. However, in the event that the student chooses not to disclose his or her race or this datum is not otherwise available, unknown is an acceptable entry. These definitions and categories are prescribed by the U.S. Department of Education. View the crosswalk between the new and old racial/ethnic codes at race_ethnicity_crosswalk.pdf

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).

Annualized Base Salary: Enter the annualized salary for employees reported as S in the Salary/Wages field. For employees reported as Full Time (9/10 month) (09), Full Time (11/12 month) in the Appointment Status field, enter the base salary as provided in the employee's contract. This amount should be exclusive of additional part-time, summer, and overload assignments. Salaries reported for 9-10 month employees should reflect service during two semesters, two trimesters or three quarters. Annualized salaries should include pay for one year, even if the individual worked for less than one year.

Country of Origin: Report the country of origin for all employees reported as nonresident aliens.

Correcting Records

To correct records that were previously submitted and loaded, see the instructions in Correcting Errors in Data Files.

Return to Faculty-Staff Files

http://regents.ohio.gov/hei/datasubdoc/faculty/production/amfile.html
Last updated December 4, 2008