PA_I_SPOUSE_VW

(SQL View)
Index Back

Spouse Birthdate Info

Used for Pension Web Estimates

SELECT EMPLID , %Substring(NAME,1,40) , BIRTHDATE FROM PS_DEPENDENT_VW WHERE RELATIONSHIP = 'SP'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 SPOUSE_NAME Character(40) VARCHAR2(40) NOT NULL Spouse Name
3 SPOUSE_BIRTHDATE Date(10) DATE Spouse Birthdate