FACIL_ID 
Base Object  EXPT_RSRC_LOC 
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  NO 
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
Experiment Resource Location
Facility Identifier 
NO     
EXPRESS (Oracle)
EXPT_RSRC_LOC
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 


LOC_ID 
Base Object  EXPT_RSRC_LOC 
Attribute Name  Location Identifier 
ColumnName  LOC_ID 
Logical Rolename   
RoleName   
Domain  Identifier 
Physical Only  NO 
Definition 
 
Note 
 

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

LOC_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  50 
Percent Null 

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

LOC_ID Security Types 
Name  Current Value 

LOC_ID Bound Attachments 
Name  Current Value 

LOC_ID Data Movement Rules 
Name  Type  Rule Text/Value 

LOC_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource Location
Location Identifier 
NO     
EXPRESS (Oracle)
EXPT_RSRC_LOC
LOC_ID 
NO     

LOC_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

LOC_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

LOC_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

LOC_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


DESCR 
Base Object  EXPT_RSRC_LOC 
Attribute Name  Description 
ColumnName  DESCR 
Logical Rolename   
RoleName   
Domain  Description 
Physical Only  NO 
Definition 
Description: Often used in validation tables accompanying an abbreviated identifer.
 
Note 
 

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

DESCR Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  255 
Percent Null 

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

DESCR Security Types 
Name  Current Value 

DESCR Bound Attachments 
Name  Current Value 

DESCR Data Movement Rules 
Name  Type  Rule Text/Value 

DESCR Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource Location
Description 
NO     
EXPRESS (Oracle)
EXPT_RSRC_LOC
DESCR 
NO     

DESCR Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

DESCR Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

DESCR Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

DESCR Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description