Research Area Identifier 
Base Entity  Person Research Area Association 
Attribute Name  Research Area Identifier 
Logical Rolename   
ColumnName  RSCH_AREA_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
Research Area Identiifer: Abbreviated identifer for the reasearch area.
 
Note 
 

Research Area Identifier Logical Attribute Properties 
Logical Attribute Name  Research Area Identifier 
Datatype  VARCHAR(20) 
Nullable  NO 

Research Area Identifier Domain Restrictions 

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

Research Area Identifier Bound Attachments 
Name  Current Value 

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

Research Area Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Person Research Area Association
Research Area Identifier 
NO     
IPTSv5 (Oracle)
PERS_RSCH_AREA_ASSC
RSCH_AREA_ID 
NO     
PRPSL (Oracle)
PERS_RSCH_AREA_ASSC
RSCH_AREA_ID 
NO     

Research Area Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Research Area Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Research Area Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Research Area Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Person Identifier 
Base Entity  Person Research Area 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
Person Research Area Association
Person Identifier 
NO     
IPTSv5 (Oracle)
PERS_RSCH_AREA_ASSC
PERSON_ID 
NO     
PRPSL (Oracle)
PERS_RSCH_AREA_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