Product: | IGS - Student System (Obsolete) |
---|---|
Description: | View for fetching legal informations for Exchange Visitor students |
Implementation/DBA Data: | Not implemented in this database |
SELECT LGL.BATCH_ID
, LGL.PERSON_ID
, LGL.PRINT_FORM
, LGL.PSPRT_NUMBER
, LGL.PSPRT_ISSUING_CNTRY_CODE
, LGL.PSPRT_EXP_DATE
, LGL.VISA_NUMBER
, LGL.VISA_ISSUING_POST
, LGL.VISA_ISSUING_CNTRY_CODE
, LGL.VISA_ISSUE_DATE
, LGL.VISA_EXPIRATION_DATE
, LGL.I94_NUMBER
, LGL.PORT_OF_ENTRY
, LGL.DATE_OF_ENTRY
, LGL.REMARKS
FROM IGS_SV_LEGAL_INFO LGL
, IGS_SV_BTCH_SUMMARY LEGALSUMM
WHERE LGL.PERSON_ID = LEGALSUMM.PERSON_ID
AND LGL.BATCH_ID = LEGALSUMM.BATCH_ID
AND LEGALSUMM.TAG_CODE = 'SV_LEGAL'
AND LEGALSUMM.ADM_ACTION_CODE = 'SEND'