AA ARTICLE Table
Stores normalized metadata for scholarly articles and conference publications associated with Academic Analytics (AA). Each row represents a unique article and includes bibliographic details, journal information, author attribution, institutional identifiers, and matching metadata.
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 |
External institutional identifier associated with the author or article record. |
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 |