Created by Corina C Larsen, last modified by Miki Yanagi on Nov 29, 2021
DO NOT USE this table. It is only updated upon request for legacy reporting purposes.
This is the HR Master Flat File ARCHIVE Export Extract version from the UM_F_EMPLOYE_VW - Employee Flat Table that contains all job records (or records) for each employee with an array of demographic details, does not include protected data, and is not regularly updated.
| Key | Record.Fieldname | Format | XLAT | Heading Text |
|---|---|---|---|---|
| → | BUSINESS_UNIT - Business Unit | Char5 | Unit | |
| → | EMPLID - Empl ID | Char11 | ID | |
| → | ARCHIVE_DT - Archive Date | Date | Ach Date | |
| → | ARCHIVE_FLAG - View Archived Messages | Char1 | Archived | |
| → | CHANGE_FLAG - Change Flag | Char1 | Change Flag | |
| → | DELETE_FLAG - Deletion Flag | Char1 | N | Delete |
| ACTION - Action | Char3 | Action | ||
| ACTION_DT - Action Date | Date | Action Date | ||
| ACTION_REASON - Reason Code | Char3 | Reason | ||
| DEPTID - Department | Char10 | DeptID | ||
| 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 | ||
| EMPL_CLASS - Employee Classification | Char3 | Empl Class | ||
| EMPL_RCD - Empl Rcd Nbr | Num3.0 | Empl Rcd# | ||
| EMPL_STATUS - Payroll Status | Char1 | N | Pay Status | |
| FIRST_NAME - First Name | Char30 | First Name | ||
| FTE - FTE | Num2.6 | FTE | ||
| FULL_PART_TIME - Full/Part Time | Char1 | N | Full/Part | |
| HIRE_DT - First Start Date | Date | Start Date | ||
| IPEDSSCODE - IPEDS-S Job Category | Char1 | N | 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 | |
| PRIMARY_JOB_IND - Primary Job Indicator | Char1 | N | Pri Job | |
| LAST_NAME - Last Name | Char30 | Last | ||
| MIDDLE_NAME - Middle Name | Char30 | Middle | ||
| NAME - Name | Char50 | Name | ||
| NAME_PREFIX - Name Prefix | Char4 | 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 | ||
| UNION_CD - Union Code | Char3 | Union Code | ||
| UM_DEPT_DESCR - Department Description | Char30 | Dept Desc | ||
| UM_EG_RANK_DESCR - EG Academic Rank Description | Char30 | EG Rank Descr | ||
| EMAIL_ADDR - Email Address | Char70 | |||
| 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 Total | ||
| UM_IPEDSCODE_DESCR - IPEDSSCODE Description | Char30 | IPEDSSCODE Desc | ||
| UM_JOBCODE_DESCR - JobCode Description | Char30 | Jobcode Descr | ||
| UM_POSITION_DESC - Position Description | Char254 | Position Descr | ||
| UM_PRIM_FUNCTION - Primary Function | Char1 | Prim Function | ||
| UM_PRIM_FUNC_DESC - Primary Function Description | Char30 | Prim Func Descr | ||
| UM_REPORTS_TO_NAME - Reports to Name | Char50 | Report to Name | ||
| UM_REPORTS_TO_EMPL - Reports to Empl ID | Char11 | Rpts To Empl | ||
| UM_REPORTS_TO_DESC - Reports To Description | Char254 | Rpts to Descr | ||
| UM_REPORTS_TOEMAIL - Reports To Email Address | Char70 | Rpts to EMail | ||
| UM_REPORTS_TO_LNME - Reports To Last Name | Char30 | Rpts to LName | ||
| UM_REPORTS_TO_FNME - Reports To First Name | Char30 | Rpts To FName | ||
| UM_UNION_DESCR - Union Code Description | Char30 | Union Cd Descr | ||
| TENURE_STATUS - Tenure Status | Char3 | N | Tenure St | |
| UM_TENURE_DESCR - UM_TENURE_DESCR | Char30 | UM_TENURE_DESCR | ||
| UM_CAMPUS_ADDRESS1 - CAMPUS_ADDRESS1 | Char55 | CAMPUS ADDR1 | ||
| LOCATION - Location Code | Char10 | Location | ||
| UM_LOCATION_DESCR - Location Description | Char30 | Location Descr | ||
| WORK_PHONE - Work Phone # | Char24 | Work Phone | ||
| UM_LAST_CHECK_DT - Last Check Date | Date | Last Chk Dte | ||
| UM_REP_TO_CMP_ADDR - Reports to Campus Address | Char55 | Rep to Cmp Addr | ||
| UM_REP_TO_LOC_CD - UM_REP_TO_LOC_CODE | Char10 | UM_REP_TO_LOC | ||
| UM_REP_TO_LOC_DESC - Reports to Location Descr | Char30 | Rep to Loc Desc | ||
| UM_LAST_PAY_END_DT - Last Pay End Date | Date | Last Pay End Dt | ||
| ANNUAL_RT - Annual Rate | Num16.3 | Annual Rt | ||
| ANNL_BENEF_BASE_RT - Annual Benefits Base Rate | Num16.3 | Ann Ben Rt |
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
UM_FGLEMPL_ACVW (this page)
Finance Database
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.