EMPLIDSEV_PREF_NMJVW(SQL View) |
Index Back |
|---|---|
Passport name FM viewSevis Passport name FM view |
| SELECT NAMES_VW.EMPLID ,CASE NAMES_VW.MIDDLE_NAME WHEN ' ' THEN NAMES_VW.FIRST_NAME||' '|| NAMES_VW.LAST_NAME||' '|| NAMES_VW.NAME_SUFFIX ELSE NAMES_VW.FIRST_NAME||' '|| NAMES_VW.MIDDLE_NAME||' '||NAMES_VW.LAST_NAME||' '|| NAMES_VW.NAME_SUFFIX END FROM PS_NAMES_VW NAMES_VW WHERE NAMES_VW.NAME_TYPE = ( SELECT SEV_PREF_JTYPE FROM PS_SEV_SETUP1_TBL) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | SEV_PREF_NAME | Character(145) | VARCHAR2(145) NOT NULL | SEVIS Preferred Name |