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
, PD.BIRTHDATE **(Month and day only)
, PD.BIRTHPLACE
, PD.BIRTHCOUNTRY
, PD.BIRTHSTATE
, PD.DT_OF_DEATH
, PD.HIGHEST_EDUC_LVL
, PD.FT_STUDENT
, PD.LANG_CD
, PD.ALTER_EMPLID
, PD.ADDRESS1_AC
, PD.ADDRESS2_AC
, PD.ADDRESS3_AC
, PD.CITY_AC
, PD.COUNTRY_OTHER
, PD.ADDRESS1_OTHER
, PD.ADDRESS2_OTHER
, PD.ADDRESS3_OTHER
, PD.ADDRESS4_OTHER
, PD.CITY_OTHER
, PD.COUNTY_OTHER
, PD.STATE_OTHER
, PD.POSTAL_OTHER
, PD.NUM1_OTHER
, PD.NUM2_OTHER
, PD.HOUSE_TYPE_OTHER
, PD.ADDR_FIELD1_OTHER
, PD.ADDR_FIELD2_OTHER
, PD.ADDR_FIELD3_OTHER
, PD.IN_CITY_LMT_OTHER
, PD.GEO_CODE_OTHER
, PD.COUNTRY_CODE
, PD.PHONE
, PD.EXTENSION
, PD.VA_BENEFIT
, PD.CAMPUS_ID
, PD.DEATH_CERTIF_NBR
, PD.FERPA
, PD.PLACE_OF_DEATH
, PD.US_WORK_ELIGIBILTY
, PD.MILITARY_STATUS
, PD.CITIZEN_PROOF1
, PD.CITIZEN_PROOF2
, PD.MEDICARE_ENTLD_DT
, PD.CPAMID
, PD.BILINGUALISM_CODE
, PD.HEALTH_CARE_NBR
, PD.HEALTH_CARE_STATE
, PD.SOC_SEC_AFF_DT
, PD.EXPCTD_MILITARY_DT
, PD.HR_RESPONSIBLE_ID
, PD.SMOKER
, PD.SMOKER_DT
, PD.GVT_CRED_MIL_SVCE
, PD.GVT_MILITARY_COMP
, PD.GVT_MIL_GRADE
, PD.GVT_MIL_RESRVE_CAT
, PD.GVT_MIL_SEP_RET
, PD.GVT_MIL_SVCE_END
, PD.GVT_MIL_SVCE_START
, 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
, substr (NID.NATIONAL_ID, 6, 4)
, EA.EMAIL_ADDRESSADDR
FROM PS_PERSONAL_DATA PD, PS_PERS_NID NID, PS_EMAIL_ADDRESSES EA
WHERE PD.EMPLID = NID.EMPLID (+)
AND 'USA' = NID.COUNTRY (+)
AND 'PR' = NID.NATIONAL_ID_TYPE (+)
AND PD.EMPLID = EA.EMPLID (+)
AND 'CAMP' = EA.EMAILE_ADDR_TYPE (+)
|