Product: | IGS - Student System |
---|---|
Description: | This entity describes accreditation details. |
Implementation/DBA Data: | APPS.IGSBV_ORG_ACCREDITATIONS |
SELECT OAD.ORG_STRUCTURE_ID ORG_STRUCTURE_IDENTIFIER
, OAD.ORG_STRUCTURE_TYPE
, OAD.ORG_AGENCY_ID ORG_AGENCY_IDENTIFIER
, '_LA:OAD.ORG_ACCR_STATUS:IGS_LOOKUP_VALUES:OR_ACCR_STATUS:MEANING'
, OAD.START_DATE EFFECTIVE_START_DATE
, OAD.END_DATE EFFECTIVE_END_DATE
, '_LA:OAD.ORG_STRUCTURE_TYPE:IGS_LOOKUP_VALUES:ORG_STRUCTURE_TYPE:MEANING'
, OAD.CREATED_BY
, OAD.CREATION_DATE
, OAD.LAST_UPDATED_BY
, OAD.LAST_UPDATE_DATE
FROM IGS_OR_ORG_ACCR_DTLS OAD