Sample Shipment Identifier 
Base Entity  Sample Shipment Attachment 
Attribute Name  Sample Shipment Identifier 
Logical Rolename   
ColumnName  SMPL_SHIP_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

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

Sample Shipment Identifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Sample Shipment Identifier Security Types 
Name  Current Value 

Sample Shipment Identifier Bound Attachments 
Name  Current Value 

Sample Shipment Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Sample Shipment Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Shipment Attachment
Sample Shipment Identifier 		 NO     
SMPL (Oracle)
SMPL_SHIP_ATTACH
SMPL_SHIP_ID 		 NO     

Sample Shipment Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Shipment Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Shipment Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Shipment Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Attachment Identifier 
Base Entity  Sample Shipment 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
Sample Shipment Attachment
Attachment Identifier 		 NO     
SMPL (Oracle)
SMPL_SHIP_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  Sample Shipment 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
Sample Shipment Attachment
File Name 		 NO     
SMPL (Oracle)
SMPL_SHIP_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  Sample Shipment 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
Sample Shipment Attachment
MIME Type 		 NO     
SMPL (Oracle)
SMPL_SHIP_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  Sample Shipment 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
Sample Shipment Attachment
File Contents 		 NO     
SMPL (Oracle)
SMPL_SHIP_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 

Attachment Type Identifier 
Base Entity  Sample Shipment Attachment 
Attribute Name  Attachment Type Identifier 
Logical Rolename   
ColumnName  ATTACH_TYPE_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note  
Allow a concatenated list of id's for instances where a file (such as a zip) contains or meets more than one type.
 

Attachment Type Identifier Logical Attribute Properties 
Logical Attribute Name  Attachment Type Identifier 
Datatype  VARCHAR(255) 
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
Sample Shipment Attachment
Attachment Type Identifier 		 NO     
SMPL (Oracle)
SMPL_SHIP_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