Proposal Identifier 
Base Entity  Proposal Laboratory Special Request Association 
Attribute Name  Proposal Identifier 
Logical Rolename   
ColumnName  PRPSL_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
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
Proposal Laboratory Special Request Association
Proposal Identifier 
NO     
IPTSv5 (Oracle)
PRPSL_LAB_SPEC_ASSC
PRPSL_ID 
NO     
PRPSL (Oracle)
PRPSL_LAB_SPEC_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 


Submission Number 
Base Entity  Proposal Laboratory Special Request Association 
Attribute Name  Submission Number 
Logical Rolename   
ColumnName  SUBMISS_NBR 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

Submission Number Logical Attribute Properties 
Logical Attribute Name  Submission Number 
Datatype  NUMERIC(38, 0) 
Nullable  NO 

Submission Number Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Submission Number Security Types 
Name  Current Value 

Submission Number Bound Attachments 
Name  Current Value 

Submission Number Data Movement Rules 
Name  Type  Rule Text/Value 

Submission Number Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal Laboratory Special Request Association
Submission Number 
NO     
IPTSv5 (Oracle)
PRPSL_LAB_SPEC_ASSC
SUBMISS_NBR 
NO     
PRPSL (Oracle)
PRPSL_LAB_SPEC_ASSC
SUBMISS_NBR 
NO     

Submission Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Submission Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Submission Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Submission Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Special Request Identifier 
Base Entity  Proposal Laboratory Special Request Association 
Attribute Name  Special Request Identifier 
Logical Rolename   
ColumnName  SPEC_REQ_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

Special Request Identifier Logical Attribute Properties 
Logical Attribute Name  Special Request Identifier 
Datatype  NUMERIC(38, 0) 
Nullable  NO 

Special Request Identifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Special Request Identifier Security Types 
Name  Current Value 

Special Request Identifier Bound Attachments 
Name  Current Value 

Special Request Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Special Request Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal Laboratory Special Request Association
Special Request Identifier 
NO     
IPTSv5 (Oracle)
PRPSL_LAB_SPEC_ASSC
SPEC_REQ_ID 
NO     
PRPSL (Oracle)
PRPSL_LAB_SPEC_ASSC
SPEC_REQ_ID 
NO     

Special Request Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Special Request Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Special Request Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Special Request Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description