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

RECORD  BREATHING_COEFF_TYPE
 
!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------
 
 
DESCRIPTION       "This relation is used to specify the components of the
                   average temperatures used in breathing save files. The
                   temperatures in the averages are weighted by a coefficient
                   supplied in this table. The telemetry items are identified
                   by their CCS number. The long and short names of these
                   engineering telemetry temperatures can be found by joining
                   to the save_telemetry table with save_type set to BREATH
                   and matching ccs_number. "

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


    FIELD  temp_num
        TYPE            I4
        DESCRIPTION     "A numeric ID for the average temperature in the
                         breathing save file. It is also the sequence number
                         of the temperatures each record of the that file."
    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  temp_coeff
        TYPE            R8
        DESCRIPTION     "The normalized coefficient used to weight the average
                         for the telemetry item identified by the ccs_number. 
                         The average is the accumulation of the product of the
                         telemetry temperature times the coefficient. "
    END_FIELD

    FIELD  temp_name
        TYPE            C17
        DESCRIPTION     "The name of the temperature average."

    END_FIELD
 
END_RECORD
 
!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------
 
 
RELATION  breathing_coeff
 
    TYPE             BREATHING_COEFF_TYPE
 
    DESCRIPTION      "Breathing Temperature Coefficients Relation"
 
    SUBSYSTEM_USING  "OPUS"

    INDEX  breathing_coeff_1
        TYPE         unique, clustered
        FIELDS       temp_num,ccs_number
    END_INDEX

END_RELATION