PERSONAL_DATA - EE Personal Data

This table exists in Human Resources - HR, this is a version available in Financials  

Detailed Information

Data Systems

PeopleSoft Human Resources - HRPRD
PeopleSoft Financials -FNPRD

Key Record.Fieldname Format XLAT Heading Text
  ADDRESS1 - Address Line 1 Char55   Address 1
  ADDRESS1_AC - Alternate Character Address 1 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 Addr 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
  AGE_STATUS - Age 18 or Older Char1   Age 18+
  ALTER_EMPLID - Alternate Employee ID Char11   Alternate ID
  APPLID - Applicant ID Char11   App ID
  APP_DT - Application Date Date   Applic Dt
  BARG_UNIT - Bargaining Unit Char4   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
  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   Cntry
  COUNTRY_CODE - Int'l Prefix Char3   Prefix
  COUNTRY_NM_FORMAT - Format for Country Char3   Format for
  COUNTRY_OTHER - Country - Other Char3   Country
  COUNTY - County Char30   County
  COUNTY_OTHER - County - Other Char30   County
  CPAMID - CPAM ID Char6   CPAMID
  DISABLED - Disabled Char1   Disabled
  DISABLED_VET - Disabled Veteran Char1   Disab Vet
  DT_OF_DEATH - Date of Death Date   Death Date
Key EMPLID - Employee ID Char11   Empl ID
  EMPL_REFERRAL_ID - Employee Referral ID Char11   Refer ID
  ENTRY_DT_FRA - Date of First Entry in France Date   Entry Dt
  ETHNIC_GROUP - Ethnic Group Char1   Ethnic Grp
  EXPCTD_MILITARY_DT - Expected Military Date Date   Expctd MDt
  FIRST_NAME - First Name Char30   FirstName
  FIRST_NAME_SRCH - First Name Char30   First Name
  FT_STUDENT - Full-Time Student Char1   FT Student
  GEO_CODE - Tax Supplier Geographical Code Char11   Geocode
  GEO_CODE_OTHER - Geo Code Other Char11   Geo Cd Other
  GRADE - Salary Grade Char3   Grade
  GUARDIAN_CHE - Guardian Char40   Guardian
  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   Draft Sts
  GVT_HIGH_GRADE - Highest Grade Char3   Grade
  GVT_HIGH_PAY_PLAN - Highest Pay Plan Char3   Highest PP
  GVT_MILITARY_COMP - Uniformed Service Char1   Component
  GVT_MIL_GRADE - Military Grade Char3   Mil Grade
  GVT_MIL_RESRVE_CAT - Reserve Category Char1   Resrve Cat
  GVT_MIL_SEP_RET - Military Separation Status Char1   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   Incentive
  GVT_SEP_INCENT_DT - Separation Incentive Date Date   Date
  GVT_TENURE - Highest Career Tenure Char1   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
  HIGHLY_COMP_EMPL_C - Highly Compensated Employee Char1 N HCE
  HIGHLY_COMP_EMPL_P - Highly Compensated Last Year Char1 N Prev HCE
  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 Lim
  IN_CITY_LMT_OTHER - In City Limit Other Char1   In Cty Lt Other
  LANG_CD - Language Code Char3 N Lang Cd
  LAST_NAME - Last Name Char30   LastName
  LAST_NAME_SRCH - Last Name Char30   Last Name
  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 Name
  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   Military Status
  MILITARY_TYPE_ITA - Type of Service Char2   Type of Service
  MILIT_SITUATN_ESP - Military Status Char3   Military
  MILIT_SITUATN_FRA - Military Status Char3 N Military
  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
  NUM1 - Number 1 Char6   Nbr 1
  NUM1_OTHER - Number 1 Other Char6   Nbr 1 Other
  NUM2 - Number 2 Char4   Nbr 2
  NUM2_OTHER - Number 2 Other Char4   Nbr 2 Other
  ON_DM_EM_DOSAVENOW - On Demand EM DoSaveNow Char1   DoSaveNow ONDM
  ORIG_HIRE_DT - Original Hire Date Date   Hire Date
  PER_STATUS - Personnel Status Char1 N Per Status
  PER_TYPE - Person Type Char1 N Per Type
  PHONE - Telephone Char24   Phone
  POSTAL - Postal Code Char12   Postal
  POSTAL_OTHER - Postal Code Char12   Postal
  PREF_FIRST_NAME - Preferred First Name Char30   Preferred First
  QDRO_IND_YN - Empl has QDRO indicator (Y/N) Char1   QDROIndYN
  REFERRAL_SOURCE - Referral Source Char2 N Ref Source
  RESUME_TEXT_FILE - Resume Text File Char64   Text File
  SAL_ADMIN_PLAN - Salary Administration Plan Char4   Sal Plan
  SECOND_LAST_NAME - Second Last Name Char30   Second Name
  SECOND_LAST_SRCH - Second Name Char30   Second Name
  SEX - Gender Char1 N Sex
  SMOKER - Smoker Char1   Smoker
  SOC_SEC_AFF_DT - Social Security Affilation Dt Date   Soc.SecAff.Dt
  SPECIFIC_REFER_SRC - Specific Referral Source Char30   Specfc Src
  STATE - State Char6   St
  STATE_OTHER - State - Other Char6   State
  SYNCDTTM - Sync Date Time DateTm   Sync Date Time
  SYNCID - Synchronization ID Num10.0   Sync ID
  TAX_BASIS_UK - Tax Basis Char1 N Tax Basis
  TAX_CODE_UK - Tax Code Char5   Tax Code
  US_WORK_ELIGIBILTY - Eligible to Work in U.S. Char1   US Wk Elig
  YEARS_OF_EXP - Years of Work Experience Num4.1   Rel Work Exper

 

Submit an Inquiry or Request to DARTS Print Article

Related Services / Offerings (1)

DARTS (UMS Data) Inquiry
Submit an inquiry about UMS Data (except Data Governance)