[Home] [Help]
View: IGS_SV_EDT_TRAVEL_V
Product: | IGS - Student System (Obsolete) |
Description: | View for fetching modified legal informations for Non-Immigrant |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT LGL.PERSON_ID
, LGL.BATCH_ID
, LGL.PSPRT_NUMBER
, LGL.PSPRT_ISSUING_CNTRY_CODE PSPT_ISSUING_CNTRY
, LGL.PSPRT_EXP_DATE PSPRT_EXPIRY_DATE
, LGL.VISA_NUMBER
, LGL.VISA_ISSUING_CNTRY_CODE VISA_ISSUING_CNTRY
, LGL.VISA_EXPIRATION_DATE VISA_EXPIRY_DATE
, LGL.I94_NUMBER ADMISSION_NUMBER
, LGL.PORT_OF_ENTRY
, LGL.DATE_OF_ENTRY
, LGL.REMARKS
, LGL.VISA_ISSUE_DATE
FROM IGS_SV_LEGAL_INFO LGL
, IGS_SV_BTCH_SUMMARY TRAVELSUMM
WHERE LGL.PERSON_ID = TRAVELSUMM.PERSON_ID
AND LGL.BATCH_ID = TRAVELSUMM.BATCH_ID
AND TRAVELSUMM.TAG_CODE = 'SV_LEGAL'
AND TRAVELSUMM.ADM_ACTION_CODE = 'SEND'
Columns
Name |
PERSON_ID |
BATCH_ID |
PSPRT_NUMBER |
PSPT_ISSUING_CNTRY |
PSPRT_EXPIRY_DATE |
VISA_NUMBER |
VISA_ISSUING_CNTRY |
VISA_EXPIRY_DATE |
ADMISSION_NUMBER |
PORT_OF_ENTRY |
DATE_OF_ENTRY |
REMARKS |
VISA_ISSUE_DATE |