Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse KEYS Table


View exposing key-allocation detail including unit, person name, key number, and quantity.


Field Name

Description

Data Type

Length

FIRST_NAME

First name associated with the person.

VARCHAR2

30

KEY_NUMBER

Key number associated with the record.

VARCHAR2

11

LAST_NAME

Last name associated with the person.

VARCHAR2

30

QUANTITY

Quantity associated with the record.

VARCHAR2

11

UNIT_ID

Business identifier for the unit.

VARCHAR2

6