!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:	OMS_TELEMETRY.SDDL
!
! Purpose:      This SDDL file defines the OMS_TELEMETRY relation.
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ----   ------------------------------------------------
! 10/19/99    39940     Baum   Original implementation
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!
 
LANGUAGE	SQL

RECORD  OMS_TELEMETRY_TYPE
 
!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------
 
 
DESCRIPTION       "This relation is used to define the values OMS needs to
                   identify engineering telemetry from CCS. This file must be
                   complete for all SIs and all servicing missions. The
                   CCS number must match those in the CCS 'golden' database of
                   historical telemetry mnemonics. The short OMS mnemonic is
                   used in OMS code and due to changes over time there may be
                   multiple long CCS mnemonic which have the same short
                   mnemonic. The OMS mnemonic and the OMS number must always
                   be the consistent when they appear multiple times. All
                   FOF-derived telemetry uses the CCS numbers in this file.
                   ALL AEDP-derived telemetry must use the pdb_telemetry_xref
                   table to get the CCS numbers needed to access this table. "

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

    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  oms_number 
        TYPE            I4
        DESCRIPTION     "This is a frozen index that identifies all the
                         telemetry items referenced in OMS software. Once
                         assigned to refer to a specific OMS telemetry mnemonic
                         it must not be reassigned to another. "

    END_FIELD
	
    FIELD  ccs_mnemonic
        TYPE            C8
        DESCRIPTION     "The mnemonic used by CCS and in CCS products. "

    END_FIELD

    FIELD  oms_mnemonic
        TYPE            C4
        DESCRIPTION     "The mnemonic used by OMS software and reports. It
                         is always of the form of an uppercase character and
                         a tree digit number. The first character always
                         matches the first character of the CCS mnemonic. 
                         Usually this mnemonic is the same as that used in 
                         shuttle software (called the MS_ID). "

    END_FIELD

    FIELD  parameter_type
        TYPE            C1
        DESCRIPTION     "C for 8-byte Character, R for 4-byte real, and I for
                         4-byte integer. "

    END_FIELD
 
    FIELD  units
        TYPE            C8
        DESCRIPTION     "For converted items: the engineering units."

    END_FIELD
 
    FIELD  description
        TYPE            C30
        DESCRIPTION     "A short description of the telemetry item. "

    END_FIELD

    FIELD  threshold
        TYPE            R4
        DESCRIPTION     "Used for OMS save files to determine minimum 
                         absolute difference form previous values to write
                         out a save record. Not used for character items. "

    END_FIELD

END_RECORD
 
 
!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------
 
 
RELATION  oms_telemetry
 
    TYPE             OMS_TELEMETRY_TYPE
 
    DESCRIPTION      "OMS Telemetry Definition Relation"
 
    SUBSYSTEM_USING  "OMS"

    INDEX  oms_telemetry_1
        TYPE         unique, clustered
        FIELDS       ccs_number
    END_INDEX

END_RELATION