Created by Corina C Larsen, last modified by Miki Yanagi on Nov 29, 2021
This is the HR Master Flat File Export Extract version of the UM_F_EMPLOYE_VW - Employee Flat Table that contains the current (last) job record (or records) for each employee with an array of demographic details, no protected data, and including student jobs. Overload job on additional pay is not included.
| Key | Record.Fieldname | Format | XLAT | Heading Text |
|---|---|---|---|---|
| ACTION - Action | Char3 | N | Action | |
| ACTION_DT - Action Date | Date | ACTN DATE | ||
| ACTION_REASON - Reason Code | Char3 | Reason | ||
| ANNL_BENEF_BASE_RT - Annual Benefits Base Rate | Num16.3 | Ann Ben Rt | ||
| ANNUAL_RT - Annual Rate | Num16.3 | Annual Rt | ||
| → | BUSINESS_UNIT - Business Unit | Char5 | Unit | |
| DEPTID - Department | Char10 | Dept | ||
| EFFDT_FROM - Effective Date From | Date | From Date | ||
| EG_ACADEMIC_RANK - Academic Rank | Char3 | Academic Rank | ||
| ELIG_CONFIG3 - Eligibility Config Field 3 | Char10 | Elig Fld 3 | ||
| → | EMPLID - Empl ID | Char11 | ID | |
| EMPL_CLASS - Employee Classification | Char3 | N | Empl Class | |
| EMPL_RCD - Empl Rcd Nbr | Num3.0 | Empl Rcd# | ||
| EMPL_STATUS - Employee Status | Char1 | N | Status | |
| FIRST_NAME - First Name | Char30 | FirstName | ||
| FTE - FTE | Num2.6 | FTE | ||
| FULL_PART_TIME - Full/Part Time | Char1 | N | Full/Part | |
| HIRE_DT - Hire Date | Date | Hire Date | ||
| IPEDSSCODE - IPEDS-S Job Category | Char1 | IPEDS Cd | ||
| JOBCODE - Job Code | Char6 | Job Code | ||
| JOB_ENTRY_DT - Job Entry Date | Date | Entry Date | ||
| JOB_FAMILY - Job Family | Char6 | Job Family | ||
| JOB_INDICATOR - Job Indicator | Char1 | N | Indicator | |
| LAST_NAME - Last Name | Char30 | LastName | ||
| LOCATION - Location Code | Char10 | Location | ||
| MIDDLE_NAME - Middle Name | Char30 | Middle Name | ||
| NAME - Name | Char50 | Name | ||
| NAME_PREFIX - Name Prefix | Char4 | N | Prefix | |
| NAME_SUFFIX - Name Suffix | Char15 | Suffix | ||
| POSITION_NBR - Position Number | Char8 | Position | ||
| REG_TEMP - Regular/Temporary | Char1 | N | Reg/Temp | |
| REHIRE_DT - Rehire Date | Date | Rehire Dt | ||
| REPORTS_TO - Reports To Position Number | Char8 | Reports To | ||
| SAL_ADMIN_PLAN - Salary Administration Plan | Char4 | Sal Plan | ||
| SERVICE_DT - Service Date | Date | Service Dt | ||
| TERMINATION_DT - Termination Date | Date | Term Date | ||
| UM_CAMPUS_ADDRESS1 - Address | Char55 | Addr | ||
| UM_DEPT_DESCR - Department Description | Char30 | Dept Desc | ||
| UM_EG_RANK_DESCR - EG Academic Rank Description | Char30 | EG Rank Descr | ||
| UM_EMAIL_BUS_ADDR - Business Email Address | Char70 | Email Addr | ||
| UM_EMPL_CLASS_DESC - Empl Class Description | Char30 | Empl Class Desc | ||
| UM_EMP_STATUS_DESC - Empl Status Description | Char30 | Emp Status Desc | ||
| UM_EXPECTED_END_DT - Planned Exit | Date | Planned Exit | ||
| UM_FTE_TOTAL - FTE Total | Num2.2 | FTE | ||
| UM_IPEDSCODE_DESCR - IPEDSSCODE Description | Char30 | IPEDSSCODE Desc | ||
| UM_JOBCODE_DESCR - JobCode Description | Char30 | Jobcode Descr | ||
| UM_LAST_CHECK_DT - Last Check Date | Date | Last Chk Dte | ||
| UM_LAST_PAY_END_DT - Last Pay End Date | Date | Last Pay End Dt | ||
| UM_LOCATION_DESCR - Location Description | Char30 | Location Descr | ||
| UM_POSITION_DESC - Position Description | Char254 | Position Descr | ||
| UM_PRIMARY_JOB_IND - Primary Job Indicator | Char1 | Primary Job Ind | ||
| UM_PRIM_FUNCTION - Primary Function | Char1 | Prim Function | ||
| UM_PRIM_FUNC_DESC - Primary Function Description | Char30 | Prim Func Descr | ||
| UM_REPORTS_TOEMAIL - Reports To Emaill Address | Char70 | Rpts To Email | ||
| UM_REPORTS_TO_DESC - Reports To Description | Char254 | Rpts To Descr | ||
| UM_REPORTS_TO_EMPL - Reports To Empl ID | Char11 | Rpts To Empl | ||
| UM_REPORTS_TO_FNME - Reports To First Name | Char30 | Rpts To FNAME | ||
| UM_REPORTS_TO_LNME - Reports To Last Name | Char30 | Rpts to LName | ||
| UM_REPORTS_TO_NAME - Reports to Name | Char50 | Reports To | ||
| UM_REP_TO_CMP_ADDR - Reports to Campus Address | Char55 | Rep to Cmp Addr | ||
| UM_TENURE_DESCR - Tenure Dewscription | Char30 | Tenure Descr | ||
| UM_TENURE_STATUS - Tenure Status | Char3 | Tenure Status | ||
| UM_UNION_DESCR - Union Code Description | Char30 | Union Cd Descr | ||
| UM_WORK_PHONE - Work Phone # | Char24 | Wrk Ph # | ||
| UNION_CD - Union Code | Char3 | Union Code |
There exist seven different versions of the table commonly referred to as "HR Flat File." Click each table for details.
Human Resources Database
UM_F_EMPLOYE_VW - Employee Flat Table - This is the parent table for all views below.
UM_F_EMPL_VW - Employee Flat Table
Campus Solutions Reporting Database
Finance Database
UM_FGLALLJOB_VW (this page)
Data Dictionary Links
Clicking the linked (blue) fields in any table will take you to the Data Dictionary and provide you with more information about that field as well as field values if they are available.