PERSONAL_DATA - PERSONAL_DATA for Rpting

Body

 

WARNING: Field Name Definitions are Linked to the UMS Data Cookbook - this requires a University of Maine System ID and password

This Table includes Personal (sensitive) Details from Student and Human Resources Data

Detailed Information

Data Systems

PeopleSoft Campus Solutions CSPRD 
PeopleSoft Campus Solutions Reporting CSRPT

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
Key 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

 

Details

Details

Article ID: 158837
Created
Fri 5/10/24 4:26 AM
Modified
Mon 8/19/24 12:11 PM
Applies To
Faculty
Staff
Community

Related Services / Offerings

Related Services / Offerings (1)

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