Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This entity contains alternate IDs for institutions or organizational |
Implementation/DBA Data: | Not implemented in this database |
SELECT OAI.ORG_STRUCTURE_ID ORG_STRUCTURE_IDENTIFIER
, OAI.ORG_STRUCTURE_TYPE
, OAI.ORG_ALTERNATE_ID_TYPE ORG_ALTERNATE_ID_TYPE
, OAI.ORG_ALTERNATE_ID ORG_ALTERNATE_IDENTIFIER
, '_LA:OAT.SYSTEM_ID_TYPE:IGS_LOOKUP_VALUES:OR_SYSTEM_ID_TYPE:MEANING'
, OAT.PREF_INST_IND
, OAT.PREF_UNIT_IND
, OAI.START_DATE EFFECTIVE_START_DATE
, OAI.END_DATE EFFECTIVE_END_DATE
, OAT.ID_TYPE_DESCRIPTION ORG_ALTERNATE_ID_TYPE_DESC
, '_LA:OAI.ORG_STRUCTURE_TYPE:IGS_LOOKUP_VALUES:ORG_STRUCTURE_TYPE:MEANING'
, OAI.CREATED_BY
, OAI.CREATION_DATE
, OAI.LAST_UPDATED_BY
, OAI.LAST_UPDATE_DATE
FROM IGS_OR_ORG_ALT_IDS OAI
, IGS_OR_ORG_ALT_IDTYP OAT
WHERE OAI.ORG_ALTERNATE_ID_TYPE = OAT.ORG_ALTERNATE_ID_TYPE WITH READ ONLY