Sequence Identifer 
Base Entity  Downtime Timer 
Attribute Name  Sequence Identifer 
Logical Rolename   
ColumnName  SEQ_ID 
RoleName   
Domain  Sequence 
Logical Only  NO 
Definition  
Sequence:  A numerical primary key value derived from a Sequence.
 
Note 
 

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

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

Sequence Identifer Security Types 
Name  Current Value 

Sequence Identifer Bound Attachments 
Name  Current Value 

Sequence Identifer Data Movement Rules 
Name  Type  Rule Text/Value 

Sequence Identifer Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Downtime Timer
Sequence Identifer 		 NO     
OPER (Oracle)
DOWNTIME_TIMER
SEQ_ID 		 NO     

Sequence Identifer Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sequence Identifer Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sequence Identifer Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Sequence Identifer Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Downtime Event Identifier 
Base Entity  Downtime Timer 
Attribute Name  Downtime Event Identifier 
Logical Rolename   
ColumnName  DOWNTIME_EVT_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

Downtime Event Identifier Logical Attribute Properties 
Logical Attribute Name  Downtime Event Identifier 
Datatype  VARCHAR(20) 
Nullable  NO 

Downtime Event Identifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Downtime Event Identifier Security Types 
Name  Current Value 

Downtime Event Identifier Bound Attachments 
Name  Current Value 

Downtime Event Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Downtime Event Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Downtime Timer
Downtime Event Identifier 		 NO     
OPER (Oracle)
DOWNTIME_TIMER
DOWNTIME_EVT_ID 		 NO     

Downtime Event Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Downtime Event Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Downtime Event Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Downtime Event Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Timer Start Date 
Base Entity  Downtime Timer 
Attribute Name  Timer Start Date 
Logical Rolename   
ColumnName  TIMER_START_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition  
Date: Date and time to seconds.
 
Note 
 

Timer Start Date Logical Attribute Properties 
Logical Attribute Name  Timer Start Date 
Datatype  DATE 
Nullable  NO 

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

Timer Start Date Security Types 
Name  Current Value 

Timer Start Date Bound Attachments 
Name  Current Value 

Timer Start Date Data Movement Rules 
Name  Type  Rule Text/Value 

Timer Start Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Downtime Timer
Timer Start Date 		 NO     
OPER (Oracle)
DOWNTIME_TIMER
TIMER_START_DTE 		 NO     

Timer Start Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Timer Start Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Timer Start Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Timer Start Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Description 
Base Entity  Downtime Timer 
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  NO 

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
Downtime Timer
Description 		 NO     
OPER (Oracle)
DOWNTIME_TIMER
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 

Timer End Date 
Base Entity  Downtime Timer 
Attribute Name  Timer End Date 
Logical Rolename   
ColumnName  TIMER_END_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition  
Date: Date and time to seconds.
 
Note 
 

Timer End Date Logical Attribute Properties 
Logical Attribute Name  Timer End Date 
Datatype  DATE 
Nullable  YES 

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

Timer End Date Security Types 
Name  Current Value 

Timer End Date Bound Attachments 
Name  Current Value 

Timer End Date Data Movement Rules 
Name  Type  Rule Text/Value 

Timer End Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Downtime Timer
Timer End Date 		 NO     
OPER (Oracle)
DOWNTIME_TIMER
TIMER_END_DTE 		 NO     

Timer End Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Timer End Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Timer End Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Timer End Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Shift Summary Indicator 
Base Entity  Downtime Timer 
Attribute Name  Shift Summary Indicator 
Logical Rolename   
ColumnName  SHIFT_SUMM_IND 
RoleName   
Domain  Indicator 
Logical Only  NO 
Definition  
Shift Summary Indicator: Indicates that this downtime event should be added to the shift summary.
 
Note 
 

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

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

Shift Summary 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 Summary Indicator Security Types 
Name  Current Value 

Shift Summary Indicator Bound Attachments 
Name  Current Value 

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

Shift Summary Indicator Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Downtime Timer
Shift Summary Indicator 		 NO     
OPER (Oracle)
DOWNTIME_TIMER
SHIFT_SUMM_IND 		 NO     

