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: IGS_DA_XML_TE_INSTITUTION_V

Product:	IGS - Student System (Obsolete)
Description:	XML element InstitutionType (child of TransferEvaluation)
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT CWDT.ALT_ID_TYPE
, CWDT.ALT_ID_VALUE
, ''
, DRF.BATCH_ID
FROM IGS_DA_REQ_FTRS DRF
, IGS_OR_CWLK_DTL CWDT
, IGS_OR_CWLK CWLK
, IGS_DA_SETUP DS
WHERE DRF.FEATURE_CODE = 'EOI'
AND CWLK.INSTITUTION_CODE = DRF.FEATURE_VALUE
AND CWLK.CROSSWALK_ID = CWDT.CROSSWALK_ID
AND CWDT.ALT_ID_TYPE = DS.DEFAULT_INST_ID_TYPE
AND DS.S_CONTROL_NUM = 1 UNION ALL SELECT 'OSS'
, HP.PARTY_NUMBER
, ''
, DRF.BATCH_ID
FROM IGS_DA_REQ_FTRS DRF
, HZ_PARTIES HP
, IGS_PE_HZ_PARTIES IPZ
WHERE DRF.FEATURE_CODE = 'EOI'
AND IPZ.OSS_ORG_UNIT_CD = DRF.FEATURE_VALUE
AND IPZ.PARTY_ID = HP.PARTY_ID
AND NOT EXISTS(SELECT 'X'
FROM IGS_OR_CWLK_DTL CWDT
, IGS_OR_CWLK CWLK
, IGS_DA_SETUP DS
WHERE IPZ.OSS_ORG_UNIT_CD = CWLK.INSTITUTION_CODE AND IPZ.PARTY_ID = HP.PARTY_ID
AND CWLK.CROSSWALK_ID = CWDT.CROSSWALK_ID
AND CWDT.ALT_ID_TYPE = DS.DEFAULT_INST_ID_TYPE
AND DS.S_CONTROL_NUM = 1)

Columns

Name
ENTITY_IDCODE_QUALIFER
ENTITY_ID_CODE
ENTITY_ID_CODE_GROUP
BATCH_ID