AA BOOK Table
View exposing scholarly book publication records associated with MIT faculty, including bibliographic metadata, ISBN identifiers, publisher information, citation formats, authorship details, and faculty linkage identifiers used for research analytics and reporting.
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 |