Author Identifier 
Base Entity  Author 
Attribute Name  Author Identifier 
Logical Rolename   
ColumnName  AUTHOR_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition  
Person Identifier: Unique identifier for a person derived from XCAMS.
 
Note 
 

Author Identifier Logical Attribute Properties 
Logical Attribute Name  Author Identifier 
Datatype  NUMERIC(38, 0) 
Nullable  NO 

Author Identifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Author Identifier Security Types 
Name  Current Value 

Author Identifier Bound Attachments 
Name  Current Value 

Author Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Author Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Author
Author Identifier 		 NO     
PUBL (Oracle)
AUTHOR
AUTHOR_ID 		 NO     

Author Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Author Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Author Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Author Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Last Name 
Base Entity  Author 
Attribute Name  Last Name 
Logical Rolename   
ColumnName  LAST_NM 
RoleName   
Domain  Name 
Logical Only  NO 
Definition  
Last Name: person last name.
 
Note 
 

Last Name Logical Attribute Properties 
Logical Attribute Name  Last Name 
Datatype  VARCHAR(120) 
Nullable  YES 

Last Name Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Last Name Security Types 
Name  Current Value 

Last Name Bound Attachments 
Name  Current Value 

Last Name Data Movement Rules 
Name  Type  Rule Text/Value 

Last Name Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Author
Last Name 		 NO     
PUBL (Oracle)
AUTHOR
LAST_NM 		 NO     

Last Name Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Last Name Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Last Name Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Last Name Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

First Initial 
Base Entity  Author 
Attribute Name  First Initial 
Logical Rolename   
ColumnName  FIRST_INIT 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

First Initial Logical Attribute Properties 
Logical Attribute Name  First Initial 
Datatype  CHAR(1) 
Nullable  YES 

First Initial Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
First Initial Security Types 
Name  Current Value 

First Initial Bound Attachments 
Name  Current Value 

First Initial Data Movement Rules 
Name  Type  Rule Text/Value 

First Initial Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Author
First Initial 		 NO     
PUBL (Oracle)
AUTHOR
FIRST_INIT 		 NO     

First Initial Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

First Initial Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

First Initial Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

First Initial Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Middle Initial 
Base Entity  Author 
Attribute Name  Middle Initial 
Logical Rolename   
ColumnName  MID_INIT 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Middle Initial Logical Attribute Properties 
Logical Attribute Name  Middle Initial 
Datatype  CHAR(1) 
Nullable  YES 

Middle Initial Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Middle Initial Security Types 
Name  Current Value 

Middle Initial Bound Attachments 
Name  Current Value 

Middle Initial Data Movement Rules 
Name  Type  Rule Text/Value 

Middle Initial Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Author
Middle Initial 		 NO     
PUBL (Oracle)
AUTHOR
MID_INIT 		 NO     

Middle Initial Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Middle Initial Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Middle Initial Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Middle Initial Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Third Initial 
Base Entity  Author 
Attribute Name  Third Initial 
Logical Rolename   
ColumnName  THIRD_INIT 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Third Initial Logical Attribute Properties 
Logical Attribute Name  Third Initial 
Datatype  CHAR(1) 
Nullable  YES 

Third Initial Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Third Initial Security Types 
Name  Current Value 

Third Initial Bound Attachments 
Name  Current Value 

Third Initial Data Movement Rules 
Name  Type  Rule Text/Value 

Third Initial Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Author
Third Initial 		 NO     
PUBL (Oracle)
AUTHOR
THIRD_INIT 		 NO     

Third Initial Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Third Initial Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Third Initial Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Third Initial Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

First Name 
Base Entity  Author 
Attribute Name  First Name 
Logical Rolename   
ColumnName  FIRST_NM 
RoleName   
Domain   
Logical Only  NO 
Definition  
First Name: Person first name.
 
Note 
 

First Name Logical Attribute Properties 
Logical Attribute Name  First Name 
Datatype  VARCHAR(64) 
Nullable  YES 

First Name Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
First Name Security Types 
Name  Current Value 

First Name Bound Attachments 
Name  Current Value 

First Name Data Movement Rules 
Name  Type  Rule Text/Value 

First Name Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Author
First Name 		 NO     
PUBL (Oracle)
AUTHOR
FIRST_NM 		 NO     

First Name Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

First Name Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

First Name Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

First Name Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Alias 
Base Entity  Author 
Attribute Name  Alias 
Logical Rolename   
ColumnName  ALIAS 
RoleName   
Domain  Name 
Logical Only  NO 
Definition  
Alias: Person sometimes publish under a name different than their legal name.
 
Note 
 

Alias Logical Attribute Properties 
Logical Attribute Name  Alias 
Datatype  VARCHAR(120) 
Nullable  YES 

Alias Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Alias Security Types 
Name  Current Value 

Alias Bound Attachments 
Name  Current Value 

Alias Data Movement Rules 
Name  Type  Rule Text/Value 

