[Home] [Help]
View: IGSFV_BUILDINGS
Product: | IGS - Student System (Obsolete) |
Description: | This entity contains building information associated to a location |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT BLD.BUILDING_CD BUILDING_CODE
, BLD.LOCATION_CD LOCATION_CODE
, BLD.DESCRIPTION
, BLD.CLOSED_IND CLOSED_INDICATOR
, LOC.DESCRIPTION LOCATION_DESC
, BLD.BUILDING_ID
, BLD.CREATED_BY
, BLD.CREATION_DATE
, BLD.LAST_UPDATED_BY
, BLD.LAST_UPDATE_DATE
FROM IGS_AD_BUILDING_ALL BLD
, IGS_AD_LOCATION_ALL LOC
WHERE BLD.LOCATION_CD = LOC.LOCATION_CD WITH READ ONLY
Columns
Name |
BUILDING_CODE |
LOCATION_CODE |
DESCRIPTION |
CLOSED_INDICATOR |
LOCATION_DESC |
BUILDING_ID |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |