Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse FAC BUILDING Table


Facilities Building Info


Field Name

Description

Data Type

Length

ACCESS_LEVEL

XXX

VARCHAR2

128

ASSIGNABLE_AREA

XXX

VARCHAR2

16

BUIILDING_NAME_LONG

XXX

VARCHAR2

64

BUILDING

XXX

VARCHAR2

40

BUILDING_HEIGHT

XXX

VARCHAR2

32

BUILDING_NAMED_FOR

XXX

VARCHAR2

96

BUILDING_NAME_FULL

XXX

VARCHAR2

128

BUILDING_SORT

XXX

VARCHAR2

10

BUILDING_TYPE

XXX

VARCHAR2

8

BUILDING_USE

XXX

VARCHAR2

32

CAMPUS_SECTOR

XXX

VARCHAR2

25

COMPONENT_OF_BUILDING

XXX

VARCHAR2

8

COST_CENTER_CODE

XXX

VARCHAR2

16

DATE_ACQUIRED

XXX

VARCHAR2

16

DATE_BUILT

XXX

VARCHAR2

16

DATE_OCCUPIED

XXX

VARCHAR2

16

EASTING_X_SPCS

XXX

VARCHAR2

50

EXT_GROSS_AREA

XXX

VARCHAR2

128

LATITUDE_WGS

XXX

VARCHAR2

50

LONGITUDE_WGS

XXX

VARCHAR2

50

NON_ASSIGNABLE_AREA

XXX

VARCHAR2

16

NORTHING_Y_SPCS

XXX

VARCHAR2

50

OCCUPANCY_CLASS

XXX

VARCHAR2

8

OWNERSHIP_TYPE

XXX

VARCHAR2

8

SITE

XXX

VARCHAR2

16

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8