!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:	ENG_TELEMETRY.SDDL
!
! Purpose:      This SDDL file defines the ENG_TELEMETRY relation.
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ----   ------------------------------------------------
! 09/28/00    44862     Baum   Original implementation
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!
 
LANGUAGE	SQL

RECORD  ENG_TELEMETRY_TYPE
 
!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------
 
 
DESCRIPTION       "This relation is used to identify the engineering telemetry
                   received from CCS that must be converted into either FGS or
                   AST eng files. The type of telemetry is identified by
                   the field eng_type. Certain telemetry items are passed on
                   in raw form and the raw_flag is used to identify these
                   items. The telemetry files used eng_number rather than
                   ccs_number.  The name of the telemetry is found in the
                   eng_telem_name table by joining on the eng_number. "

!------------------------------------------------------------------------------
!
!   FIELD INFORMATION
!
!------------------------------------------------------------------------------

    FIELD  eng_type
        TYPE            C3
        DESCRIPTION     "Either FGS or AST, for FGS obslogs or astrometry,
                         respectively."

    END_FIELD

    FIELD  ccs_number
        TYPE            I4
        DESCRIPTION     "A positive value less than 64K defined by CCS for
                         every unique telemetry item in the engineering 
                         warehouse. It is the Numeric ID described in the
                         definition of FOF elements (see Appendix A of 
                         HST-ICD-T2). "
    END_FIELD

    FIELD  eng_number
        TYPE            I4
        DESCRIPTION     "A small positive value used only in FGS or AST eng
                         files. "
    END_FIELD

    FIELD  raw_flag
        TYPE            C1
        DESCRIPTION     "Y -- only use raw value, N -- use engineering value."

    END_FIELD
 
    FIELD  change_only
        TYPE            C1
        DESCRIPTION     "Y -- change-only item, N -- all-points item."

    END_FIELD

END_RECORD
 
 
!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------
 
 
RELATION  eng_telemetry
 
    TYPE             ENG_TELEMETRY_TYPE
 
    DESCRIPTION      "ENG Telemetry Definition Relation"
 
    SUBSYSTEM_USING  "OPUS"

    INDEX  eng_telemetry_1
        TYPE         unique, clustered
        FIELDS       eng_type,ccs_number
    END_INDEX

    INDEX  eng_telemetry_2
        TYPE         nonclustered
        FIELDS       eng_type,eng_number
    END_INDEX

END_RELATION