AA ARTICLE Table
View exposing scholarly article publication records associated with MIT faculty, including article metadata, journal information, DOI identifiers, authorship details, citation formats, publisher data, 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 |
128 |
AA_FACULTY_ID |
Unique identifier for the faculty member within the Academic Analytics system. |
VARCHAR2 |
32 |
AA_MATCH_SCORE |
Numeric score representing the confidence or quality of the match between source records and Academic Analytics entities. |
NUMBER |
34 |
ARTICLE_ID |
Unique identifier for the article record within the Academic Analytics system. Primary key for the table. |
VARCHAR2 |
10 |
ARTICLE_TITLE |
Full title of the scholarly article or publication. |
VARCHAR2 |
2000 |
ARTICLE_YEAR |
Four-digit year in which the article was published. |
VARCHAR2 |
4 |
AUTHORS |
Complete list of article authors, typically in canonical or source-provided order. |
CLOB |
|
AUTHORS_MLA_FORMAT |
Author list formatted according to MLA citation standards. |
VARCHAR2 |
500 |
DOI |
Digital Object Identifier (DOI) assigned to the article. |
VARCHAR2 |
72 |
FULL_NAME |
Full name of the associated faculty member or author as represented in Academic Analytics records. |
VARCHAR2 |
128 |
ISSN_ELECTRONIC |
Electronic International Standard Serial Number (ISSN) for the journal. |
VARCHAR2 |
13 |
ISSN_PRINT |
Print International Standard Serial Number (ISSN) for the journal. |
VARCHAR2 |
13 |
IS_CONFERENCE_PROCEEDING |
Flag indicating whether the article is from a conference proceeding (Y or N). |
VARCHAR2 |
1 |
JOURNAL_FIRST_PAGE |
First page number of the article in the journal or conference proceedings. |
VARCHAR2 |
20 |
JOURNAL_ID |
Unique identifier for the journal within the Academic Analytics system. |
VARCHAR2 |
10 |
JOURNAL_ISSUE |
Issue number of the journal volume containing the article. |
VARCHAR2 |
50 |
JOURNAL_LAST_PAGE |
Last page number of the article in the journal or conference proceedings. |
VARCHAR2 |
20 |
JOURNAL_NAME |
Official name of the journal in which the article was published. |
VARCHAR2 |
500 |
JOURNAL_VOLUME |
Volume number of the journal issue containing the article. |
VARCHAR2 |
50 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
50 |
MLA_CITATION |
Full article citation formatted according to MLA style guidelines. |
VARCHAR2 |
4000 |
PUBLISHER |
Name of the publisher responsible for the journal or conference proceedings. |
VARCHAR2 |
2000 |
PUBLISH_DATE |
Publication date of the article as provided by the source, stored as text to preserve original formatting. |
VARCHAR2 |
35 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |