Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This entity contains notes about institutions, organizational units or locations. |
Implementation/DBA Data: | Not implemented in this database |
SELECT ONT.ORG_STRUCTURE_ID ORG_STRUCTURE_IDENTIFIER
, ONT.ORG_STRUCTURE_TYPE
, ONT.ORG_NOTE_SEQUENCE
, ONT.ORG_NOTE_TYPE
, ONT.START_DATE EFFECTIVE_START_DATE
, ONT.END_DATE EFFECTIVE_END_DATE
, ONT.NOTE_TEXT NOTES
, '_LA:ONT.ORG_STRUCTURE_TYPE:IGS_LOOKUP_VALUES:ORG_STRUCTURE_TYPE:MEANING'
, ONY.NOTE_TYPE_DESCRIPTION ORG_NOTE_TYPE_DESC
, ONT.CREATED_BY
, ONT.CREATION_DATE
, ONT.LAST_UPDATED_BY
, ONT.LAST_UPDATE_DATE
FROM IGS_OR_ORG_NOTES ONT
, IGS_OR_ORG_NOTE_TYPE ONY
WHERE ONT.ORG_NOTE_TYPE = ONY.ORG_NOTES_TYPE WITH READ ONLY