[Home] [Help]
View: IGS_SV_CRT_DPND_BLK_V
Product: | IGS - Student System (Obsolete) |
Description: | View for obtaining information for the XML block describing the creation of the student dependent information. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT DPDT.BATCH_ID
, DPDT.PERSON_ID
, DPDT.PRINT_FORM
, 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.DEPDNT_ID
, DPDT.REMARKS
FROM IGS_SV_DEPDNT_INFO DPDT
, IGS_SV_BTCH_SUMMARY DEPSUMM
WHERE DPDT.DEPDNT_ACTION_TYPE = 'A'
AND DPDT.PERSON_ID = DEPSUMM.PERSON_ID
AND DPDT.BATCH_ID = DEPSUMM.BATCH_ID
AND DEPSUMM.TAG_CODE = 'SV_DEPDNT'
AND DEPSUMM.ADM_ACTION_CODE = 'SEND'
AND DPDT.DEPDNT_ID = DEPSUMM.OWNER_TABLE_IDENTIFIER
Columns
Name |
BATCH_ID |
PERSON_ID |
PRINT_FORM |
LAST_NAME |
FIRST_NAME |
MIDDLE_NAME |
SUFFIX |
BIRTH_DATE |
GENDER |
BIRTH_CNTRY_CODE |
CITIZENSHIP_CNTRY_CODE |
VISA_TYPE |
RELATIONSHIP |
DEPDNT_ID |
REMARKS |