[Home] [Help]
View: IGS_OR_ORG_ALT_IDS_V
Product: | IGS - Student System (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT OLI.ROWID ROW_ID
, OLI.ORG_STRUCTURE_ID
, OLI.ORG_STRUCTURE_TYPE
, OLI.ORG_ALTERNATE_ID_TYPE
, OLT.ID_TYPE_DESCRIPTION
, OLI.ORG_ALTERNATE_ID
, OLI.START_DATE
, OLI.END_DATE
, OLI.CREATION_DATE
, OLI.CREATED_BY
, OLI.LAST_UPDATE_DATE
, OLI.LAST_UPDATED_BY
, OLI.LAST_UPDATE_LOGIN
FROM IGS_OR_ORG_ALT_IDS OLI
, IGS_OR_ORG_ALT_IDTYP OLT
WHERE OLI.ORG_ALTERNATE_ID_TYPE = OLT.ORG_ALTERNATE_ID_TYPE
Columns
Name |
ROW_ID |
ORG_STRUCTURE_ID |
ORG_STRUCTURE_TYPE |
ORG_ALTERNATE_ID_TYPE |
ID_TYPE_DESCRIPTION |
ORG_ALTERNATE_ID |
START_DATE |
END_DATE |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |