AA BOOK Table
Stores metadata for books associated with Academic Analytics (AA). Each row represents a unique book record and includes bibliographic details, author attribution, institutional identifiers, and warehouse load metadata.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AA_CLIENT_ID |
Identifier for the Academic Analytics client institution or organization. |
VARCHAR2 |
10 |
AA_FACULTY_ID |
Unique identifier for the faculty member within the Academic Analytics system. |
VARCHAR2 |
40 |
AUTHORS_MLA_FORMAT |
Author list formatted according to MLA citation standards. |
VARCHAR2 |
500 |
AUTHOR_NAME |
Author name as provided by the source record (may represent primary author). |
VARCHAR2 |
400 |
BISAC |
Book Industry Standards and Communications (BISAC) subject or category code for the book. |
VARCHAR2 |
60 |
BOOK_ID |
Unique identifier for the book record within the Academic Analytics system. Primary key for the table. |
VARCHAR2 |
10 |
BOOK_TITLE |
Title of the book. |
VARCHAR2 |
400 |
FULL_NAME |
Full name of the associated faculty member or author as represented in Academic Analytics records. |
VARCHAR2 |
128 |
ISBN |
International Standard Book Number (ISBN) for the book. |
VARCHAR2 |
20 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
100 |
MLA_CITATION |
Full book citation formatted according to MLA style guidelines. |
VARCHAR2 |
4000 |
PUBLISHER |
Name of the publisher of the book. |
VARCHAR2 |
400 |
PUBLISH_DATE |
Publication date of the book as provided by the source, stored as text to preserve original formatting. |
VARCHAR2 |
20 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |