DM

Logical Entity Name | DM
Default Table Name | DM
Definition | Summary information on a decimation

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