HR Info Table Elements
Field Name Description
RECORD_NBR Employment Record Number Number which identifies an employee record number. Assigned number used to differentiate concurrent active appointments for an employee (used in association with the employee ID).
EMPLOYEE_NAME Employee Name Name of the Employee.
AGENCY_NBR Employment Agency Number Number which identifies an Agency associated with the SEMA4 Department ID. An agency is an employing organization within state government.
AGENCY_NAME Employment Agency Name Name of the state agency.
DEPARTMENT_NBR Department Number Number which identifies a further breakdown of the agency.
DEPARTMENT_NAME Department Name Name (30-character) of a department.
BRANCH_CODE Department Branch Code Code which represents the branch of government with which a department is affiliated.
BRANCH_NAME Department Branch Name Name of the branch of government with which a department is affiliated.
JOB_CODE Job Code Code which represents a state job classification related to a particular position.
JOB_TITLE Job Description Description (30-character) of the job code.
LOCATION_NBR Location Code Code which represents an agency's location address.The location code corresponds to an address on the Location table.
LOCATION_NAME Location Name Name (30-character) of location(e.g. Centennial Building).
LOCATION_POSTAL_CODE Zip Code Code which represents the U.S. Postal Service zip code designation for a state office.
REG_TEMP_CODE Regular/Temporary Code Code (one-digit) which represents the appointment status (i.e. shows how the employee is appointed: unlimited, limited, temporary, etc.).
REG_TEMP_DESC Regular/Temporary Description Description of the Regular/Temporary (appointment status) code.
CLASSIFIED_CODE Employee Classification Code Code which represents the classification status of position (i.e. classified, unclassified, non status).
CLASSIFIED_DESC Employee Classification Description Description of employee classification.
ORIGINAL_HIRE_DATE Original Hire Date Date employee originally started work with the state. This date would theoretically never be changed.
LAST_HIRE_DATE State Last Hire Date Date of the employee's most recent return to the state following a period in which the employee did not work for the state.
JOB_ENTRY_DATE Job Entry Date Date that the employee entered the job class (job code).
FULL_PART_TIME_CODE Full/Part Time Code Code which represents a position; whether it is full time, part time, or intermittent.
FULL_PART_TIME_DESC Full/Part Time Description Description of the FULL_PART_TM_CD: Full time, part time, or intermittent.
SALARY_PLAN_GRID Salary Admin Plan Number Number which identifies a salary Admin Plan (grid) which is a matrix of hourly, monthly, and annual rates of pay, usually unique to a group of classes, such as those contained in a bargaining unit.
SALARY_GRADE_RANGE Salary Grade Number Number which identifies the salary Grade (range) for a job on the Salary Admin Plan.
MAX_SALARY_STEP Max Salary Step Number Number which identifies the highest step at which an appointment can be made to a job code.
COMPENSATION_RATE Compensation Rate Rate at which an employee is paid. This rate reflects the most current rate the employee was paid either on or before June 30, 2019.
COMP_FREQUENCY_CODE Compensation Frequency Code Code which represents the frequency (i.e. weekly, bi-weekly) that an employee is paid.
COMP_FREQUENCY_DESC Compensation Frequency Description Description of the compensation frequency.
POSITION_FTE Position Full-Time Equivalency Percent Rate of percentage of full-time that employees are intended to normally work in their jobs. FTE =(full-time equivalency).Does not represent actual hours worked.
BARGAINING_UNIT_NBR Bargaining Unit Number Number which identifies an Employee's bargaining unit. A bargaining unit is a group of employees in similar occupational categories.
BARGAINING_UNIT_NAME Bargaining Unit Name Name of the bargaining unit.
ACTIVE_ON_JUNE_30_2019 Active on June 30, 2019 Based on Employee's working status code as of June 30, 2019. Yes = Active or Paid Leave. No = Deceased, Retired, Separated,Terminated, Layoff, Seasonal Layoff, or Leave of Absence.
Column Name Description
REGULAR_WAGES Regular Wages Total amount expended to the individual for regular work, vacation, sick, holiday etc. for full time, part time, seasonal and other service in all pay periods ending June 26, 2018 to June 11, 2019. This amount does not represent what would appear on their W2 as various types of earnings are taxable and others are not. In addition, the figure does not necessarily reflect the employee's current or annualized salary and may include retroactive earnings for the prior fiscal year.
OVERTIME_WAGES Overtime Wages Total amount for overtime, call back/call in, overload, etc.
OTHER_WAGES Other Wages Total amount for differentials (including shift, equipment, bridge/intermittent foreman, corrections trade, delivery van driver), on call, etc. as well as total amount for separation expenses (including severance pay, vacation liquidation, retirement incentive). This also includes any additional compensation for items above base salary such as achievement awards, vacation time conversion to deferred compensation, holiday payoff, grievance settlement, etc. Compensation similar to business expenses, such as relocation expenses, clothing/uniform allowance, communication allowance, etc., are no longer included.
TOTAL_WAGES Total Wages The sum total of the Regular, Overtime, and Other Wages columns.


Random Job Titles from Minnesota State Salaries
Child Health Program Supv
Housing Dev Off Inter
Pub Util Rates Analyst 4
Exec Dir Chiropractic Exam Bd
Dir Corrections Industries
Jud Deputy District Admin C
Asst Commr Empl & Economic Dev
MnSCU Academic Professional 4
Interstate Milk Rating Officer
Jud Inform Tech Supv I





Random Departments from Minnesota State Salaries
Project Development Baxter
CS&P ICWA Compliance
Information Technology Srv Stf
FOR Badoura Nurs Seasonal
Admin Supp Staff
CCLD Elevator Inspections
800 MHZ Radio
Maryland Subarea Days
PAT-R2 Jay Cooke Staff 1
Mpls 22 Nurse Staff E



Random Agencies from Minnesota State Salaries
Dietetics & Nutrition Practice
Asian-Pacific Council
Disability Council
Veterans Affairs Dept
Marriage & Family Therapy
Campaign Fin & Public Discl Bd
Podiatric Medicine Board
Housing Finance Agency
Public Defense Board
Bureau of Mediation Services



Random Locations from Minnesota State Salaries
Location NameZip Code
Fort Snelling SP Interp Center 55111
St Peter 56082
MCF - Willow River (CIP) 55795
AGO-1200 BRM 55101
MnSCU S Cntrl Mankato TC 560021920
Elysian Office 56028
0760 JS/UI Thief River Falls 56701
MnSCUMichiganIronwood 0
DVS Customer Support 164 551015164
DLI Grand Rapids 2 - WFH 55744