Select PD.EMPLID
, PD.COUNTRY_NM_FORMAT
, PD.NAME, PD.NAME_INITIALS
, PD.NAME_PREFIX
, PD.NAME_SUFFIX
, PD.NAME_ROYAL_PREFIX
, PD.NAME_ROYAL_SUFFIX
, PD.NAME_TITLE
, PD. LAST_NAME_SRCH
, PD.FIRST_NAME_SRCH
, PD.LAST_NAME
, PD.FIRST_NAME
, PD.MIDDLE_NAME
, PD.SECOND_LAST_NAME
, PD.SECOND_LAST_SRCH
, PD.NAME_AC
, PD.PREF_FIRST_NAME
, PD.PARTNER_LAST_NAME
, PD.PARTNER_ROY_PREFIX
, PD.LAST_NAME_PREF_NLD
, PD.NAME_DISPLAY
, PD.NAME_FORMAL
, PD.COUNTRY
, PD.ADDRESS1
, PD.ADDRESS2
, PD.ADDRESS3
, PD.ADDRESS4
, PD.CITY
, PD.NUM1
, PD.NUM2
, PD.HOUSE_TYPE
, PD.ADDR_FIELD1
, PD.ADDR_FIELD2
, PD.ADDR_FIELD3
, PD.COUNTY
, PD.STATE
, PD.POSTAL
, PD.GEO_CODE
, PD.IN_CITY_LIMIT
, PD.SEX
, PD.MAR_STATUS
, PD.MAR_STATUS_DT
BIRTHDATE **(Month and day only)
BIRTHPLACE
BIRTHCOUNTRY
BIRTHSTATE
DT_OF_DEATH
HIGHEST_EDUC_LVL
FT_STUDENT
LANG_CD
ALTER_EMPLID
ADDRESS1_AC
ADDRESS2_AC
ADDRESS3_AC
CITY_AC
COUNTRY_OTHER
ADDRESS1_OTHER
ADDRESS2_OTHER
ADDRESS3_OTHER
ADDRESS4_OTHER
CITY_OTHER
COUNTY_OTHER
STATE_OTHER
POSTAL_OTHER
NUM1_OTHER
NUM2_OTHER
HOUSE_TYPE_OTHER
ADDR_FIELD1_OTHER
ADDR_FIELD2_OTHER
ADDR_FIELD3_OTHER
IN_CITY_LMT_OTHER
GEO_CODE_OTHER
COUNTRY_CODE
PHONE
EXTENSION
VA_BENEFIT
CAMPUS_ID
DEATH_CERTIF_NBR
FERPA
PLACE_OF_DEATH - Place of Death
US_WORK_ELIGIBILTY - Eligible to Work in U.S.
MILITARY_STATUS - Military Status
CITIZEN_PROOF1 - Citizenship (Proof 1)
CITIZEN_PROOF2 - Citizenship (Proof 2)
MEDICARE_ENTLD_DT - Date Entitled to Medicare
HONSEKI_JPN - Honseki Prefecture
MILITARY_STAT_ITA - Military Status Italy
MILITARY_TYPE_ITA - Type of Service
MILITARY_RANK_ITA - Function or Rank
MILITARY_END_ITA - Military End Date
ENTRY_DT_FRA - Date of First Entry in France
MILIT_SITUATN_FRA - Military Status
CPAMID - CPAM ID
BILINGUALISM_CODE - Bilingualism Code
HEALTH_CARE_NBR - Health Care Number
HEALTH_CARE_STATE - Health Care Province
MILIT_SITUATN_ESP - Military Status
SOC_SEC_AFF_DT - Social Security Affiliation Dt
MILITARY_STAT_GER - Military Status
EXPCTD_MILITARY_DT - Expected Military Date
HR_RESPONSIBLE_ID - HR Responsible ID
SMOKER - Smoker
SMOKER_DT - Smoker Date
GVT_CRED_MIL_SVCE - Creditable Military Service
GVT_MILITARY_COMP - Uniformed Service
GVT_MIL_GRADE - Military Grade
GVT_MIL_RESRVE_CAT - Reserve Category
GVT_MIL_SEP_RET - Military Separation Status
GVT_MIL_SVCE_END - Military Service End Date
GVT_MIL_SVCE_START - Military Service Start Date
, PD.GVT_MIL_VERIFY
, PD.GVT_PAR_NBR_LAST
, PD.GVT_UNIF_SVC_CTR
, PD.GVT_VET_PREF_APPT
, PD.GVT_VET_PREF_RIF
, PD.GVT_CHANGE_FLAG
, PD.GVT_DRAFT_STATUS
, PD.GVT_YR_ATTAINED
, PD.DISABLED_VET
, PD.DISABLED
, PD.GVT_DISABILITY_CD
, PD.LASTUPDDTTM
FROM PS_PERSONAL_DATA PD
|