DM Columns

ColumnName	Domain	Datatype	NULL	Definition
key		NUMBER(8, 0)	NO	This attribute denotes a unique identifier for a decimation
name		VARCHAR2(80)	YES	Descriptive name
samprate		BINARY_FLOAT	NO	Sampling rate. This attribute is the sample rate in samples/second
factor		NUMBER(8, 0)	NO	The decimation factor. When this number of samples are read in, one final sample comes out. The output sample rate can be calculated by dividing samprate by the decimation factor
offset		NUMBER(8, 0)	YES	This field determines which sample is chosen for use. The value of this field has to be greater than or equal to zero, but less than the decimation factor
delay		BINARY_FLOAT	YES	The estimated pure delay for the stage
correction		BINARY_FLOAT	NO	The time shift applied to the time tag due to delay at this stage of the filter; a negative number indicating the amount of time added to the former time tag. The actual delay is difficult to estimate, and the correction applied neglects dispersion.This field allows to know how much correction was used, in case a more accurate correction is to be applied later. A zero here implies no correction was done
lddate		DATE	YES	Load date. Date and time that the record was created or last modified, in Oracle date datatype

DM Primary and Unique Keys

Key Name	Key Type	Keys
DM00	PrimaryKey	key

DM Foreign Keys

Parent Relationships:

Table Name

Type

Cardinality

Constraint Name

VerbPhrase

InversePhrase

Foreign Keys

Is Supertype

Deferrable

Initially Deferred

Child Relationships:

Table Name	Type	Cardinality	Constraint Name	VerbPhrase	InversePhrase	Foreign Keys	Is Subtype	Deferrable	Initially Deferred
Decimation	Non-Identifying	One To Zero or More	Dec_DM				NO	NO	NO

DM Check Constraints

Check Constraint Name	CheckConstraint
DM01	offset >= 0.0
DM02	samprate >= 0.0