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 |