!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:	WGOBSETS.SDDL
!
! Purpose:      This SDDL file defines the wgobsets relation.
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ---   -------------------------------------------------
! 10/31/94   27329      RSL   Original implementation
! 11/08/96   32087      sfs   Added "C" to LANGUAGE list
! 02/18/98   35442      sss   Added summary columns
! 11/02/98   37306      bao   Delete remnants of GSSS interface from SPSS
! 
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!
 
LANGUAGE	FORTRAN, C, SQL

INCLUDE         ZSPSS_USER_TYPES.SDDL
 
RECORD  OBSETS_TYPE
 
!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------
 
 
    DESCRIPTION       "The wgobsets relation stores guide star request and 
                      response tracking information and selected flags, 
                      for observation sets input to the SPSS command,
		      GS_REQUEST. 

                      GS_REQUEST inserts a record into wgobsets for each 
                      observation set that either is not in a previous 
                      acquisition sequence, or else starts a previous 
                      acquisition sequence. (A previous acquisition sequence
                      is a group of observation sets that uses the same guide
                      stars.) 

                      GS_REQUEST processes the request and generates a re-
		      sponse for each observation set. During the processing,
                      GS_REQUEST determines the setting of the following flags:

                         - valid request
                         - sparse field
                         - difficult acquisition
                      
                      Wgobsets is updated with the flag values, processing
		      summary information, and a time stamp."
                      
!------------------------------------------------------------------------------
!
!   FIELD INFORMATION
!
!------------------------------------------------------------------------------
 
 
    FIELD  proposal_id
        TYPE            PROPOSAL_ID_TYPE
        DESCRIPTION     "The proposal id is inserted by GS_REQUEST."
    END_FIELD
 
 
    FIELD  obset_id
        TYPE            OBSET_ID_TYPE
        DESCRIPTION     "The observation set id is inserted by GS_REQUEST."
    END_FIELD
 
 
    FIELD  version_num
        TYPE            VERSION_NUM_TYPE
        DESCRIPTION     "The version number is inserted by GS_REQUEST."
    END_FIELD
 
 
    FIELD  resp_date
        TYPE            TIME_STAMP_TYPE
        DESCRIPTION     "This is the time at which this relation was entered
			into the database. It corresponds to the time at which
			a valid response was entered into the database, or the 
			time at which the GS_REQUEST program stopped processing 
		        because an error was detected."

    END_FIELD
 
 
    FIELD  validity
        TYPE            YES_NO_FLAG_TYPE
        DESCRIPTION     "When there is a problem in the request data
                        pertaining to this observation set, the flag is
                        set to 'N'. 'Y' means there is no problem."
    END_FIELD
 
 
    FIELD  sparse_field
        TYPE            YES_NO_FLAG_TYPE
        DESCRIPTION     "'Y' means that there are too few guide star pairs 
                        available to support this observation set.  
                        'N' means that there is a sufficient number of
                        guide star pairs."
    END_FIELD
 
 
    FIELD  diff_acq
        TYPE            YES_NO_FLAG_TYPE
        DESCRIPTION     "If the acquisition probabilities for all GS pairs 
                        for this obset are below a given threshold,
                        then this is considered a difficult acquisition
                        and the difficult acquisition flag is set to 'Y'. If 
			at least one pair has an acquisition probability that 
			is greater than the threshold, the flag will be set to 
			'N'."
    END_FIELD

 
    FIELD  summary_1
        TYPE            C*80
        DESCRIPTION     "This field contains line 1 of a text description 
                         of the results from a guide star request.  The 
                         GS_REQUEST program populates this field with either 
                         an error message or a success message.  This field
                         can be displayed using the GUI interface in the
                         GS_REQUEST program."
    END_FIELD

    FIELD  summary_2
        TYPE            C*80
        DESCRIPTION     "This field contains line 2 of a text description" 
    END_FIELD
    FIELD  summary_3
        TYPE            C*80
        DESCRIPTION     "This field contains line 3 of a text description" 
    END_FIELD
    FIELD  summary_4
        TYPE            C*80
        DESCRIPTION     "This field contains line 4 of a text description" 
    END_FIELD
    FIELD  summary_5
        TYPE            C*80
        DESCRIPTION     "This field contains line 5 of a text description" 
    END_FIELD
    FIELD  summary_6
        TYPE            C*80
        DESCRIPTION     "This field contains line 6 of a text description" 
    END_FIELD
    FIELD  summary_7
        TYPE            C*80
        DESCRIPTION     "This field contains line 7 of a text description" 
    END_FIELD
    FIELD  summary_8
        TYPE            C*80
        DESCRIPTION     "This field contains line 8 of a text description" 
    END_FIELD
    FIELD  summary_9
        TYPE            C*80
        DESCRIPTION     "This field contains line 9 of a text description" 
    END_FIELD
    FIELD  summary_10
        TYPE            C*80
        DESCRIPTION     "This field contains line 10 of a text description" 
    END_FIELD

END_RECORD
 
 
!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------
 
 
RELATION  wgobsets
 
    TYPE             OBSETS_TYPE
 
    DESCRIPTION      "Guide Star Observation Set Request/Response Data Relation"
 
    SUBSYSTEM_USING  "SPSS"
 
    INDEX  wgobsets_1
        TYPE         unique, clustered
        FIELDS       proposal_id, obset_id, version_num
    END_INDEX
 
END_RELATION
 
!------------------------------------------------------------------------------
!
!   INSTANCE DECLARATION
!
!------------------------------------------------------------------------------
 
 
INSTANCE  wgobsets
 
    GLOBAL
 
    TYPE        OBSETS_TYPE
 
END_INSTANCE