!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:    CONV_LINEAR.SDDL
!
! Purpose:      This SDDL file defines the CONV_LINEAR relation.
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ---   -------------------------------------------------
! 06/28/96    29389     Rose  Original implementation
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!

LANGUAGE        SQL

RECORD  CONV_LINEAR

!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------

DESCRIPTION    "This relation specifies the LINEAR conversions which
		are to be applied to certain telemetry mnemonics.

		In the past PODPS used a wide relation: one which had a
		single tuple for each mnemonic, and 16 groups of fields
		specifying up to 16 conversion steps. Not only is this
		a poor design limit on the number of possible steps, but
		if a mnemonic only used 2 fields (a majority of cases) 
		there would be a significant amount of unused space reserved
		in the database.

		The current design allows a mnemonic to have any number of
		tuples, each one of which only specifies a single conversion
		step. See OPR.29389.

		The set of conversion tuples (ordered by x_val) allows a
		stepwise linear conversion of any value between 0 and the
		last x_val.  It is recommended that the last x_val be the
		maximum possible for the number of bits in the mnemonic. 
		That is, if the mnemonic has 8 bits, the last x_val should
		be 255.
"
!------------------------------------------------------------------------------
!
!   FIELD INFORMATION
!
!------------------------------------------------------------------------------

    FIELD  mnemonic
        TYPE            C8
        DESCRIPTION     "The name of the telemetry mnemonic"
    END_FIELD

    FIELD  x_val
        TYPE            I4
        DESCRIPTION     "The next telemetry value"
    END_FIELD

    FIELD  y_val
        TYPE            R4
        DESCRIPTION     "The corresponding point in engineering units"
    END_FIELD


END_RECORD

!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------


RELATION  conv_linear

    TYPE             CONV_LINEAR

    DESCRIPTION      "linear conversion coefficients"

    SUBSYSTEM_USING  "OPUS"

    INDEX  conv_linear_1
        TYPE         unique, clustered
        FIELDS       mnemonic, x_val
    END_INDEX

END_RELATION

!------------------------------------------------------------------------------
!
!   INSTANCE DECLARATION
!
!------------------------------------------------------------------------------


INSTANCE  conv_linear

    GLOBAL

    TYPE        CONV_LINEAR

END_INSTANCE