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 |