FND Design Data [Home] [Help]

Table: IGS_OR_ORG_ALT_IDS

Product: IGS - Student System
Description: This entity contains alternate IDs for institutions or organizational units.
Implementation/DBA Data: TableIGS.IGS_OR_ORG_ALT_IDS
Primary Key: IGS_OR_ORG_ALTERNATE_IDS_PK
  1. ColumnORG_STRUCTURE_ID
  2. ColumnORG_STRUCTURE_TYPE
  3. ColumnORG_ALTERNATE_ID_TYPE
  4. ColumnORG_ALTERNATE_ID
  5. ColumnSTART_DATE
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_OR_ORG_ALT_IDS FK Joins to TableIGS_AD_LOCATION_ALL IGS_OR_ORG_ALT_IDS.ORG_STRUCTURE_ID
IGS_OR_ORG_ALT_IDS FK Joins to TableIGS_OR_ORG_ALT_IDTYP IGS_OR_ORG_ALT_IDS.ORG_ALTERNATE_ID_TYPE
IGS_OR_ORG_ALT_IDS FK Joins to TableIGS_AD_LOCATION_ALL IGS_OR_ORG_ALT_IDS.ORG_STRUCTURE_ID
IGS_OR_ORG_ALT_IDS FK Joins to TableIGS_OR_ORG_ALT_IDTYP IGS_OR_ORG_ALT_IDS.ORG_ALTERNATE_ID_TYPE