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

RSCH_AREA_ID Column Properties 
Datatype  VARCHAR2(20) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

RSCH_AREA_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  20 
Percent Null 

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

RSCH_AREA_ID Security Types 
Name  Current Value 

RSCH_AREA_ID Bound Attachments 
Name  Current Value 

RSCH_AREA_ID Data Movement Rules 
Name  Type  Rule Text/Value 

RSCH_AREA_ID 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     

RSCH_AREA_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

RSCH_AREA_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

RSCH_AREA_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

RSCH_AREA_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


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

PERSON_ID Column Properties 
Datatype  VARCHAR2(10) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

PERSON_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  10 
Percent Null 

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

PERSON_ID Security Types 
Name  Current Value 

PERSON_ID Bound Attachments 
Name  Current Value 

PERSON_ID Data Movement Rules 
Name  Type  Rule Text/Value 

PERSON_ID 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_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

PERSON_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

PERSON_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

PERSON_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description