SRCH_PER_DTL_VW(SQL View) |
Index Back |
|---|
| SELECT A.EMPLID , A.BIRTHDATE , B.COUNTRY , B.NATIONAL_ID , B.NATIONAL_ID_TYPE , NAMES.NAME_TYPE , NAMES.FIRST_NAME , NAMES.LAST_NAME FROM PS_PERSON A LEFT OUTER JOIN PS_PERS_NID B ON ( A.EMPLID = B.EMPLID) LEFT OUTER JOIN PS_NAMES NAMES ON (A.EMPLID = NAMES.EMPLID) WHERE (B.PRIMARY_NID = 'Y' OR B.PRIMARY_NID =' ') AND NAMES.NAME_TYPE = 'PRI' AND NAMES.EFF_STATUS = 'A' AND NAMES.EFFDT = ( SELECT MAX(NAMES1.EFFDT) FROM PS_NAMES NAMES1 WHERE NAMES1.EMPLID = NAMES.EMPLID AND NAMES1.NAME_TYPE = NAMES.NAME_TYPE AND NAMES1.EFFDT <= %CurrentDateIn ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | BIRTHDATE | Date(10) | DATE | Date of Birth |
| 3 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 4 | NATIONAL_ID | Character(20) | VARCHAR2(20) NOT NULL | National ID |
| 5 | NATIONAL_ID_TYPE | Character(6) | VARCHAR2(6) NOT NULL | National ID Type |
| 6 | NAME_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Type of Name |
| 7 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 8 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |