!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:	HST_INSTRUMENTS.SDDL
!
! Purpose:      This SDDL file defines the HST_INSTRUMENTS relation.
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ----   ------------------------------------------------
! 11/16/99    39941     Baum   Original implementation
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!
 
LANGUAGE	SQL

RECORD  HST_INSTRUMENTS_TYPE
 
!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------
 
 
DESCRIPTION       "This relation is used to define the set of instruments
                   that are in place at the time of a status buffer
                   message. The names of instruments used in the telemetry
                   for status buffer messages are sometimes cryptic, like SI1.
                   This table can be used to interpret such values. The
                   names used here have the same values as the name in the
                   oms_status+message table. "

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




    FIELD  start_date
        TYPE            C8
        DESCRIPTION     "The installation day for the instrument. Format is
                         YYYY.DDD. "
    END_FIELD

    FIELD  bin_number
        TYPE            I4
        DESCRIPTION     "The HST instrument bin number in the range 1 to 5. "
    END_FIELD
	
    FIELD  name 
        TYPE            C6
        DESCRIPTION     "This one of the SI names used for the table
                         oms_status_message. The allowed values are FOC, FOS,
                         HRS, HSP, WFPC, COSTAR, WFPC2, NICMOS, STIS, ACS,
                         COS, and WFPC3. "
    END_FIELD

END_RECORD
 
 
!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------
 
 
RELATION  hst_instruments
 
    TYPE             HST_INSTRUMENTS_TYPE
 
    DESCRIPTION      "HST Instrument Configuration Relation"
 
    SUBSYSTEM_USING  "OMS"

    INDEX  hst_instruments_1
        TYPE         unique, clustered
        FIELDS       start_date, bin_number, name
    END_INDEX

END_RELATION