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

RECORD  MSC_EVENTS_TYPE
 
!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------
 
 
DESCRIPTION       "This relation is used to contain the events of interest to
                   FGS processing that are extracted from the mission schedule,
                   the MSC file."

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


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

    FIELD  event_type
        TYPE            C3
        DESCRIPTION     "OPS for operational info; FGS for jitter; RTI for PCS 
                         events; RTO for offset slot data; TDR for TDRSS
                         COMCON events."
                         

    END_FIELD

    FIELD  event_class
        TYPE            C5
        DESCRIPTION     "      for OPR type classes
                               --------------------

                          BOM   begin mission schedule
                          EOM   end mission schedule

                               for FGS type classes
                               --------------------
                         
                          BOSn  begin slew of type n (n=1 to 4)
                          PCP   Pointing Control Processor
                          ORBIT related to HST orbit
                          BOA   begin GS acquisition or reacquisition
                          EOA   end GS acquisition or reacquisition

                                for RTI type classes
                                --------------------

                          EOS2  end slew of type 2
                          FHST3 fhst - start of 3-axis update
                         
                                for RTO type classes
                                --------------------
 
                          GEN   generate offset slot
                          REUSE reuse offset slot
                          SET   set offset slot
                          CLEAR clear offset slot

                                for TDR type classes
                                --------------------

                          BOC   begin COMCON
                          EOC   end COMCON
                          BRC   begin rejected COMCON
                          ERC   end rejected COMCON
                          BTC   begin trimmed COMCON
                          ETC   end trimmed COMCON "
    END_FIELD

    FIELD  event_name 
        TYPE            C10
        DESCRIPTION     "Format     Description
                         ---------- --------------------------------------
                         mmmmmmmmm  9-char MSC rootname for BOM and EOM
                         aaaaaaaaaa 10-char aperture name for BOSn,or EOS2
                         TERMINATE  PCP state
                         GYRO       PCP state
                         FGS_OCCULT PCP state
                         SAA        PCP state
                         ENTR_DAY   entering ORBIT day 
                         ENTR_NIGHT entering ORBIT night
                         GSACQ1     first acquisition for BOA and EOA
                         GSACQ2     second acquisition for BOA and EOA
                         REACQ      reacquisition for BOA and EOA
                         S_ss_pppoo RTO: ss is slot num, pppoo is obset
                         pppoo_ssss TDR: pppoo is obset, ssss is service "
    END_FIELD

END_RECORD
 
 
!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------
 
 
RELATION  msc_events
 
    TYPE             MSC_EVENTS_TYPE
 
    DESCRIPTION      "Mission Schedule Events"
 
    SUBSYSTEM_USING  "OPUS"

    INDEX  msc_events_1
        TYPE         unique, clustered
        FIELDS       event_time, event_type, event_class, event_name
    END_INDEX

END_RELATION