!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:    QOARCHIVES.SDDL     
!
! Purpose:      This SDDL file defines relation QOARCHIVES
!
! Modification History:
!
!   Date       OPR      Who                    Reason
!----------------------------------------------------------------------
! 18-SEP-96    31905    MARose         Original
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!

LANGUAGE        SQL

RECORD  QOARCH_TYPE 

!----------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!----------------------------------------------------------------------
!
   DESCRIPTION   "This SDDL file defines relation QOARCHIVES.  A record
                  is appended to this relation when the OPUS data 
                  partitioning process determines the name of the ipppssoot
                  from the science POD file.  Any pipeline process that
                  subsequently has trouble processing science data will
                  update the trouble_flag and trbl_process fields.  Archive 
                  processing updates a number of fields in QOARCHIVES."
  
!----------------------------------------------------------------------
!
!   FIELD INFORMATION
!
!----------------------------------------------------------------------

   FIELD  program_id
       TYPE            C*3
       DESCRIPTION     "Unique 3 character base 36 program identifier for
                        the proposal for which this observation is a part.
                        Used with the obset_id, ob_number, and data_class
                        fields to form the observation 'rootname', which 
                        uniquely identifies an observation."
       UNITS
   END_FIELD

   FIELD  obset_id
       TYPE            C*2
       DESCRIPTION     "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.  Part of the OPUS 
                        rootname."
       UNITS
   END_FIELD

   FIELD  ob_number
       TYPE            C*2
       DESCRIPTION     "Observations are numbered sequentially throughout
                        an observation set and are assigned by sms
                        (base 36 number max. 1295 observations per obset).
                        Part of the OPUS rootname."
       UNITS
   END_FIELD

   FIELD  data_class
       TYPE            C*1
       DESCRIPTION     "Type of data (R real-time, T tape-recorded, etc)."
       UNITS
   END_FIELD

   FIELD  obs_root
       TYPE            C*9
       DESCRIPTION     "The ipppssoot, where
                        
                        i   = instrument code (N - NICMOS
                                               O - STIS
                                               U - WFPC2
                                               V - HSP
                                               W - WFPC1
                                               X - FOC
                                               Y - FOS
                                               Z - HRS)
                        ppp = program_id
                        ss  = obset_id
                        oo  = ob_number
                        t   = data_class"
       UNITS
   END_FIELD

   FIELD  proc_strt_tm
       TYPE            C*16
       DESCRIPTION     "Time pipeline processing for this dataset.  Format
                        is yyyydddHHMMSSsss."
       UNITS
   END_FIELD

   FIELD  proc_stop_tm
       TYPE            C*16
       DESCRIPTION     "Time pipeline processing completed for this dataset.  
                        Format is yyyydddHHMMSSsss."
       UNITS
   END_FIELD

   FIELD  data_eval
       TYPE            I*4
       DESCRIPTION     "obsolete field??"
       UNITS
   END_FIELD

   FIELD  flg_mismatch
       TYPE            C*1
       DESCRIPTION     "archive flag for file count mismatches"
       UNITS
   END_FIELD

   FIELD  geis_only
       TYPE            C*1
       DESCRIPTION     "obsolete field??"
       UNITS
   END_FIELD

   FIELD  calib_indic
       TYPE            I*2
       DESCRIPTION     "obsolete field??"
       UNITS
   END_FIELD

   FIELD  trouble_flag
       TYPE            C*1
       DESCRIPTION     "Set to 'T' if observation sent to 'trouble'."
       UNITS
   END_FIELD

   FIELD  trbl_process
       TYPE            C*6
       DESCRIPTION     "Name of process that sent observation to 'trouble'."
       UNITS
   END_FIELD

   FIELD  edsci_file
       TYPE            C*9
       DESCRIPTION     "obsolete field??"
       UNITS
   END_FIELD

   FIELD  edt_archdate
       TYPE            C*20
       DESCRIPTION     "DADS ARCHDATE for EDT archive class.  Format is 
                        yyyydddHHMMSSsss."
       UNITS
   END_FIELD

   FIELD  edt_fcnt
       TYPE            I*2
       DESCRIPTION     "File count for EDT archive class."
       UNITS
   END_FIELD

   FIELD  calib_file
       TYPE            C*9
       DESCRIPTION     "obsolete field??"
       UNITS
   END_FIELD

   FIELD  cal_archdate
       TYPE            C*20
       DESCRIPTION     "DADS ARCHDATE for CAL archive class.  Format is 
                        yyyydddHHMMSSsss."
       UNITS
   END_FIELD

   FIELD  cal_fcnt
       TYPE            I*2
       DESCRIPTION     "File count for CAL archive class."
       UNITS
   END_FIELD

   FIELD  cdbs_data
       TYPE            C*15
       DESCRIPTION     "obsolete field??"
       UNITS
   END_FIELD

   FIELD  repro_flg
       TYPE            C*10
       DESCRIPTION     "obsolete field."
       UNITS
   END_FIELD

END_RECORD

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!   RELATION DECLARATION
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

RELATION  qoarchives

    TYPE            QOARCH_TYPE

    DESCRIPTION     "History of science data processing for a given 
                     observation"

    SUBSYSTEM_USING "OPUS"

    INDEX  qoarchives_1      
        TYPE            clustered
        FIELDS        program_id, obset_id, ob_number
        ATTRIBUTES    ignore_dup_row
    END_INDEX

    INDEX  qoarchives_2      
        TYPE            nonclustered
        FIELDS        obs_root
    END_INDEX

    INDEX  qoarchives_3      
        TYPE            nonclustered
        FIELDS        proc_strt_tm
    END_INDEX

END_RELATION

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!   INSTANCE DECLARATION
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

INSTANCE  QOARCHIVES

    GLOBAL

    TYPE        QOARCH_TYPE

END_INSTANCE