SEV_VISATYPE_VW

(SQL View)
Index Back

SEVIS Visa Type View


SELECT A.EMPLID , B.SEV_VISA_TYPE FROM PS_VISA_PMT_DATA A , PS_SEV_VISA_TBL B WHERE A.DEPENDENT_ID = ' ' AND A.COUNTRY = 'USA' AND B.COUNTRY = A.COUNTRY AND B.VISA_PERMIT_TYPE = A.VISA_PERMIT_TYPE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 SEV_VISA_TYPE Character(2) VARCHAR2(2) NOT NULL SEVIS Visa Type
01=F-1
02=M-1
03=J-1
04=F-2
05=M-2
06=J-2
99=No Visa Type

Default Value: 99