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

LANGUAGE        SQL

RECORD  SAA_LINK_TYPE

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

DESCRIPTION       "This relation is used to link NICMOS exposures to the
                   SAA dark association that is relevant to the exposure. If
                   no record exists, then either the exposure is an SAA dark
                   or the exposure occurs too long after the SAA exit time.
                   The individual exposures of the associations can be accessed
                   through the asn_product_link table. All the timing info for 
                   both the exposures and the darks are found in the 
                   nic_saa_exit table. 

                   For records in this table, the dark association must have 
                   nearly the same saa_exit time (from NIC_SAA_EXIT table) as
                   the exposure. That is, the most recent SAA exit for both the
                   darks and the exposures must be in the same orbit. 
                   The exposure from the dark association must have the same 
                   qelogsheet.config value.  The qelogsheet.targname value
                   for the dark exposures will be POST-SAA-DARK. 

                   The records in this table are inserted during the processing
                   of the mission schedule, after updating the the asn tables. "

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

    FIELD  program_id
        TYPE		C3

        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.  This program
                    identifier is tagged as 'program_id' in most PMDB relations.
                    Is 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
        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.

                    An observation set is identified by a 2 character base 36
                    string.  This field,  typically called 'obset_id', will
                    often contribute to the index on relation together with a
                    proposal_id, version_num, and possibly other fields.

                    OBSET is an abbreviation for observation set."
    END_FIELD

    FIELD ob_number
        TYPE         C2
        DESCRIPTION  "Observations are numbered sequentially throughout
                     an observation set and are assigned by SMS/Gen.
                     An ob_number is _NOT_ the same as an obset_ID.
                     This field can be joined to member_num for 
                     exposure records in asn_members."
    END_FIELD

    FIELD  dark_program_id
        TYPE		C3

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

    FIELD  dark_obset_id
        TYPE		C2

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

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

    FIELD dark_association
        TYPE         C9
        DESCRIPTION  "This is a convenience field. It can be reconstructed
                     from the letter N, the dark_program_id, the 
                     dark_obset_id, and the dark_member_num. See 
                     asn_members for complete definition of association_id. "
    END_FIELD

END_RECORD

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

RELATION  nic_saa_link

    TYPE             SAA_LINK_TYPE

    DESCRIPTION      "NICMOS SAA Link Relation"

    SUBSYSTEM_USING  "OPUS"

    INDEX  nic_saa_link_1
        TYPE         unique, clustered
        FIELDS       program_id, obset_id, ob_number
    END_INDEX

    INDEX  nic_saa_link_2
        TYPE         nonclustered
        FIELDS       dark_program_id, dark_obset_id, dark_member_num
    END_INDEX

END_RELATION