STOR_ID 
Base Object  SMPL_STOR 
Attribute Name  Storage Identifier 
ColumnName  STOR_ID 
Logical Rolename   
RoleName   
Domain  Identifier 
Physical Only  NO 
Definition 
 
Note 
 

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

STOR_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  75 
Percent Null 

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

STOR_ID Security Types 
Name  Current Value 

STOR_ID Bound Attachments 
Name  Current Value 

STOR_ID Data Movement Rules 
Name  Type  Rule Text/Value 

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

STOR_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

STOR_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

STOR_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

STOR_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


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

FACIL_ID Column Properties 
Datatype  VARCHAR2(10) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

FACIL_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  10 
Percent Null 

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

FACIL_ID Security Types 
Name  Current Value 

FACIL_ID Bound Attachments 
Name  Current Value 

FACIL_ID Data Movement Rules 
Name  Type  Rule Text/Value 

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

FACIL_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

FACIL_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

FACIL_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

FACIL_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


BLDG_ID 
Base Object  SMPL_STOR 
Attribute Name  Bldg Id 
ColumnName  BLDG_ID 
Logical Rolename   
RoleName   
Domain  Building 
Physical Only  NO 
Definition 
Building:  The building number.
 
Note 
 

BLDG_ID Column Properties 
Datatype  VARCHAR2(10) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

BLDG_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  10 
Percent Null 

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_NBR 
Base Object  SMPL_STOR 
Attribute Name  Room Number 
ColumnName  ROOM_NBR 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

ROOM_NBR Column Properties 
Datatype  VARCHAR2(25) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

ROOM_NBR Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  25 
Percent Null 

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

ROOM_NBR Security Types 
Name  Current Value 

ROOM_NBR Bound Attachments 
Name  Current Value 

ROOM_NBR Data Movement Rules 
Name  Type  Rule Text/Value 

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

ROOM_NBR Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ROOM_NBR Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ROOM_NBR Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ROOM_NBR Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description