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

SEQ_ID Column Properties 
Datatype  NUMBER(38, 0) 
Nullable  NO 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

SEQ_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  20 
Percent Null  0 

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

SEQ_ID Security Types 
Name  Current Value 

SEQ_ID Bound Attachments 
Name  Current Value 

SEQ_ID Data Movement Rules 
Name  Type  Rule Text/Value 

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

SEQ_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SEQ_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SEQ_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SEQ_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

DOWNTIME_EVT_ID 
Base Object  DOWNTIME_TIMER 
Attribute Name  Downtime Event Identifier 
ColumnName  DOWNTIME_EVT_ID 
Logical Rolename   
RoleName   
Domain  Identifier 
Physical Only  NO 
Definition 
 
Note 
 

DOWNTIME_EVT_ID Column Properties 
Datatype  VARCHAR2(20) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

DOWNTIME_EVT_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  20 
Percent Null  0 

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

DOWNTIME_EVT_ID Security Types 
Name  Current Value 

DOWNTIME_EVT_ID Bound Attachments 
Name  Current Value 

DOWNTIME_EVT_ID Data Movement Rules 
Name  Type  Rule Text/Value 

DOWNTIME_EVT_ID 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_EVT_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

DOWNTIME_EVT_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

DOWNTIME_EVT_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

DOWNTIME_EVT_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

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

TIMER_START_DTE Column Properties 
Datatype  DATE 
Nullable  NO 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

TIMER_START_DTE Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  7 
Percent Null  0 

TIMER_START_DTE Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  sysdate 
Bound Default   

TIMER_START_DTE Security Types 
Name  Current Value 

TIMER_START_DTE Bound Attachments 
Name  Current Value 

TIMER_START_DTE Data Movement Rules 
Name  Type  Rule Text/Value 

TIMER_START_DTE 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_DTE Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

TIMER_START_DTE Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

TIMER_START_DTE Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

TIMER_START_DTE Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

DESCR 
Base Object  DOWNTIME_TIMER 
Attribute Name  Description 
ColumnName  DESCR 
Logical Rolename   
RoleName   
Domain  Description 
Physical Only  NO 
Definition  
Description: Often used in validation tables accompanying an abbreviated identifer.
 
Note 
 

DESCR Column Properties 
Datatype  VARCHAR2(255) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

DESCR Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  255 
Percent Null  0 

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

DESCR Security Types 
Name  Current Value 

DESCR Bound Attachments 
Name  Current Value 

DESCR Data Movement Rules 
Name  Type  Rule Text/Value 

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

DESCR Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

DESCR Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

DESCR Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

DESCR Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

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

TIMER_END_DTE Column Properties 
Datatype  DATE 
Nullable  YES 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

TIMER_END_DTE Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  7 
Percent Null  0 

TIMER_END_DTE Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  sysdate 
Bound Default   

TIMER_END_DTE Security Types 
Name  Current Value 

TIMER_END_DTE Bound Attachments 
Name  Current Value 

TIMER_END_DTE Data Movement Rules 
Name  Type  Rule Text/Value 

TIMER_END_DTE 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_DTE Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

TIMER_END_DTE Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

TIMER_END_DTE Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

TIMER_END_DTE Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

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

SHIFT_SUMM_IND Column Properties 
Datatype  CHAR(1) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

SHIFT_SUMM_IND Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  1 
Percent Null  0 

SHIFT_SUMM_IND Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

SHIFT_SUMM_IND 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_SUMM_IND Security Types 
Name  Current Value 

SHIFT_SUMM_IND Bound Attachments 
Name  Current Value 

SHIFT_SUMM_IND Data Movement Rules 
Name  Type  Rule Text/Value 

SHIFT_SUMM_IND 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_SUMM_IND Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SHIFT_SUMM_IND Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SHIFT_SUMM_IND Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SHIFT_SUMM_IND Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

ATTACH_FILE_NM 
Base Object  DOWNTIME_TIMER 
Attribute Name  Attachment File Name 
ColumnName  ATTACH_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 
 

ATTACH_FILE_NM Column Properties 
Datatype  VARCHAR2(255) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

ATTACH_FILE_NM Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  255 
Percent Null  0 

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

ATTACH_FILE_NM Security Types 
Name  Current Value 

ATTACH_FILE_NM Bound Attachments 
Name  Current Value 

ATTACH_FILE_NM Data Movement Rules 
Name  Type  Rule Text/Value 

ATTACH_FILE_NM 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     

ATTACH_FILE_NM Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ATTACH_FILE_NM Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ATTACH_FILE_NM Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ATTACH_FILE_NM Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

ATTACH_MIME_TYPE 
Base Object  DOWNTIME_TIMER 
Attribute Name  Attachment MIME Type 
ColumnName  ATTACH_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 
 

ATTACH_MIME_TYPE Column Properties 
Datatype  VARCHAR2(255) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

ATTACH_MIME_TYPE Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  255 
Percent Null  0 

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

ATTACH_MIME_TYPE Security Types 
Name  Current Value 

ATTACH_MIME_TYPE Bound Attachments 
Name  Current Value 

ATTACH_MIME_TYPE Data Movement Rules 
Name  Type  Rule Text/Value 

ATTACH_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     

ATTACH_MIME_TYPE Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ATTACH_MIME_TYPE Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ATTACH_MIME_TYPE Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ATTACH_MIME_TYPE Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

FILE_ATTACH 
Base Object  DOWNTIME_TIMER 
Attribute Name  File Attachment 
ColumnName  FILE_ATTACH 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

FILE_ATTACH Column Properties 
Datatype  BLOB 
Nullable  YES 
Not Null Constraint   

FILE_ATTACH Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  2048 
Percent Null  0 

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

FILE_ATTACH Security Types 
Name  Current Value 

FILE_ATTACH Bound Attachments 
Name  Current Value 

FILE_ATTACH Data Movement Rules 
Name  Type  Rule Text/Value 

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

FILE_ATTACH Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

FILE_ATTACH Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

FILE_ATTACH Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

FILE_ATTACH Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

IMG_FILE_NM 
Base Object  DOWNTIME_TIMER 
Attribute Name  Image File Name 
ColumnName  IMG_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 
 

IMG_FILE_NM Column Properties 
Datatype  VARCHAR2(255) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

IMG_FILE_NM Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  255 
Percent Null  0 

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

IMG_FILE_NM Security Types 
Name  Current Value 

IMG_FILE_NM Bound Attachments 
Name  Current Value 

IMG_FILE_NM Data Movement Rules 
Name  Type  Rule Text/Value 

IMG_FILE_NM 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     

IMG_FILE_NM Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

IMG_FILE_NM Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

IMG_FILE_NM Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

IMG_FILE_NM Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

IMG_MIME_TYPE 
Base Object  DOWNTIME_TIMER 
Attribute Name  Image MIME Type 
ColumnName  IMG_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 
 

IMG_MIME_TYPE Column Properties 
Datatype  VARCHAR2(255) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

IMG_MIME_TYPE Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  255 
Percent Null  0 

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

IMG_MIME_TYPE Security Types 
Name  Current Value 

IMG_MIME_TYPE Bound Attachments 
Name  Current Value 

IMG_MIME_TYPE Data Movement Rules 
Name  Type  Rule Text/Value 

IMG_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     

IMG_MIME_TYPE Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

IMG_MIME_TYPE Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

IMG_MIME_TYPE Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

IMG_MIME_TYPE Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

IMG_FILE_ATTACH 
Base Object  DOWNTIME_TIMER 
Attribute Name  Image File Attachment 
ColumnName  IMG_FILE_ATTACH 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

IMG_FILE_ATTACH Column Properties 
Datatype  BLOB 
Nullable  YES 
Not Null Constraint   

IMG_FILE_ATTACH Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  2048 
Percent Null  0 

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

IMG_FILE_ATTACH Security Types 
Name  Current Value 

IMG_FILE_ATTACH Bound Attachments 
Name  Current Value 

IMG_FILE_ATTACH Data Movement Rules 
Name  Type  Rule Text/Value 

IMG_FILE_ATTACH 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     

IMG_FILE_ATTACH Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

IMG_FILE_ATTACH Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

IMG_FILE_ATTACH Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

IMG_FILE_ATTACH Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description