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

RECORD  GSA_DATA_TYPE
 
!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------
 
 
DESCRIPTION       "This relation is used to identify the full time range of the
                   planned Guide Star acquisition, and to report results of the
                   actual acquisition. The first three fields are populated
                   when the record is inserted into the table and the remaining
                   fields are updated after gs acqisition processing. "

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

    FIELD  gsa_rootname
        TYPE            C14
        DESCRIPTION     "GYYYYDDDHHMMSS where the time values match the 
                         gsa_start_time."
    END_FIELD

    FIELD  gsa_start_time
        TYPE            C17
        DESCRIPTION     "YYYY.DDD:HH:MM:SS, Commanded start of the GSACQ1 or
                         REACQ event."
    END_FIELD

    FIELD  gsa_end_time
        TYPE            C17
        DESCRIPTION     "YYYY.DDD:HH:MM:SS, Allocated end of the REACQ
                         event, or the end of the GSACQ1 event if num_pair is
                         1, or end of the GSACQ2 event if num_pair is 2."

    END_FIELD

    FIELD  acq_success_time
        TYPE            C17
        DESCRIPTION     "YYYY.DDD:HH:MM:SS, time of the start of FGS guiding
                        when takedata flag is first raised during the 
                        acquistion or blank if no telemetry or acq failure. "
    END_FIELD

    FIELD guiding_mode
        TYPE            C2
        DESCRIPTION     "Guiding mode at end of acquisition. GY - gyro, 
                         FL - fine lock on both stars, FG - fine lock/gyro,
                         CT - coarse track on both stars, CG - coarse track/
                         gyro. CT and CG are no longer allowed but old
                         schedules allowed these modes. "
    END_FIELD

    FIELD acq_status
        TYPE            C12
        DESCRIPTION     "GSFAIL keyword value or blank. The non-blank values
                         are: TLMGAP - unknown due to missing telemetry;
                         VEHSAFE - not attempted due to safing; SSLEXP -
                         scan step limit exceeded on primary GS; SSLEXS -
                         scan step limit exceeded on secondary GS; SREXCPn -
                         search radius exceeded on primary GS of pair n;
                         SREXCSn - search radius exceeded on secondary GS of
                         pair n;  NOLOCK - failed to obtain finelock on either
                         GS. "
    END_FIELD

    FIELD acq_tlm_gap 
        TYPE            R4
        DESCRIPTION     "(Seconds) time of telemetry gap that overlaps 
                        the acquisition window between gsa_start_time and 
                        gsa_end_time. "
    END_FIELD

    FIELD actual_pair_num 
        TYPE            I4
        DESCRIPTION     " -1 = undetermined, 0 - failure, 1 - first pair is
                        acquired, or 2 - second pair is acquired. "
    END_FIELD

    FIELD acq_dom_fgs 
        TYPE            I4
        DESCRIPTION     "Dominant FGS number or 0, after acquisition. A zero
                         value indicates a total failure."
    END_FIELD

    FIELD acq_rol_fgs 
        TYPE            I4
        DESCRIPTION     "Roll FGS number or 0, after acquisition. A zero 
                         value is either a planned FGS/GYRO mode or a
                         failure to acquire both GSs."
    END_FIELD

END_RECORD
 
 
!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------
 
 
RELATION  gsa_data
 
    TYPE             GSA_DATA_TYPE
 
    DESCRIPTION      "GS Acq Data Relation"
 
    SUBSYSTEM_USING  "OPUS"

    INDEX  gsa_data_1
        TYPE         unique, clustered
        FIELDS       gsa_rootname
    END_INDEX

    INDEX  gsa_data_2
        TYPE         nonclustered
        FIELDS       gsa_start_time
    END_INDEX

END_RELATION