Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This entity contains information about the person entering the institution as an exchange visitor. |
Implementation/DBA Data: | Not implemented in this database |
SELECT PEV.PRINT_FORM
, PEV.FORM_EFFECTIVE_DATE
, '_LA:PEV.FORM_STATUS:IGS_LOOKUP_VALUES:PE_SV_FM_STAT_TYPE:MEANING'
, PEV.CREATE_REASON
, PEV.IS_VALID
, PEV.PRGM_SPONSOR_AMT
, PEV.GOVT_ORG1_AMT
, PEV.GOVT_ORG1_CODE
, PEV.GOVT_ORG2_AMT
, PEV.GOVT_ORG2_CODE
, PEV.INTL_ORG1_AMT
, PEV.INTL_ORG1_CODE
, PEV.INTL_ORG2_AMT
, PEV.INTL_ORG2_CODE
, PEV.EV_GOVT_AMT
, PEV.BI_NATNL_COM_AMT
, PEV.OTHER_GOVT_AMT
, PEV.PERSONAL_FUNDS_AMT
, PEV.EV_FORM_NUMBER
, PEV.PRGM_START_DATE
, PEV.PRGM_END_DATE
, PEV.LAST_REPRINT_DATE
, '_LA:PEV.REPRINT_REASON:IGS_LOOKUP_VALUES:PE_SV_REPRINT_REASON:MEANING'
, PEV.REPRINT_REMARKS
, '_LA:PEV.POSITION_CODE:IGS_LOOKUP_VALUES:PE_SV_EV_POSITION:MEANING'
, PEV.POSITION_REMARKS
, '_LA:PEV.SUBJECT_FIELD_CODE:IGS_LOOKUP_VALUES:PE_US_COURSE_SUBJECT:MEANING'
, PEV.SUBJECT_FIELD_REMARKS
, '_LA:PEV.MATRICULATION:IGS_LOOKUP_VALUES:PE_SV_EV_MATR_CODE:MEANING'
, PEV.REMARKS
, '_LA:PEV.CATEGORY_CODE:IGS_LOOKUP_VALUES:PE_SV_EV_PRG_CATEGORY:MEANING'
, PEV.INIT_PRGM_START_DATE
, PEV.EV_FORM_ID
, PEV.PERSON_ID
, PEV.CREATION_DATE
, PEV.CREATED_BY
, PEV.LAST_UPDATED_BY
, PEV.LAST_UPDATE_DATE
FROM IGS_PE_EV_FORM PEV WITH READ ONLY