SSF_IHC_EXPDTVW (SQL View)	Index Back
Visa Expiration Date View This is a view of VISA_PMT_DATA. It selects the row with the largest expiration data in the future. Used to display exipration date on International Student Health Coverage Student Maintenance page (SSF_IHC_STDNT).

SSF_IHC_EXPDTVW

(SQL View)

Visa Expiration Date View

This is a view of VISA_PMT_DATA. It selects the row with the largest expiration data in the future. Used to display exipration date on International Student Health Coverage Student Maintenance page (SSF_IHC_STDNT).

SELECT A.EMPLID , A.EXPIRATN_DT FROM PS_VISA_PMT_DATA A WHERE A.EXPIRATN_DT = ( SELECT MAX (A1.EXPIRATN_DT) FROM PS_VISA_PMT_DATA A1 WHERE A1.EMPLID = A.EMPLID AND A1.EXPIRATN_DT > %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 EXPIRATN_DT Date(10) DATE Expiration Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EXPIRATN_DT	Date(10)	DATE	Expiration Date