Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse FAC FLOOR Table


View exposing facilities floor reference data including building, floor, space-area measures, floor sort sequence, level, wing, and access-level attributes.


Field Name

Description

Data Type

Length

ACCESS_LEVEL

Access level associated with the record.

VARCHAR2

2

ASSIGNABLE_AREA

Assignable area associated with the record.

NUMBER

32,20

BUILDING_WINGS_ID

Business identifier for the building wings.

VARCHAR2

64

EXT_GROSS_AREA

Ext gross area associated with the record.

NUMBER

32,20

FLOOR

Floor associated with the record.

VARCHAR2

4

FLOOR_SORT_SEQUENCE

Floor sort sequence associated with the record.

VARCHAR2

3

LEVEL_ID

Business identifier for the level.

VARCHAR2

25

NON_ASSIGNABLE_AREA

Non assignable area associated with the record.

NUMBER

32,20

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE