PA_I_SPOUSE_VW(SQL View) |
Index Back |
---|---|
Spouse Birthdate InfoUsed 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 |