| SNAPSHOT_ID |
| Base Object | MACH_SNAPSHOT |
| 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 Snapshot Id |
NO | ||
| DIAG (Oracle) MACH_SNAPSHOT SNAPSHOT_ID |
NO | ||
| EPICS (Oracle) MACH_SNAPSHOT SNAPSHOT_ID |
NO | ||
| PV_LOGGER (Oracle) MACH_SNAPSHOT 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 |
| SNAPSHOT_DTE |
| Base Object | MACH_SNAPSHOT |
| Attribute Name | Snapshot Dte |
| ColumnName | SNAPSHOT_DTE |
| Logical Rolename | |
| RoleName | |
| Domain | Date |
| Physical Only | NO |
| Definition | Date: Date and time to seconds. |
| Note |
| SNAPSHOT_DTE Column Properties |
| Datatype | DATE |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SNAPSHOT_DTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| SNAPSHOT_DTE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| SNAPSHOT_DTE Security Types |
| Name | Current Value |
| SNAPSHOT_DTE Bound Attachments |
| Name | Current Value |
| SNAPSHOT_DTE Data Movement Rules |
| Name | Type | Rule Text/Value |
| SNAPSHOT_DTE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Machine Snapshot Snapshot Dte |
NO | ||
| DIAG (Oracle) MACH_SNAPSHOT SNAPSHOT_DTE |
NO | ||
| EPICS (Oracle) MACH_SNAPSHOT SNAPSHOT_DTE |
NO | ||
| PV_LOGGER (Oracle) MACH_SNAPSHOT SNAPSHOT_DTE |
NO |
| SNAPSHOT_DTE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNAPSHOT_DTE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNAPSHOT_DTE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNAPSHOT_DTE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNAPSHOT_SCORE |
| Base Object | MACH_SNAPSHOT |
| Attribute Name | Snapshot Score |
| ColumnName | SNAPSHOT_SCORE |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Snapshot Score: A scale from 0 - 5 that indicates the quality of the snapshot data. |
| Note |
| SNAPSHOT_SCORE Column Properties |
| Datatype | NUMBER(1, 0) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SNAPSHOT_SCORE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| SNAPSHOT_SCORE Domain Restrictions |
| CheckConstraint | snapshot_score < 6 |
| Check Constraint Name | SYS_C008827 |
| Bound Rule | |
| Declared Default | 0 |
| Bound Default |
| SNAPSHOT_SCORE Security Types |
| Name | Current Value |
| SNAPSHOT_SCORE Bound Attachments |
| Name | Current Value |
| SNAPSHOT_SCORE Data Movement Rules |
| Name | Type | Rule Text/Value |
| SNAPSHOT_SCORE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Machine Snapshot Snapshot Score |
NO | ||
| DIAG (Oracle) MACH_SNAPSHOT SNAPSHOT_SCORE |
NO | ||
| EPICS (Oracle) MACH_SNAPSHOT SNAPSHOT_SCORE |
NO | ||
| PV_LOGGER (Oracle) MACH_SNAPSHOT SNAPSHOT_SCORE |
NO |
| SNAPSHOT_SCORE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNAPSHOT_SCORE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNAPSHOT_SCORE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNAPSHOT_SCORE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNAPSHOT_TYPE_NM |
| Base Object | MACH_SNAPSHOT |
| Attribute Name | Snapshot Type Nm |
| ColumnName | SNAPSHOT_TYPE_NM |
| Logical Rolename | |
| RoleName | |
| Domain | Name |
| Physical Only | NO |
| Definition | Name: A long description name usually accompanied by an abbreviated code. |
| Note |
| SNAPSHOT_TYPE_NM Column Properties |
| Datatype | VARCHAR2(120) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SNAPSHOT_TYPE_NM Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 120 |
| Percent Null | 0 |
| SNAPSHOT_TYPE_NM Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SNAPSHOT_TYPE_NM Security Types |
| Name | Current Value |
| SNAPSHOT_TYPE_NM Bound Attachments |
| Name | Current Value |
| SNAPSHOT_TYPE_NM Data Movement Rules |
| Name | Type | Rule Text/Value |
| SNAPSHOT_TYPE_NM Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Machine Snapshot Snapshot Type Nm |
NO | ||
| DIAG (Oracle) MACH_SNAPSHOT SNAPSHOT_TYPE_NM |
NO | ||
| EPICS (Oracle) MACH_SNAPSHOT SNAPSHOT_TYPE_NM |
NO | ||
| PV_LOGGER (Oracle) MACH_SNAPSHOT SNAPSHOT_TYPE_NM |
NO |
| SNAPSHOT_TYPE_NM Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNAPSHOT_TYPE_NM Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNAPSHOT_TYPE_NM Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNAPSHOT_TYPE_NM Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CMNT |
| Base Object | MACH_SNAPSHOT |
| Attribute Name | Comment |
| ColumnName | CMNT |
| Logical Rolename | |
| RoleName | |
| Domain | Comment |
| Physical Only | NO |
| Definition | Comment: General comments. |
| Note |
| CMNT Column Properties |
| Datatype | VARCHAR2(2000) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| CMNT Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 2000 |
| Percent Null | 0 |
| CMNT Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| CMNT Security Types |
| Name | Current Value |
| CMNT Bound Attachments |
| Name | Current Value |
| CMNT Data Movement Rules |
| Name | Type | Rule Text/Value |
| CMNT Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Machine Snapshot Comment |
NO | ||
| DIAG (Oracle) MACH_SNAPSHOT CMNT |
NO | ||
| EPICS (Oracle) MACH_SNAPSHOT CMNT |
NO | ||
| PV_LOGGER (Oracle) MACH_SNAPSHOT CMNT |
NO |
| CMNT Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CMNT Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CMNT Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CMNT Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |