| Device Identifer |
| Base Entity | IOC DB File Asgn |
| 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 DB File Asgn Device Identifer |
NO | ||
| EPICS (Oracle) IOC_DB_FILE_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 |
| Ext Src File Nm |
| Base Entity | IOC DB File Asgn |
| Attribute Name | Ext Src File Nm |
| Logical Rolename | |
| ColumnName | Ext Src File Nm |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | External Source File name: The file name for cases where the signal was imported from a spreadsheet or graphical design tool. |
| Note |
| Ext Src File Nm Logical Attribute Properties |
| Logical Attribute Name | Ext Src File Nm |
| Datatype | VARCHAR(100) |
| Nullable | NO |
| Ext Src File Nm Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Ext Src File Nm Security Types |
| Name | Current Value |
| Ext Src File Nm Bound Attachments |
| Name | Current Value |
| Ext Src File Nm Data Movement Rules |
| Name | Type | Rule Text/Value |
| Ext Src File Nm Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical IOC DB File Asgn Ext Src File Nm |
NO | ||
| EPICS (Oracle) IOC_DB_FILE_ASGN Ext Src File Nm |
NO |
| Ext Src File Nm Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Ext Src File Nm Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Ext Src File Nm Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Ext Src File Nm Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mod By Uid |
| Base Entity | IOC DB File Asgn |
| Attribute Name | Mod By Uid |
| Logical Rolename | |
| ColumnName | MOD_BY_UID |
| RoleName | |
| Domain | Mod By Uid |
| Logical Only | NO |
| Definition | Modified by Userid: The database userid of the person who inserted or update a record in the table. |
| Note |
| Mod By Uid Logical Attribute Properties |
| Logical Attribute Name | Mod By Uid |
| Datatype | VARCHAR(64) |
| Nullable | NO |
| Mod By Uid Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Mod By Uid Security Types |
| Name | Current Value |
| Mod By Uid Bound Attachments |
| Name | Current Value |
| Mod By Uid Data Movement Rules |
| Name | Type | Rule Text/Value |
| Mod By Uid Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical IOC DB File Asgn Mod By Uid |
NO | ||
| EPICS (Oracle) IOC_DB_FILE_ASGN MOD_BY_UID |
NO |
| Mod By Uid Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mod By Uid Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mod By Uid Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mod By Uid Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mod Dte |
| Base Entity | IOC DB File Asgn |
| Attribute Name | Mod Dte |
| Logical Rolename | |
| ColumnName | MOD_DTE |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Modify Date: The date the record was created or modified. |
| Note |
| Mod Dte Logical Attribute Properties |
| Logical Attribute Name | Mod Dte |
| Datatype | DATE |
| Nullable | NO |
| Mod Dte Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | SYSDATE | ||
| Bound Default |
| Mod Dte Security Types |
| Name | Current Value |
| Mod Dte Bound Attachments |
| Name | Current Value |
| Mod Dte Data Movement Rules |
| Name | Type | Rule Text/Value |
| Mod Dte Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical IOC DB File Asgn Mod Dte |
NO | ||
| EPICS (Oracle) IOC_DB_FILE_ASGN MOD_DTE |
NO |
| Mod Dte Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mod Dte Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mod Dte Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mod Dte Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Ext Src Dir Nm |
| Base Entity | IOC DB File Asgn |
| Attribute Name | Ext Src Dir Nm |
| Logical Rolename | |
| ColumnName | Ext Src Dir Nm |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | External Source Directory Name: The directory where the .db file name was imported. |
| Note |
| Ext Src Dir Nm Logical Attribute Properties |
| Logical Attribute Name | Ext Src Dir Nm |
| Datatype | VARCHAR(255) |
| Nullable | YES |
| Ext Src Dir Nm Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Ext Src Dir Nm Security Types |
| Name | Current Value |
| Ext Src Dir Nm Bound Attachments |
| Name | Current Value |
| Ext Src Dir Nm Data Movement Rules |
| Name | Type | Rule Text/Value |
| Ext Src Dir Nm Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical IOC DB File Asgn Ext Src Dir Nm |
NO | ||
| EPICS (Oracle) IOC_DB_FILE_ASGN Ext Src Dir Nm |
NO |
| Ext Src Dir Nm Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Ext Src Dir Nm Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Ext Src Dir Nm Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Ext Src Dir Nm Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Ext Src File Mod Dte |
| Base Entity | IOC DB File Asgn |
| Attribute Name | Ext Src File Mod Dte |
| Logical Rolename | |
| ColumnName | Ext Src File Mod Dte |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | External Source File Modification Date: The date the imported file was lasted modified. This is used to synchronize newly generated files. |
| Note |
| Ext Src File Mod Dte Logical Attribute Properties |
| Logical Attribute Name | Ext Src File Mod Dte |
| Datatype | DATE |
| Nullable | YES |
| Ext Src File Mod Dte Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| Ext Src File Mod Dte Security Types |
| Name | Current Value |
| Ext Src File Mod Dte Bound Attachments |
| Name | Current Value |
| Ext Src File Mod Dte Data Movement Rules |
| Name | Type | Rule Text/Value |
| Ext Src File Mod Dte Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical IOC DB File Asgn Ext Src File Mod Dte |
NO | ||
| EPICS (Oracle) IOC_DB_FILE_ASGN Ext Src File Mod Dte |
NO |
| Ext Src File Mod Dte Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Ext Src File Mod Dte Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Ext Src File Mod Dte Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Ext Src File Mod Dte Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Ext Src File Loc |
| Base Entity | IOC DB File Asgn |
| Attribute Name | Ext Src File Loc |
| Logical Rolename | |
| ColumnName | EXT_SRC_FILE_LOC |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Ext Src File Loc Logical Attribute Properties |
| Logical Attribute Name | Ext Src File Loc |
| Datatype | VARCHAR(355) |
| Nullable | YES |
| Ext Src File Loc Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Ext Src File Loc Security Types |
| Name | Current Value |
| Ext Src File Loc Bound Attachments |
| Name | Current Value |
| Ext Src File Loc Data Movement Rules |
| Name | Type | Rule Text/Value |
| Ext Src File Loc Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical IOC DB File Asgn Ext Src File Loc |
NO | ||
| EPICS (Oracle) IOC_DB_FILE_ASGN EXT_SRC_FILE_LOC |
NO |
| Ext Src File Loc Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Ext Src File Loc Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Ext Src File Loc Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Ext Src File Loc Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |