SMPL_ID 
Base Object  SMPL_PRPSL_ASSC 
Attribute Name  Sample Identifier 
ColumnName  SMPL_ID 
Logical Rolename  Sample Identifier 
RoleName   
Domain  Identifier 
Physical Only  NO 
Definition 
 
Note 
 

SMPL_ID Column Properties 
Datatype  NUMBER(38, 0) 
Nullable  NO 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

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

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

SMPL_ID Security Types 
Name  Current Value 

SMPL_ID Bound Attachments 
Name  Current Value 

SMPL_ID Data Movement Rules 
Name  Type  Rule Text/Value 

SMPL_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Proposal Association
Sample Identifier 
NO     
SMPL (Oracle)
SMPL_PRPSL_ASSC
SMPL_ID 
NO     

SMPL_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SMPL_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SMPL_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SMPL_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


PRPSL_ID 
Base Object  SMPL_PRPSL_ASSC 
Attribute Name  Proposal Identifier 
ColumnName  PRPSL_ID 
Logical Rolename  Proposal Identifier 
RoleName   
Domain   
Physical Only  NO 
Definition 
Proposal Identifier: Unique identifer assigned to the proposal.
 
Note 
 

PRPSL_ID Column Properties 
Datatype  NUMBER(10, 0) 
Nullable  NO 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

PRPSL_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width 
Percent Null 

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

PRPSL_ID Security Types 
Name  Current Value 

PRPSL_ID Bound Attachments 
Name  Current Value 

PRPSL_ID Data Movement Rules 
Name  Type  Rule Text/Value 

PRPSL_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Proposal Association
Proposal Identifier 
NO     
SMPL (Oracle)
SMPL_PRPSL_ASSC
PRPSL_ID 
NO     

PRPSL_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

PRPSL_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

PRPSL_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

PRPSL_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


PRPSL_SMPL_ID 
Base Object  SMPL_PRPSL_ASSC 
Attribute Name  Proposal Sample Identifier 
ColumnName  PRPSL_SMPL_ID 
Logical Rolename   
RoleName   
Domain  Identifier 
Physical Only  NO 
Definition 
 
Note 
 

PRPSL_SMPL_ID Column Properties 
Datatype  NUMBER(38, 0) 
Nullable  YES 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

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

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

PRPSL_SMPL_ID Security Types 
Name  Current Value 

PRPSL_SMPL_ID Bound Attachments 
Name  Current Value 

PRPSL_SMPL_ID Data Movement Rules 
Name  Type  Rule Text/Value 

PRPSL_SMPL_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Proposal Association
Proposal Sample Identifier 
NO     
SMPL (Oracle)
SMPL_PRPSL_ASSC
PRPSL_SMPL_ID 
NO     

PRPSL_SMPL_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

PRPSL_SMPL_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

PRPSL_SMPL_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

PRPSL_SMPL_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description