EMPLIDC=Common-Law
D=Divorced
E=Separated
H=Head of Household
L=DissDeclLost Civil Partner
M=Married
P=Civil Partnership
S=Single
T=Surviving Civil Partner
U=Unknown
V=Dissolved Civil Partnership
W=Widowed
SEC_A_PD_VW(SQL View) |
Index Back |
|---|---|
ISIR Sec A Personal Data |
| SELECT A.EMPLID ,A.NAME ,A.NATIONAL_ID ,A.BIRTHDATE ,B.MAR_STATUS FROM PS_PEOPLE_SRCH A , PS_HCR_PER_PDE_I B WHERE A.EMPLID = B.EMPLID AND A.NID_COUNTRY = 'USA' AND A.NATIONAL_ID_TYPE = 'PR' AND B.EFFDT = ( SELECT MAX (B2.EFFDT) FROM PS_HCR_PER_PDE_I B2 WHERE B2.EMPLID = B.EMPLID AND B2.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 3 | NATIONAL_ID | Character(20) | VARCHAR2(20) NOT NULL | National ID |
| 4 | BIRTHDATE | Date(10) | DATE | Date of Birth |
| 5 | MAR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Marital Status
C=Common-Law D=Divorced E=Separated H=Head of Household L=DissDeclLost Civil Partner M=Married P=Civil Partnership S=Single T=Surviving Civil Partner U=Unknown V=Dissolved Civil Partnership W=Widowed |