Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse TIP MATERIAL Table


View exposing instructional material reference data including ISBN, title, author, edition, publisher, publication year, shelf and rental prices, and material information source.


Field Name

Description

Data Type

Length

AUTHOR

Author associated with the person or organization.

VARCHAR2

1999

EDITION

Edition associated with the record.

VARCHAR2

500

ISBN

Isbn associated with the record.

VARCHAR2

36

MATERIAL_INFO_SOURCE

Material info source associated with the record.

VARCHAR2

4

PUBLISHER

Publisher associated with the record.

VARCHAR2

500

TIP_MATERIAL_KEY

Surrogate key identifying the tip material.

VARCHAR2

156

TITLE

Title associated with the record.

VARCHAR2

500

YEAR

Year associated with the record.

VARCHAR2

4