| OS_ID |
| Base Object | MPS_PROP |
| Attribute Name | OS_ID |
| ColumnName | OS_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Operating System Identifier: Indicates 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 |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| OS_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 5 |
| 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 |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| VER Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 13 |
| 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 | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| VER_DTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 13 |
| 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 | CSV File Location: The directory location and file name of the driver file |
| Note |
| CSV_FILE_LOC Column Properties |
| Datatype | VARCHAR2(128) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| CSV_FILE_LOC Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 33 |
| 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 |
| 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 |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| IMAGE_FILE_LOC Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 42 |
| 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 |
| DB_FILE_LOC |
| Base Object | MPS_PROP |
| Attribute Name | DB_FILE_LOC |
| ColumnName | DB_FILE_LOC |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | DB File Location: The directory location of the MPS .db and substitution files. |
| Note |
| DB_FILE_LOC Column Properties |
| Datatype | VARCHAR2(128) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DB_FILE_LOC Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 36 |
| 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 |
| 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 |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| ARCH_REQ_FILE_LOC Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 39 |
| 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 |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| TMPL_FILE_LOC Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 42 |
| 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 |
| 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 |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| STARTUP_FILE_LOC Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 51 |
| 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 |
| EPICS_VER |
| Base Object | MPS_PROP |
| Attribute Name | EPICS_VER |
| ColumnName | EPICS_VER |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| EPICS_VER Column Properties |
| Datatype | VARCHAR2(15) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| EPICS_VER Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 8 |
| 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 |
| 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 | |
| Note |
| PCI_DBD_FILE_NM Column Properties |
| Datatype | VARCHAR2(128) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PCI_DBD_FILE_NM Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 14 |
| 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 |
| BLM_DB_FILE_LOC |
| Base Object | MPS_PROP |
| Attribute Name | BLM_DB_FILE_LOC |
| ColumnName | BLM_DB_FILE_LOC |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Beam Loss Monitor File Location: The default file location for the BLM IOC .db files generated from the Rdb. |
| Note |
| BLM_DB_FILE_LOC Column Properties |
| Datatype | VARCHAR2(128) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| BLM_DB_FILE_LOC Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 48 |
| Percent Null | 0 |
| BLM_DB_FILE_LOC Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| BLM_DB_FILE_LOC Security Types |
| Name | Current Value |
| BLM_DB_FILE_LOC Bound Attachments |
| Name | Current Value |
| BLM_DB_FILE_LOC Data Movement Rules |
| Name | Type | Rule Text/Value |
| BLM_DB_FILE_LOC Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical MPS Property BLM_DB_FILE_LOC |
NO | ||
| EPICS (Oracle) MPS_PROP BLM_DB_FILE_LOC |
NO | ||
| MPS (Oracle) MPS_PROP BLM_DB_FILE_LOC |
NO |
| BLM_DB_FILE_LOC Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BLM_DB_FILE_LOC Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BLM_DB_FILE_LOC Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BLM_DB_FILE_LOC Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |