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
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 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
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 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
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 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	16
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
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 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	2
Percent Null	98

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
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