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_ADDRESSES

Object Details

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

IGS_SV_ADDRESSES - Table for foreign students and exchange visitors holding the addresses for US, Foreign, and Site of Activity.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_SV_ADDRESSES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BATCH_ID PERSON_ID PARTY_SITE_ID
IGS_SV_ADDRESSES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSON_ID PARTY_SITE_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
PARTY_SITE_ID	NUMBER	(15)	Yes	Party site identifier for the persons address type.
PRINT_FORM	VARCHAR2	(1)	Yes	Flag to indicate if the form is to be printed by SEVIS.
ADDRESS_TYPE	VARCHAR2	(1)	Yes	Address type that indicates the record type being stored Foreign, US, or Site of Activity.
ADDRESS_LINE1	VARCHAR2	(60)	Yes	First line of the students address.
ADDRESS_LINE2	VARCHAR2	(60)		Second line of the students address.
CITY	VARCHAR2	(60)		City for the address lines given for the student.
STATE	VARCHAR2	(2)		State that the students address resides in.
POSTAL_CODE	VARCHAR2	(20)		Postal code for the students address given.
POSTAL_ROUTING_CODE	VARCHAR2	(4)		Postal routing code for the students address.
COUNTRY_CODE	VARCHAR2	(2)		Country code for the address given for the student
PROVINCE	VARCHAR2	(30)		Province of the address given for the student
STDNT_VALID_FLAG	VARCHAR2	(1)		Flag indicating if the student is valid or not
ACTION_TYPE	VARCHAR2	(1)		Used for Exchange Visitors for site of activity address. R - Remove site A - Add site.
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
REMARKS	VARCHAR2	(500)		Address remarks for the Exchange Visitor
PRIMARY_FLAG	VARCHAR2	(1)		To indicate that a particular Site of Activity is Primary
ACTIVITY_SITE_CD	VARCHAR2	(10)		Stores the Site of Activity code

Query Text

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


SELECT BATCH_ID
,      PERSON_ID
,      PARTY_SITE_ID
,      PRINT_FORM
,      ADDRESS_TYPE
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      CITY
,      STATE
,      POSTAL_CODE
,      POSTAL_ROUTING_CODE
,      COUNTRY_CODE
,      PROVINCE
,      STDNT_VALID_FLAG
,      ACTION_TYPE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REMARKS
,      PRIMARY_FLAG
,      ACTIVITY_SITE_CD
FROM IGS.IGS_SV_ADDRESSES;

Dependencies

[top of page]

IGS.IGS_SV_ADDRESSES does not reference any database object

IGS.IGS_SV_ADDRESSES is referenced by following:

APPS: IGS_SV_ADDRESSES