eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGS_SV_EV_EDT_DPD_BLK_V

Product:	IGS - Student System (Obsolete)
Description:	Edit dependent block for the Exchange Visitor
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT DPDT.BATCH_ID BATCH_ID
, DPDT.PERSON_ID PERSON_ID
, DPDT.LAST_NAME LAST_NAME
, DPDT.FIRST_NAME FIRST_NAME
, DPDT.MIDDLE_NAME MIDDLE_NAME
, DPDT.SUFFIX SUFFIX
, DPDT.BIRTH_DATE BIRTH_DATE
, DPDT.GENDER GENDER
, DPDT.BIRTH_CITY BIRTH_CITY
, DPDT.BIRTH_CNTRY_CODE BIRTH_CNTRY_CODE
, DPDT.CITIZEN_CNTRY_CODE CITIZENSHIP_CNTRY_CODE
, DPDT.LEGAL_RES_CNTRY_CODE PERM_RESIDENCY_CODE
, DPDT.RELATIONSHIP RELATIONSHIP
, DPDT.DEPDNT_ID DEPDNT_ID
, DPDT.REMARKS REMARKS
, DPDT.BIRTH_CNTRY_RESN_CODE
, DPDT.DEPDNT_SEVIS_ID DEPDNT_SEVIS_ID
, LTRIM(TO_CHAR(SUBSTR(DPDT.DEPDNT_ID
, 1
, 10)
, '0000000000')) PERSON_NUMBER
, LTRIM(TO_CHAR(SUBSTR(DPDT.DEPDNT_ID
, 1
, 14)
, '00000000000000')) PERSON_ID_LONG
FROM IGS_SV_DEPDNT_INFO DPDT
WHERE DPDT.DEPDNT_ACTION_TYPE = 'U'

Columns

Name
BATCH_ID
PERSON_ID
LAST_NAME
FIRST_NAME
MIDDLE_NAME
SUFFIX
BIRTH_DATE
GENDER
BIRTH_CITY
BIRTH_CNTRY_CODE
CITIZENSHIP_CNTRY_CODE
PERM_RESIDENCY_CODE
RELATIONSHIP
DEPDNT_ID
REMARKS
BIRTH_CNTRY_RESN_CODE
DEPDNT_SEVIS_ID
PERSON_NUMBER
PERSON_ID_LONG