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
INST_A_PD_VW(SQL View) |
Index Back |
|---|---|
Inst Sec A Personal DataView is used to display student personal data information on Profile Pages. |
| SELECT A.EMPLID ,A.NAME ,A.NATIONAL_ID ,A.BIRTHDATE ,B.MAR_STATUS ,A.NID_COUNTRY ,A.NATIONAL_ID_TYPE FROM PS_PEOPLE_SRCH A , PS_HCR_PER_PDE_I B WHERE A.EMPLID = B.EMPLID AND B.EFFDT = ( SELECT MAX (B2.EFFDT) FROM PS_HCR_PER_PDE_I B2 WHERE B2.EMPLID = B.EMPLID) |
| # | 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 |
| 6 | NID_COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | National ID Country |
| 7 | NATIONAL_ID_TYPE | Character(6) | VARCHAR2(6) NOT NULL | National ID Type |