DVC_ID |
Base Object | DSGN_DVC_MNFCTR_MDL_ASGN |
Attribute Name | DVC_ID |
ColumnName | DVC_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical 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 |
DVC_ID Column Properties |
Datatype | VARCHAR2(40) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
DVC_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 17 |
Percent Null | 0 |
DVC_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
DVC_ID Security Types |
Name | Current Value |
DVC_ID Bound Attachments |
Name | Current Value |
DVC_ID Data Movement Rules |
Name | Type | Rule Text/Value |
DVC_ID 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 |
DVC_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
DVC_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
DVC_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
DVC_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MNFCTR_ID |
Base Object | DSGN_DVC_MNFCTR_MDL_ASGN |
Attribute Name | MNFCTR_ID |
ColumnName | MNFCTR_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Manufacturer Identifier: The unique identifier for a manufacturer. |
Note |
MNFCTR_ID Column Properties |
Datatype | NUMBER(4, 0) |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
MNFCTR_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 3 |
Percent Null | 0 |
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 Object | DSGN_DVC_MNFCTR_MDL_ASGN |
Attribute Name | MDL_NBR |
ColumnName | MDL_NBR |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Manufacturer Model Number: The manufacturer supplied model number for the equipment. |
Note |
MDL_NBR Column Properties |
Datatype | VARCHAR2(75) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
MDL_NBR Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 9 |
Percent Null | 0 |
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 Object | DSGN_DVC_MNFCTR_MDL_ASGN |
Attribute Name | BLDG_ID |
ColumnName | BLDG_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Building Code: The unique identifier for a building. |
Note |
BLDG_ID Column Properties |
Datatype | VARCHAR2(10) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
BLDG_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 10 |
Percent Null | 100 |
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 Object | DSGN_DVC_MNFCTR_MDL_ASGN |
Attribute Name | AREA_ID |
ColumnName | AREA_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Full Name: Area Identifier |
Note |
AREA_ID Column Properties |
Datatype | VARCHAR2(50) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
AREA_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 50 |
Percent Null | 100 |
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 |