SEV_POE_ADM_VW

(SQL View)
 Index Back

Port of Entry Data View

This view displays the most recent Port of Entry Admission nUmber for an Emplid.

SELECT A.EMPLID ,A.SEV_ADM_NBR FROM PS_SEV_POE_DATA A WHERE A.SEV_ENTRY_DT = ( SELECT MAX(B.SEV_ENTRY_DT) FROM PS_SEV_POE_DATA B WHERE A.EMPLID = B.EMPLID)

  • Parent record: VISA_PMT_DATA

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    2 SEV_ADM_NBR Character(11) VARCHAR2(11) NOT NULL SEVIS Admission Number