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


TABLE: IGS.IGS_SV_LEGAL_INFO

Object Details
Object Name: IGS_SV_LEGAL_INFO
Object Type: TABLE
Owner: IGS
FND Design Data: TableIGS.IGS_SV_LEGAL_INFO
Subobject Name:
Status: VALID


IGS_SV_LEGAL_INFO - Table to store all Legal information that is to be sent to SEVIS on the Foreign students and Exchange Visitors.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_SV_LEGAL_INFO_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBATCH_ID
ColumnPERSON_ID
IGS_SV_LEGAL_INFO_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPERSON_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
PRINT_FORM VARCHAR2 (1) Yes Flag indicating if SEVIS is being requested to print form
PSPRT_NUMBER VARCHAR2 (25)
Passport number for the student
PSPRT_ISSUING_CNTRY_CODE VARCHAR2 (3)
Country code where the passport was issued from
PSPRT_EXP_DATE VARCHAR2 (10)
Date the passport for the student expires
VISA_NUMBER VARCHAR2 (25)
Visa Number the student is visiting with.
VISA_ISSUING_POST VARCHAR2 (3)
SEVIS Issuing post code where the visa was issued.
VISA_ISSUING_CNTRY_CODE VARCHAR2 (3)
SEVIS country code where the visa issued.
VISA_EXPIRATION_DATE VARCHAR2 (10)
Date visa for the student expires
I94_NUMBER VARCHAR2 (11)
Country Admission form number to enter country.
PORT_OF_ENTRY VARCHAR2 (3)
SEVIS code for the port where the student entered country
DATE_OF_ENTRY VARCHAR2 (10)
Date the student entered the country
REMARKS VARCHAR2 (500)
Remarks for the students legal information
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
VISA_ISSUE_DATE VARCHAR2 (10)
Stores the VISA issue date
Query Text

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


SELECT BATCH_ID
,      PERSON_ID
,      PRINT_FORM
,      PSPRT_NUMBER
,      PSPRT_ISSUING_CNTRY_CODE
,      PSPRT_EXP_DATE
,      VISA_NUMBER
,      VISA_ISSUING_POST
,      VISA_ISSUING_CNTRY_CODE
,      VISA_EXPIRATION_DATE
,      I94_NUMBER
,      PORT_OF_ENTRY
,      DATE_OF_ENTRY
,      REMARKS
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      VISA_ISSUE_DATE
FROM IGS.IGS_SV_LEGAL_INFO;

Dependencies

[top of page]

IGS.IGS_SV_LEGAL_INFO does not reference any database object

IGS.IGS_SV_LEGAL_INFO is referenced by following:

SchemaAPPS
SynonymIGS_SV_LEGAL_INFO