eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGSFV_EXCHANGE_VISITORS

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

View Text

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
, HZP.PARTY_NUMBER
, 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
, HZ_PARTIES HZP
WHERE PEV.PERSON_ID=HZP.PARTY_ID WITH READ ONLY

Columns

Name
PRINT_FORM
FORM_EFFECTIVE_DATE
"_LA:FORM_STATUS"
CREATE_REASON
IS_VALID
PROGRAM_SPONSOR_AMOUNT
GOVERNMENT_ORG1_AMOUNT
GOVERNMENT_ORG1_CODE
GOVERNMENT_ORG2_AMOUNT
GOVERNMENT_ORG2_CODE
INTERNATIONAL_ORG1_AMOUNT
INTERNATIONAL_ORG1_CODE
INTERNATIONAL_ORG2_AMOUNT
INTERNATIONAL_ORG2_CODE
EXCHANGE_VISITOR_GOVT_AMOUNT
BI_NATIONAL_COMMISION_AMOUNT
OTHER_GOVERNMENT_AMOUNT
PERSONAL_FUNDS_AMOUNT
EXCHANGE_VISITOR_FORM_NUMBER
PROGRAM_START_DATE
PROGRAM_END_DATE
LAST_REPRINT_DATE
"_LA:REPRINT_REASON"
REPRINT_REMARKS
"_LA:POSITION_CODE"
POSITION_REMARKS
"_LA:SUBJECT_FIELD_CODE"
SUBJECT_FIELD_REMARKS
"_LA:MATRICULATION"
REMARKS
"_LA:CATEGORY_CODE"
INITIAL_PROGRAM_START_DATE
PERSON_NUMBER
EV_FORM_ID
PERSON_ID
CREATION_DATE
CREATED_BY
LAST_UPDATED_BY
LAST_UPDATE_DATE