| EPICS_VER |
| Base Object | MPS_PROP |
| Attribute Name | Epics Version |
| ColumnName | EPICS_VER |
| Logical Rolename | |
| RoleName | |
| Domain | EPICS Version |
| Physical Only | NO |
| Definition | EPICS Version: The EPICS versions previously used, currently used or be be used by SNS. |
| Note |
| EPICS_VER Column Properties |
| Datatype | VARCHAR2(50) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| EPICS_VER Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 15 |
| Percent Null | 0 |
| EPICS_VER Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| EPICS_VER Security Types |
| Name | Current Value |
| EPICS_VER Bound Attachments |
| Name | Current Value |
| EPICS_VER Data Movement Rules |
| Name | Type | Rule Text/Value |
| EPICS_VER Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical MPS Property EPICS Ver |
NO | ||
| EPICS (Oracle) MPS_PROP EPICS_VER |
NO | ||
| MPS (Oracle) MPS_PROP EPICS_VER |
NO |
| EPICS_VER Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EPICS_VER Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EPICS_VER Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EPICS_VER Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| OS_ID |
| Base Object | MPS_PROP |
| Attribute Name | OS Id |
| ColumnName | OS_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Operating System Identifier: Inidcates whether the property directories are for Windows or Unix. |
| Note |
| OS_ID Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| OS_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| OS_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| OS_ID Security Types |
| Name | Current Value |
| OS_ID Bound Attachments |
| Name | Current Value |
| OS_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| OS_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical MPS Property OS Id |
NO | ||
| EPICS (Oracle) MPS_PROP OS_ID |
NO | ||
| MPS (Oracle) MPS_PROP OS_ID |
NO |
| OS_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| OS_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| OS_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| OS_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| VER |
| Base Object | MPS_PROP |
| Attribute Name | Ver |
| ColumnName | VER |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Version: The present operation version of the MPS operating software. |
| Note |
| VER Column Properties |
| Datatype | VARCHAR2(50) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| VER Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 50 |
| Percent Null | 0 |
| VER Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| VER Security Types |
| Name | Current Value |
| VER Bound Attachments |
| Name | Current Value |
| VER Data Movement Rules |
| Name | Type | Rule Text/Value |
| VER Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical MPS Property Ver |
NO | ||
| EPICS (Oracle) MPS_PROP VER |
NO | ||
| MPS (Oracle) MPS_PROP VER |
NO |
| VER Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| VER Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| VER Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| VER Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| VER_DTE |
| Base Object | MPS_PROP |
| Attribute Name | Ver Dte |
| ColumnName | VER_DTE |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Version Date: The date the current MPS operating software was generated. |
| Note |
| VER_DTE Column Properties |
| Datatype | VARCHAR2(64) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| VER_DTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 64 |
| Percent Null | 0 |
| VER_DTE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| VER_DTE Security Types |
| Name | Current Value |
| VER_DTE Bound Attachments |
| Name | Current Value |
| VER_DTE Data Movement Rules |
| Name | Type | Rule Text/Value |
| VER_DTE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical MPS Property Ver Dte |
NO | ||
| EPICS (Oracle) MPS_PROP VER_DTE |
NO | ||
| MPS (Oracle) MPS_PROP VER_DTE |
NO |
| VER_DTE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| VER_DTE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| VER_DTE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| VER_DTE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CSV_FILE_LOC |
| Base Object | MPS_PROP |
| Attribute Name | CSV File Loc |
| ColumnName | CSV_FILE_LOC |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | CSVFile Location: The directory location for the .CSV file. |
| Note |
| CSV_FILE_LOC Column Properties |
| Datatype | VARCHAR2(128) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| CSV_FILE_LOC Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 128 |
| Percent Null | 0 |
| CSV_FILE_LOC Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| CSV_FILE_LOC Security Types |
| Name | Current Value |
| CSV_FILE_LOC Bound Attachments |
| Name | Current Value |
| CSV_FILE_LOC Data Movement Rules |
| Name | Type | Rule Text/Value |
| CSV_FILE_LOC Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical MPS Property CSV File Loc |
NO | ||
| EPICS (Oracle) MPS_PROP CSV_FILE_LOC |
NO | ||
| MPS (Oracle) MPS_PROP CSV_FILE_LOC |
NO |
| CSV_FILE_LOC Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CSV_FILE_LOC Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CSV_FILE_LOC Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CSV_FILE_LOC Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| STARTUP_FILE_LOC |
| Base Object | MPS_PROP |
| Attribute Name | Startup File Loc |
| ColumnName | STARTUP_FILE_LOC |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Startup File Location: The directory location for the MPS startup file snippet. |
| Note |
| STARTUP_FILE_LOC Column Properties |
| Datatype | VARCHAR2(128) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| STARTUP_FILE_LOC Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 128 |
| Percent Null | 0 |
| STARTUP_FILE_LOC Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| STARTUP_FILE_LOC Security Types |
| Name | Current Value |
| STARTUP_FILE_LOC Bound Attachments |
| Name | Current Value |
| STARTUP_FILE_LOC Data Movement Rules |
| Name | Type | Rule Text/Value |
| STARTUP_FILE_LOC Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical MPS Property Startup File Loc |
NO | ||
| EPICS (Oracle) MPS_PROP STARTUP_FILE_LOC |
NO | ||
| MPS (Oracle) MPS_PROP STARTUP_FILE_LOC |
NO |
| STARTUP_FILE_LOC Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| STARTUP_FILE_LOC Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| STARTUP_FILE_LOC Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| STARTUP_FILE_LOC Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DB_FILE_LOC |
| Base Object | MPS_PROP |
| Attribute Name | DB File Loc |
| ColumnName | DB_FILE_LOC |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Database File Location: The directory location for the database and substitution files. |
| Note |
| DB_FILE_LOC Column Properties |
| Datatype | VARCHAR2(128) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| DB_FILE_LOC Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 128 |
| Percent Null | 0 |
| DB_FILE_LOC Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| DB_FILE_LOC Security Types |
| Name | Current Value |
| DB_FILE_LOC Bound Attachments |
| Name | Current Value |
| DB_FILE_LOC Data Movement Rules |
| Name | Type | Rule Text/Value |
| DB_FILE_LOC Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical MPS Property DB File Loc |
NO | ||
| EPICS (Oracle) MPS_PROP DB_FILE_LOC |
NO | ||
| MPS (Oracle) MPS_PROP DB_FILE_LOC |
NO |
| DB_FILE_LOC Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DB_FILE_LOC Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DB_FILE_LOC Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DB_FILE_LOC Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| IMAGE_FILE_LOC |
| Base Object | MPS_PROP |
| Attribute Name | Image File Loc |
| ColumnName | IMAGE_FILE_LOC |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Image File Location: The directory location and file name of the MPS image file. |
| Note |
| IMAGE_FILE_LOC Column Properties |
| Datatype | VARCHAR2(128) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| IMAGE_FILE_LOC Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 128 |
| Percent Null | 0 |
| IMAGE_FILE_LOC Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| IMAGE_FILE_LOC Security Types |
| Name | Current Value |
| IMAGE_FILE_LOC Bound Attachments |
| Name | Current Value |
| IMAGE_FILE_LOC Data Movement Rules |
| Name | Type | Rule Text/Value |
| IMAGE_FILE_LOC Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical MPS Property Image File Loc |
NO | ||
| EPICS (Oracle) MPS_PROP IMAGE_FILE_LOC |
NO | ||
| MPS (Oracle) MPS_PROP IMAGE_FILE_LOC |
NO |
| IMAGE_FILE_LOC Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| IMAGE_FILE_LOC Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| IMAGE_FILE_LOC Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| IMAGE_FILE_LOC Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ARCH_REQ_FILE_LOC |
| Base Object | MPS_PROP |
| Attribute Name | Arch Req File Loc |
| ColumnName | ARCH_REQ_FILE_LOC |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Archive Request File Location: The directory where the MPS archive request file will be saved. |
| Note |
| ARCH_REQ_FILE_LOC Column Properties |
| Datatype | VARCHAR2(128) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| ARCH_REQ_FILE_LOC Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 128 |
| Percent Null | 0 |
| ARCH_REQ_FILE_LOC Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ARCH_REQ_FILE_LOC Security Types |
| Name | Current Value |
| ARCH_REQ_FILE_LOC Bound Attachments |
| Name | Current Value |
| ARCH_REQ_FILE_LOC Data Movement Rules |
| Name | Type | Rule Text/Value |
| ARCH_REQ_FILE_LOC Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical MPS Property Arch Req File Loc |
NO | ||
| EPICS (Oracle) MPS_PROP ARCH_REQ_FILE_LOC |
NO | ||
| MPS (Oracle) MPS_PROP ARCH_REQ_FILE_LOC |
NO |
| ARCH_REQ_FILE_LOC Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ARCH_REQ_FILE_LOC Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ARCH_REQ_FILE_LOC Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ARCH_REQ_FILE_LOC Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TMPL_FILE_LOC |
| Base Object | MPS_PROP |
| Attribute Name | Tmpl File Loc |
| ColumnName | TMPL_FILE_LOC |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Template File Location: The directory location of the MPS template files. |
| Note |
| TMPL_FILE_LOC Column Properties |
| Datatype | VARCHAR2(128) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| TMPL_FILE_LOC Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 128 |
| Percent Null | 0 |
| TMPL_FILE_LOC Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| TMPL_FILE_LOC Security Types |
| Name | Current Value |
| TMPL_FILE_LOC Bound Attachments |
| Name | Current Value |
| TMPL_FILE_LOC Data Movement Rules |
| Name | Type | Rule Text/Value |
| TMPL_FILE_LOC Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical MPS Property Tmpl File Loc |
NO | ||
| EPICS (Oracle) MPS_PROP TMPL_FILE_LOC |
NO | ||
| MPS (Oracle) MPS_PROP TMPL_FILE_LOC |
NO |
| TMPL_FILE_LOC Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TMPL_FILE_LOC Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TMPL_FILE_LOC Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TMPL_FILE_LOC Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PCI_DBD_FILE_NM |
| Base Object | MPS_PROP |
| Attribute Name | PCI Dbd File Nm |
| ColumnName | PCI_DBD_FILE_NM |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | PCI DBD File Name. The PCI .dbd file name, whose name is dependent on the EPICS version. |
| Note |
| PCI_DBD_FILE_NM Column Properties |
| Datatype | VARCHAR2(128) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| PCI_DBD_FILE_NM Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 128 |
| Percent Null | 0 |
| PCI_DBD_FILE_NM Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PCI_DBD_FILE_NM Security Types |
| Name | Current Value |
| PCI_DBD_FILE_NM Bound Attachments |
| Name | Current Value |
| PCI_DBD_FILE_NM Data Movement Rules |
| Name | Type | Rule Text/Value |
| PCI_DBD_FILE_NM Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical MPS Property PCI Dbd File Nm |
NO | ||
| EPICS (Oracle) MPS_PROP PCI_DBD_FILE_NM |
NO | ||
| MPS (Oracle) MPS_PROP PCI_DBD_FILE_NM |
NO |
| PCI_DBD_FILE_NM Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PCI_DBD_FILE_NM Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PCI_DBD_FILE_NM Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PCI_DBD_FILE_NM Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |