[Home] [Help]
View: IGS_SV_EDT_BIO_V
Product: | IGS - Student System (Obsolete) |
Description: | View for fetching biographic information |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT BIO.BATCH_ID
, BIO.PERSON_ID
, BIO.PRINT_FORM
, BIO.FIRST_NAME
, BIO.LAST_NAME
, BIO.MIDDLE_NAME
, BIO.BIRTH_DATE
, BIO.GENDER
, BIO.BIRTH_CNTRY_CODE
, BIO.CITIZEN_CNTRY_CODE CTZNSHIP_CNTRY_CODE
, BIO.COMMUTER
, BIO.SUFFIX
FROM IGS_SV_BIO_INFO BIO
, IGS_SV_BTCH_SUMMARY BIOSUMM
WHERE BIO.BATCH_ID = BIOSUMM.BATCH_ID
AND BIO.PERSON_ID = BIOSUMM.PERSON_ID
AND BIOSUMM.TAG_CODE = 'SV_BIO'
AND BIOSUMM.ADM_ACTION_CODE = 'SEND'
Columns
Name |
BATCH_ID |
PERSON_ID |
PRINT_FORM |
FIRST_NAME |
LAST_NAME |
MIDDLE_NAME |
BIRTH_DATE |
GENDER |
BIRTH_CNTRY_CODE |
CTZNSHIP_CNTRY_CODE |
COMMUTER |
SUFFIX |