| DVC_ID |
| Base Object | EQUIP_DVC_ASGN |
| Attribute Name | Device Identifer |
| ColumnName | DVC_ID |
| Logical Rolename | |
| RoleName | |
| Domain | Device Id |
| Physical 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 |
| DVC_ID Column Properties |
| Datatype | VARCHAR2(50) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| DVC_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 40 |
| 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 |
| EQUIP (Oracle) EQUIP_DVC_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 |
| EQUIP_ID |
| Base Object | EQUIP_DVC_ASGN |
| Attribute Name | Equip Id |
| ColumnName | EQUIP_ID |
| Logical Rolename | |
| RoleName | |
| Domain | Asset Identifier |
| Physical Only | NO |
| Definition | Equipment Identifier: The unique identifier for the equipment. |
| Note |
| EQUIP_ID Column Properties |
| Datatype | VARCHAR2(30) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| EQUIP_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 11 |
| Percent Null | 0 |
| EQUIP_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| EQUIP_ID Security Types |
| Name | Current Value |
| EQUIP_ID Bound Attachments |
| Name | Current Value |
| EQUIP_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| EQUIP_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| EQUIP (Oracle) EQUIP_DVC_ASGN EQUIP_ID |
NO |
| EQUIP_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EQUIP_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EQUIP_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EQUIP_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ASGN_BDTE |
| Base Object | EQUIP_DVC_ASGN |
| Attribute Name | Asgn Bdte |
| ColumnName | ASGN_BDTE |
| Logical Rolename | |
| RoleName | |
| Domain | Date |
| Physical Only | NO |
| Definition | Assignment Begin Date: The date when the equipment was first placed in a device. |
| Note |
| ASGN_BDTE Column Properties |
| Datatype | DATE |
| Nullable | NO |
| ASGN_BDTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| ASGN_BDTE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| ASGN_BDTE Security Types |
| Name | Current Value |
| ASGN_BDTE Bound Attachments |
| Name | Current Value |
| ASGN_BDTE Data Movement Rules |
| Name | Type | Rule Text/Value |
| ASGN_BDTE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| EQUIP (Oracle) EQUIP_DVC_ASGN ASGN_BDTE |
NO |
| ASGN_BDTE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ASGN_BDTE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ASGN_BDTE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ASGN_BDTE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ASGN_EDTE |
| Base Object | EQUIP_DVC_ASGN |
| Attribute Name | Asgn Edte |
| ColumnName | ASGN_EDTE |
| Logical Rolename | |
| RoleName | |
| Domain | Date |
| Physical Only | NO |
| Definition | Assignment End Date: The day the equipment was removed from a particular device. |
| Note |
| ASGN_EDTE Column Properties |
| Datatype | DATE |
| Nullable | YES |
| ASGN_EDTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| ASGN_EDTE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| ASGN_EDTE Security Types |
| Name | Current Value |
| ASGN_EDTE Bound Attachments |
| Name | Current Value |
| ASGN_EDTE Data Movement Rules |
| Name | Type | Rule Text/Value |
| ASGN_EDTE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| EQUIP (Oracle) EQUIP_DVC_ASGN ASGN_EDTE |
NO |
| ASGN_EDTE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ASGN_EDTE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ASGN_EDTE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ASGN_EDTE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |