SEV_PRG_NBRPrompt Table: SEV_PRG_SP_TBL
SEV_RO_EMPLIDPrompt Table: PEOPLE_SRCH
SEV_PRG_OFF_VW(SQL View) |
Index Back |
|---|---|
SEVIS Program Number/RO View |
| SELECT A.SEV_PRG_NBR , A.EMPLID , B.NAME FROM PS_SEV_PRG_OFF_TBL A , PS_PERSONAL_VW B WHERE A.EMPLID = B.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SEV_PRG_NBR |
Character(9) | VARCHAR2(9) NOT NULL |
SEVIS Program Number
Prompt Table: SEV_PRG_SP_TBL |
| 2 | SEV_RO_EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Responsible Officer
Prompt Table: PEOPLE_SRCH |
| 3 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |