Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This entity contains information about international non-immigrant students. |
Implementation/DBA Data: | Not implemented in this database |
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