Participant Identifier 
Base Entity  Participant 
Attribute Name  Participant Identifier 
Logical Rolename   
ColumnName  PART_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

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

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

Participant Identifier Security Types 
Name  Current Value 

Participant Identifier Bound Attachments 
Name  Current Value 

Participant Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Participant Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Participant
Participant Identifier 		 NO     
ENGA (Oracle)
PARTICIPANT
PART_ID 		 NO     

Participant Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Participant Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Participant Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Participant Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Email Addr 
Base Entity  Participant 
Attribute Name  Email Addr 
Logical Rolename   
ColumnName  EMAIL_ADDR 
RoleName   
Domain  Email Addr 
Logical Only  NO 
Definition  
Email Address:
 
Note 
 

Email Addr Logical Attribute Properties 
Logical Attribute Name  Email Addr 
Datatype  VARCHAR(75) 
Nullable  NO 

Email Addr Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Email Addr Security Types 
Name  Current Value 

Email Addr Bound Attachments 
Name  Current Value 

Email Addr Data Movement Rules 
Name  Type  Rule Text/Value 

Email Addr Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Participant
Email Addr 		 NO     
ENGA (Oracle)
PARTICIPANT
EMAIL_ADDR 		 NO     

Email Addr Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Email Addr Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Email Addr Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Email Addr Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Last Name 
Base Entity  Participant 
Attribute Name  Last Name 
Logical Rolename   
ColumnName  LAST_NM 
RoleName   
Domain  Name 
Logical Only  NO 
Definition  
Name: A long description name usually accompanied by an abbreviated code.
 
Note 
 

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

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
Participant
Last Name 		 NO     
ENGA (Oracle)
PARTICIPANT
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 Name 
Base Entity  Participant 
Attribute Name  First Name 
Logical Rolename   
ColumnName  FIRST_NM 
RoleName   
Domain  Name 
Logical Only  NO 
Definition  
Name: A long description name usually accompanied by an abbreviated code.
 
Note 
 

First Name Logical Attribute Properties 
Logical Attribute Name  First Name 
Datatype  VARCHAR(120) 
Nullable  NO 

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
Participant
First Name 		 NO     
ENGA (Oracle)
PARTICIPANT
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 

Middle Initial 
Base Entity  Participant 
Attribute Name  Middle Initial 
Logical Rolename   
ColumnName  MID_INIT 
RoleName   
Domain  Name 
Logical Only  NO 
Definition  
Name: A long description name usually accompanied by an abbreviated code.
 
Note 
 

Middle Initial Logical Attribute Properties 
Logical Attribute Name  Middle Initial 
Datatype  VARCHAR(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
Participant
Middle Initial 		 NO     
ENGA (Oracle)
PARTICIPANT
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 

Open Researcher and Contributor ID Identifier 
Base Entity  Participant 
Attribute Name  Open Researcher and Contributor ID Identifier 
Logical Rolename   
ColumnName  ORCID_ID 
RoleName   
Domain  Open Researcher and Contributor ID Identifier 
Logical Only  NO 
Definition 
 
Note 
 

Open Researcher and Contributor ID Identifier Logical Attribute Properties 
Logical Attribute Name  Open Researcher and Contributor ID Identifier 
Datatype  VARCHAR(19) 
Nullable  YES 

Open Researcher and Contributor ID Identifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Open Researcher and Contributor ID Identifier Security Types 
Name  Current Value 

Open Researcher and Contributor ID Identifier Bound Attachments 
Name  Current Value 

Open Researcher and Contributor ID Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Open Researcher and Contributor ID Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Participant
Open Researcher and Contributor ID Identifier 		 NO     
ENGA (Oracle)
PARTICIPANT
ORCID_ID 		 NO     

Open Researcher and Contributor ID Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Open Researcher and Contributor ID Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Open Researcher and Contributor ID Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Open Researcher and Contributor ID Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Alernate Email Address 
Base Entity  Participant 
Attribute Name  Alernate Email Address 
Logical Rolename   
ColumnName  EMAIL_ADDR_ALT 
RoleName   
Domain  Email Addr 
Logical Only  NO 
Definition  
Email Address:
 
Note 
 

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

Alernate Email Address Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Alernate Email Address Security Types 
Name  Current Value 

Alernate Email Address Bound Attachments 
Name  Current Value 

Alernate Email Address Data Movement Rules 
Name  Type  Rule Text/Value 

Alernate Email Address Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Participant
Alernate Email Address 		 NO     
ENGA (Oracle)
PARTICIPANT
EMAIL_ADDR_ALT 		 NO     

Alernate Email Address Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Alernate Email Address Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Alernate Email Address Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Alernate Email Address Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Confirmed Indicator 
Base Entity  Participant 
Attribute Name  Confirmed Indicator 
Logical Rolename   
ColumnName  CONFIRM_IND 
RoleName   
Domain  Indicator 
Logical Only  NO 
Definition 
 
Note 
 

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

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

Confirmed 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 

Confirmed Indicator Security Types 
Name  Current Value 

Confirmed Indicator Bound Attachments 
Name  Current Value 

Confirmed Indicator Data Movement Rules 
Name  Type  Rule Text/Value 

Confirmed Indicator Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Participant
Confirmed Indicator 		 NO     
ENGA (Oracle)
PARTICIPANT
CONFIRM_IND 		 NO     

Confirmed Indicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Confirmed Indicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Confirmed Indicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Confirmed Indicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Person Identifier 
Base Entity  Participant 
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
Participant
Person Identifier 		 NO     
ENGA (Oracle)
PARTICIPANT
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