Alias Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Author
Alias 		 NO     
PUBL (Oracle)
AUTHOR
ALIAS 		 NO     

Alias Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Alias Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Alias Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Alias Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Email Address 
Base Entity  Author 
Attribute Name  Email Address 
Logical Rolename   
ColumnName  EMAIL_ADDR 
RoleName   
Domain   
Logical Only  NO 
Definition  
Email Address: Person email address.
 
Note 
 

Email Address Logical Attribute Properties 
Logical Attribute Name  Email Address 
Datatype  VARCHAR(100) 
Nullable  YES 

Email Address Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Email Address Security Types 
Name  Current Value 

Email Address Bound Attachments 
Name  Current Value 

Email Address Data Movement Rules 
Name  Type  Rule Text/Value 

Email Address Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Author
Email Address 		 NO     
PUBL (Oracle)
AUTHOR
EMAIL_ADDR 		 NO     

Email Address Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Email Address Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Email Address Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Email Address Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Country Identifier 
Base Entity  Author 
Attribute Name  Country Identifier 
Logical Rolename   
ColumnName  CNTRY_ID 
RoleName   
Domain   
Logical Only  NO 
Definition  
Country Identifier: Abbreviated identrifier for a country.
 
Note 
 

Country Identifier Logical Attribute Properties 
Logical Attribute Name  Country Identifier 
Datatype  VARCHAR(10) 
Nullable  YES 

Country Identifier Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Country Identifier Security Types 
Name  Current Value 

Country Identifier Bound Attachments 
Name  Current Value 

Country Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Country Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Author
Country Identifier 		 NO     
PUBL (Oracle)
AUTHOR
CNTRY_ID 		 NO     

Country Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Country Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Country Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Country Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Institute Identifier 
Base Entity  Author 
Attribute Name  Institute Identifier 
Logical Rolename   
ColumnName  INST_ID 
RoleName   
Domain   
Logical Only  NO 
Definition  
Institute Identifer: Abbreviated identifier for a institute.
 
Note 
 

Institute Identifier Logical Attribute Properties 
Logical Attribute Name  Institute Identifier 
Datatype  INTEGER 
Nullable  YES 

Institute Identifier Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Institute Identifier Security Types 
Name  Current Value 

Institute Identifier Bound Attachments 
Name  Current Value 

Institute Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Institute Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Author
Institute Identifier 		 NO     
PUBL (Oracle)
AUTHOR
INST_ID 		 NO     

Institute Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Institute Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Institute Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Institute Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Researcher Identifier 
Base Entity  Author 
Attribute Name  Researcher Identifier 
Logical Rolename   
ColumnName  RESEARCH_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition  
ResearcherID: A unique identifier assinged by Thomson Reuters to enable researchers to manage their publication lists, track their times cited counts and h-index, identify potential collaborators and avoid author misidentification. In addition, your ResearcherID information integrates with the Web of Science and is ORCID compliant, allowing you to claim and showcase your publications from a single one account.
 
Note 
 

Researcher Identifier Logical Attribute Properties 
Logical Attribute Name  Researcher Identifier 
Datatype  VARCHAR(20) 
Nullable  YES 

Researcher Identifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Researcher Identifier Security Types 
Name  Current Value 

Researcher Identifier Bound Attachments 
Name  Current Value 

Researcher Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Researcher Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Author
Researcher Identifier 		 NO     
PUBL (Oracle)
AUTHOR
RESEARCH_ID 		 NO     

Researcher Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Researcher Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Researcher Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Researcher Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

ORCID Identitifer 
Base Entity  Author 
Attribute Name  ORCID Identitifer 
Logical Rolename   
ColumnName  ORCID_ID 
RoleName   
Domain  URI 
Logical Only  NO 
Definition  
ORCID Id: The ORCID iD is a URI with a 16-digit number that is compatible with the ISO Standard (ISO 27729), also known as the International Standard Name Identifier (ISNI). Initially ORCID iDs will be randomly assigned by the ORCID Registry from a block of numbers that will not conflict with ISNI-formatted numbers assigned in other ways. ORCID iDs always need all 16-digits; they can not be shortened to remove leading zeros if they exist.



Expressing the ORCID iD

The ORCID iD is expressed as a HTTP URI; the number is proceeded by "http://orcid.org/". A hyphen is inserted every 4 digits to aid readability.



Storage of the ORCID iD in a database

The ORCID iD should always be expressed and stored as a URI: http://orcid.org/xxxx-xxxx-xxxx-xxxx (with the protocol (http://), and with hyphens in the number xxxx-xxxx-xxxx-xxxx).
 
Note 
 

ORCID Identitifer Logical Attribute Properties 
Logical Attribute Name  ORCID Identitifer 
Datatype  VARCHAR(255) 
Nullable  YES 

ORCID Identitifer Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

ORCID Identitifer Security Types 
Name  Current Value 

