| Device Identifer |
| Base Entity | IOC Software |
| Attribute Name | Device Identifer |
| Logical Rolename | |
| ColumnName | DVC_ID |
| RoleName | |
| Domain | Device Id |
| Logical 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 |
| 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 IOC Software Device Identifer |
NO | ||
| EPICS (Oracle) IOC_SFTW 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 |
| Sftw Nm |
| Base Entity | IOC Software |
| Attribute Name | Sftw Nm |
| Logical Rolename | |
| ColumnName | SFTW_NM |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Software Name: The software module name. |
| Note |
| Sftw Nm Logical Attribute Properties |
| Logical Attribute Name | Sftw Nm |
| Datatype | VARCHAR(256) |
| Nullable | NO |
| Sftw Nm Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Sftw Nm Security Types |
| Name | Current Value |
| Sftw Nm Bound Attachments |
| Name | Current Value |
| Sftw Nm Data Movement Rules |
| Name | Type | Rule Text/Value |
| Sftw Nm Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical IOC Software Sftw Nm |
NO | ||
| EPICS (Oracle) IOC_SFTW SFTW_NM |
NO |
| Sftw Nm Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sftw Nm Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sftw Nm Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sftw Nm Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Epics Version |
| Base Entity | IOC Software |
| Attribute Name | Epics Version |
| Logical Rolename | |
| ColumnName | EPICS_VER |
| RoleName | |
| Domain | EPICS Version |
| Logical Only | NO |
| Definition | EPICS Version: The EPICS versions previously used, currently used or be be used by SNS. |
| Note |
| Epics Version Logical Attribute Properties |
| Logical Attribute Name | Epics Version |
| Datatype | VARCHAR(50) |
| Nullable | NO |
| Epics Version Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Epics Version Security Types |
| Name | Current Value |
| Epics Version Bound Attachments |
| Name | Current Value |
| Epics Version Data Movement Rules |
| Name | Type | Rule Text/Value |
| Epics Version Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical IOC Software Epics Version |
NO | ||
| EPICS (Oracle) IOC_SFTW EPICS_VER |
NO |
| Epics Version Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Epics Version Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Epics Version Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Epics Version Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Boot Dte |
| Base Entity | IOC Software |
| Attribute Name | Boot Dte |
| Logical Rolename | |
| ColumnName | Boot Dte |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | Boot Date: The date and time the IOC was last booted. |
| Note |
| Boot Dte Logical Attribute Properties |
| Logical Attribute Name | Boot Dte |
| Datatype | DATE |
| Nullable | NO |
| Boot Dte Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| Boot Dte Security Types |
| Name | Current Value |
| Boot Dte Bound Attachments |
| Name | Current Value |
| Boot Dte Data Movement Rules |
| Name | Type | Rule Text/Value |
| Boot Dte Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical IOC Software Boot Dte |
NO | ||
| EPICS (Oracle) IOC_SFTW Boot Dte |
NO |
| Boot Dte Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Boot Dte Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Boot Dte Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Boot Dte Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sftw Ver |
| Base Entity | IOC Software |
| Attribute Name | Sftw Ver |
| Logical Rolename | |
| ColumnName | Sftw Ver |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Sftw Ver Logical Attribute Properties |
| Logical Attribute Name | Sftw Ver |
| Datatype | VARCHAR(25) |
| Nullable | YES |
| Sftw Ver Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Sftw Ver Security Types |
| Name | Current Value |
| Sftw Ver Bound Attachments |
| Name | Current Value |
| Sftw Ver Data Movement Rules |
| Name | Type | Rule Text/Value |
| Sftw Ver Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical IOC Software Sftw Ver |
NO | ||
| EPICS (Oracle) IOC_SFTW Sftw Ver |
NO |
| Sftw Ver Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sftw Ver Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sftw Ver Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sftw Ver Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sftw Loc |
| Base Entity | IOC Software |
| Attribute Name | Sftw Loc |
| Logical Rolename | |
| ColumnName | SFTW_LOC |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Sftw Loc Logical Attribute Properties |
| Logical Attribute Name | Sftw Loc |
| Datatype | CHAR(255) |
| Nullable | YES |
| Sftw Loc Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Sftw Loc Security Types |
| Name | Current Value |
| Sftw Loc Bound Attachments |
| Name | Current Value |
| Sftw Loc Data Movement Rules |
| Name | Type | Rule Text/Value |
| Sftw Loc Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical IOC Software Sftw Loc |
NO | ||
| EPICS (Oracle) IOC_SFTW SFTW_LOC |
NO |
| Sftw Loc Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sftw Loc Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sftw Loc Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sftw Loc Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sftw Desc |
| Base Entity | IOC Software |
| Attribute Name | Sftw Desc |
| Logical Rolename | |
| ColumnName | SFTW_DESC |
| RoleName | |
| Domain | Description |
| Logical Only | NO |
| Definition | Software Description: Detailed description of the software module. |
| Note |
| Sftw Desc Logical Attribute Properties |
| Logical Attribute Name | Sftw Desc |
| Datatype | VARCHAR(255) |
| Nullable | YES |
| Sftw Desc Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Sftw Desc Security Types |
| Name | Current Value |
| Sftw Desc Bound Attachments |
| Name | Current Value |
| Sftw Desc Data Movement Rules |
| Name | Type | Rule Text/Value |
| Sftw Desc Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical IOC Software Sftw Desc |
NO | ||
| EPICS (Oracle) IOC_SFTW SFTW_DESC |
NO |
| Sftw Desc Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sftw Desc Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sftw Desc Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sftw Desc Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sftw Maint Nm |
| Base Entity | IOC Software |
| Attribute Name | Sftw Maint Nm |
| Logical Rolename | |
| ColumnName | SFTW_MAINT_NM |
| RoleName | |
| Domain | Name |
| Logical Only | NO |
| Definition | Software Maintainer Name: The person responsible for maintaining the software module. |
| Note |
| Sftw Maint Nm Logical Attribute Properties |
| Logical Attribute Name | Sftw Maint Nm |
| Datatype | VARCHAR(120) |
| Nullable | YES |
| Sftw Maint Nm Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Sftw Maint Nm Security Types |
| Name | Current Value |
| Sftw Maint Nm Bound Attachments |
| Name | Current Value |
| Sftw Maint Nm Data Movement Rules |
| Name | Type | Rule Text/Value |
| Sftw Maint Nm Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical IOC Software Sftw Maint Nm |
NO | ||
| EPICS (Oracle) IOC_SFTW SFTW_MAINT_NM |
NO |
| Sftw Maint Nm Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sftw Maint Nm Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sftw Maint Nm Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sftw Maint Nm Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |