Shift Identifier 
Base Entity  Shift Summary File Attachment 
Attribute Name  Shift Identifier 
Logical Rolename   
ColumnName  SHIFT_ID 
RoleName   
Domain   
Logical Only  NO 
Definition  
Shift Identifier: The name given to a defined shift.
 
Note 
 

Shift Identifier Logical Attribute Properties 
Logical Attribute Name  Shift Identifier 
Datatype  VARCHAR(5) 
Nullable  NO 

Shift Identifier Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Shift Identifier Security Types 
Name  Current Value 

Shift Identifier Bound Attachments 
Name  Current Value 

Shift Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Shift Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Shift Summary File Attachment
Shift Identifier 		 NO     
OPER (Oracle)
SHIFT_SUMM_FILE_ATTACH
SHIFT_ID 		 NO     

Shift Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Shift Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Shift Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Shift Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Calendar Date 
Base Entity  Shift Summary File Attachment 
Attribute Name  Calendar Date 
Logical Rolename   
ColumnName  CAL_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition  
Date: Date and time to seconds.
 
Note 
 

Calendar Date Logical Attribute Properties 
Logical Attribute Name  Calendar Date 
Datatype  DATE 
Nullable  NO 

Calendar Date Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  sysdate 
Bound Default   

Calendar Date Security Types 
Name  Current Value 

Calendar Date Bound Attachments 
Name  Current Value 

Calendar Date Data Movement Rules 
Name  Type  Rule Text/Value 

Calendar Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Shift Summary File Attachment
Calendar Date 		 NO     
OPER (Oracle)
SHIFT_SUMM_FILE_ATTACH
CAL_DTE 		 NO     

Calendar Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Calendar Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Calendar Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Calendar Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Attachment Sequence Identifer 
Base Entity  Shift Summary File Attachment 
Attribute Name  Attachment Sequence Identifer 
Logical Rolename   
ColumnName  ATTACH_SEQ_ID 
RoleName   
Domain  Sequence 
Logical Only  NO 
Definition  
Sequence:  A numerical primary key value derived from a Sequence.
 
Note 
 

Attachment Sequence Identifer Logical Attribute Properties 
Logical Attribute Name  Attachment Sequence Identifer 
Datatype  INTEGER 
Nullable  NO 

Attachment Sequence Identifer Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Attachment Sequence Identifer Security Types 
Name  Current Value 

Attachment Sequence Identifer Bound Attachments 
Name  Current Value 

Attachment Sequence Identifer Data Movement Rules 
Name  Type  Rule Text/Value 

Attachment Sequence Identifer Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Shift Summary File Attachment
Attachment Sequence Identifer 		 NO     
OPER (Oracle)
SHIFT_SUMM_FILE_ATTACH
ATTACH_SEQ_ID 		 NO     

Attachment Sequence Identifer Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Attachment Sequence Identifer Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Attachment Sequence Identifer Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Attachment Sequence Identifer Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Shift Start Indicator 
Base Entity  Shift Summary File Attachment 
Attribute Name  Shift Start Indicator 
Logical Rolename   
ColumnName  SHIFT_START_IND 
RoleName   
Domain  Indicator 
Logical Only  NO 
Definition 
 
Note 
 

Shift Start Indicator Logical Attribute Properties 
Logical Attribute Name  Shift Start Indicator 
Datatype  CHAR(1) 
Nullable  NO 

Shift Start Indicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

Shift Start Indicator 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 

Shift Start Indicator Security Types 
Name  Current Value 

Shift Start Indicator Bound Attachments 
Name  Current Value 

Shift Start Indicator Data Movement Rules 
Name  Type  Rule Text/Value 

Shift Start Indicator Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Shift Summary File Attachment
Shift Start Indicator 		 NO     
OPER (Oracle)
SHIFT_SUMM_FILE_ATTACH
SHIFT_START_IND 		 NO     

Shift Start Indicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Shift Start Indicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Shift Start Indicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Shift Start Indicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

File Name 
Base Entity  Shift Summary File Attachment 
Attribute Name  File Name 
Logical Rolename   
ColumnName  FILE_NAME 
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  YES 

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
Shift Summary File Attachment
File Name 		 NO     
OPER (Oracle)
SHIFT_SUMM_FILE_ATTACH
FILE_NAME 		 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  Shift Summary File 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  YES 

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
Shift Summary File Attachment
MIME Type 		 NO     
OPER (Oracle)
SHIFT_SUMM_FILE_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 Attachment 
Base Entity  Shift Summary File Attachment 
Attribute Name  File Attachment 
Logical Rolename   
ColumnName  FILE_ATTACH 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

File Attachment Logical Attribute Properties 
Logical Attribute Name  File Attachment 
Datatype  VARBINARY/BLOB(50) 
Nullable  YES 

File Attachment Domain Restrictions 

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

File Attachment Bound Attachments 
Name  Current Value 

File Attachment Data Movement Rules 
Name  Type  Rule Text/Value 

File Attachment Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Shift Summary File Attachment
File Attachment 		 NO     
OPER (Oracle)
SHIFT_SUMM_FILE_ATTACH
FILE_ATTACH 		 NO     

File Attachment Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

File Attachment Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

File Attachment Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

File Attachment Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Attachment Type Code 
Base Entity  Shift Summary File Attachment 
Attribute Name  Attachment Type Code 
Logical Rolename   
ColumnName  ATTACH_TYPE_CODE 
RoleName   
Domain   
Logical Only  NO 
Definition  
Attachment Type Code: The insert logbook attachment code. (A - Attachment, I - Image).
 
Note 
 

Attachment Type Code Logical Attribute Properties 
Logical Attribute Name  Attachment Type Code 
Datatype  CHAR(1) 
Nullable  NO 

Attachment Type Code Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Attachment Type Code Security Types 
Name  Current Value 

Attachment Type Code Bound Attachments 
Name  Current Value 

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

Attachment Type Code Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Shift Summary File Attachment
Attachment Type Code 		 NO     
OPER (Oracle)
SHIFT_SUMM_FILE_ATTACH
ATTACH_TYPE_CODE 		 NO     

Attachment Type Code Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Attachment Type Code Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Attachment Type Code Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Attachment Type Code Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description