Product: | IGS - Student System (Obsolete) |
---|---|
Description: | View for obtaining information for the XML block describing the updated dependent information for the student. |
Implementation/DBA Data: | Not implemented in this database |
SELECT DPDT.BATCH_ID
, DPDT.PERSON_ID
, DPDT.PRINT_FORM
, DPDT.DEPDNT_ID
, NULL PERSON_NUMBER
, DPDT.DEPDNT_SEVIS_ID
, DPDT.LAST_NAME
, DPDT.FIRST_NAME
, DPDT.MIDDLE_NAME
, DPDT.SUFFIX
, DPDT.BIRTH_DATE
, DPDT.GENDER
, DPDT.BIRTH_CNTRY_CODE
, DPDT.CITIZEN_CNTRY_CODE CITIZENSHIP_CNTRY_CODE
, DPDT.VISA_TYPE
, DPDT.RELATIONSHIP
, DPDT.REMARKS
, NULL PERSON_ID_LONG
FROM IGS_SV_DEPDNT_INFO DPDT
WHERE DPDT.DEPDNT_ACTION_TYPE = 'U'