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

VIEW: APPS.IGS_SV_STDNT_REG_BLK_V

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

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.


View for obtaining information for the XML block describing the students registration information.


[View Source]

Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER (14) Yes Batch identifier for the requested run.
PDSO_SEVIS_ID VARCHAR2 (11)
Pseudo SEVIS Id
PERSON_ID NUMBER (15) Yes Person identifier for the student in the request.
PRINT_FORM VARCHAR2 (1) Yes Flag indicating if form is to be printed by SEVIS or not.
CURRENT_SESSION_END_DATE VARCHAR2 (10)
Students current session end date
NEXT_SESSION_START_DATE VARCHAR2 (10)
Students next session start date
COMMUTER VARCHAR2 (1)
Flag indicating if student is a commuter or not
US_ADDRESS_LINE1 VARCHAR2 (0)
Student United States address line 1.
US_ADDRESS_LINE2 VARCHAR2 (0)
Student United States address line 2.
US_CITY VARCHAR2 (0)
Student United States city address.
US_STATE VARCHAR2 (0)
Students United States address state
US_POSTAL_CODE VARCHAR2 (0)
Students United States Address Postal Code
US_POSTAL_ROUTING_CODE VARCHAR2 (0)
Students United States address postal routing code.
FN_ADDRESS_LINE1 VARCHAR2 (0)
Students foreign address line 1.
FN_ADDRESS_LINE2 VARCHAR2 (0)
Students foreign address line 2.
FN_CITY VARCHAR2 (0)
Student foreign address city
FN_CNTRY_CODE VARCHAR2 (0)
Student foreign address country code.
FN_PROVINCE VARCHAR2 (0)
Student foreign address province.
FN_POSTAL_CODE VARCHAR2 (0)
Student foreign address postal code
PSPT_NUMBER VARCHAR2 (0)
Students passport number
PSPT_ISSUING_CNTRY VARCHAR2 (0)
Country code where passport was issued.
PSPT_EXPIRY_DATE VARCHAR2 (0)
Date passport expires
VISA_NUMBER VARCHAR2 (0)
Students visa number issued.
VISA_ISSUING_CNTRY VARCHAR2 (0)
Country code issuing visa.
VISA_EXPIRY_DATE VARCHAR2 (0)
Date visa expires for student.
ADMISSION_NUMBER VARCHAR2 (0)
Admission form number for entering country.
PORT_OF_ENTRY VARCHAR2 (0)
Port Of Entry the student entered.
DATE_OF_ENTRY VARCHAR2 (0)
Date student entered the country
REMARKS VARCHAR2 (0)
Remarks for student registration.
LAST_SESSION_FLAG VARCHAR2 (1)
Indicates that the student is in the last session of his/her program
SEVIS_USER_ID VARCHAR2 (11)
SEVIS User Id
RECORD_NUMBER NUMBER (20) Yes Record Number
PERSON_NUMBER VARCHAR2 (11)
Person Number
PERSON_ID_LONG VARCHAR2 (15)
Person Id
REPRINT_REASON VARCHAR2 (30)
Reprint Reason
REPRINT_REMARKS VARCHAR2 (500)
Remarks for Reprinting
Query Text

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


SELECT BATCH_ID
,      PDSO_SEVIS_ID
,      PERSON_ID
,      PRINT_FORM
,      CURRENT_SESSION_END_DATE
,      NEXT_SESSION_START_DATE
,      COMMUTER
,      US_ADDRESS_LINE1
,      US_ADDRESS_LINE2
,      US_CITY
,      US_STATE
,      US_POSTAL_CODE
,      US_POSTAL_ROUTING_CODE
,      FN_ADDRESS_LINE1
,      FN_ADDRESS_LINE2
,      FN_CITY
,      FN_CNTRY_CODE
,      FN_PROVINCE
,      FN_POSTAL_CODE
,      PSPT_NUMBER
,      PSPT_ISSUING_CNTRY
,      PSPT_EXPIRY_DATE
,      VISA_NUMBER
,      VISA_ISSUING_CNTRY
,      VISA_EXPIRY_DATE
,      ADMISSION_NUMBER
,      PORT_OF_ENTRY
,      DATE_OF_ENTRY
,      REMARKS
,      LAST_SESSION_FLAG
,      SEVIS_USER_ID
,      RECORD_NUMBER
,      PERSON_NUMBER
,      PERSON_ID_LONG
,      REPRINT_REASON
,      REPRINT_REMARKS
FROM APPS.IGS_SV_STDNT_REG_BLK_V;

Dependencies

[top of page]

APPS.IGS_SV_STDNT_REG_BLK_V references the following:

SchemaAPPS
SynonymIGS_SV_BATCHES
SynonymIGS_SV_BIO_INFO
SynonymIGS_SV_BTCH_SUMMARY
SynonymIGS_SV_PERSONS

APPS.IGS_SV_STDNT_REG_BLK_V is not referenced by any database object