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

VIEW: APPS.IGS_SV_CRT_STDT_BLK_V

Object Details
Object Name: IGS_SV_CRT_STDT_BLK_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_SV_CRT_STDT_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 creation of the student information.


[View Source]

Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER (14) Yes Batch identifier for the requested run.
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.
STDNT_LAST_NAME VARCHAR2 (0)
Students last name
STDNT_FIRST_NAME VARCHAR2 (0)
Students first name.
STDNT_MIDDLE_NAME VARCHAR2 (0)
Students middle name.
STDNT_SUFFIX VARCHAR2 (0)
Students suffix of name
STDNT_BIRTH_DATE VARCHAR2 (0)
Students birth date.
STDNT_GENDER VARCHAR2 (0)
Students gender
STDNT_BIRTH_CNTRY_CODE VARCHAR2 (0)
Students birth country code.
STDNT_CITIZEN_CNTRY_CODE VARCHAR2 (0)
Students citizenship country code.
STDNT_COMMUTER VARCHAR2 (0)
Flag indicating if the student is a commuter or not.
STDNT_VISA_TYPE VARCHAR2 (0)
Students visa type
ADMISSION_NUMBER VARCHAR2 (0)
Student admission number to get into the country.
DRIVERS_LICENSE VARCHAR2 (0)
Student driver license number.
DRIVERS_LICENSE_STATE VARCHAR2 (0)
State the drivers license was issued.
SSN VARCHAR2 (0)
Students social security number
TAX_ID VARCHAR2 (0)
Students tax identifier
FN_ADDRESS_LINE1 VARCHAR2 (0)
Students foreign address line 1
FN_ADDRESS_LINE2 VARCHAR2 (0)
Students foreign address line 2
FN_CITY VARCHAR2 (0)
Students foreign address city.
FN_PROVINCE VARCHAR2 (0)
Students foreign address province.
FN_COUNTRY_CODE VARCHAR2 (0)
Students foreign address country code.
FN_POSTAL_CODE VARCHAR2 (0)
Students foreign address postal code.
US_ADDRESS_LINE1 VARCHAR2 (0)
Students United States address line 1
US_ADDRESS_LINE2 VARCHAR2 (0)
Students United States address line 2.
US_CITY VARCHAR2 (0)
Students United States address city.
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.
EDUCATION_LEVEL VARCHAR2 (0)
Students education level.
EDUC_LVL_REMARKS VARCHAR2 (0)
Remarks made for the Education Level and only required if education level is OTHER.
PRIMARY_MAJOR VARCHAR2 (0)
Students primary major.
SECOND_MAJOR VARCHAR2 (0)
Students second major.
MINOR VARCHAR2 (0)
Students minor
LENGTH_OF_STUDY VARCHAR2 (0)
Students length of study.
PRG_START_DATE VARCHAR2 (0)
Students program start date
PRG_END_DATE VARCHAR2 (0)
Students program end date.
ENGL_REQUIRED VARCHAR2 (0)
Flag indicating if english language is required or not.
ENGL_REQUIREMENTS_MET VARCHAR2 (0)
Flag indicating if the english requirements have been met or not.
ENGL_NOT_REQD_REASON VARCHAR2 (0)
Reason why english is not required for the student in program.
ACADEMIC_TERM VARCHAR2 (0)
Length of the academic term the student is in.
TUITION VARCHAR2 (0)
Amount of tuition for the student
LIVING_EXPENSE VARCHAR2 (0)
Amount of living expense for the student.
DEPENDENT_EXPENSE VARCHAR2 (0)
Amount of expense on the student for dependent.
OTHER_EXPENSE VARCHAR2 (0)
Amount of other expenses for the student.
OTHER_EXPENSE_DESC VARCHAR2 (0)
Other expenses description that the student has.
PERSONAL_FUNDS VARCHAR2 (0)
Personal funds the student has.
SCHOOL_FUNDS VARCHAR2 (0)
Amount of school funds the student receives
SCHOOL_FUNDS_DESC VARCHAR2 (0)
School funds description the student is receiving.
OTHER_FUNDS VARCHAR2 (0)
Amount of other funds the student has.
OTHER_FUNDS_DESC VARCHAR2 (0)
Other funds description that the student has.
EMPLOYMENT_FUNDS VARCHAR2 (0)
Amount of employment funds the student is receiving.
FUNDING_REMARKS VARCHAR2 (0)
Remarks on the students funding.
RECORD_NUMBER NUMBER (20) Yes Record number of the batch.
PDSO_SEVIS_ID VARCHAR2 (11)
Person responsible for students data SEVIS identifier.
STDNT_PERSON_ID NUMBER (15) Yes Students person identifier
STDNT_PERSON_NUMBER VARCHAR2 (11)
Students person number
PROG_REMARKS VARCHAR2 (0)
Program remarks for the student.
PERSON_ID_LONG VARCHAR2 (15)
Column to be used as UserDefinedA reference to SEVIS
REMARKS VARCHAR2 (500)
Remarks
ISSUE_REASON VARCHAR2 (30)
Issue Reason
Query Text

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


