Table: IGS_AD_BUILDING_ALL

Product:	IGS - Student System
Description:	Contains building information
Implementation/DBA Data:	IGS.IGS_AD_BUILDING_ALL

Primary Key: IGS_AD_BUILDING_PK

1. BUILDING_ID

Primary Key: IGS_AD_BUILDING_U2

1. LOCATION_CD
2. BUILDING_CD

Foreign Keys

Table		Foreign Table	Foreign Key Column
IGS_AD_BUILDING_ALL		IGS_AD_LOCATION_ALL	IGS_AD_BUILDING_ALL.LOCATION_CD
IGS_PS_USEC_OCCURS_ALL		IGS_AD_BUILDING_ALL	IGS_PS_USEC_OCCURS_ALL.DEDICATED_BUILDING_CODE
IGS_PS_USEC_OCCURS_ALL		IGS_AD_BUILDING_ALL	IGS_PS_USEC_OCCURS_ALL.PREFERRED_BUILDING_CODE
IGS_PS_US_UNSCHED_CL		IGS_AD_BUILDING_ALL	IGS_PS_US_UNSCHED_CL.BUILDING_ID
IGS_PS_UNIT_LOCATION		IGS_AD_BUILDING_ALL	IGS_PS_UNIT_LOCATION.BUILDING_ID
IGS_PS_USEC_OCCURS_ALL		IGS_AD_BUILDING_ALL	IGS_PS_USEC_OCCURS_ALL.BUILDING_CODE