TIP MATERIAL Table
Inforamtion about Course Material (Author,Title,ISBN, Publisher, etc.)
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AUTHOR |
Author of the Course Material. |
VARCHAR2 |
500 |
EDITION |
Edition of the Course Material |
VARCHAR2 |
500 |
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 |
MATERIAL_INFO_SOURCE |
Source of Information about specific material. It reflects whether the information about the Title, Publisher, etc. came from ISBN, or has been passed to us by COOP. |
VARCHAR2 |
4 |
PRICE |
Price of the Course Material. This is ISBN pricing. |
NUMBER |
22 |
PUBLISHER |
XXX |
VARCHAR2 |
100 |
TIP_MATERIAL_KEY |
A unique Identifier for a TIP Material record ( based on ISBN, Title, and Academic Term). |
VARCHAR2 |
100 |
TITLE |
In the OSP AWARD, COST COLLECTOR, and PROJECT OSP tables, this is the Title of a Research Proposal. In KRB_PERSON, TITLE is the position title of the person. In TIP_MATERIAL view it is a TITLE of the course material. |
VARCHAR2 |
50 |
YEAR |
In KRB_PERSON, YEAR is a one-character field identifying the students year of degree (or current year); eg.: 1, 2, 3, 4, G, U. In TIP_MATERIAL YEAR is a Year when a Title was published |
VARCHAR2 |
1 |