Product: | IGS - Student System (Obsolete) |
---|---|
Description: | View for fetching modified biographic informations for Exchange Visitor students |
Implementation/DBA Data: | Not implemented in this database |
SELECT BIO.BATCH_ID BATCH_ID
, BIO.PERSON_ID PERSON_ID
, BIO.LAST_NAME LAST_NAME
, BIO.FIRST_NAME FIRST_NAME
, BIO.MIDDLE_NAME MIDDLE_NAME
, BIO.SUFFIX SUFFIX
, BIO.BIRTH_DATE BIRTH_DATE
, BIO.GENDER GENDER
, BIO.BIRTH_CITY BIRTH_CITY
, BIO.BIRTH_CNTRY_CODE BIRTH_CNTRY_CODE
, BIO.CITIZEN_CNTRY_CODE CITIZEN_CNTRY_CODE
, BIO.LEGAL_RES_CNTRY_CODE PERM_RES_CNTRY_CODE
, BIO.POSITION_CODE POSITION_CODE
, BIO.REMARKS REMARKS
, BIO.BIRTH_CNTRY_RESN_CODE
, BIO.PRINT_FORM
FROM IGS_SV_BIO_INFO BIO
, IGS_SV_BTCH_SUMMARY BIOSUMM
WHERE BIO.PERSON_ID = BIOSUMM.PERSON_ID
AND BIO.BATCH_ID = BIOSUMM.BATCH_ID
AND BIOSUMM.TAG_CODE = 'SV_BIO'
AND BIOSUMM.ADM_ACTION_CODE = 'SEND'