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

VIEW: APPS.IGS_SV_EV_UADD_SOA_BLK_V

Object Details
Object Name: IGS_SV_EV_UADD_SOA_BLK_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_SV_EV_UADD_SOA_BLK_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


View for fetching new site of activities added to Exchange Visitor students


[View Source]

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
US_ADDRESS_LINE1 VARCHAR2 (60) Yes First line of the students address.
US_ADDRESS_LINE2 VARCHAR2 (60)
Second line of the students address.
US_CITY VARCHAR2 (60)
City for the address lines given for the student.
US_STATE VARCHAR2 (2)
State that the students address resides in.
US_POSTAL_CODE VARCHAR2 (20)
Postal code for the students address given.
US_POSTAL_ROUTING_CODE VARCHAR2 (4)
Postal routing code for the students address.
PARTY_SITE_ID NUMBER (15) Yes Party site identifier for the persons address type.
PARTY_SITE_NAME VARCHAR2 (162)
Party Site Name
PRIMARY_FLAG VARCHAR2 (1)
Primary Flag
Query Text

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


SELECT BATCH_ID
,      PERSON_ID
,      US_ADDRESS_LINE1
,      US_ADDRESS_LINE2
,      US_CITY
,      US_STATE
,      US_POSTAL_CODE
,      US_POSTAL_ROUTING_CODE
,      PARTY_SITE_ID
,      PARTY_SITE_NAME
,      PRIMARY_FLAG
FROM APPS.IGS_SV_EV_UADD_SOA_BLK_V;

Dependencies

[top of page]

APPS.IGS_SV_EV_UADD_SOA_BLK_V references the following:

SchemaAPPS
SynonymIGS_SV_ADDRESSES

APPS.IGS_SV_EV_UADD_SOA_BLK_V is not referenced by any database object