FACIL_ID 
Base Object  EXPT_FACIL 
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  0 

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 Facility
Facility Identifier 		 NO     
EXPRESS (Oracle)
EXPT_FACIL
FACIL_ID 		 NO     
IPTSv5 (Oracle)
EXPT_FACIL
FACIL_ID 		 NO     
PRPSL (Oracle)
EXPT_FACIL
FACIL_ID 		 NO     
PUBL (Oracle)
EXPT_FACIL
FACIL_ID 		 NO     
XF_ADMIN (Oracle)
EXPT_FACIL
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 

FACIL_NM 
Base Object  EXPT_FACIL 
Attribute Name  Facility Name 
ColumnName  FACIL_NM 
Logical Rolename   
RoleName   
Domain  Name 
Physical Only  NO 
Definition  
Name: A long description name usually accompanied by an abbreviated code.
 
Note 
 

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

FACIL_NM Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  120 
Percent Null  0 

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

FACIL_NM Security Types 
Name  Current Value 

FACIL_NM Bound Attachments 
Name  Current Value 

FACIL_NM Data Movement Rules 
Name  Type  Rule Text/Value 

FACIL_NM Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Facility
Facility Name 		 NO     
EXPRESS (Oracle)
EXPT_FACIL
FACIL_NM 		 NO     
IPTSv5 (Oracle)
EXPT_FACIL
FACIL_NM 		 NO     
PRPSL (Oracle)
EXPT_FACIL
FACIL_NM 		 NO     
PUBL (Oracle)
EXPT_FACIL
FACIL_NM 		 NO     
XF_ADMIN (Oracle)
EXPT_FACIL
FACIL_NM 		 NO     

FACIL_NM Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

FACIL_NM Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

FACIL_NM Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

FACIL_NM Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

EMAIL_ADDR 
Base Object  EXPT_FACIL 
Attribute Name  Email Addr 
ColumnName  EMAIL_ADDR 
Logical Rolename   
RoleName   
Domain  Email Addr 
Physical Only  NO 
Definition  
Email Address:
 
Note 
 

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

EMAIL_ADDR Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  64 
Percent Null  0 

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

EMAIL_ADDR Security Types 
Name  Current Value 

EMAIL_ADDR Bound Attachments 
Name  Current Value 

EMAIL_ADDR Data Movement Rules 
Name  Type  Rule Text/Value 

EMAIL_ADDR Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Facility
Email Addr 		 NO     
EXPRESS (Oracle)
EXPT_FACIL
EMAIL_ADDR 		 NO     
IPTSv5 (Oracle)
EXPT_FACIL
EMAIL_ADDR 		 NO     
PRPSL (Oracle)
EXPT_FACIL
EMAIL_ADDR 		 NO     
PUBL (Oracle)
EXPT_FACIL
EMAIL_ADDR 		 NO     
XF_ADMIN (Oracle)
EXPT_FACIL
EMAIL_ADDR 		 NO     

EMAIL_ADDR Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

EMAIL_ADDR Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

EMAIL_ADDR Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

EMAIL_ADDR Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

EMS_FACIL_ID 
Base Object  EXPT_FACIL 
Attribute Name  Experiment Management System Facility Identifier 
ColumnName  EMS_FACIL_ID 
Logical Rolename   
RoleName   
Domain  Identifier 
Physical Only  NO 
Definition 
 
Note 
 

EMS_FACIL_ID Column Properties 
Datatype  NUMBER(38, 0) 
Nullable  NO 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

EMS_FACIL_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  20 
Percent Null  0 

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

EMS_FACIL_ID Security Types 
Name  Current Value 

EMS_FACIL_ID Bound Attachments 
Name  Current Value 

EMS_FACIL_ID Data Movement Rules 
Name  Type  Rule Text/Value 

EMS_FACIL_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Facility
Experiment Management System Facility Identifier 		 NO     
EXPRESS (Oracle)
EXPT_FACIL
EMS_FACIL_ID 		 NO     
IPTSv5 (Oracle)
EXPT_FACIL
EMS_FACIL_ID 		 NO     
PRPSL (Oracle)
EXPT_FACIL
EMS_FACIL_ID 		 NO     
PUBL (Oracle)
EXPT_FACIL
EMS_FACIL_ID 		 NO     
XF_ADMIN (Oracle)
EXPT_FACIL
EMS_FACIL_ID 		 NO     

EMS_FACIL_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

EMS_FACIL_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

EMS_FACIL_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

EMS_FACIL_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

DISP_IND 
Base Object  EXPT_FACIL 
Attribute Name  Display Indicator 
ColumnName  DISP_IND 
Logical Rolename   
RoleName   
Domain  Indicator 
Physical Only  NO 
Definition 
 
Note 
 

DISP_IND Column Properties 
Datatype  CHAR(1) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

DISP_IND Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  1 
Percent Null  0 

DISP_IND Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

DISP_IND Reference Value (Bound to Domain) 
Name  Standard Indicator 
Description  These are the standard values for the Indicator domain. 
Type  By List 
Value  Value Description 
Y  Yes 
N  No 

DISP_IND Security Types 
Name  Current Value 

DISP_IND Bound Attachments 
Name  Current Value 

DISP_IND Data Movement Rules 
Name  Type  Rule Text/Value 

DISP_IND Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Facility
Display Indicator 		 NO     
EXPRESS (Oracle)
EXPT_FACIL
DISP_IND 		 NO     
IPTSv5 (Oracle)
EXPT_FACIL
DISP_IND 		 NO     
PRPSL (Oracle)
EXPT_FACIL
DISP_IND 		 NO     
PUBL (Oracle)
EXPT_FACIL
DISP_IND 		 NO     
XF_ADMIN (Oracle)
EXPT_FACIL
DISP_IND 		 NO     

DISP_IND Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

DISP_IND Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

DISP_IND Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

DISP_IND Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description