!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:    QEASSOCIATION.SDDL
!
! Purpose:      This SDDL file defines the QEASSOCIATION relation.
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ---   -------------------------------------------------
! 02/27/96   30902      Baum  Original implementation
! 04/03/96   30902      JB    Final requirements
! 04/11/96   30954      JB    Description modifications, field name expansion
! 04/15/96   30954      MRB   Description and field name modifications with EGB
! 04/25/96   30954.1    MRB   Description modifications from Rose
! 06/21/96   31689      SFS   Reorganize - use 9-char id, reorder fields and
!                             index
! 11/03/99   39993      MRB   Removed product_id, collect_date, member_name
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!

LANGUAGE  C, FORTRAN, SQL

INCLUDE  ZSPSS_USER_TYPES.SDDL

RECORD  QEASSN_TYPE

!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------

DESCRIPTION       "This relation is used to define the set of exposures that
                   form an OPUS association.

                   An association is a set of exposures that will be merged 
                   into products by OPUS pipeline. The full association 
                   consists of a list of exposures and products.  STIS can 
                   only have one product per association.  NICMOS can have 
                   as many as nine products.

                   If an exposure has a record in this table with the COLLECT 
                   field set to Y, then OPUS will wait for all observations 
                   in the association to be processed into an associated data 
                   set before archiving. In OPUS the associated exposures will 
                   be defined by a file with the type .ASN.  

                   This relation will also contain association product 
                   information populated by OPUS.  An association product is
                   is a dataset, distinct from any exposure dataset, that
                   is generated by the pipeline.  Exposures are associated 
                   in order to generate products.  

                   This relation is populated by TRANS (defines the exposure to 
		   association mapping), and OPUS (defines product to 
		   association mapping), and used by SPSS (just a copy and
		   delete _prior_ to scheduling), and finally it is replicated
                   into DADS.

                   For more information refer to the TRANS Scripting Guide. "

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

    FIELD  association_id
        TYPE            OPUS_ASSOCIATION_ID_TYPE
    END_FIELD

    FIELD  proposal_id
        TYPE            PROPOSAL_ID_TYPE
    END_FIELD

    FIELD  obset_id
        TYPE            OBSET_ID_TYPE
    END_FIELD

    FIELD  alignment_id
        TYPE            ALIGN_ID_TYPE
    END_FIELD

    FIELD  exposure_id
        TYPE            EXPOSURE_ID_TYPE
    END_FIELD

    FIELD  version_num
        TYPE            VERSION_NUM_TYPE
    END_FIELD

    FIELD  si_name
        TYPE            SI_ID_TYPE
    END_FIELD

    FIELD  exp_type   
        TYPE            C12
        DESCRIPTION     "This field describes the role of the exposure in the
                         association. Valid values for STIS are (SCIENCE,
                         CRSPLIT, REPEATOBS, AUTO-WAVECAL, GO-WAVECAL,
                         ENG-WAVECAL, ACQ, ACQ/PEAK). Valid values for NIC are
                         (SOURCE, BACKGR1, BACKGR2, ..., BACKGR20).  

		  	 For products other values may be used to describe the
                         product type. Note this is not to be confused with
			 qexposure.type field since it is the role of exposure 
			 in the association and not a property of the 
			 exposure itself."
    END_FIELD

    FIELD  collect
        TYPE            YES_NO_FLAG_TYPE
        DESCRIPTION     "This field controls OPUS collection, with:

                           'Y' indicating inclusion and 
                           'N' indicating exclusion from the collected dataset. 
                           ' ' indicates a product record

                         At least two exposures with the same association_id 
			 must have this field set to Y in order for OPUS to 
                         process this association. 

                         Default values are set by TRANS to be overridden by
                         OPUS operations staff. Every exposure having the same 
			 association_id may have this field set to N but 
                         typically, every exposure having the same 
			 association_id will have this field set to Y.  For 
			 products this field is left blank."           

    END_FIELD

END_RECORD


!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------


RELATION  qeassociation

    TYPE             QEASSN_TYPE

    DESCRIPTION      "Exposure Association Relation"

    SUBSYSTEM_USING  "SPSS", "TRANS", "OPUS", "DADS", "REPLICATION-FROM-SOGS"

    RELATED_FIELDS   "qexposure.*"

    INDEX  qeassociation_1
        TYPE         unique, clustered
        FIELDS       association_id, proposal_id, obset_id, 
                     alignment_id, exposure_id, version_num
    END_INDEX

    INDEX  qeassociation_2
        TYPE         nonclustered
        FIELDS       proposal_id, obset_id, alignment_id, 
                     exposure_id, version_num
    END_INDEX
    INDEX  qeassociation_3
        TYPE         nonclustered
        FIELDS       association_id
    END_INDEX

END_RELATION

!------------------------------------------------------------------------------
!
!   INSTANCE DECLARATION
!
!------------------------------------------------------------------------------


INSTANCE  qeassociation

    GLOBAL

    TYPE        QEASSN_TYPE

END_INSTANCE