Device Identifier |
Base Entity | Design Device Manufacturer Model Assignment |
Attribute Name | Device Identifier |
Logical Rolename | |
ColumnName | DVC_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Device Id: The unique identifier for the device. It is represented in the form of a bar code. The identifier consists of the concatenation of the following fields: System ID, Subsystem ID, Device Qualifier, Device Type and Device Instance. |
Note |
Device Identifier Logical Attribute Properties |
Logical Attribute Name | Device Identifier |
Datatype | VARCHAR(30) |
Nullable | NO |
Device Identifier Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Device Identifier Security Types |
Name | Current Value |
Device Identifier Bound Attachments |
Name | Current Value |
Device Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Device Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Design Device Manufacturer Model Assignment Device Identifier |
NO | ||
EPICS (Oracle) DSGN_DVC_MNFCTR_MDL_ASGN DVC_ID |
NO |
Device Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Device Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Device Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Device Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Mnfctr Id |
Base Entity | Design Device Manufacturer Model Assignment |
Attribute Name | Mnfctr Id |
Logical Rolename | |
ColumnName | MNFCTR_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Manufacturer Identifier: The unique identifier for a manufacturer. |
Note |
Mnfctr Id Logical Attribute Properties |
Logical Attribute Name | Mnfctr Id |
Datatype | NUMERIC(4, 0) |
Nullable | NO |
Mnfctr Id Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Mnfctr Id Security Types |
Name | Current Value |
Mnfctr Id Bound Attachments |
Name | Current Value |
Mnfctr Id Data Movement Rules |
Name | Type | Rule Text/Value |
Mnfctr Id Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Design Device Manufacturer Model Assignment Mnfctr Id |
NO | ||
EPICS (Oracle) DSGN_DVC_MNFCTR_MDL_ASGN MNFCTR_ID |
NO |
Mnfctr Id Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Mnfctr Id Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Mnfctr Id Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Mnfctr Id Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Mdl Nbr |
Base Entity | Design Device Manufacturer Model Assignment |
Attribute Name | Mdl Nbr |
Logical Rolename | |
ColumnName | MDL_NBR |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Manufacturer Model Number: The manufacturer supplied model number for the equipment. |
Note |
Mdl Nbr Logical Attribute Properties |
Logical Attribute Name | Mdl Nbr |
Datatype | VARCHAR(75) |
Nullable | NO |
Mdl Nbr Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Mdl Nbr Security Types |
Name | Current Value |
Mdl Nbr Bound Attachments |
Name | Current Value |
Mdl Nbr Data Movement Rules |
Name | Type | Rule Text/Value |
Mdl Nbr Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Design Device Manufacturer Model Assignment Mdl Nbr |
NO | ||
EPICS (Oracle) DSGN_DVC_MNFCTR_MDL_ASGN MDL_NBR |
NO |
Mdl Nbr Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Mdl Nbr Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Mdl Nbr Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Mdl Nbr Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Bldg Id |
Base Entity | Design Device Manufacturer Model Assignment |
Attribute Name | Bldg Id |
Logical Rolename | |
ColumnName | BLDG_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Building Code: The unique identifier for a building. |
Note |
Bldg Id Logical Attribute Properties |
Logical Attribute Name | Bldg Id |
Datatype | VARCHAR(10) |
Nullable | YES |
Bldg Id Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Bldg Id Security Types |
Name | Current Value |
Bldg Id Bound Attachments |
Name | Current Value |
Bldg Id Data Movement Rules |
Name | Type | Rule Text/Value |
Bldg Id Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Design Device Manufacturer Model Assignment Bldg Id |
NO | ||
EPICS (Oracle) DSGN_DVC_MNFCTR_MDL_ASGN BLDG_ID |
NO |
Bldg Id Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Bldg Id Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Bldg Id Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Bldg Id Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Area Id |
Base Entity | Design Device Manufacturer Model Assignment |
Attribute Name | Area Id |
Logical Rolename | |
ColumnName | AREA_ID |
RoleName | |
Domain | Default Text |
Logical Only | NO |
Definition | Area Identifier: The unique identifier for a location within a building. |
Note |
Area Id Logical Attribute Properties |
Logical Attribute Name | Area Id |
Datatype | VARCHAR(50) |
Nullable | YES |
Area Id Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Area Id Security Types |
Name | Current Value |
Area Id Bound Attachments |
Name | Current Value |
Area Id Data Movement Rules |
Name | Type | Rule Text/Value |
Area Id Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Design Device Manufacturer Model Assignment Area Id |
NO | ||
EPICS (Oracle) DSGN_DVC_MNFCTR_MDL_ASGN AREA_ID |
NO |
Area Id Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Area Id Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Area Id Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Area Id Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |