VIEW: APPS.IGSBV_NONIMMIGRANT_STUDENTS

Source

View Text - Preformatted

SELECT PNI.PRINT_FORM, PNI.FORM_EFFECTIVE_DATE, '_LA:PNI.FORM_STATUS:IGS_LOOKUP_VALUES:PE_SV_FM_STAT_TYPE:MEANING', PNI.ACAD_TERM_LENGTH, PNI.TUITION_AMT, PNI.LIVING_EXP_AMT, PNI.PERSONAL_FUNDS_AMT, PNI.ISSUE_REASON, PNI.COMMUTER_IND, PNI.ENGLISH_REQD, PNI.LENGTH_OF_STUDY, PNI.PRGM_START_DATE, PNI.PRGM_END_DATE, '_LA:PNI.PRIMARY_MAJOR:IGS_LOOKUP_VALUES:PE_US_COURSE_SUBJECT:MEANING', '_LA:PNI.EDUCATION_LEVEL:IGS_LOOKUP_VALUES:PE_SV_EDUC_LEVEL:MEANING', PNI.DEPDNT_EXP_AMT, PNI.OTHER_EXP_AMT, PNI.OTHER_EXP_DESC, PNI.SCHOOL_FUNDS_AMT, PNI.SCHOOL_FUNDS_DESC, PNI.OTHER_FUNDS_AMT, PNI.OTHER_FUNDS_DESC, PNI.EMPL_FUNDS_AMT, PNI.REMARKS, PNI.CURR_SESSION_END_DATE, PNI.NEXT_SESSION_START_DATE, PNI.TRANSFER_FROM_SCHOOL, PNI.OTHER_REASON, PNI.LAST_REPRINT_DATE, '_LA:PNI.REPRINT_REASON:IGS_LOOKUP_VALUES:PE_SV_REPRINT_REASON:MEANING', PNI.REPRINT_REMARKS, '_LA:PNI.SECONDARY_MAJOR:IGS_LOOKUP_VALUES:PE_US_COURSE_SUBJECT:MEANING', '_LA:PNI.MINOR:IGS_LOOKUP_VALUES:PE_US_COURSE_SUBJECT:MEANING', PNI.ENGLISH_REQD_MET, PNI.NOT_REQD_REASON, PNI.EDUC_LVL_REMARKS, PNI.VISA_TYPE, PNI.NONIMG_FORM_ID, PNI.PERSON_ID, PNI.CREATION_DATE, PNI.CREATED_BY, PNI.LAST_UPDATED_BY, PNI.LAST_UPDATE_DATE FROM IGS_PE_NONIMG_FORM PNI WITH READ ONLY

View Text - HTML Formatted

SELECT PNI.PRINT_FORM
, PNI.FORM_EFFECTIVE_DATE
, '_LA:PNI.FORM_STATUS:IGS_LOOKUP_VALUES:PE_SV_FM_STAT_TYPE:MEANING'
, PNI.ACAD_TERM_LENGTH
, PNI.TUITION_AMT
, PNI.LIVING_EXP_AMT
, PNI.PERSONAL_FUNDS_AMT
, PNI.ISSUE_REASON
, PNI.COMMUTER_IND
, PNI.ENGLISH_REQD
, PNI.LENGTH_OF_STUDY
, PNI.PRGM_START_DATE
, PNI.PRGM_END_DATE
, '_LA:PNI.PRIMARY_MAJOR:IGS_LOOKUP_VALUES:PE_US_COURSE_SUBJECT:MEANING'
, '_LA:PNI.EDUCATION_LEVEL:IGS_LOOKUP_VALUES:PE_SV_EDUC_LEVEL:MEANING'
, PNI.DEPDNT_EXP_AMT
, PNI.OTHER_EXP_AMT
, PNI.OTHER_EXP_DESC
, PNI.SCHOOL_FUNDS_AMT
, PNI.SCHOOL_FUNDS_DESC
, PNI.OTHER_FUNDS_AMT
, PNI.OTHER_FUNDS_DESC
, PNI.EMPL_FUNDS_AMT
, PNI.REMARKS
, PNI.CURR_SESSION_END_DATE
, PNI.NEXT_SESSION_START_DATE
, PNI.TRANSFER_FROM_SCHOOL
, PNI.OTHER_REASON
, PNI.LAST_REPRINT_DATE
, '_LA:PNI.REPRINT_REASON:IGS_LOOKUP_VALUES:PE_SV_REPRINT_REASON:MEANING'
, PNI.REPRINT_REMARKS
, '_LA:PNI.SECONDARY_MAJOR:IGS_LOOKUP_VALUES:PE_US_COURSE_SUBJECT:MEANING'
, '_LA:PNI.MINOR:IGS_LOOKUP_VALUES:PE_US_COURSE_SUBJECT:MEANING'
, PNI.ENGLISH_REQD_MET
, PNI.NOT_REQD_REASON
, PNI.EDUC_LVL_REMARKS
, PNI.VISA_TYPE
, PNI.NONIMG_FORM_ID
, PNI.PERSON_ID
, PNI.CREATION_DATE
, PNI.CREATED_BY
, PNI.LAST_UPDATED_BY
, PNI.LAST_UPDATE_DATE
FROM IGS_PE_NONIMG_FORM PNI WITH READ ONLY