| Snapshot Id |
| Base Entity | Machine Snapshot |
| Attribute Name | Snapshot Id |
| Logical Rolename | |
| ColumnName | Snapshot Id |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Snapshot Identifier: A unique numeric value generated from an Oracle sequence object to identify the snapshot. |
| Note |
| Snapshot Id Logical Attribute Properties |
| Logical Attribute Name | Snapshot Id |
| Datatype | NUMERIC(8, 0) |
| Nullable | NO |
| 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 | ||
| 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 Entity | Machine Snapshot |
| Attribute Name | Snapshot Dte |
| Logical Rolename | |
| ColumnName | Snapshot Dte |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | Date: Date and time to seconds. |
| Note |
| Snapshot Dte Logical Attribute Properties |
| Logical Attribute Name | Snapshot Dte |
| Datatype | DATE |
| Nullable | NO |
| 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 | ||
| 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 Entity | Machine Snapshot |
| Attribute Name | Snapshot Score |
| Logical Rolename | |
| ColumnName | Snapshot Score |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Snapshot Score: A scale from 0 - 5 that indicates the quality of the snapshot data. |
| Note |
| Snapshot Score Logical Attribute Properties |
| Logical Attribute Name | Snapshot Score |
| Datatype | NUMERIC(1, 0) |
| Nullable | YES |
| 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 | ||
| 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 Entity | Machine Snapshot |
| Attribute Name | Snapshot Type Nm |
| Logical Rolename | |
| ColumnName | Snapshot Type Nm |
| RoleName | |
| Domain | Name |
| Logical Only | NO |
| Definition | Name: A long description name usually accompanied by an abbreviated code. |
| Note |
| Snapshot Type Nm Logical Attribute Properties |
| Logical Attribute Name | Snapshot Type Nm |
| Datatype | VARCHAR(120) |
| Nullable | YES |
| 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 | ||
| 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 |
| Comment |
| Base Entity | Machine Snapshot |
| Attribute Name | Comment |
| Logical Rolename | |
| ColumnName | CMNT |
| RoleName | |
| Domain | Comment |
| Logical Only | NO |
| Definition | Comment: General comments. |
| Note |
| Comment Logical Attribute Properties |
| Logical Attribute Name | Comment |
| Datatype | VARCHAR(2000) |
| Nullable | YES |
| Comment Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Comment Security Types |
| Name | Current Value |
| Comment Bound Attachments |
| Name | Current Value |
| Comment Data Movement Rules |
| Name | Type | Rule Text/Value |
| Comment Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Machine Snapshot Comment |
NO | ||
| DIAG (Oracle) MACH_SNAPSHOT CMNT |
NO | ||
| PV_LOGGER (Oracle) MACH_SNAPSHOT CMNT |
NO |
| Comment Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Comment Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Comment Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Comment Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |