Handling Identifier 
Base Entity  Sample Handling 
Attribute Name  Handling Identifier 
Logical Rolename   
ColumnName  HAND_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

Handling Identifier Logical Attribute Properties 
Logical Attribute Name  Handling Identifier 
Datatype  VARCHAR(75) 
Nullable  NO 

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

Handling Identifier Security Types 
Name  Current Value 

Handling Identifier Bound Attachments 
Name  Current Value 

Handling Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Handling Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Handling
Handling Identifier 
NO     
SMPL (Oracle)
SMPL_HAND
HAND_ID 
NO     

Handling Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Handling Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Handling Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Handling Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Facility Identifier 
Base Entity  Sample Handling 
Attribute Name  Facility Identifier 
Logical Rolename   
ColumnName  FACIL_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
Facility Identifer: A unique abbreviated identifier for the facilty in which the proposed experiment is to take place.
 
Note 
 

Facility Identifier Logical Attribute Properties 
Logical Attribute Name  Facility Identifier 
Datatype  VARCHAR(10) 
Nullable  YES 

Facility Identifier Domain Restrictions 

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

Facility Identifier Bound Attachments 
Name  Current Value 

Facility Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Facility Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Handling
Facility Identifier 
NO     
SMPL (Oracle)
SMPL_HAND
FACIL_ID 
NO     

Facility Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Facility Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Facility Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Facility Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Bldg Id 
Base Entity  Sample Handling 
Attribute Name  Bldg Id 
Logical Rolename   
ColumnName  BLDG_ID 
RoleName   
Domain  Building 
Logical Only  NO 
Definition 
Building:  The building number.
 
Note 
 

Bldg Id Logical Attribute Properties 
Logical Attribute Name  Bldg Id 
Datatype  VARCHAR(10) 
Nullable  YES 

Bldg Id Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Bldg Id Security Types 
Name  Current Value 

Bldg Id Bound Attachments 
Name  Current Value 

Bldg Id Data Movement Rules 
Name  Type  Rule Text/Value 

Bldg Id Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Handling
Bldg Id 
NO     
SMPL (Oracle)
SMPL_HAND
BLDG_ID 
NO     

Bldg Id Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Bldg Id Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Bldg Id Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Bldg Id Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Room Number 
Base Entity  Sample Handling 
Attribute Name  Room Number 
Logical Rolename   
ColumnName  ROOM_NBR 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Room Number Logical Attribute Properties 
Logical Attribute Name  Room Number 
Datatype  VARCHAR(25) 
Nullable  YES 

Room Number Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Room Number Security Types 
Name  Current Value 

Room Number Bound Attachments 
Name  Current Value 

Room Number Data Movement Rules 
Name  Type  Rule Text/Value 

Room Number Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Handling
Room Number 
NO     
SMPL (Oracle)
SMPL_HAND
ROOM_NBR 
NO     

Room Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Room Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Room Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Room Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description