Created by Corina C Larsen, last modified on Apr 22, 2020
Do not use this table.
This table is not available to query directly. Many of the fields, however, are included in the UM_STUD_EXTRACT - Student Reporting Extract and can be queried there.
This table does exist in HR where it is available to query.
| Key | Record.Fieldname | Format | XLAT | Heading Text |
|---|---|---|---|---|
| ADDRESS1 - Address Line 1 | Char55 | Address 1 | ||
| ADDRESS1_AC - Alternate Character Address | Char55 | AC Address 1 | ||
| ADDRESS1_OTHER - Address Line 1 | Char55 | Address 1 | ||
| ADDRESS2 - Address Line 2 | Char55 | Address 2 | ||
| ADDRESS2_AC - Alternate Character Address 2 | Char55 | AC Address 2 | ||
| ADDRESS2_OTHER - Address Line 2 | Char55 | Address 2 | ||
| ADDRESS3 - Address Line 3 | Char55 | Address 3 | ||
| ADDRESS3_AC - Alternate Character Address 3 | Char55 | AC Address 3 | ||
| ADDRESS3_OTHER - Address Line 3 | Char55 | Address 3 | ||
| ADDRESS4 - Address Line 4 | Char55 | Address 4 | ||
| ADDRESS4_OTHER - Address Line 4 | Char55 | Address 4 | ||
| ADDR_FIELD1 - Address Field 1 | Char2 | N | Address Field 1 | |
| ADDR_FIELD1_OTHER - Address Field 1 | Char2 | N | Address Field 1 | |
| ADDR_FIELD2 - Address Field 2 | Char4 | Address Field 2 | ||
| ADDR_FIELD2_OTHER - Address Field 2 | Char4 | Address Field 2 | ||
| ADDR_FIELD3 - Address Field 3 | Char4 | Address Field 3 | ||
| ADDR_FIELD3_OTHER - Address Field 3 | Char4 | Address Field 3 | ||
| ALTER_EMPLID - Alternate Employee ID | Char11 | Alternate ID | ||
| BARG_UNIT - Bargaining Unit | Char4 | N | Barg Unit | |
| BILINGUALISM_CODE - Bilingualism Code | Char1 | N | Bilingual | |
| BIRTHCOUNTRY - Birth Country | Char3 | Country | ||
| BIRTHDATE - Date of Birth | Date | Birthdate | ||
| BIRTHPLACE - Birth Location | Char30 | Birthplace | ||
| BIRTHSTATE - Birth State | Char6 | State | ||
| CAMPUS_ID - Campus ID | Char16 | Campus ID | ||
| CITIZEN_PROOF1 - Citizenship (Proof 1) | Char10 | Citizen 1 | ||
| CITIZEN_PROOF2 - Citizenship (Proof 2) | Char10 | Citizen 2 | ||
| CITY - City | Char30 | City | ||
| CITY_AC - Alternate Character City | Char30 | AC City | ||
| CITY_OTHER - City - Other | Char30 | City | ||
| COUNTRY - Country | Char3 | Country | ||
| COUNTRY_CODE - Country Code | Char3 | Country | ||
| COUNTRY_NM_FORMAT - Format Using | Char3 | Use | ||
| COUNTRY_OTHER - Country - Other | Char3 | Country | ||
| COUNTY - County | Char30 | County | ||
| COUNTY_OTHER - County - Other | Char30 | County | ||
| CPAMID - CPAM ID | Char6 | CPAMID | ||
| DEATH_CERTIF_NBR - Death Certificate Nbr | Char10 | Certif Nbr | ||
| DISABLED - Disabled | Char1 | Disabled | ||
| DISABLED_VET - Disabled Veteran | Char1 | Disab Vet | ||
| DT_OF_DEATH - Date of Death | Date | Death Date | ||
| → | EMPLID - Empl ID | Char11 | ID | |
| ENTRY_DT_FRA - Date of First Entry in France | Date | Entry Dt | ||
| EXPCTD_MILITARY_DT - Expected Military Date | Date | Expctd MDt | ||
| EXTENSION - Phone Extension | Char6 | Ext | ||
| FERPA - FERPA | Char1 | FERPA | ||
| FIRST_NAME - First Name | Char30 | First Name | ||
| FIRST_NAME_SRCH - First Name | Char30 | First Name | ||
| FT_STUDENT - Full-Time Student | Char1 | FT Student | ||
| GEO_CODE - Tax Vendor Geographical Code | Char11 | Geo Code | ||
| GEO_CODE_OTHER - Geo Code Other | Char11 | Geo Cd Other | ||
| GRADE - Salary Grade | Char3 | Grade | ||
| GVT_CHANGE_FLAG - Change Flag | Char1 | Chnge Flag | ||
| GVT_CRED_MIL_SVCE - Creditable Military Service | Char4 | Cred Milty | ||
| GVT_CURR_AGCY_EMPL - Current Agency Employee | Char1 | CurrAgcyEm | ||
| GVT_CURR_FED_EMPL - Current Federal Employee | Char1 | CurrFedEmp | ||
| GVT_DISABILITY_CD - Disability Code | Char2 | Disability Cd | ||
| GVT_DRAFT_STATUS - Draft Status | Char1 | N | Draft Sts | |
| GVT_HIGH_GRADE - Highest Grade | Char3 | Grade | ||
| GVT_HIGH_PAY_PLAN - Highest Pay Plan | Char2 | Highest PP | ||
| GVT_MILITARY_COMP - Uniformed Service | Char1 | N | Component | |
| GVT_MIL_GRADE - Military Grade | Char3 | N | Mil Grade | |
| GVT_MIL_RESRVE_CAT - Reserve Category | Char1 | N | Resrve Cat | |
| GVT_MIL_SEP_RET - Military Separation Status | Char1 | N | Sep Status | |
| GVT_MIL_SVCE_END - Military Service End Date | Date | End Date | ||
| GVT_MIL_SVCE_START - Military Service Start Date | Date | Start Date | ||
| GVT_MIL_VERIFY - Military Service Verified | Char1 | Svce Verf | ||
| GVT_PAR_NBR_LAST - Last Personnel Action Reqst # | Num6.0 | Last PAR# | ||
| GVT_PAY_PLAN - Pay Plan | Char2 | Pay Plan | ||
| GVT_PREV_AGCY_EMPL - Previous Agency Employee | Char1 | PrevAgcyEm | ||
| GVT_PREV_FED_EMPL - Previous Federal Employee | Char1 | PrevFedEmp | ||
| GVT_SEP_INCENTIVE - Separation Incentive | Char1 | N | Incentive | |
| GVT_SEP_INCENT_DT - Separation Incentive Date | Date | Date | ||
| GVT_TENURE - Highest Career Tenure | Char1 | N | Tenure | |
| GVT_UNIF_SVC_CTR - Notify Military Pay Center | Char1 | SvcPayCtr | ||
| GVT_VET_PREF_APPT - Veterans Preference | Char1 | Veterans Pref | ||
| GVT_VET_PREF_RIF - Veterans Preference RIF | Char1 | Pref RIF | ||
| GVT_YR_ATTAINED - Year Attained | Date | Year | ||
| HEALTH_CARE_NBR - Health Care Number | Char12 | Health# | ||
| HEALTH_CARE_STATE - Health Care Province | Char6 | Hlth Prov | ||
| HIGHEST_EDUC_LVL - Highest Education Level | Char2 | N | Hi Educ Lv | |
| HONSEKI_JPN - Honseki Prefecture | Char2 | Honseki | ||
| HOUSE_TYPE - House Type | Char2 | N | House | |
| HOUSE_TYPE_OTHER - House Type Other | Char2 | N | House Other | |
| HR_RESPONSIBLE_ID - HR Responsible ID | Char11 | HR ID | ||
| IN_CITY_LIMIT - In City Limit | Char1 | In Cty Lmt | ||
| IN_CITY_LMT_OTHER - In City Limit Other | Char1 | In Cty Lt Other | ||
| LANG_CD - Language Code | Char3 | N | Lang Cd | |
| LASTUPDDTTM - Last Update Date/Time | DateTm | Last Upd DtTm | ||
| LAST_NAME - Last Name | Char30 | Last | ||
| LAST_NAME_PREF_NLD - Last Name Preference | Char1 | N | Preference | |
| LAST_NAME_SRCH - Last Name | Char30 | Last | ||
| MAR_STATUS - Marital Status | Char1 | N | Mar Status | |
| MAR_STATUS_DT - Marital Status Date | Date | Mar StatDt | ||
| MEDICARE_ENTLD_DT - Date Entitled to Medicare | Date | Medcare Dt | ||
| MIDDLE_NAME - Middle Name | Char30 | Middle | ||
| MILITARY_END_ITA - Military End Date | Date | End Date | ||
| MILITARY_RANK_ITA - Function or Rank | Char50 | Function/Rank | ||
| MILITARY_STATUS - Military Status | Char1 | N | Mil Status | |
| MILITARY_STAT_GER - Military Status | Char1 | N | Military Status | |
| MILITARY_STAT_ITA - Military Status Italy | Char1 | N | Military Status | |
| MILITARY_TYPE_ITA - Type of Service | Char2 | N | Type of Service | |
| MILIT_SITUATN_ESP - Military Status | Char3 | N | Military | |
| MILIT_SITUATN_FRA - Military Status | Char3 | N | Military | |
| NAME - Name | Char50 | Name | ||
| NAME_AC - Alternate Character Name | Char50 | AC Name | ||
| NAME_DISPLAY - Display Name | Char50 | Display Name | ||
| NAME_FORMAL - Formal Name | Char60 | Formal 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 | ||
| NUM1 - Number 1 | Char6 | Nbr 1 | ||
| NUM1_OTHER - Number 1 Other | Char6 | Nbr 1 Other | ||
| NUM2 - Number 2 | Char6 | Nbr 2 | ||
| NUM2_OTHER - Number 2 Other | Char6 | Nbr 2 Other | ||
| PARTNER_LAST_NAME - Last Name Partner | Char30 | Last Name | ||
| PARTNER_ROY_PREFIX - Prefix Partner | Char15 | Prefix | ||
| PHONE - Telephone | Char24 | Phone | ||
| PLACE_OF_DEATH - Place of Death | Char30 | Death Plce | ||
| POSTAL - Postal Code | Char12 | Postal | ||
| POSTAL_OTHER - Postal Code - Other | Char12 | Postal | ||
| PREF_FIRST_NAME - Preferred First Name | Char30 | Preferred First | ||
| SAL_ADMIN_PLAN - Salary Administration Plan | Char4 | Sal Plan | ||
| SECOND_LAST_NAME - Second Last Name | Char30 | Second Last | ||
| SECOND_LAST_SRCH - Second Name | Char30 | Second Name | ||
| SEX - Gender | Char1 | N | Sex | |
| SMOKER - Smoker | Char1 | Smoker | ||
| SMOKER_DT - Smoker Date | Date | Smoker Date | ||
| SOC_SEC_AFF_DT - Social Security Affiliation Dt | Date | Soc.SecAff.Dt | ||
| STATE - State | Char6 | State | ||
| STATE_OTHER - State - Other | Char6 | State | ||
| US_WORK_ELIGIBILTY - Eligible to Work in U.S. | Char1 | US Wk Elig | ||
| VA_BENEFIT - VA Benefit | Char1 | VA Benefit |
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.