[Home] [Help]
View: IGS_SV_EV_DEL_DPD_BLK_V
Product: | IGS - Student System (Obsolete) |
Description: | View for fetching deleted dependents information |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT SVDI.BATCH_ID BATCH_ID
, SVDI.PERSON_ID PERSON_ID
, SVDI.DEPDNT_SEVIS_ID DEPDNT_SEVIS_ID
, SVDI.DEPDNT_ID DEPDNT_ID
FROM IGS_SV_DEPDNT_INFO SVDI
WHERE SVDI.DEPDNT_ACTION_TYPE = 'D'
Columns
Name |
BATCH_ID |
PERSON_ID |
DEPDNT_SEVIS_ID |
DEPDNT_ID |