!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:    NIC_SAA_DARK.SDDL
!
! Purpose:      This SDDL file defines the NIC_SAA_DARK relation.
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ---   -------------------------------------------------
! 03/03/00   40279      Baum  Original implementation
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!

LANGUAGE        SQL

RECORD  SAA_DARK_TYPE

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

DESCRIPTION       "This relation is used to identify NICMOS associations 
                   containing Post-SAA dark exposures. The records are
                   created for all such associations whether or not there are
                   any exposures that use it. There is a separate record for
                   each NICMOS configuration and saa_exit time. The relation
                   is used to allow the linkage of NICMOS exposures to SAA
                   darks that may occur in a previous (replan) SMS. Records
                   having saa_exit_hour values that are a few weeks old have
                   no operational value and may be deleted at any time. There
                   is no reason to archive any of these records. " 

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

    FIELD  saa_exit_hour
        TYPE            C11
        DESCRIPTION     "YYYY.DDD:HH -- This is the hour at which the saa
                         exit occurs. If the exit time is near an hour 
                         boundary, a second record with the adjacent hour
                         is also present. This field is used to match with
                         the first 11 characters of nic_saa_exit.saa_exit
                         to create the nic_saa_link records. "
    END_FIELD

    FIELD  config
        TYPE		C15

        DESCRIPTION "This is the value from qelogsheet.config that must be
                    the same for both exposures of the association. The same
                    value must match any qelogsheet.config for linked 
                    exposures in nic_saa_link. There should be three records
                    with different config values for each value of
                    saa_exit_hour. "
    END_FIELD

    FIELD  program_id
        TYPE		C3

        DESCRIPTION "The program_id of the dark association. See 
                    asn_product_link.program_id. "
    END_FIELD

    FIELD  obset_id
        TYPE		C2

        DESCRIPTION "Association observation set identifier of the dark
                    association. See asn_product_link.asn_obset_id. " 
    END_FIELD

    FIELD member_num
        TYPE         C3
        DESCRIPTION  "Member number of the dark association primary product.
                     See asn_product_link.member_num. "
    END_FIELD

END_RECORD

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

RELATION  nic_saa_dark

    TYPE             SAA_DARK_TYPE

    DESCRIPTION      "NICMOS SAA Dark Association Relation"

    SUBSYSTEM_USING  "OPUS"

    INDEX  nic_saa_dark_1
        TYPE         unique, clustered
        FIELDS       saa_exit_hour,config
    END_INDEX

    INDEX  nic_saa_dark_2
        TYPE         nonclustered
        FIELDS       program_id,obset_id,member_num,saa_exit_hour
    END_INDEX

END_RELATION