PRPSL_TYPE_ID 
Base Object  PRPSL_TYPE_PRPSL_REV_ASSC 
Attribute Name  Proposal Type Identifer 
ColumnName  PRPSL_TYPE_ID 
Logical Rolename  Proposal Type Identifer 
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

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

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

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

PRPSL_TYPE_ID Security Types 
Name  Current Value 

PRPSL_TYPE_ID Bound Attachments 
Name  Current Value 

PRPSL_TYPE_ID Data Movement Rules 
Name  Type  Rule Text/Value 

PRPSL_TYPE_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal Type Proposal Review Association
Proposal Type Identifer 
NO     
IPTSv5 (Oracle)
PRPSL_TYPE_PRPSL_REV_ASSC
PRPSL_TYPE_ID 
NO     
PRPSL (Oracle)
PRPSL_TYPE_PRPSL_REV_ASSC
PRPSL_TYPE_ID 
NO     

PRPSL_TYPE_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

PRPSL_TYPE_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

PRPSL_TYPE_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

PRPSL_TYPE_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


REVIEW_ID 
Base Object  PRPSL_TYPE_PRPSL_REV_ASSC 
Attribute Name  Review Identifier 
ColumnName  REVIEW_ID 
Logical Rolename  Review Identifier 
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

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

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

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

REVIEW_ID Security Types 
Name  Current Value 

REVIEW_ID Bound Attachments 
Name  Current Value 

REVIEW_ID Data Movement Rules 
Name  Type  Rule Text/Value 

REVIEW_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal Type Proposal Review Association
Review Identifier 
NO     
IPTSv5 (Oracle)
PRPSL_TYPE_PRPSL_REV_ASSC
REVIEW_ID 
NO     
PRPSL (Oracle)
PRPSL_TYPE_PRPSL_REV_ASSC
REVIEW_ID 
NO     

REVIEW_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

REVIEW_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

REVIEW_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

REVIEW_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description