SEV_EVNT_TYP_VW

(SQL View)
Index Back

SEVIS Event Type


SELECT DISTINCT SEV_STDNT_TYPE ,EFFDT ,EFF_STATUS FROM PS_SEV_EVENT_TYPE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SEV_STDNT_TYPE Character(2) VARCHAR2(2) NOT NULL SEVIS Student Visa Category
EV=Exchange Visitor
FM=F or M Visa Student

Default Value: FM

2 EFFDT Date(10) DATE Effective Date

Default Value: %date

3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A