[Home] [Help]
View: IGSBV_ORG_ACCREDITATIONS
Product: | IGS - Student System (Obsolete) |
Description: | This entity describes accreditation details. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
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
Columns
Name |
ORG_STRUCTURE_IDENTIFIER |
ORG_STRUCTURE_TYPE |
ORG_AGENCY_IDENTIFIER |
"_LA:ORG_ACCREDITATION_STATUS" |
EFFECTIVE_START_DATE |
EFFECTIVE_END_DATE |
"_LA:ORG_STRUCTURE_TYPE_DESC" |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |