[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 |