EMPLIDSEV_PASS_NMFMVW(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.LAST_NAME||' '|| NAMES_VW.FIRST_NAME ELSE NAMES_VW.LAST_NAME||' '|| NAMES_VW.FIRST_NAME||' '|| NAMES_VW.MIDDLE_NAME END FROM PS_NAMES_VW NAMES_VW WHERE NAMES_VW.NAME_TYPE = ( SELECT SEV_PASS_FMTYPE 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_PASS_NAME | Character(145) | VARCHAR2(145) NOT NULL | SEVIS Preferred Name |