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

RECORD  MSC_GS_ACQ_TYPE
 
!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------
 
 
DESCRIPTION       "This relation is used to contain the detailed parameters
                   of GS acquisition and reacquisition events. "

!------------------------------------------------------------------------------
!
!   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_name 
        TYPE            C10
        DESCRIPTION     "Format     Description
                         ---------- --------------------------------------
                         GSACQ1     first acquisition for BOA and EOA
                         GSACQ2     second acquisition for BOA and EOA
                         REACQ      reacquisition for BOA and EOA"
    END_FIELD

    FIELD  dom_fgs 
        TYPE            C1
        DESCRIPTION     "FGS number for  dominant GS"
    END_FIELD

    FIELD  prim_fgs 
        TYPE            C1
        DESCRIPTION     "FGS number for primary GS, that is acquired first"
    END_FIELD

    FIELD  rol_fgs 
        TYPE            C1
        DESCRIPTION     "FGS number for  roll GS"
    END_FIELD

    FIELD  dom_gs_ra 
        TYPE            R8
        DESCRIPTION     "Right ascension (degrees) for dominant GS"
    END_FIELD

    FIELD  dom_gs_dec 
        TYPE            R8
        DESCRIPTION     "Declination (degrees) for  dominant GS"
    END_FIELD

    FIELD  rol_gs_ra 
        TYPE            R8
        DESCRIPTION     "Right ascension (degrees) for roll GS or zero"
    END_FIELD

    FIELD  rol_gs_dec 
        TYPE            R8
        DESCRIPTION     "Declination (degrees) for  roll GS or zero"
    END_FIELD

    FIELD  dom_gs_mag 
        TYPE            R4
        DESCRIPTION     "(Vmag) brightness of dominant GS"
    END_FIELD

    FIELD  rol_gs_mag 
        TYPE            R4
        DESCRIPTION     "(Vmag) brightness of roll GS or zero"
    END_FIELD

    FIELD  dom_gs_id 
        TYPE            C10
        DESCRIPTION     "GSC ID of dominant GS"
    END_FIELD

    FIELD  rol_gs_id 
        TYPE            C10
        DESCRIPTION     "GSC ID of roll GS or blank if no GS"
    END_FIELD

    FIELD  tracking 
        TYPE            C2
        DESCRIPTION     "FL for finelock, CT for coarse track, FG for
                         finelock/gyro, and CG for coarse track/gyro.
                         CT and CG tracking modes are no longer used. "
    END_FIELD


END_RECORD
 
 
!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------
 
 
RELATION  msc_gs_acq
 
    TYPE             MSC_GS_ACQ_TYPE
 
    DESCRIPTION      "GS Acquisition Data from the MSC file"
 
    SUBSYSTEM_USING  "OPUS"

    INDEX  msc_gs_acq_1
        TYPE         unique, clustered
        FIELDS       event_time, event_name
    END_INDEX

END_RELATION