ATTACH_ID 
Base Object  EXPT_RSRC_ATTACH 
Attribute Name  Attachment Identifier 
ColumnName  ATTACH_ID 
Logical Rolename   
RoleName   
Domain  Identifier 
Physical Only  NO 
Definition 
 
Note 
 

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

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

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

ATTACH_ID Security Types 
Name  Current Value 

ATTACH_ID Bound Attachments 
Name  Current Value 

ATTACH_ID Data Movement Rules 
Name  Type  Rule Text/Value 

ATTACH_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource Attachment
Attachment Identifier 		 NO     
EXPRESS (Oracle)
EXPT_RSRC_ATTACH
ATTACH_ID 		 NO     

ATTACH_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ATTACH_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ATTACH_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ATTACH_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

FILE_NM 
Base Object  EXPT_RSRC_ATTACH 
Attribute Name  File Name 
ColumnName  FILE_NM 
Logical Rolename   
RoleName   
Domain  File Name 
Physical Only  NO 
Definition  
File Name: An external file system file name.  Often the external file name of data imported into the Rdb, such as EPICS .db files.
 
Note 
 

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

FILE_NM Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  255 
Percent Null  0 

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

FILE_NM Security Types 
Name  Current Value 

FILE_NM Bound Attachments 
Name  Current Value 

FILE_NM Data Movement Rules 
Name  Type  Rule Text/Value 

FILE_NM Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource Attachment
File Name 		 NO     
EXPRESS (Oracle)
EXPT_RSRC_ATTACH
FILE_NM 		 NO     

FILE_NM Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

FILE_NM Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

FILE_NM Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

FILE_NM Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

MIME_TYPE 
Base Object  EXPT_RSRC_ATTACH 
Attribute Name  MIME Type 
ColumnName  MIME_TYPE 
Logical Rolename   
RoleName   
Domain  MIME Type 
Physical Only  NO 
Definition  
MIME Type: Multipurpose Internet Mail Extensions (MIME) is an Internet standard that extends the format of e-mail to support:



    * text in character sets other than US-ASCII;

    * non-text attachments;

    * message bodies with multiple parts; and

    * header information in non-ASCII character sets.



MIME's use, however, has grown beyond describing the content of e-mail to describing content type in general.
 
Note 
 

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

MIME_TYPE Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  255 
Percent Null  0 

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

MIME_TYPE Security Types 
Name  Current Value 

MIME_TYPE Bound Attachments 
Name  Current Value 

MIME_TYPE Data Movement Rules 
Name  Type  Rule Text/Value 

MIME_TYPE Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource Attachment
MIME Type 		 NO     
EXPRESS (Oracle)
EXPT_RSRC_ATTACH
MIME_TYPE 		 NO     

MIME_TYPE Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIME_TYPE Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIME_TYPE Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MIME_TYPE Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

FILE_CONTENT 
Base Object  EXPT_RSRC_ATTACH 
Attribute Name  File Contents 
ColumnName  FILE_CONTENT 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

FILE_CONTENT Column Properties 
Datatype  BLOB 
Nullable  NO 
Not Null Constraint   

FILE_CONTENT Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  2048 
Percent Null  0 

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

FILE_CONTENT Security Types 
Name  Current Value 

FILE_CONTENT Bound Attachments 
Name  Current Value 

FILE_CONTENT Data Movement Rules 
Name  Type  Rule Text/Value 

FILE_CONTENT Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource Attachment
File Contents 		 NO     
EXPRESS (Oracle)
EXPT_RSRC_ATTACH
FILE_CONTENT 		 NO     

FILE_CONTENT Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

FILE_CONTENT Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

FILE_CONTENT Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

FILE_CONTENT Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

FILE_LAST_UPDATE 
Base Object  EXPT_RSRC_ATTACH 
Attribute Name  File Last Update 
ColumnName  FILE_LAST_UPDATE 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

FILE_LAST_UPDATE Column Properties 
Datatype  DATE 
Nullable  YES 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

FILE_LAST_UPDATE Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  7 
Percent Null  0 

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

FILE_LAST_UPDATE Security Types 
Name  Current Value 

FILE_LAST_UPDATE Bound Attachments 
Name  Current Value 

FILE_LAST_UPDATE Data Movement Rules 
Name  Type  Rule Text/Value 

FILE_LAST_UPDATE Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource Attachment
File Last Update 		 NO     
EXPRESS (Oracle)
EXPT_RSRC_ATTACH
FILE_LAST_UPDATE 		 NO     

FILE_LAST_UPDATE Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

FILE_LAST_UPDATE Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

FILE_LAST_UPDATE Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

FILE_LAST_UPDATE Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

ATTACH_TYPE_ID 
Base Object  EXPT_RSRC_ATTACH 
Attribute Name  Attachment Type Identifier 
ColumnName  ATTACH_TYPE_ID 
Logical Rolename   
RoleName   
Domain  Identifier 
Physical Only  NO 
Definition 
 
Note 
 

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

ATTACH_TYPE_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  10 
Percent Null  0 

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

ATTACH_TYPE_ID Security Types 
Name  Current Value 

ATTACH_TYPE_ID Bound Attachments 
Name  Current Value 

ATTACH_TYPE_ID Data Movement Rules 
Name  Type  Rule Text/Value 

ATTACH_TYPE_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource Attachment
Attachment Type Identifier 		 NO     
EXPRESS (Oracle)
EXPT_RSRC_ATTACH
ATTACH_TYPE_ID 		 NO     

ATTACH_TYPE_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ATTACH_TYPE_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ATTACH_TYPE_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ATTACH_TYPE_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

VIEW_CD 
Base Object  EXPT_RSRC_ATTACH 
Attribute Name  View Code 
ColumnName  VIEW_CD 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

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

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

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

VIEW_CD Security Types 
Name  Current Value 

VIEW_CD Bound Attachments 
Name  Current Value 

VIEW_CD Data Movement Rules 
Name  Type  Rule Text/Value 

VIEW_CD Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource Attachment
View Code 		 NO     
EXPRESS (Oracle)
EXPT_RSRC_ATTACH
VIEW_CD 		 NO     

VIEW_CD Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

VIEW_CD Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

VIEW_CD Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

VIEW_CD Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

DESCR 
Base Object  EXPT_RSRC_ATTACH 
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  0 

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 Attachment
Description 		 NO     
EXPRESS (Oracle)
EXPT_RSRC_ATTACH
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