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

RECORD  MSC_AST_OBSET_TYPE
 
!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------
 
 
DESCRIPTION       "This relation is used to contain the obset level data for
                   astrometry. The event time is taken from the time found in
                   the MSC file but there is no msc_events record for this
                   event. The fields are used to set astrometry keywords. "

!------------------------------------------------------------------------------
!
!   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 fgs
        TYPE        C1
        DESCRIPTION "FGS number, 1 2 or 3, or 0 for all."
    END_FIELD

    FIELD param_name
        TYPE        C8
        DESCRIPTION "Keyword name or keyword related parameter name."
    END_FIELD

    FIELD param_value
        TYPE        C20
        DESCRIPTION "Formatted value of parameter."
    END_FIELD


END_RECORD
 
 
!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------
 
 
RELATION  msc_ast_obset
 
    TYPE             MSC_AST_OBSET_TYPE
 
    DESCRIPTION      "Astrometry obset keyword data from MSC file"
 
    SUBSYSTEM_USING  "OPUS"

    INDEX  msc_ast_obset_1
        TYPE         unique, clustered
        FIELDS       event_time, program_id, obset_id, fgs, param_name
    END_INDEX

    INDEX  msc_ast_obset_2
        TYPE         nonclustered
        FIELDS       program_id, obset_id, fgs, param_name
    END_INDEX

END_RELATION