[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGSFV_NONIMMIGRANT_STUDENTS |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGSFV_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 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. |
| PERSON_NUMBER | VARCHAR2 | (30) | Yes | Person number for a person. |
| 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
, PERSON_NUMBER
, NONIMG_FORM_ID
, PERSON_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGSFV_NONIMMIGRANT_STUDENTS;
APPS
HZ_PARTIES
IGS_PE_NONIMG_FORM
APPS.IGSFV_NONIMMIGRANT_STUDENTS is not referenced by any database object
|
|
|
|