Attachment Identifier 
Base Entity  Experiment Resource Attachment 
Attribute Name  Attachment Identifier 
Logical Rolename   
ColumnName  ATTACH_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

Attachment Identifier Logical Attribute Properties 
Logical Attribute Name  Attachment Identifier 
Datatype  NUMERIC(38, 0) 
Nullable  NO 

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

Attachment Identifier Security Types 
Name  Current Value 

Attachment Identifier Bound Attachments 
Name  Current Value 

Attachment Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Attachment Identifier 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     

Attachment Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Attachment Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Attachment Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Attachment Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

File Name 
Base Entity  Experiment Resource Attachment 
Attribute Name  File Name 
Logical Rolename   
ColumnName  FILE_NM 
RoleName   
Domain  File Name 
Logical 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 Name Logical Attribute Properties 
Logical Attribute Name  File Name 
Datatype  VARCHAR(255) 
Nullable  NO 

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

File Name Security Types 
Name  Current Value 

File Name Bound Attachments 
Name  Current Value 

File Name Data Movement Rules 
Name  Type  Rule Text/Value 

File Name 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 Name Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

File Name Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

File Name Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

File Name Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

MIME Type 
Base Entity  Experiment Resource Attachment 
Attribute Name  MIME Type 
Logical Rolename   
ColumnName  MIME_TYPE 
RoleName   
Domain  MIME Type 
Logical 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 Logical Attribute Properties 
Logical Attribute Name  MIME Type 
Datatype  VARCHAR(255) 
Nullable  NO 

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 Contents 
Base Entity  Experiment Resource Attachment 
Attribute Name  File Contents 
Logical Rolename   
ColumnName  FILE_CONTENT 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

File Contents Logical Attribute Properties 
Logical Attribute Name  File Contents 
Datatype  VARBINARY/BLOB(50) 
Nullable  NO 

File Contents Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
File Contents Security Types 
Name  Current Value 

File Contents Bound Attachments 
Name  Current Value 

File Contents Data Movement Rules 
Name  Type  Rule Text/Value 

File Contents 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 Contents Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

File Contents Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

File Contents Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

File Contents Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

File Last Update 
Base Entity  Experiment Resource Attachment 
Attribute Name  File Last Update 
Logical Rolename   
ColumnName  FILE_LAST_UPDATE 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

File Last Update Logical Attribute Properties 
Logical Attribute Name  File Last Update 
Datatype  DATE 
Nullable  YES 

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 

Attachment Type Identifier 
Base Entity  Experiment Resource Attachment 
Attribute Name  Attachment Type Identifier 
Logical Rolename   
ColumnName  ATTACH_TYPE_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

Attachment Type Identifier Logical Attribute Properties 
Logical Attribute Name  Attachment Type Identifier 
Datatype  VARCHAR(10) 
Nullable  YES 

Attachment Type Identifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Attachment Type Identifier Security Types 
Name  Current Value 

Attachment Type Identifier Bound Attachments 
Name  Current Value 

Attachment Type Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Attachment Type Identifier 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     

Attachment Type Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Attachment Type Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Attachment Type Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Attachment Type Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

View Code 
Base Entity  Experiment Resource Attachment 
Attribute Name  View Code 
Logical Rolename   
ColumnName  VIEW_CD 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

View Code Logical Attribute Properties 
Logical Attribute Name  View Code 
Datatype  CHAR(1) 
Nullable  YES 

View Code Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   
View Code Security Types 
Name  Current Value 

View Code Bound Attachments 
Name  Current Value 

View Code Data Movement Rules 
Name  Type  Rule Text/Value 

View Code 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 Code Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

View Code Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

View Code Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

View Code Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Description 
Base Entity  Experiment Resource Attachment 
Attribute Name  Description 
Logical Rolename   
ColumnName  DESCR 
RoleName   
Domain  Description 
Logical Only  NO 
Definition  
Description: Often used in validation tables accompanying an abbreviated identifer.
 
Note 
 

Description Logical Attribute Properties 
Logical Attribute Name  Description 
Datatype  VARCHAR(255) 
Nullable  YES 

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

Description Security Types 
Name  Current Value 

Description Bound Attachments 
Name  Current Value 

Description Data Movement Rules 
Name  Type  Rule Text/Value 

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

Description Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Description Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Description Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Description Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description