Created by Corina C Larsen, last modified on Nov 29, 2021
UMS Reporting Terminology#Ethnicity
| Key | Record.Fieldname | Format | XLAT | Heading Text |
|---|---|---|---|---|
| ACTION - Action | Char3 | Action | ||
| ACTION_DT - Action Date | Date | Action Date | ||
| ACTION_REASON - Reason Code | Char3 | Reason | ||
| ADDRESS1 - Address Line 1 | Char55 | Address 1 | ||
| ADDRESS2 - Address Line 2 | Char55 | Address 2 | ||
| ADDRESS3 - Address Line 3 | Char55 | Address 3 | ||
| ADDRESS4 - Address Line 4 | Char55 | Address 4 | ||
| ADDR_FIELD1 - Address Field 1 | Char2 | N | Address Field 1 | |
| ADDR_FIELD2 - Address Field 2 | Char4 | Address Field 2 | ||
| ADDR_FIELD3 - Address Field 3 | Char4 | Address Field 3 | ||
| ANNL_BENEF_BASE_RT - Annual Benefits Base Rate | Num16.3 | Ann Ben Rt | ||
| ANNUAL_RT - Annual Rate | Num16.3 | Annual Rt | ||
| ASOFDATE - As Of Date | Date | As Of | ||
| BARG_UNIT - Bargaining Unit | Char4 | N | Barg Unit | |
| BENEFIT_RCD_NBR - Benefit Record Number | Num3.0 | Ben Record | ||
| BIRTHDATE - Date of Birth | Date | Birthdate | ||
| BIRTHPLACE - Birth Location | Char30 | Birthplace | ||
| BUSINESS_TITLE - Business Title | Char30 | Title | ||
| BUSINESS_UNIT - Business Unit | Char5 | Unit | ||
| CHANGE_AMT - Change Amount | SNm14.6 | Chng Amt | ||
| CHANGE_PCT - Change Percent | SNm5.3 | Pct | ||
| CITIZENSHIP_STATUS - Citizenship Status | Char1 | Status | ||
| CITY - City | Char30 | City | ||
| CMPNY_SENIORITY_DT - Company Seniority Date | Date | Company Dt | ||
| COMPANY - Company | Char3 | Co | ||
| COMPRATE - Compensation Rate | Num13.6 | Comp Rate | ||
| COMP_FREQUENCY - Compensation Frequency | Char5 | Comp Freq | ||
| COUNTRY - Country | Char3 | Country | ||
| COUNTRY_NM_FORMAT - Format Using | Char3 | Use | ||
| COUNTY - County | Char30 | County | ||
| CURRENCY_CD - Currency Code | Char3 | Currency | ||
| CUR_RT_TYPE - Exchange Rate Type | Char5 | Rate Type | ||
| DAILY_RT - Daily Rate | Num16.3 | Daily Rt | ||
| DEPTID - Department | Char10 | Dept ID | ||
| DEPTNAME - Department | Char30 | Dept | ||
| DEPTNAME_ABBRV - Short Name | Char10 | Dept Name | ||
| DEPT_ENTRY_DT - Department Entry Date | Date | Dept Date | ||
| DIRECTLY_TIPPED - Tipped | Char1 | N | Tipped | |
| DISABLED - Disabled | Char1 | Disabled | ||
| DISABLED_VET - Disabled Veteran | Char1 | Disab Vet | ||
| DT_OF_DEATH - Date of Death | Date | Death Date | ||
| EEO1CODE - EEO-1 Job Category | Char1 | N | EEO-1 Cat | |
| EEO4CODE - EEO-4 Job Category | Char1 | N | EEO-4 Cat | |
| EEO4_FUNCTION - U.S. EEO4 Function | Char2 | N | EEO4 Fcn | |
| EEO5CODE - EEO-5 Job Category | Char2 | N | EEO-5 Cat | |
| EEO6CODE - EEO-6 Job Category | Char1 | N | EEO-6 Cat | |
| EEO_CLASS - EEO Classification | Char1 | N | EEO Class | |
| EEO_JOB_GROUP - EEO Job Group | Char4 | Job Group | ||
| EFFDT - Effective Date | Date | Eff Date | ||
| EFFSEQ - Effective Sequence | Num3.0 | Sequence | ||
| → | EMPLID - Empl ID | Char11 | ID | |
| EMPL_CTG - Employee Category | Char6 | Category | ||
| EMPL_CTG_L1 - Employee Subcategory | Char6 | Subcategory | ||
| EMPL_CTG_L2 - Employee Subcategory 2 | Char6 | Subcategory 2 | ||
| → | EMPL_RCD - Empl Record | Num3.0 | Empl Record | |
| EMPL_STATUS - Payroll Status | Char1 | N | Pay Status | |
| EMPL_TYPE - Employee Type | Char1 | N | Type | |
| ENTRY_DATE - Date Entered | Date | Entered | ||
| ETHNIC_GROUP - Ethnic Group | Char1 | N | Ethnic Grp | |
| EXPECTED_RETURN_DT - Expected Return Date | Date | Return Dt | ||
| FIRST_NAME - First Name | Char30 | First Name | ||
| FIRST_NAME_SRCH - First Name | Char30 | First Name | ||
| FLSA_STATUS - FLSA Status | Char1 | N | FLSA Stat | |
| FROMDATE - From Date | Date | From Date | ||
| FTE - FTE | Num2.6 | FTE | ||
| FT_STUDENT - Full-Time Student | Char1 | FT Student | ||
| FULL_PART_TIME - Full/Part Time | Char1 | N | Full/Part | |
| GEO_CODE - Tax Vendor Geographical Code | Char11 | Geo Code | ||
| GL_PAY_TYPE - General Ledger Pay Type | Char6 | GL Pay Type | ||
| GP_ASOF_DT_EXG_RT - Use Rate As Of | Char1 | N | Rate As Of | |
| GP_ELIG_GRP - Eligibility Group | Char10 | Elig Grp | ||
| GP_PAYGROUP - Pay Group | Char10 | Pay Group | ||
| GRADE - Salary Grade | Char3 | Grade | ||
| GRADE_ENTRY_DT - Grade Entry Date | Date | Grade Date | ||
| GVT_APPT_EXPIR_DT - Appointment Expiration Date | Date | Hire NTE Dt | ||
| GVT_BIWEEKLY_RT - Biweekly Rate | Num8.2 | Biweek Rt | ||
| GVT_CAREER_CNV_DUE - Conversion to Career Due | Date | Career Due | ||
| GVT_CLRNCE_STAT_DT - Security Clearance Status Date | Date | Status Dt | ||
| GVT_DETAIL_EXPIRES - Date Detail Expires | Date | Detl Expir | ||
| GVT_DT_LEI - Date Last Equivalent Increase | Date | Date LEI | ||
| GVT_INTRM_DAYS_WGI - Intermittent Days Worked | Num3.0 | Days WGI | ||
| GVT_LOCALITY_ADJ - Locality Adjustment | Num6.2 | Loc Adjust | ||
| GVT_MAND_RET_DT - Mandatory Retirement Date | Date | MandRetDt | ||
| GVT_ORG_TTL_DESCR - Organization Position Title | Char70 | Title | ||
| GVT_OVERTIME_RT - Overtime Hourly Rate | Num5.3 | Ovrtime Rt | ||
| GVT_PAY_BASIS - Pay Basis | Char2 | N | Pay Basis | |
| GVT_RTND_GRADE - Retained Grade | Char3 | Rtnd Grade | ||
| GVT_RTND_GRADE_BEG - Retained Grade Begins | Date | Begin Date | ||
| GVT_RTND_GRADE_EXP - Retained Grade Expires | Date | Expires Date | ||
| GVT_RTND_GVT_STEP - Retained US Federal Step | Char2 | RtndFedStp | ||
| GVT_RTND_PAY_BASIS - Retained Pay Basis | Char2 | Rtnd Basis | ||
| GVT_RTND_PAY_PLAN - Retained Pay Plan | Char2 | Rtnd PP | ||
| GVT_RTND_SAL_PLAN - Retained Pay Table | Char4 | Rtnd Table | ||
| GVT_RTND_STEP - Retained Step | Num2.0 | Step | ||
| GVT_SABBATIC_EXPIR - Date Sabbatical Expires | Date | Sabbatical | ||
| GVT_SCD_RETIRE - Service Comp Date - Retire | Date | SCD Retire | ||
| GVT_SCD_SEVPAY - Service Comp Date - Sev Pay | Date | SCD Sevpay | ||
| GVT_SCD_TSP - Service Comp Date - TSP | Date | SCD TSP | ||
| GVT_SEC_CLR_STATUS - Security Clearance Status | Char1 | N | Status | |
| GVT_SES_PROB_DT - SES Probation Date | Date | SES Prb Dt | ||
| GVT_SEVPAY_PRV_WKS - Severance Pay Previous Weeks | Num2.0 | SevPay Wks | ||
| GVT_STEP - US Federal Step | Char2 | Fed Step | ||
| GVT_SUPV_PROB_DT - Supv/Manager Probation Date | Date | S/M Prb Dt | ||
| GVT_TEMP_PRO_EXPIR - Temp Promotion Expires | Date | Temp Prom Expir | ||
| GVT_TEMP_PSN_EXPIR - Temporary Posn Change Expires | Date | Posn Expir | ||
| GVT_TYPE_OF_APPT - Type of Appointment | Char2 | N | Type Appt | |
| GVT_WGI_DUE_DATE - Within-Grade Increase Due Date | Date | WGI Due Dt | ||
| GVT_WGI_STATUS - Current WGI Status | Char1 | N | WGI Status | |
| GVT_WORK_SCHED - Work Schedule | Char1 | N | Wrk Sched | |
| HIGHEST_EDUC_LVL - Highest Education Level | Char2 | N | Hi Educ Lv | |
| HIRE_DT - First Start Date | Date | Start Date | ||
| HOLIDAY_SCHEDULE - Holiday Schedule | Char6 | Hol Sched | ||
| HOME_HOST_CLASS - Home/Host Classification | Char1 | N | Home/Host | |
| HOME_PHONE - Home Phone # | Char24 | Phone | ||
| HOURLY_RT - Hourly Rate | Num13.6 | Hrly Rate | ||
| HOUSE_TYPE - House Type | Char2 | N | House | |
| IN_CITY_LIMIT - In City Limit | Char1 | In Cty Lmt | ||
| IPEDSSCODE - IPEDS-S Job Category | Char1 | N | IPEDS Cd | |
| JOBCODE - Job Code | Char6 | Job Code | ||
| JOBTITLE - Job Title | Char30 | Job Title | ||
| JOBTITLE_ABBRV - Short Name | Char10 | Job Title | ||
| JOB_ACCNTAB_PCT - Accountability-Percent | Num4.1 | Percent | ||
| JOB_ACCNTAB_POINTS - Accountability-Points | Num5.0 | Accountability | ||
| JOB_ENTRY_DT - Job Entry Date | Date | Entry Date | ||
| JOB_FAMILY - Job Family | Char6 | Job Family | ||
| JOB_INDICATOR - Job Indicator | Char1 | N | Indicator | |
| JOB_KNOWHOW_PCT - Knowhow-Percent | Num4.1 | Percent | ||
| JOB_KNOWHOW_POINTS - Knowhow-Points | Num5.0 | Knowhow | ||
| JOB_POINTS_TOTAL - Total Points | Num5.0 | Tot Points | ||
| JOB_PROBSLV_PCT - Problem-Solving-Percent | Num4.1 | Percent | ||
| JOB_PROBSLV_POINTS - Problem-Solving-Points | Num5.0 | Prob Solving | ||
| LABOR_AGREEMENT - Labor Agreement | Char6 | Labor Agreement | ||
| LABOR_FACILITY_ID - Labor Facility ID | Char10 | Labor Facility | ||
| LAST_DATE_WORKED - Last Date Worked | Date | Last Date | ||
| LAST_INCREASE_DT - Date Last Increase | Date | Incr Dt | ||
| LAST_NAME - Last Name | Char30 | Last | ||
| LAST_NAME_PREF_NLD - Last Name Preference | Char1 | N | Preference | |
| LAST_NAME_SRCH - Last Name | Char30 | Last | ||
| LAYOFF_EXEMPT_FLAG - Exempt from Layoff | Char1 | Exempt Layoff | ||
| LAYOFF_EXEMPT_RSN - Layoff Exemption Reason | Char11 | Reason | ||
| LBR_FAC_ENTRY_DT - Labor Facility Entry Date | Date | Entry Date | ||
| LOCATION - Location Code | Char10 | Location | ||
| MANAGER_ID - Manager ID | Char11 | MgrID | ||
| MAR_STATUS - Marital Status | Char1 | N | Mar Status | |
| MIDDLE_NAME - Middle Name | Char30 | Middle | ||
| MILITARY_STATUS - Military Status | Char1 | N | Mil Status | |
| MILIT_SITUATN_FRA - Military Status | Char3 | N | Military | |
| MONTHLY_RT - Monthly Rate | Num16.3 | Monthly Rt | ||
| NAME - Name | Char50 | Name | ||
| NAME_AC - Alternate Character Name | Char50 | AC Name | ||
| NAME_INITIALS - Name Initials | Char6 | Initials | ||
| NAME_PREFIX - Name Prefix | Char4 | Prefix | ||
| NAME_ROYAL_PREFIX - Name Royal Prefix | Char15 | Royal Prefix | ||
| NAME_ROYAL_SUFFIX - Name Royal Suffix | Char15 | Royal Suffix | ||
| NAME_SUFFIX - Name Suffix | Char15 | Suffix | ||
| NAME_TITLE - Title | Char30 | Title | ||
| NATIONAL_ID - National ID | Char20 | NID | ||
| NATIONAL_ID_TYPE - National ID Type | Char6 | NID Type | ||
| NID_COUNTRY - National ID Country | Char3 | NID Country | ||
| NUM1 - Number 1 | Char6 | Nbr 1 | ||
| NUM2 - Number 2 | Char6 | Nbr 2 | ||
| OFFICER_CD - Officer Code | Char1 | N | Officer Cd | |
| ORIG_HIRE_DT - Original Start Date | Date | Start Date | ||
| OWN_5PERCENT_CO - Owns 5% (or More) of Company | Char1 | Own 5%- Co | ||
| PAID_FTE - Paid FTE | Num2.6 | Paid FTE | ||
| PAID_HOURS - Paid Hours | Num5.2 | Paid Hrs | ||
| PAID_HRS_FREQUENCY - Paid Work Period | Char5 | Work Period | ||
| PAYGROUP - Pay Group | Char3 | Group | ||
| PAY_SYSTEM_FLG - Payroll System | Char2 | N | Payroll System | |
| PAY_UNION_FEE - Pay Union Fee | Char1 | Pay Union Fee | ||
| PER_ORG - Organizational Relationship | Char3 | N | Org Relation | |
| POSITION_ENTRY_DT - Position Entry Date | Date | Posn Dt | ||
| POSITION_NBR - Position Number | Char8 | Position | ||
| POSTAL - Postal Code | Char12 | Postal | ||
| PREF_FIRST_NAME - Preferred First Name | Char30 | Preferred First | ||
| PROBATION_DT - Probation Date | Date | Probation Dates | ||
| REG_REGION - Regulatory Region | Char5 | Reg Region | ||
| 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 | ||
| SECOND_LAST_NAME - Second Last Name | Char30 | Second Last | ||
| SECOND_LAST_SRCH - Second Last Name | Char30 | Second Last | ||
| SEC_CLEARANCE_TYPE - Security Clearance Type | Char3 | Clearance Type | ||
| SERVICE_DT - Service Date | Date | Service Dt | ||
| SETID_DEPT - Department Set ID | Char5 | Dept Set ID | ||
| SETID_JOBCODE - Job Code Set ID | Char5 | Jobcode Set ID | ||
| SETID_LBR_AGRMNT - Labor Agreement Set ID | Char5 | Lab.Agmt SetI D | ||
| SETID_LOCATION - Location Set ID | Char5 | Location Set ID | ||
| SETID_SALARY - Salary Set ID | Char5 | Salary Set ID | ||
| SEX - Gender | Char1 | N | Sex | |
| SHIFT - Regular Shift | Char1 | N | Shift | |
| SHIFT_FACTOR - Shift Differential Factor | Num2.3 | Shift Fctr | ||
| SHIFT_RT - Shift Differential Rate | Num13.6 | Shift Rate | ||
| STATE - State | Char6 | State | ||
| STD_HOURS - Standard Hours | Num5.2 | Stnd Hrs/Wk | ||
| STD_HRS_FREQUENCY - Standard Work Period | Char5 | Work Period | ||
| STEP - Step | Num2.0 | Step | ||
| STEP_ENTRY_DT - Step Entry Date | Date | Step Date | ||
| SUPERVISOR_ID - Supervisor ID | Char11 | Supv ID | ||
| TERMINATION_DT - Termination Date | Date | Term Date | ||
| TWO_RACES_IND_USA - Two or More Races | Char1 | Two Races | ||
| UNION_CD - Union Code | Char3 | Union Code | ||
| UNION_SENIORITY_DT - Union Seniority Date | Date | Union Date | ||
| US_WORK_ELIGIBILTY - Eligible to Work in U.S. | Char1 | US Wk Elig | ||
| VALUE_1_FRA - Value 1 | Char5 | Value 1 | ||
| VALUE_2_FRA - Value 2 | Char5 | Value 2 | ||
| VALUE_3_FRA - Value 3 | Char5 | Value 3 | ||
| VALUE_4_FRA - Value 4 | Char5 | Value 4 | ||
| VALUE_5_FRA - Value 5 | Char5 | Value 5 | ||
| WORK_PHONE - Work Phone # | Char24 | Work Phone | ||
| WPP_STOP_FLAG - Stop Wage Progression | Char1 | Stop WPP |
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.