Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse FAC FLOOR Table


Facilities Floor Info


Field Name

Description

Data Type

Length

ACCESS_LEVEL

XXX

VARCHAR2

2

ASSIGNABLE_AREA

XXX

NUMBER

32,20

BUILDING_WINGS_ID

XXX

VARCHAR2

64

EXT_GROSS_AREA

XXX

NUMBER

32,20

FLOOR

The floor number. for example: E19-332B; building: E19; Floor: 3; Room: 32B

VARCHAR2

4

FLOOR_SORT_SEQUENCE

XXX

VARCHAR2

3

LEVEL_ID

XXX

VARCHAR2

25

NON_ASSIGNABLE_AREA

XXX

NUMBER

32,20

WAREHOUSE_LOAD_DATE

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

DATE