FND Design Data [Home] [Help]

Table: IGS_AD_BUILDING_ALL

Product: IGS - Student System (Obsolete)
Description: Contains building information
Implementation/DBA Data: Not implemented in this database
Primary Key: IGS_AD_BUILDING_PK
  1. ColumnBUILDING_ID
Primary Key: IGS_AD_BUILDING_U2
  1. ColumnLOCATION_CD
  2. ColumnBUILDING_CD
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_AD_BUILDING_ALL FK Joins to TableIGS_AD_LOCATION_ALL IGS_AD_BUILDING_ALL.LOCATION_CD
TableIGS_PS_USEC_OCCURS_ALL FK Joins to IGS_AD_BUILDING_ALL IGS_PS_USEC_OCCURS_ALL.DEDICATED_BUILDING_CODE
TableIGS_PS_USEC_OCCURS_ALL FK Joins to IGS_AD_BUILDING_ALL IGS_PS_USEC_OCCURS_ALL.PREFERRED_BUILDING_CODE
TableIGS_PS_US_UNSCHED_CL FK Joins to IGS_AD_BUILDING_ALL IGS_PS_US_UNSCHED_CL.BUILDING_ID
TableIGS_PS_UNIT_LOCATION FK Joins to IGS_AD_BUILDING_ALL IGS_PS_UNIT_LOCATION.BUILDING_ID
TableIGS_PS_USEC_OCCURS_ALL FK Joins to IGS_AD_BUILDING_ALL IGS_PS_USEC_OCCURS_ALL.BUILDING_CODE