Device Identifer |
Base Entity | Device Outage Affected Devices |
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 Device Outage Affected Devices 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 |
Outage Dte |
Base Entity | Device Outage Affected Devices |
Attribute Name | Outage Dte |
Logical Rolename | |
ColumnName | OUTAGE_DTE |
RoleName | |
Domain | Date |
Logical Only | NO |
Definition | Date: Date and time to seconds. |
Note |
Outage Dte Logical Attribute Properties |
Logical Attribute Name | Outage Dte |
Datatype | DATE |
Nullable | NO |
Outage Dte Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
Outage Dte Security Types |
Name | Current Value |
Outage Dte Bound Attachments |
Name | Current Value |
Outage Dte Data Movement Rules |
Name | Type | Rule Text/Value |
Outage Dte Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Device Outage Affected Devices Outage Dte |
NO |
Outage Dte Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Outage Dte Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Outage Dte Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Outage Dte Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Affect Dvc Id |
Base Entity | Device Outage Affected Devices |
Attribute Name | Device Identifer |
Logical Rolename | Affect Dvc Id |
ColumnName | AFFECT_DVC_ID |
RoleName | AFFECT_DVC_ID |
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 |
Affect Dvc Id Logical Attribute Properties |
Logical Attribute Name | Device Identifer |
Datatype | VARCHAR(50) |
Nullable | NO |
Affect Dvc Id Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Affect Dvc Id Security Types |
Name | Current Value |
Affect Dvc Id Bound Attachments |
Name | Current Value |
Affect Dvc Id Data Movement Rules |
Name | Type | Rule Text/Value |
Affect Dvc Id Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Device Outage Affected Devices Device Identifer |
NO |
Affect Dvc Id Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Affect Dvc Id Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Affect Dvc Id Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Affect Dvc Id Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |