[Home] [Help] [Dependency Information]
Object Name: | IGS_SV_STDNT_REG_BLK_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_SV_STDNT_REG_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 students registration information.
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 |
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;
APPS.IGS_SV_STDNT_REG_BLK_V is not referenced by any database object
|
|
|