Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse TIP DETAIL Table


Information about the course materials fed into the Data Warehouse from COOP. Based on the on-line form submitted by the faculty members.


Field Name

Description

Data Type

Length

ISBN

The ISBN (International Standard Book Number) is a unique number assigned to a book title by its publisher for tracking and ordering purposes. ISBN is a 10-digit number that uniquely identifies books and book-like products published internationally. The purpose of the ISBN is to establish and identify one title or edition of a title from one specific publisher and is unique to that edition, allowing for more efficient marketing of products by booksellers, libraries, universities, wholesalers and distributors.

VARCHAR2

100

RECORD_COUNT

A counter for number of records.

NUMBER

1

SUBJECT_ID

The subject ID (eg.18.01, 15.012, 21W.731)

VARCHAR2

8

TERM_CODE

** For FINANCIAL DATA: the Term Code identifies the status of the cost collector. Blank - open for charges between start and end dates. Term Code = 1 - Closed. Pre-end date charges allowed. Term Code = 2 - No longer in use. Term Code = 3 - Terminated. Charges not allowed. ** For STUDENT DATA: the Term Code identifies one of the terms in an academic year; for example: 1999FA==>Fall Term of the 1998-99 academic year, and 1999SP==>Spring Term of the 1998-99 academic year.

VARCHAR2

6

TIP_MATERIAL_KEY

A unique Identifier for a TIP Material record ( based on ISBN, Title, and Academic Term).

VARCHAR2

100

TIP_MATERIAL_STATUS_KEY

Uniquely Identifies TIP MAterial Status

VARCHAR2

4

TIP_SUBJECT_OFFERED_KEY

A Unique Identifier for Subject Offered (combination of subject and academic term)

VARCHAR2

16

WAREHOUSE_LOAD_DATE

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

DATE

8