| SNAPSHOT_ID |
| Base Object | MACH_SNAPSHOT_SGNL |
| Attribute Name | Snapshot Id |
| ColumnName | SNAPSHOT_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Snapshot Identifier: A unique numeric value generated from an Oracle sequence object to identify the snapshot. |
| Note |
| SNAPSHOT_ID Column Properties |
| Datatype | NUMBER(8, 0) |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SNAPSHOT_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 5 |
| Percent Null | 0 |
| SNAPSHOT_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SNAPSHOT_ID Security Types |
| Name | Current Value |
| SNAPSHOT_ID Bound Attachments |
| Name | Current Value |
| SNAPSHOT_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| SNAPSHOT_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Machine Snapshot Signal Snapshot Id |
NO | ||
| DIAG (Oracle) MACH_SNAPSHOT_SGNL SNAPSHOT_ID |
NO | ||
| EPICS (Oracle) MACH_SNAPSHOT_SGNL SNAPSHOT_ID |
NO | ||
| PV_LOGGER (Oracle) MACH_SNAPSHOT_SGNL SNAPSHOT_ID |
NO |
| SNAPSHOT_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNAPSHOT_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNAPSHOT_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNAPSHOT_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SGNL_ID |
| Base Object | MACH_SNAPSHOT_SGNL |
| Attribute Name | Sgnl Id |
| ColumnName | SGNL_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| SGNL_ID Column Properties |
| Datatype | VARCHAR2(75) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SGNL_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 75 |
| Percent Null | 0 |
| SGNL_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SGNL_ID Security Types |
| Name | Current Value |
| SGNL_ID Bound Attachments |
| Name | Current Value |
| SGNL_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| SGNL_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Machine Snapshot Signal Sgnl Id |
NO | ||
| DIAG (Oracle) MACH_SNAPSHOT_SGNL SGNL_ID |
NO | ||
| EPICS (Oracle) MACH_SNAPSHOT_SGNL SGNL_ID |
NO | ||
| PV_LOGGER (Oracle) MACH_SNAPSHOT_SGNL SGNL_ID |
NO |
| SGNL_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SGNL_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SGNL_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SGNL_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SGNL_TIMESTP |
| Base Object | MACH_SNAPSHOT_SGNL |
| Attribute Name | Sgnl TimeStp |
| ColumnName | SGNL_TIMESTP |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| SGNL_TIMESTP Column Properties |
| Datatype | TIMESTAMP(6) |
| Nullable | NO |
| Not Null Constraint | |
| Time Zone | NO |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SGNL_TIMESTP Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| SGNL_TIMESTP Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SGNL_TIMESTP Security Types |
| Name | Current Value |
| SGNL_TIMESTP Bound Attachments |
| Name | Current Value |
| SGNL_TIMESTP Data Movement Rules |
| Name | Type | Rule Text/Value |
| SGNL_TIMESTP Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Machine Snapshot Signal Sgnl TimeStp |
NO | ||
| DIAG (Oracle) MACH_SNAPSHOT_SGNL SGNL_TIMESTP |
NO | ||
| EPICS (Oracle) MACH_SNAPSHOT_SGNL SGNL_TIMESTP |
NO | ||
| PV_LOGGER (Oracle) MACH_SNAPSHOT_SGNL SGNL_TIMESTP |
NO |
| SGNL_TIMESTP Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SGNL_TIMESTP Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SGNL_TIMESTP Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SGNL_TIMESTP Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SGNL_VAL |
| Base Object | MACH_SNAPSHOT_SGNL |
| Attribute Name | Sgnl Val |
| ColumnName | SGNL_VAL |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Signal Values: The values for the signal at the given timestamp. Implemented as an Oracle varray. |
| Note |
| SGNL_VAL Column Properties |
| Datatype | CHAR(10) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SGNL_VAL Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| SGNL_VAL Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SGNL_VAL Security Types |
| Name | Current Value |
| SGNL_VAL Bound Attachments |
| Name | Current Value |
| SGNL_VAL Data Movement Rules |
| Name | Type | Rule Text/Value |
| SGNL_VAL Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Machine Snapshot Signal Sgnl Val |
NO | ||
| DIAG (Oracle) MACH_SNAPSHOT_SGNL SGNL_VAL |
NO | ||
| EPICS (Oracle) MACH_SNAPSHOT_SGNL SGNL_VAL |
NO | ||
| PV_LOGGER (Oracle) MACH_SNAPSHOT_SGNL SGNL_VAL |
NO |
| SGNL_VAL Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SGNL_VAL Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SGNL_VAL Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SGNL_VAL Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SGNL_STAT |
| Base Object | MACH_SNAPSHOT_SGNL |
| Attribute Name | Sgnl Stat |
| ColumnName | SGNL_STAT |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Signal Status: Synonymous with the EPICS PV status. |
| Note |
| SGNL_STAT Column Properties |
| Datatype | NUMBER(4, 0) |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SGNL_STAT Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 3 |
| Percent Null | 0 |
| SGNL_STAT Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SGNL_STAT Security Types |
| Name | Current Value |
| SGNL_STAT Bound Attachments |
| Name | Current Value |
| SGNL_STAT Data Movement Rules |
| Name | Type | Rule Text/Value |
| SGNL_STAT Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Machine Snapshot Signal Sgnl Stat |
NO | ||
| DIAG (Oracle) MACH_SNAPSHOT_SGNL SGNL_STAT |
NO | ||
| EPICS (Oracle) MACH_SNAPSHOT_SGNL SGNL_STAT |
NO | ||
| PV_LOGGER (Oracle) MACH_SNAPSHOT_SGNL SGNL_STAT |
NO |
| SGNL_STAT Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SGNL_STAT Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SGNL_STAT Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SGNL_STAT Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SGNL_SVRTY |
| Base Object | MACH_SNAPSHOT_SGNL |
| Attribute Name | Sgnl Svrty |
| ColumnName | SGNL_SVRTY |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Signal Severity: Synonymous with the EPICS PV severity. |
| Note |
| SGNL_SVRTY Column Properties |
| Datatype | NUMBER(4, 0) |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SGNL_SVRTY Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 3 |
| Percent Null | 0 |
| SGNL_SVRTY Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SGNL_SVRTY Security Types |
| Name | Current Value |
| SGNL_SVRTY Bound Attachments |
| Name | Current Value |
| SGNL_SVRTY Data Movement Rules |
| Name | Type | Rule Text/Value |
| SGNL_SVRTY Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Machine Snapshot Signal Sgnl Svrty |
NO | ||
| DIAG (Oracle) MACH_SNAPSHOT_SGNL SGNL_SVRTY |
NO | ||
| EPICS (Oracle) MACH_SNAPSHOT_SGNL SGNL_SVRTY |
NO | ||
| PV_LOGGER (Oracle) MACH_SNAPSHOT_SGNL SGNL_SVRTY |
NO |
| SGNL_SVRTY Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SGNL_SVRTY Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SGNL_SVRTY Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SGNL_SVRTY Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |