| Device Identifer |
| Base Entity | Equipment Device Assignment |
| Attribute Name | Device Identifer |
| Logical Rolename | |
| ColumnName | DVC_ID |
| RoleName | |
| Domain | Device Id |
| Logical 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 |
| 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 Equipment Device Assignment Device Identifer |
NO | ||
| XAL_OPTICS (Oracle) Equip_Dvc_Asgn DVC_ID |
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 |
| Equip Id |
| Base Entity | Equipment Device Assignment |
| Attribute Name | Equip Id |
| Logical Rolename | |
| ColumnName | Equip Id |
| RoleName | |
| Domain | Asset Identifier |
| Logical Only | NO |
| Definition | Equipment Identifier: The unique identifier for the equipment. |
| Note |
| Equip Id Logical Attribute Properties |
| Logical Attribute Name | Equip Id |
| Datatype | VARCHAR(30) |
| Nullable | NO |
| 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 Entity | Equipment Device Assignment |
| Attribute Name | Asgn Bdte |
| Logical Rolename | |
| ColumnName | Asgn Bdte |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | Assignment Begin Date: The date when the equipment was first placed in a device. |
| Note |
| Asgn Bdte Logical Attribute Properties |
| Logical Attribute Name | Asgn Bdte |
| Datatype | DATE |
| Nullable | NO |
| 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 Entity | Equipment Device Assignment |
| Attribute Name | Asgn Edte |
| Logical Rolename | |
| ColumnName | Asgn Edte |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | Assignment End Date: The day the equipment was removed from a particular device. |
| Note |
| Asgn Edte Logical Attribute Properties |
| Logical Attribute Name | Asgn Edte |
| Datatype | DATE |
| Nullable | YES |
| 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 |