SHIFT_ID 
Base Object  SHIFT_SUMM_FILE_ATTACH 
Attribute Name  Shift Identifier 
ColumnName  SHIFT_ID 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition  
Shift Identifier: The name given to a defined shift.
 
Note 
 

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

SHIFT_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  5 
Percent Null  0 

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

SHIFT_ID Security Types 
Name  Current Value 

SHIFT_ID Bound Attachments 
Name  Current Value 

SHIFT_ID Data Movement Rules 
Name  Type  Rule Text/Value 

SHIFT_ID 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_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SHIFT_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SHIFT_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SHIFT_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

CAL_DTE 
Base Object  SHIFT_SUMM_FILE_ATTACH 
Attribute Name  Calendar Date 
ColumnName  CAL_DTE 
Logical Rolename   
RoleName   
Domain  Date 
Physical Only  NO 
Definition  
Date: Date and time to seconds.
 
Note 
 

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

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

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

CAL_DTE Security Types 
Name  Current Value 

CAL_DTE Bound Attachments 
Name  Current Value 

CAL_DTE Data Movement Rules 
Name  Type  Rule Text/Value 

CAL_DTE 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     

CAL_DTE Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

CAL_DTE Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

CAL_DTE Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

CAL_DTE Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

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

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

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

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

ATTACH_SEQ_ID Security Types 
Name  Current Value 

ATTACH_SEQ_ID Bound Attachments 
Name  Current Value 

ATTACH_SEQ_ID Data Movement Rules 
Name  Type  Rule Text/Value 

ATTACH_SEQ_ID 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     

ATTACH_SEQ_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ATTACH_SEQ_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ATTACH_SEQ_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ATTACH_SEQ_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

SHIFT_START_IND 
Base Object  SHIFT_SUMM_FILE_ATTACH 
Attribute Name  Shift Start Indicator 
ColumnName  SHIFT_START_IND 
Logical Rolename   
RoleName   
Domain  Indicator 
Physical Only  NO 
Definition 
 
Note 
 

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

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

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

SHIFT_START_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_START_IND Security Types 
Name  Current Value 

SHIFT_START_IND Bound Attachments 
Name  Current Value 

SHIFT_START_IND Data Movement Rules 
Name  Type  Rule Text/Value 

SHIFT_START_IND 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_IND Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SHIFT_START_IND Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SHIFT_START_IND Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SHIFT_START_IND Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

FILE_NAME 
Base Object  SHIFT_SUMM_FILE_ATTACH 
Attribute Name  File Name 
ColumnName  FILE_NAME 
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_NAME Column Properties 
Datatype  VARCHAR2(255) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

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

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 Object  SHIFT_SUMM_FILE_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  YES 
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
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_ATTACH 
Base Object  SHIFT_SUMM_FILE_ATTACH 
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
Shift Summary File Attachment
File Attachment 		 NO     
OPER (Oracle)
SHIFT_SUMM_FILE_ATTACH
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 

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

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

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

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

ATTACH_TYPE_CODE Security Types 
Name  Current Value 

ATTACH_TYPE_CODE Bound Attachments 
Name  Current Value 

ATTACH_TYPE_CODE Data Movement Rules 
Name  Type  Rule Text/Value 

ATTACH_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     

ATTACH_TYPE_CODE Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ATTACH_TYPE_CODE Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ATTACH_TYPE_CODE Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ATTACH_TYPE_CODE Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description