SEV_VISA_PMT_VW

(SQL View)
Index Back

SEVIS Visa Permit VW

Use SEV_VISA_PMT_VW to retrieve Visa_Permit_Type for Emplid and Country.

SELECT EMPLID , COUNTRY , VISA_PERMIT_TYPE FROM PS_VISA_PMT_DATA WHERE DEPENDENT_ID = ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
3 VISA_PERMIT_TYPE Character(3) VARCHAR2(3) NOT NULL Visa/Permit Type