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

VIEW: APPS.IGS_SV_EDT_PERS_BLK_V

Object Details
Object Name: IGS_SV_EDT_PERS_BLK_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_SV_EDT_PERS_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 student personal information changes.


[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.
SEVIS_USER_ID VARCHAR2 (11)
Sevis USER Id
RECORD_NUMBER NUMBER (20) Yes Record Number
PERSON_NUMBER VARCHAR2 (11)
Person Number for SEVIS Person
PERSON_ID_LONG VARCHAR2 (15)
Person ID
REPRINT_REASON VARCHAR2 (30)
Reason code for the reprint request
REPRINT_REMARKS VARCHAR2 (500)
Remarks for the reprint request
OTHER_REMARKS VARCHAR2 (500)
Other remarks
PRINT_FORM VARCHAR2 (0)
Flag indicating if the form is to be printed by SEVIS or not.
FIRST_NAME VARCHAR2 (40)
Student first name
LAST_NAME VARCHAR2 (40)
Student last name
MIDDLE_NAME VARCHAR2 (40)
Student middle name
BIRTH_DATE VARCHAR2 (10)
Student date of birth.
GENDER VARCHAR2 (1)
Student gender
BIRTH_CNTRY_CODE VARCHAR2 (2)
Student birth country code.
CTZNSHIP_CNTRY_CODE VARCHAR2 (2)
Student citizenship country code.
FN_ADDRESS_LINE1 VARCHAR2 (0)
Student foreign address line 1.
FN_ADDRESS_LINE2 VARCHAR2 (0)
Student 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.
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 address city.
US_STATE VARCHAR2 (0)
Student United States address state code.
US_POSTAL_CODE VARCHAR2 (0)
Student United States address postal code.
US_POSTAL_ROUTING_CODE VARCHAR2 (0)
Student United States address postal routing code.
DRIVERS_LICENSE VARCHAR2 (0)
Student drivers license number
DRIVERS_LICENSE_STATE VARCHAR2 (0)
Student drivers license state where issued.
SSN VARCHAR2 (0)
Student social security number
TAX_ID VARCHAR2 (0)
Student Tax identifier number.
ADMISSION_NUMBER VARCHAR2 (0)
Admission form number to enter country.
COMMUTER VARCHAR2 (1)
Flag indicating if student is commuter or not.
SUFFIX VARCHAR2 (3)
Student suffix for name
Query Text

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


SELECT BATCH_ID
,      PDSO_SEVIS_ID
,      PERSON_ID
,      SEVIS_USER_ID
,      RECORD_NUMBER
,      PERSON_NUMBER
,      PERSON_ID_LONG
,      REPRINT_REASON
,      REPRINT_REMARKS
,      OTHER_REMARKS
,      PRINT_FORM
,      FIRST_NAME
,      LAST_NAME
,      MIDDLE_NAME
,      BIRTH_DATE
,      GENDER
,      BIRTH_CNTRY_CODE
,      CTZNSHIP_CNTRY_CODE
,      FN_ADDRESS_LINE1
,      FN_ADDRESS_LINE2
,      FN_CITY
,      FN_CNTRY_CODE
,      FN_PROVINCE
,      FN_POSTAL_CODE
,      US_ADDRESS_LINE1
,      US_ADDRESS_LINE2
,      US_CITY
,      US_STATE
,      US_POSTAL_CODE
,      US_POSTAL_ROUTING_CODE
,      DRIVERS_LICENSE
,      DRIVERS_LICENSE_STATE
,      SSN
,      TAX_ID
,      ADMISSION_NUMBER
,      COMMUTER
,      SUFFIX
FROM APPS.IGS_SV_EDT_PERS_BLK_V;

Dependencies

[top of page]

APPS.IGS_SV_EDT_PERS_BLK_V references the following:

SchemaAPPS
SynonymIGS_SV_BIO_INFO
SynonymIGS_SV_BTCH_SUMMARY
SynonymIGS_SV_PERSONS

APPS.IGS_SV_EDT_PERS_BLK_V is not referenced by any database object