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

RECORD  MSC_SLEW_SLOT_TYPE
 
!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------
 
 
DESCRIPTION       "This relation is used to contain the details of msc_events
                   of type RTO and class GEN taken from the MSC GEN-SLEW 
                   block. "

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


    FIELD  event_time
        TYPE            C20
        DESCRIPTION     "YYYY.DDD.HH.MM.SS.CC the time within a hundreth of
                         a second for each obset. "
    END_FIELD

    FIELD program_id
        TYPE        C3
        UNITS	    "BASE_36"
        DESCRIPTION "When a proposal is accepted into the PMDB by SPSS it must
		    be assigned a unique 3 character base 36 program identifier.
		    This is done by the PMDB/ACCEPT_PROP command.
                    It is used for identification of proposals by spacecraft 
                    and OPUS software. It is also used in the OPUS and DADS 
                    rootname for all archived science data files. 
                    Because of flight design software, program_id must be
                    three characters. "
    END_FIELD

    FIELD obset_id
        TYPE        C2
        UNITS	    "BASE_36"
        DESCRIPTION "An observation set is a collection of one or more 
		    alignments that are grouped together based on FGS pointing 
		    requirements.  That is, if multiple alignments can all be 
		    executed using the same guide star pair, they are grouped
		    into the same observation set. "
    END_FIELD

    FIELD slot
        TYPE        C3
        DESCRIPTION "Slot number"
    END_FIELD

    FIELD load_by
        TYPE        C17
        DESCRIPTION "YYYY.DDD:HH;MM:SS - load by date"
    END_FIELD

    FIELD max_slew
        TYPE        C3
        DESCRIPTION "formatted as integer arcsec - maximum slew angle"
    END_FIELD

    FIELD offset_id
        TYPE        C13
        DESCRIPTION "An identified used in the SPSS database"
    END_FIELD
END_RECORD
 
 
!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------
 
 
RELATION  msc_slew_slot
 
    TYPE             MSC_SLEW_SLOT_TYPE
 
    DESCRIPTION      "RTO GEN data from MSC file"
 
    SUBSYSTEM_USING  "OPUS"

    INDEX  msc_slew_slot_1
        TYPE         unique, clustered
        FIELDS       event_time, program_id, obset_id, slot
    END_INDEX

    INDEX  msc_slew_slot_2
        TYPE         nonclustered
        FIELDS       program_id, obset_id, slot
    END_INDEX

END_RELATION