ORCID Identitifer Bound Attachments 
Name  Current Value 

ORCID Identitifer Data Movement Rules 
Name  Type  Rule Text/Value 

ORCID Identitifer Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Author
ORCID Identitifer 		 NO     
PUBL (Oracle)
AUTHOR
ORCID_ID 		 NO     

ORCID Identitifer Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ORCID Identitifer Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ORCID Identitifer Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ORCID Identitifer Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Person Identifier 
Base Entity  Author 
Attribute Name  Person Identifier 
Logical Rolename   
ColumnName  PERSON_ID 
RoleName   
Domain   
Logical Only  NO 
Definition  
Person Identifier: Unique identifier for a person derived from XCAMS.
 
Note 
 

Person Identifier Logical Attribute Properties 
Logical Attribute Name  Person Identifier 
Datatype  VARCHAR(10) 
Nullable  YES 

Person Identifier Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Person Identifier Security Types 
Name  Current Value 

Person Identifier Bound Attachments 
Name  Current Value 

Person Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Person Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Author
Person Identifier 		 NO     
PUBL (Oracle)
AUTHOR
PERSON_ID 		 NO     

Person Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Person Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Person Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Person Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Comment 
Base Entity  Author 
Attribute Name  Comment 
Logical Rolename   
ColumnName  CMNT 
RoleName   
Domain  Comment 
Logical Only  NO 
Definition  
Comment:  General comments.
 
Note 
 

Comment Logical Attribute Properties 
Logical Attribute Name  Comment 
Datatype  VARCHAR(2000) 
Nullable  YES 

Comment Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Comment Security Types 
Name  Current Value 

Comment Bound Attachments 
Name  Current Value 

Comment Data Movement Rules 
Name  Type  Rule Text/Value 

Comment Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Author
Comment 		 NO     
PUBL (Oracle)
AUTHOR
CMNT 		 NO     

Comment Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Comment Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Comment Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Comment Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

HFIR Indicator 
Base Entity  Author 
Attribute Name  HFIR Indicator 
Logical Rolename   
ColumnName  HFIR_IND 
RoleName   
Domain  Indicator 
Logical Only  NO 
Definition 
 
Note 
 

HFIR Indicator Logical Attribute Properties 
Logical Attribute Name  HFIR Indicator 
Datatype  CHAR(1) 
Nullable  NO 

HFIR Indicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

HFIR Indicator Reference Value (Bound to Domain) 
Name  Standard Indicator 
Description  These are the standard values for the Indicator domain. 
Type  By List 
Value  Value Description 
Y  Yes 
N  No 

HFIR Indicator Security Types 
Name  Current Value 

HFIR Indicator Bound Attachments 
Name  Current Value 

HFIR Indicator Data Movement Rules 
Name  Type  Rule Text/Value 

HFIR Indicator Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Author
HFIR Indicator 		 NO     
PUBL (Oracle)
AUTHOR
HFIR_IND 		 NO     

HFIR Indicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

HFIR Indicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

HFIR Indicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

HFIR Indicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

SNS Indicator 
Base Entity  Author 
Attribute Name  SNS Indicator 
Logical Rolename   
ColumnName  SNS_IND 
RoleName   
Domain  Indicator 
Logical Only  NO 
Definition 
 
Note 
 

SNS Indicator Logical Attribute Properties 
Logical Attribute Name  SNS Indicator 
Datatype  CHAR(1) 
Nullable  NO 

SNS Indicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

SNS Indicator Reference Value (Bound to Domain) 
Name  Standard Indicator 
Description  These are the standard values for the Indicator domain. 
Type  By List 
Value  Value Description 
Y  Yes 
N  No 

SNS Indicator Security Types 
Name  Current Value 

SNS Indicator Bound Attachments 
Name  Current Value 

SNS Indicator Data Movement Rules 
Name  Type  Rule Text/Value 

SNS Indicator Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Author
SNS Indicator 		 NO     
PUBL (Oracle)
AUTHOR
SNS_IND 		 NO     

SNS Indicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SNS Indicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SNS Indicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SNS Indicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

NSCD Division Identifier 
Base Entity  Author 
Attribute Name  NSCD Division Identifier 
Logical Rolename   
ColumnName  NSCD_DIV_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

NSCD Division Identifier Logical Attribute Properties 
Logical Attribute Name  NSCD Division Identifier 
Datatype  VARCHAR(10) 
Nullable  YES 

NSCD Division Identifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

NSCD Division Identifier Security Types 
Name  Current Value 

NSCD Division Identifier Bound Attachments 
Name  Current Value 

NSCD Division Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

NSCD Division Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Author
NSCD Division Identifier 		 NO     
PUBL (Oracle)
AUTHOR
NSCD_DIV_ID 		 NO     

NSCD Division Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

NSCD Division Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

NSCD Division Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

NSCD Division Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description