SELECT BATCH_ID
,      PERSON_ID
,      PRINT_FORM
,      STDNT_LAST_NAME
,      STDNT_FIRST_NAME
,      STDNT_MIDDLE_NAME
,      STDNT_SUFFIX
,      STDNT_BIRTH_DATE
,      STDNT_GENDER
,      STDNT_BIRTH_CNTRY_CODE
,      STDNT_CITIZEN_CNTRY_CODE
,      STDNT_COMMUTER
,      STDNT_VISA_TYPE
,      ADMISSION_NUMBER
,      DRIVERS_LICENSE
,      DRIVERS_LICENSE_STATE
,      SSN
,      TAX_ID
,      FN_ADDRESS_LINE1
,      FN_ADDRESS_LINE2
,      FN_CITY
,      FN_PROVINCE
,      FN_COUNTRY_CODE
,      FN_POSTAL_CODE
,      US_ADDRESS_LINE1
,      US_ADDRESS_LINE2
,      US_CITY
,      US_STATE
,      US_POSTAL_CODE
,      US_POSTAL_ROUTING_CODE
,      EDUCATION_LEVEL
,      EDUC_LVL_REMARKS
,      PRIMARY_MAJOR
,      SECOND_MAJOR
,      MINOR
,      LENGTH_OF_STUDY
,      PRG_START_DATE
,      PRG_END_DATE
,      ENGL_REQUIRED
,      ENGL_REQUIREMENTS_MET
,      ENGL_NOT_REQD_REASON
,      ACADEMIC_TERM
,      TUITION
,      LIVING_EXPENSE
,      DEPENDENT_EXPENSE
,      OTHER_EXPENSE
,      OTHER_EXPENSE_DESC
,      PERSONAL_FUNDS
,      SCHOOL_FUNDS
,      SCHOOL_FUNDS_DESC
,      OTHER_FUNDS
,      OTHER_FUNDS_DESC
,      EMPLOYMENT_FUNDS
,      FUNDING_REMARKS
,      RECORD_NUMBER
,      PDSO_SEVIS_ID
,      STDNT_PERSON_ID
,      STDNT_PERSON_NUMBER
,      PROG_REMARKS
,      PERSON_ID_LONG
,      REMARKS
,      ISSUE_REASON
FROM APPS.IGS_SV_CRT_STDT_BLK_V;

Dependencies

[top of page]

APPS.IGS_SV_CRT_STDT_BLK_V references the following:

SchemaAPPS
SynonymIGS_SV_BTCH_SUMMARY
SynonymIGS_SV_PERSONS

APPS.IGS_SV_CRT_STDT_BLK_V is not referenced by any database object