!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:    ASN_ASSOCIATION.SDDL
!
! Purpose:      This SDDL file defines the ASN_ASSOCIATION relation.
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ---   -------------------------------------------------
! 05/10/99   39260      Baum  Original implementation
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!

LANGUAGE        SQL

RECORD  ASN_ASSOC_TYPE

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

DESCRIPTION       "This relation is used to provide attributes that apply to
                   entire associations.

                   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.

                   This is one of the relations used to define 
                   associations for OPUS. ASN_MEMBERS and ASN_PRODUCT_LINK
                   are the others relations."


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

    FIELD  association_id
        TYPE 	C9

        DESCRIPTION "This field identifies an OPUS association.   An
                    association is a set of exposures that will be
                    merged into products by OPUS pipeline calibration
                    processing. The full association consists of a
                    list of exposures and products.  

                    This field completely identifies an association. This is 
                    the OPUS value used for the keyword ASN_ID.  It has the
                    following format:

                           IPPPSSAAa

                    where:
                           I = instrument code
                               (e.g., N for NICMOS, O for STIS),
                         PPP = program_id
                          SS = obset_id of the first associated exposure,
                         AAa = the two-character sequence (AA = 01,02,...)
                               is unique within the obset SS;
                               plus the product id (a) that is always
                               0 for associations and primary products."
    END_FIELD

    FIELD  si_name
	TYPE		C4

        DESCRIPTION "This is the identifier type for a Science Instrument (SI).
                    The SI list includes the:
                       FOC  - Faint Object Camera
                       FOS  - Faint Object Spectrograph
                       WFII - Wide Field Planetary Camera 2
                       HRS  - High Resloution Spectrograph
                       CSTR - COSTAR
                       FGS  - Fine Guidance Sensor
                       NIC  - NICMOS
                       STIS - Space Telescope Infrared Spectrograph
                       ACS  - Advanced Camera for Surveys
                       COS  - Cosmic Origins Spectrometer
                       WF3  - Wide Field Planetary Camera 3"
    END_FIELD

    FIELD  last_exp_date
        TYPE 		C17   

        DESCRIPTION "This field contains the latest predicted time of the
                    exposure members of an association. It uses the standard
                    SOGS time format - yyyy.ddd:hh:mm:ss
                    where yyyy = year
                          ddd = day of year
                          hh = hours
                          mm = minutes
                          ss = seconds"
    END_FIELD
 
    FIELD  collect_date
        TYPE 		C17   

        DESCRIPTION "This field contains the date of the association file 
	            created by OPUS. It uses the standard SOGS time
                    format - yyyy.ddd:hh:mm:ss
                    where yyyy = year
                          ddd = day of year
                          hh = hours
                          mm = minutes
                          ss = seconds"
    END_FIELD
 
END_RECORD

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


RELATION  asn_association

    TYPE             ASN_ASSOC_TYPE

    DESCRIPTION      "Association Relation"

    SUBSYSTEM_USING  "OPUS", "DADS"

    INDEX  asn_association_1
        TYPE         unique, clustered
        FIELDS       association_id
    END_INDEX

    INDEX  asn_association_2
        TYPE         nonclustered
        FIELDS       last_exp_date
    END_INDEX

    INDEX  asn_association_3
        TYPE         nonclustered
        FIELDS       si_name, last_exp_date
    END_INDEX
END_RELATION