Shift Summary Indicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Shift Summary Indicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Shift Summary Indicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Shift Summary Indicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Attachment File Name 
Base Entity  Downtime Timer 
Attribute Name  Attachment File Name 
Logical Rolename   
ColumnName  ATTACH_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 
 

Attachment File Name Logical Attribute Properties 
Logical Attribute Name  Attachment File Name 
Datatype  VARCHAR(255) 
Nullable  YES 

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

Attachment File Name Security Types 
Name  Current Value 

Attachment File Name Bound Attachments 
Name  Current Value 

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

Attachment File Name Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Downtime Timer
Attachment File Name 		 NO     
OPER (Oracle)
DOWNTIME_TIMER
ATTACH_FILE_NM 		 NO     

Attachment File Name Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Attachment File Name Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Attachment File Name Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Attachment File Name Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Attachment MIME Type 
Base Entity  Downtime Timer 
Attribute Name  Attachment MIME Type 
Logical Rolename   
ColumnName  ATTACH_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 
 

Attachment MIME Type Logical Attribute Properties 
Logical Attribute Name  Attachment MIME Type 
Datatype  VARCHAR(255) 
Nullable  YES 

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

Attachment MIME Type Security Types 
Name  Current Value 

Attachment MIME Type Bound Attachments 
Name  Current Value 

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

Attachment MIME Type Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Downtime Timer
Attachment MIME Type 		 NO     
OPER (Oracle)
DOWNTIME_TIMER
ATTACH_MIME_TYPE 		 NO     

Attachment MIME Type Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Attachment MIME Type Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Attachment MIME Type Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Attachment MIME Type Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

File Attachment 
Base Entity  Downtime Timer 
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
Downtime Timer
File Attachment 		 NO     
OPER (Oracle)
DOWNTIME_TIMER
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 

Image File Name 
Base Entity  Downtime Timer 
Attribute Name  Image File Name 
Logical Rolename   
ColumnName  IMG_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 
 

Image File Name Logical Attribute Properties 
Logical Attribute Name  Image File Name 
Datatype  VARCHAR(255) 
Nullable  YES 

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

Image File Name Security Types 
Name  Current Value 

Image File Name Bound Attachments 
Name  Current Value 

Image File Name Data Movement Rules 
Name  Type  Rule Text/Value 

Image File Name Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Downtime Timer
Image File Name 		 NO     
OPER (Oracle)
DOWNTIME_TIMER
IMG_FILE_NM 		 NO     

Image File Name Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Image File Name Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Image File Name Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Image File Name Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Image MIME Type 
Base Entity  Downtime Timer 
Attribute Name  Image MIME Type 
Logical Rolename   
ColumnName  IMG_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 
 

Image MIME Type Logical Attribute Properties 
Logical Attribute Name  Image MIME Type 
Datatype  VARCHAR(255) 
Nullable  YES 

Image MIME Type Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Image MIME Type Security Types 
Name  Current Value 

Image MIME Type Bound Attachments 
Name  Current Value 

Image MIME Type Data Movement Rules 
Name  Type  Rule Text/Value 

Image MIME Type Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Downtime Timer
Image MIME Type 		 NO     
OPER (Oracle)
DOWNTIME_TIMER
IMG_MIME_TYPE 		 NO     

Image MIME Type Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Image MIME Type Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Image MIME Type Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Image MIME Type Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Image File Attachment 
Base Entity  Downtime Timer 
Attribute Name  Image File Attachment 
Logical Rolename   
ColumnName  IMG_FILE_ATTACH 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

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

Image File Attachment Domain Restrictions 

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

Image File Attachment Bound Attachments 
Name  Current Value 

Image File Attachment Data Movement Rules 
Name  Type  Rule Text/Value 

Image File Attachment Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Downtime Timer
Image File Attachment 		 NO     
OPER (Oracle)
DOWNTIME_TIMER
IMG_FILE_ATTACH 		 NO     

Image File Attachment Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Image File Attachment Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Image File Attachment Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Image File Attachment Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description