[Home] [Help] [Dependency Information]
Object Name: | IGS_SV_CRT_STDT_BLK_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_SV_CRT_STDT_BLK_V |
Subobject Name: | |
Status: | VALID |
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.
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 |
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;
APPS.IGS_SV_CRT_STDT_BLK_V is not referenced by any database object
|
|
|