INSTR_ID 
Base Entity  Instrument Program Development Review Association 
Attribute Name  INSTR_ID 
Logical Rolename   
ColumnName  INSTR_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

INSTR_ID Logical Attribute Properties 
Logical Attribute Name  INSTR_ID 
Datatype  VARCHAR(20) 
Nullable  NO 

INSTR_ID Domain Restrictions 

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

INSTR_ID Bound Attachments 
Name  Current Value 

INSTR_ID Data Movement Rules 
Name  Type  Rule Text/Value 

INSTR_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Instrument Program Development Review Association
INSTR_ID 
NO     
IPTSv5 (Oracle)
INSTR_PDRC_ASSC
INSTR_ID 
NO     
PRPSL (Oracle)
INSTR_PDRC_ASSC
INSTR_ID 
NO     

INSTR_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

INSTR_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

INSTR_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

INSTR_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Role Identifer 
Base Entity  Instrument Program Development Review Association 
Attribute Name  Role Identifer 
Logical Rolename   
ColumnName  ROLE_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Role Identifer Logical Attribute Properties 
Logical Attribute Name  Role Identifer 
Datatype  VARCHAR(20) 
Nullable  NO 

Role Identifer Domain Restrictions 

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

Role Identifer Bound Attachments 
Name  Current Value 

Role Identifer Data Movement Rules 
Name  Type  Rule Text/Value 

Role Identifer Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Instrument Program Development Review Association
Role Identifer 
NO     
IPTSv5 (Oracle)
INSTR_PDRC_ASSC
ROLE_ID 
NO     
PRPSL (Oracle)
INSTR_PDRC_ASSC
ROLE_ID 
NO     

Role Identifer Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Role Identifer Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Role Identifer Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Role Identifer Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Person Identifier 
Base Entity  Instrument Program Development Review 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
Instrument Program Development Review Association
Person Identifier 
NO     
IPTSv5 (Oracle)
INSTR_PDRC_ASSC
PERSON_ID 
NO     
PRPSL (Oracle)
INSTR_PDRC_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