| DVC_ID |
| Base Object | Equip_Dvc_Asgn |
| Attribute Name | Device Identifer |
| ColumnName | DVC_ID |
| Logical Rolename | Device Identifer |
| RoleName | |
| Domain | Device Id |
| Physical Only | NO |
| Definition | 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(50) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| 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 |
| Logical Equipment Device Assignment Device Identifer |
NO | ||
| XAL_OPTICS (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 |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| 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 |
| Logical Equipment Device Assignment Equip Id |
NO | ||
| XAL_OPTICS (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 |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| 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 |
| Logical Equipment Device Assignment Asgn Bdte |
NO | ||
| XAL_OPTICS (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 |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| 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 |
| Logical Equipment Device Assignment Asgn Edte |
NO | ||
| XAL_OPTICS (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 |