Sample Identifier 
Base Entity  Sample Log 
Attribute Name  Sample Identifier 
Logical Rolename   
ColumnName  SMPL_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

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

Sample Identifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Sample Identifier Security Types 
Name  Current Value 

Sample Identifier Bound Attachments 
Name  Current Value 

Sample Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

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

Sample Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Activity Identifier 
Base Entity  Sample Log 
Attribute Name  Activity Identifier 
Logical Rolename   
ColumnName  ACT_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
Activity Identifier: Abbreviated identifer of the activity that can be taken against a proposal.
 
Note 
 

Activity Identifier Logical Attribute Properties 
Logical Attribute Name  Activity Identifier 
Datatype  VARCHAR(10) 
Nullable  NO 

Activity Identifier Domain Restrictions 

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

Activity Identifier Bound Attachments 
Name  Current Value 

Activity Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Activity Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Log
Activity Identifier 
NO     
SMPL (Oracle)
SMPL_LOG
ACT_ID 
NO     

Activity Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Activity Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Activity Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Activity Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Current Date 
Base Entity  Sample Log 
Attribute Name  Current Date 
Logical Rolename   
ColumnName  CUR_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition 
Date: Date and time to seconds.
 
Note 
 

Current Date Logical Attribute Properties 
Logical Attribute Name  Current Date 
Datatype  DATE 
Nullable  NO 

Current Date Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  sysdate 
Bound Default   

Current Date Security Types 
Name  Current Value 

Current Date Bound Attachments 
Name  Current Value 

Current Date Data Movement Rules 
Name  Type  Rule Text/Value 

Current Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Log
Current Date 
NO     
SMPL (Oracle)
SMPL_LOG
CUR_DTE 
NO     

Current Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Current Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Current Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Current Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Comment 
Base Entity  Sample Log 
Attribute Name  Comment 
Logical Rolename   
ColumnName  CMNT 
RoleName   
Domain  Comment 
Logical Only  NO 
Definition 
Comment:  General comments.
 
Note 
 

Comment Logical Attribute Properties 
Logical Attribute Name  Comment 
Datatype  VARCHAR(2000) 
Nullable  YES 

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

Comment Security Types 
Name  Current Value 

Comment Bound Attachments 
Name  Current Value 

Comment Data Movement Rules 
Name  Type  Rule Text/Value 

Comment Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Log
Comment 
NO     
SMPL (Oracle)
SMPL_LOG
CMNT 
NO     

Comment Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Comment Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Comment Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Comment Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description