EMPLIDNAME_TYPEGPDE_NMTYPE_VW(SQL View) |
Index Back |
|---|---|
View to Retrive NameView to Retrive correct Name type for Germany reporting. |
| SELECT EMPLID , NAME_TYPE FROM PS_NAME_TYPE_VW A WHERE ( NOT EXISTS( SELECT 'x' FROM PS_NAME_TYPE_VW B WHERE B.EMPLID = A.EMPLID AND B.NAME_TYPE IN ( SELECT C.NAME_TYPE FROM PS_GPDE_AL_INSTALL C) ) AND ORDER_BY_SEQ = ( SELECT MIN(D.ORDER_BY_SEQ) FROM PS_NAME_TYPE_VW D WHERE D.EMPLID = A.EMPLID) ) OR NAME_TYPE IN ( SELECT NAME_TYPE FROM PS_GPDE_AL_INSTALL) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | NAME_TYPE |
Character(3) | VARCHAR2(3) NOT NULL | Type of Name |