EMPLIDSEV_PRG_NBRSEV_DEP_EMPLIDEFFDTDefault Value: %date
SEV_EV_DEP_VW(SQL View) |
Index Back |
|---|---|
Dependent ViewActive SEVIS Exchange Visitor Dependents with a current SEVIS ID. |
| SELECT A.EMPLID , A.SEV_PRG_NBR , A.SEV_DEP_EMPLID , A.EFFDT , C.NAME , C.LAST_NAME_SRCH , D.CAMPUS_ID , B.SEV_ID FROM PS_DS2019_DEP A , PS_SEV_ID_MAINT B , PS_SCC_CUR_NAME_VW C , PS_SCC_PERS_SA_VW D WHERE A.SEV_DEP_EMPLID = C.EMPLID AND A.SEV_DEP_EMPLID = B.EMPLID AND A.SEV_DEP_EMPLID = D.EMPLID AND C.EMPLID = D.EMPLID AND B.SEV_SCHOOL_CD = ' ' AND A.SEV_PRG_NBR = B.SEV_PRG_NBR AND %EffdtCheck (DS2019_DEP A1, A, %CurrentDateIn) AND %EffdtCheck (SEV_ID_MAINT B1, B, %CurrentDateIn) AND A.SEV_DS_REL_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | SEV_PRG_NBR |
Character(9) | VARCHAR2(9) NOT NULL | SEVIS Program Number |
| 3 | SEV_DEP_EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | SEVIS Dependent ID |
| 4 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 6 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 7 | CAMPUS_ID | Character(16) | VARCHAR2(16) NOT NULL | Campus ID |
| 8 | SEV_ID | Character(11) | VARCHAR2(11) NOT NULL | SEVIS ID |