Device Identifer 
Base Entity  Diagnostics IOC Parameter Value 
Attribute Name  Device Identifer 
Logical Rolename   
ColumnName  DVC_ID 
RoleName   
Domain  Device Id 
Logical Only  NO 
Definition 
Device Identifier: The unique identifier for the device.  The identifier consists of the concatenation of the following fields:  System ID, Subsystem ID, Device Qualifier, Device Type and Device Instance.
 
Note 
 

Device Identifer Logical Attribute Properties 
Logical Attribute Name  Device Identifer 
Datatype  VARCHAR(50) 
Nullable  NO 

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

Device Identifer Security Types 
Name  Current Value 

Device Identifer Bound Attachments 
Name  Current Value 

Device Identifer Data Movement Rules 
Name  Type  Rule Text/Value 

Device Identifer Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Diagnostics IOC Parameter Value
Device Identifer 
NO     

Device Identifer Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Device Identifer Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Device Identifer Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Device Identifer Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


IOC Config Type Id 
Base Entity  Diagnostics IOC Parameter Value 
Attribute Name  IOC Config Type Id 
Logical Rolename   
ColumnName  IOC Config Type Id 
RoleName   
Domain   
Logical Only  NO 
Definition 
IOC Configuration Type Identifier: Allows a granular grouping of IOCs by its base configuration file.
 
Note 
 

IOC Config Type Id Logical Attribute Properties 
Logical Attribute Name  IOC Config Type Id 
Datatype  VARCHAR(25) 
Nullable  NO 

IOC Config Type Id Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
IOC Config Type Id Security Types 
Name  Current Value 

IOC Config Type Id Bound Attachments 
Name  Current Value 

IOC Config Type Id Data Movement Rules 
Name  Type  Rule Text/Value 

IOC Config Type Id Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Diagnostics IOC Parameter Value
IOC Config Type Id 
NO     

IOC Config Type Id Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

IOC Config Type Id Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

IOC Config Type Id Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

IOC Config Type Id Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Maj Ver Nbr 
Base Entity  Diagnostics IOC Parameter Value 
Attribute Name  Maj Ver Nbr 
Logical Rolename   
ColumnName  Maj Ver Nbr 
RoleName   
Domain   
Logical Only  NO 
Definition 
Major Version Number: The top level version number for change tracking of the Diagnostics IOC configuration parameters.
 
Note 
 

Maj Ver Nbr Logical Attribute Properties 
Logical Attribute Name  Maj Ver Nbr 
Datatype  NUMERIC(3, 0) 
Nullable  NO 

Maj Ver Nbr Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Maj Ver Nbr Security Types 
Name  Current Value 

Maj Ver Nbr Bound Attachments 
Name  Current Value 

Maj Ver Nbr Data Movement Rules 
Name  Type  Rule Text/Value 

Maj Ver Nbr Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Diagnostics IOC Parameter Value
Maj Ver Nbr 
NO     

Maj Ver Nbr Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Maj Ver Nbr Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Maj Ver Nbr Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Maj Ver Nbr Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Min Ver Nbr 
Base Entity  Diagnostics IOC Parameter Value 
Attribute Name  Min Ver Nbr 
Logical Rolename   
ColumnName  Min Ver Nbr 
RoleName   
Domain   
Logical Only  NO 
Definition 
Minor Version Number: The low level version number for change tracking of Diagnostics IOC configuration parameters.
 
Note 
 

Min Ver Nbr Logical Attribute Properties 
Logical Attribute Name  Min Ver Nbr 
Datatype  NUMERIC(4, 0) 
Nullable  NO 

Min Ver Nbr Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Min Ver Nbr Security Types 
Name  Current Value 

Min Ver Nbr Bound Attachments 
Name  Current Value 

Min Ver Nbr Data Movement Rules 
Name  Type  Rule Text/Value 

Min Ver Nbr Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Diagnostics IOC Parameter Value
Min Ver Nbr 
NO     

Min Ver Nbr Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Min Ver Nbr Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Min Ver Nbr Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Min Ver Nbr Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Grp Ord 
Base Entity  Diagnostics IOC Parameter Value 
Attribute Name  Grp Ord 
Logical Rolename   
ColumnName  Grp Ord 
RoleName   
Domain   
Logical Only  NO 
Definition 
Group Order: The order in which the group names appears in the configuration file.
 
Note 
 

Grp Ord Logical Attribute Properties 
Logical Attribute Name  Grp Ord 
Datatype  NUMERIC(3, 0) 
Nullable  NO 

Grp Ord Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Grp Ord Security Types 
Name  Current Value 

Grp Ord Bound Attachments 
Name  Current Value 

Grp Ord Data Movement Rules 
Name  Type  Rule Text/Value 

Grp Ord Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Diagnostics IOC Parameter Value
Grp Ord 
NO     

Grp Ord Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Grp Ord Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Grp Ord Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Grp Ord Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Prmtr Ord 
Base Entity  Diagnostics IOC Parameter Value 
Attribute Name  Prmtr Ord 
Logical Rolename   
ColumnName  Prmtr Ord 
RoleName   
Domain   
Logical Only  NO 
Definition 
Parameter Order: The order of the parameter with the parameter group.
 
Note 
 

Prmtr Ord Logical Attribute Properties 
Logical Attribute Name  Prmtr Ord 
Datatype  NUMERIC(4, 0) 
Nullable  NO 

Prmtr Ord Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Prmtr Ord Security Types 
Name  Current Value 

Prmtr Ord Bound Attachments 
Name  Current Value 

Prmtr Ord Data Movement Rules 
Name  Type  Rule Text/Value 

Prmtr Ord Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Diagnostics IOC Parameter Value
Prmtr Ord 
NO     

Prmtr Ord Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Prmtr Ord Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Prmtr Ord Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Prmtr Ord Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Prmtr Val 
Base Entity  Diagnostics IOC Parameter Value 
Attribute Name  Prmtr Val 
Logical Rolename   
ColumnName  Prmtr Val 
RoleName   
Domain   
Logical Only  NO 
Definition 
Parameter Value: The value for the given parametr for the given version for the given IOC.
 
Note 
 

Prmtr Val Logical Attribute Properties 
Logical Attribute Name  Prmtr Val 
Datatype  VARCHAR(255) 
Nullable  NO 

Prmtr Val Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Prmtr Val Security Types 
Name  Current Value 

Prmtr Val Bound Attachments 
Name  Current Value 

Prmtr Val Data Movement Rules 
Name  Type  Rule Text/Value 

Prmtr Val Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Diagnostics IOC Parameter Value
Prmtr Val 
NO     

Prmtr Val Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Prmtr Val Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Prmtr Val Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Prmtr Val Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Modify Date 
Base Entity  Diagnostics IOC Parameter Value 
Attribute Name  Modify Date 
Logical Rolename   
ColumnName  MOD_DATE 
RoleName   
Domain  Modify Date 
Logical Only  NO 
Definition 
Modify Date: The date the entity values were were created or modified.
 
Note 
 

Modify Date Logical Attribute Properties 
Logical Attribute Name  Modify Date 
Datatype  DATE 
Nullable  YES 

Modify Date Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Modify Date Security Types 
Name  Current Value 

Modify Date Bound Attachments 
Name  Current Value 

Modify Date Data Movement Rules 
Name  Type  Rule Text/Value 

Modify Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Diagnostics IOC Parameter Value
Modify Date 
NO     

Modify Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Modify Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Modify Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Modify Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Modified By Badge Number 
Base Entity  Diagnostics IOC Parameter Value 
Attribute Name  Modified By Badge Number 
Logical Rolename   
ColumnName  MOD_BY_BN 
RoleName   
Domain  Modied By Badge Number 
Logical Only  NO 
Definition 
Modified by Badge Number:  The ORNL badge number of the person who inserted or update a record in the table.
 
Note 
 

Modified By Badge Number Logical Attribute Properties 
Logical Attribute Name  Modified By Badge Number 
Datatype  VARCHAR(10) 
Nullable  NO 

Modified By Badge Number Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Modified By Badge Number Security Types 
Name  Current Value 

Modified By Badge Number Bound Attachments 
Name  Current Value 

Modified By Badge Number Data Movement Rules 
Name  Type  Rule Text/Value 

Modified By Badge Number Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Diagnostics IOC Parameter Value
Modified By Badge Number 
NO     

Modified By Badge Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Modified By Badge Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Modified By Badge Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Modified By Badge Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description