ATTACH_ID 
Base Object  SMPL_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
Sample Attachment
Attachment Identifier 		 NO     
SMPL (Oracle)
SMPL_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  SMPL_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
Sample Attachment
File Name 		 NO     
SMPL (Oracle)
SMPL_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  SMPL_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
Sample Attachment
MIME Type 		 NO     
SMPL (Oracle)
SMPL_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  SMPL_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
Sample Attachment
File Contents 		 NO     
SMPL (Oracle)
SMPL_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 

ATTACH_TYPE_ID 
Base Object  SMPL_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(25) 
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  25 
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
Sample Attachment
Attachment Type Identifier 		 NO     
SMPL (Oracle)
SMPL_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