Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse FAC BUILDING Table


Facilities Building Info


Field Name

Description

Data Type

Length

ASSIGNABLE_AREA

XXX

NUMBER

32,20

BUILDING_HEIGHT

XXX

VARCHAR2

32

BUILDING_NAMED_FOR

XXX

VARCHAR2

96

BUILDING_SORT

XXX

VARCHAR2

10

BUILDING_TYPE

XXX

VARCHAR2

8

BUILDING_USE

XXX

VARCHAR2

32

CAMPUS_SECTOR

XXX

VARCHAR2

25

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

NUMBER

32,20

EXT_GROSS_AREA

XXX

NUMBER

32,20

LATITUDE_WGS

XXX

NUMBER

32,20

LONGITUDE_WGS

XXX

NUMBER

32,20

NON_ASSIGNABLE_AREA

XXX

NUMBER

32,20

NORTHING_Y_SPCS

XXX

NUMBER

32,20

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