Publication Identifer 
Base Entity  Publication Research Area Association 
Attribute Name  Publication Identifer 
Logical Rolename   
ColumnName  PUBL_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

Publication Identifer Logical Attribute Properties 
Logical Attribute Name  Publication Identifer 
Datatype  NUMERIC(38, 0) 
Nullable  NO 

Publication Identifer Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Publication Identifer Security Types 
Name  Current Value 

Publication Identifer Bound Attachments 
Name  Current Value 

Publication Identifer Data Movement Rules 
Name  Type  Rule Text/Value 

Publication Identifer Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Publication Research Area Association
Publication Identifer 
NO     
PUBL (Oracle)
PUBL_RSCH_AREA_ASSC
PUBL_ID 
NO     

Publication Identifer Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Publication Identifer Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Publication Identifer Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Publication Identifer Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Proposal Identifier 
Base Entity  Publication Research Area Association 
Attribute Name  Proposal Identifier 
Logical Rolename   
ColumnName  PRPSL_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
Proposal Identifier: Unique identifer assigned to the proposal.
 
Note 
 

Proposal Identifier Logical Attribute Properties 
Logical Attribute Name  Proposal Identifier 
Datatype  NUMERIC(10, 0) 
Nullable  NO 

Proposal Identifier Domain Restrictions 

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

Proposal Identifier Bound Attachments 
Name  Current Value 

Proposal Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Proposal Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Publication Research Area Association
Proposal Identifier 
NO     
PUBL (Oracle)
PUBL_RSCH_AREA_ASSC
PRPSL_ID 
NO     

Proposal Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Proposal Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Proposal Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Proposal Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Research Area Identifier 
Base Entity  Publication 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
Publication Research Area Association
Research Area Identifier 
NO     
PUBL (Oracle)
PUBL_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