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

128

ASSIGNABLE_AREA

XXX

VARCHAR2

16

BUILDING

XXX

VARCHAR2

40

BUILDING_FLOOR

XXX

VARCHAR2

13

BUILDING_WINGS_ID

XXX

VARCHAR2

64

EXT_GROSS_AREA

XXX

VARCHAR2

128

FLOOR

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

VARCHAR2

3

FLOOR_SORT_SEQUENCE

XXX

VARCHAR2

3

LEVEL_ID

XXX

VARCHAR2

25

NON_ASSIGNABLE_AREA

XXX

VARCHAR2

16

WAREHOUSE_LOAD_DATE

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

DATE

8