Storage Identifier 
Base Entity  Sample Storage 
Attribute Name  Storage Identifier 
Logical Rolename   
ColumnName  STOR_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

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

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

Storage Identifier Security Types 
Name  Current Value 

Storage Identifier Bound Attachments 
Name  Current Value 

Storage Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Storage Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Storage
Storage Identifier 
NO     
SMPL (Oracle)
SMPL_STOR
STOR_ID 
NO     

Storage Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Storage Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Storage Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Storage Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Facility Identifier 
Base Entity  Sample Storage 
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 Storage
Facility Identifier 
NO     
SMPL (Oracle)
SMPL_STOR
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 Storage 
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 Storage
Bldg Id 
NO     
SMPL (Oracle)
SMPL_STOR
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 Storage 
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 Storage
Room Number 
NO     
SMPL (Oracle)
SMPL_STOR
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