!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:	PRODUCT_CODE.SDDL
!
! Purpose:      This SDDL file defines the product_code relation.
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ---   -------------------------------------------------
! 03/11/97   33526    Baum    Initial implementation
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
LANGUAGE        SQL

RECORD  PRODCODE_TYPE
 
!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------
 
 
    DESCRIPTION       "This relation is used to provide the tool, UPDATE_QODATA,
                       with a mechanism to assign a product_id and member_name
                       (of a product) for NICMOS or any that has multiple 
                       products. The product_id is correlated with the unique
                       value of EXP_TYPE in qeassociation table. This is a one
                       character product_id that supercedes the last character
                       of the association_id to form the member-name of a 
                       product."

!------------------------------------------------------------------------------
!
!   FIELD INFORMATION
!
!------------------------------------------------------------------------------
 
    FIELD  si_name
        TYPE         C4
        DESCRIPTION "This is the identifier type for a Science Instrument (SI).
		     The current SI list for qeassociation candidates are:

			NIC  - NICMOS - Near IR Camera - Multi-Object Spectr.
			STIS - Space Telescope Infrared Spectrograph

                     STIS only has one product_id but many exp_type values and
                     will not appear in this table."
    END_FIELD

    FIELD  exp_type   
        TYPE            C12
        DESCRIPTION     "This field describes the role of the exposure in the
                         association.  Valid values for NICMOS exposures are
                         (EXP-TARG, EXP-BCK1, EXP-BCK2, ..., EXP-BCK8)."  
    END_FIELD

    FIELD  product_id
        TYPE            C1
        DESCRIPTION     "This is the last character of an member_id of a
                         product. The first eight characters of the id are the
                         same as the association_id. The first product_id is 0
                         which forms a member_name that is the same as the 
                         association_id."
    END_FIELD

RELATION  product_code
 
    TYPE             PRODCODE_TYPE
 
    DESCRIPTION      "Assign product_id by exp_type."
 
    SUBSYSTEM_USING  "OPUS"
 
    INDEX  product_code_1
        TYPE         unique, clustered
        FIELDS       si_name, exp_type, product_id
    END_INDEX

END_RELATION
END_RECORD