eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: IGS.IGS_SV_DEPDNT_INFO

Object Details

Object Name:	IGS_SV_DEPDNT_INFO
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGS_SV_DEPDNT_INFO
Subobject Name:
Status:	VALID

IGS_SV_DEPDNT_INFO - Table to hold the information on the dependent information for the Foreign students and Exchange Visitors for SEVIS.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_SV_DEPDNT_INFO_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BATCH_ID PERSON_ID DEPDNT_ID
IGS_SV_DEPDNT_INFO_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSON_ID DEPDNT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_ID	NUMBER	(14)	Yes	Batch identifier used for the run of the SEVIS process
PERSON_ID	NUMBER	(15)	Yes	Person identifier that the conviction record is associated to
DEPDNT_ID	NUMBER	(15)	Yes	Student dependent record identifier.
PERSON_NUMBER	VARCHAR2	(30)	Yes	Person number for the dependent information being sent to SEVIS
PRINT_FORM	VARCHAR2	(1)	Yes	Flag indicating if form is to be printed or not.
DEPDNT_ACTION_TYPE	VARCHAR2	(1)	Yes	Dependent action being taken on the record.
DEPDNT_SEVIS_ID	VARCHAR2	(11)		SEVIS identifier for the dependent of the student
VISA_TYPE	VARCHAR2	(2)		Visa Type that the dependent has.
LAST_NAME	VARCHAR2	(40)		Last name of the dependent.
FIRST_NAME	VARCHAR2	(40)		First name of the dependent.
MIDDLE_NAME	VARCHAR2	(40)		Middle name of the dependent
SUFFIX	VARCHAR2	(3)		Suffix for the name of the dependent
BIRTH_DATE	VARCHAR2	(10)		Birth date of the dependent
GENDER	VARCHAR2	(1)		Sex of the dependent.
BIRTH_CNTRY_CODE	VARCHAR2	(30)		Stores the reason code if the birth of country is U.S. or a U.S. Territory
CITIZEN_CNTRY_CODE	VARCHAR2	(2)		Country code of the dependent citizenship.
RELATIONSHIP	VARCHAR2	(2)		Relationship the dependent is to the student
TERMINATION_REASON	VARCHAR2	(2)		Reason code why dependent was terminated from student relation
RELATIONSHIP_REMARKS	VARCHAR2	(500)		Remarks for the dependent relationship to student
PERM_RES_CNTRY_CODE	VARCHAR2	(2)		Dependent permanent residency country code.
TERMINATION_EFFECT_DATE	VARCHAR2	(10)		Date that the dependent was terminated from student relationship.
REMARKS	VARCHAR2	(500)		Remarks on the dependent record.
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
LEGAL_RES_CNTRY_CODE	VARCHAR2	(2)		Legal residency country code for the Exchange Visitor
BIRTH_CITY	VARCHAR2	(60)		City where the Exchange Visitor dependent was born.
OTHER_REASON_REMARKS	VARCHAR2	(500)		Other reason remarks for the dependent information for Exchange Visitor
BIRTH_CNTRY_RESN_CODE	VARCHAR2	(30)		Stores the reason code if the birth of country is U.S. or a U.S. Territory
REPRINT_RSN_CODE	VARCHAR2	(30)		Captures the reason for Reprint
REPRINT_REMARKS	VARCHAR2	(500)		Captures the remarks for Reprint

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BATCH_ID
,      PERSON_ID
,      DEPDNT_ID
,      PERSON_NUMBER
,      PRINT_FORM
,      DEPDNT_ACTION_TYPE
,      DEPDNT_SEVIS_ID
,      VISA_TYPE
,      LAST_NAME
,      FIRST_NAME
,      MIDDLE_NAME
,      SUFFIX
,      BIRTH_DATE
,      GENDER
,      BIRTH_CNTRY_CODE
,      CITIZEN_CNTRY_CODE
,      RELATIONSHIP
,      TERMINATION_REASON
,      RELATIONSHIP_REMARKS
,      PERM_RES_CNTRY_CODE
,      TERMINATION_EFFECT_DATE
,      REMARKS
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LEGAL_RES_CNTRY_CODE
,      BIRTH_CITY
,      OTHER_REASON_REMARKS
,      BIRTH_CNTRY_RESN_CODE
,      REPRINT_RSN_CODE
,      REPRINT_REMARKS
FROM IGS.IGS_SV_DEPDNT_INFO;

Dependencies

[top of page]

IGS.IGS_SV_DEPDNT_INFO does not reference any database object

IGS.IGS_SV_DEPDNT_INFO is referenced by following:

APPS: IGS_SV_DEPDNT_INFO