[Home] [Help] [Dependency Information]
Object Name: | IGSBV_NONIMMIGRANT_STUDENTS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGSBV_NONIMMIGRANT_STUDENTS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This entity contains information about international non-immigrant students.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PRINT_FORM | VARCHAR2 | (1) | Yes | Indicates if the form is to be printed |
FORM_EFFECTIVE_DATE | DATE | Yes | Form Effective Date | |
_LA:FORM_STATUS | CHAR | (64) | Status of the form | |
ACADEMIC_TERM_LENGTH | VARCHAR2 | (2) | Yes | Length of the academic term |
TUITION_AMOUNT | NUMBER | (10) | Yes | Amount of Tuition for the student |
LIVING_EXP_AMOUNT | NUMBER | (10) | Yes | Amount of living expenses for the student |
PERSONAL_FUNDS_AMOUNT | NUMBER | (10) | Yes | Amount of personal funds for the student |
ISSUE_REASON | VARCHAR2 | (30) | Yes | Issue reason for the Form |
COMMUTER_INDICATOR | VARCHAR2 | (1) | Indicates if the student is a Commuter | |
ENGLISH_REQUIRED | VARCHAR2 | (1) | Yes | Indicates if English is required for the student |
LENGTH_OF_STUDY | VARCHAR2 | (2) | Yes | Length of time for the student to study in the country. |
PROGRAM_START_DATE | DATE | Yes | Date that the program is starting | |
PROGRAM_END_DATE | DATE | Yes | Date that the program is ending | |
_LA:PRIMARY_MAJOR | CHAR | (68) | Student's primary major of study | |
_LA:EDUCATION_LEVEL | CHAR | (66) | Student's level of education | |
DEPENDENT_EXPENSE_AMOUNT | NUMBER | (10) | Amount of dependents expenses | |
OTHER_EXPENSE_AMOUNT | NUMBER | (10) | Amount of other expenses | |
OTHER_EXPENSE_DESCRIPTION | VARCHAR2 | (500) | Other expenses description | |
SCHOOL_FUNDS_AMOUNT | NUMBER | (10) | Amount of School funds | |
SCHOOL_FUNDS_DESC | VARCHAR2 | (500) | School funds description for the student | |
OTHER_FUNDS_AMOUNT | NUMBER | (10) | Amount of Other funds | |
OTHER_FUNDS_DESC | VARCHAR2 | (500) | Other funds description for the student | |
EMPL_FUNDS_AMOUNT | NUMBER | (10) | Amount of Employment funds | |
REMARKS | VARCHAR2 | (500) | Remarks for student | |
CURR_SESSION_END_DATE | DATE | Current school session end date | ||
NEXT_SESSION_START_DATE | DATE | Next school session start date | ||
TRANSFER_FROM_SCHOOL | VARCHAR2 | (500) | School student transferred from | |
OTHER_REASON | VARCHAR2 | (500) | Other reason for coming to school | |
LAST_REPRINT_DATE | DATE | Last date the form was requested for reprint | ||
_LA:REPRINT_REASON | CHAR | (69) | Reason for the reprint of form | |
REPRINT_REMARKS | VARCHAR2 | (500) | Remarks on the reason code for reprint | |
_LA:SECONDARY_MAJOR | CHAR | (70) | Student's secondary major of study | |
_LA:MINOR | CHAR | (60) | Minor study for the student | |
ENGLISH_REQUIREMENT_MET | VARCHAR2 | (1) | Indicates if English requirement is met. | |
NOT_REQUIREMENT_REASON | VARCHAR2 | (500) | Reason why requirement not needed to be met | |
EDUCATION_LEVEL_REMARKS | VARCHAR2 | (500) | Education level remarks are optional except if if Education Level chosen is OTHER | |
VISA_TYPE | VARCHAR2 | (30) | Yes | Visa Type the student is applying for. |
NONIMG_FORM_ID | NUMBER | (15) | Yes | Unique identifier of the non-immigrant form |
PERSON_ID | NUMBER | (15) | Yes | Unique identifier of a Person |
CREATION_DATE | DATE | Yes | Standard Who Column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column |
Cut, paste (and edit) the following text to query this object:
SELECT PRINT_FORM
, FORM_EFFECTIVE_DATE
, _LA:FORM_STATUS
, ACADEMIC_TERM_LENGTH
, TUITION_AMOUNT
, LIVING_EXP_AMOUNT
, PERSONAL_FUNDS_AMOUNT
, ISSUE_REASON
, COMMUTER_INDICATOR
, ENGLISH_REQUIRED
, LENGTH_OF_STUDY
, PROGRAM_START_DATE
, PROGRAM_END_DATE
, _LA:PRIMARY_MAJOR
, _LA:EDUCATION_LEVEL
, DEPENDENT_EXPENSE_AMOUNT
, OTHER_EXPENSE_AMOUNT
, OTHER_EXPENSE_DESCRIPTION
, SCHOOL_FUNDS_AMOUNT
, SCHOOL_FUNDS_DESC
, OTHER_FUNDS_AMOUNT
, OTHER_FUNDS_DESC
, EMPL_FUNDS_AMOUNT
, REMARKS
, CURR_SESSION_END_DATE
, NEXT_SESSION_START_DATE
, TRANSFER_FROM_SCHOOL
, OTHER_REASON
, LAST_REPRINT_DATE
, _LA:REPRINT_REASON
, REPRINT_REMARKS
, _LA:SECONDARY_MAJOR
, _LA:MINOR
, ENGLISH_REQUIREMENT_MET
, NOT_REQUIREMENT_REASON
, EDUCATION_LEVEL_REMARKS
, VISA_TYPE
, NONIMG_FORM_ID
, PERSON_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGSBV_NONIMMIGRANT_STUDENTS;
APPS.IGSBV_NONIMMIGRANT_STUDENTS is not referenced by any database object
|
|
|