Person Identifier 
Base Entity  Group Leader Research Capability Association 
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  NO 

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
Group Leader Research Capability Association
Person Identifier 
NO     
CNMS_PRPSL (Oracle)
GRP_LEAD_RSCH_CAPBLTY_ASSC
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 


Research Capability Identifier 
Base Entity  Group Leader Research Capability Association 
Attribute Name  Research Capability Identifier 
Logical Rolename   
ColumnName  RSCH_CAP_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

Research Capability Identifier Logical Attribute Properties 
Logical Attribute Name  Research Capability Identifier 
Datatype  VARCHAR(50) 
Nullable  NO 

Research Capability Identifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Research Capability Identifier Security Types 
Name  Current Value 

Research Capability Identifier Bound Attachments 
Name  Current Value 

Research Capability Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Research Capability Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Group Leader Research Capability Association
Research Capability Identifier 
NO     
CNMS_PRPSL (Oracle)
GRP_LEAD_RSCH_CAPBLTY_ASSC
RSCH_CAP_ID 
NO     

Research Capability Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Research Capability Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Research Capability Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Research Capability Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description