!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:    CCAO_STIS_REF
!
! Purpose:      This SDDL file defines the CCAO_STIS_REF relation.
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ---   -------------------------------------------------
! 07/02/96    28182     Rose  Original implementation
! 12/16/96    32670     MSwam Added SCLAMP field
! 02/27/97    33036     MSwam Change length of SCLAMP (8 to 9 for DEUTERIUM)
! 05/06/97    34023     MSwam Change lengths of CCDAMP (4 to 3),
!                               DETECTOR (11 to 10), and OPT_ELEM (12 to 8).
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!

LANGUAGE        SQL

RECORD  CCAO_STIS

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

DESCRIPTION    "This relation specifies the parameters by which the various
		STIS reference files should be selected by the OPUS pipeline.

		Each reference file keyword in the primary header of the
		STIS science file must have a value. While it would make
		more sense to have a separate relation for each reference
		file type, the CDBS design did not allow this.  Thus all
		selection criteria for all file types are contained in this
		relation.

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

    FIELD  filetype
        TYPE            C8
        DESCRIPTION     "Name of the filetype.  eg DARKFILE"
    END_FIELD

    FIELD  detector
        TYPE            C10
        DESCRIPTION     "Which detector was used for the exposure"
        RANGE           NUV-MAMA, FUV-MAMA, CCD
    END_FIELD

    FIELD  ccdamp
        TYPE            C3
        DESCRIPTION     "Which CCD amp was used for the readout"
        RANGE           A,B,C,D,N/A
    END_FIELD

    FIELD  ccdgain
        TYPE            I4
        DESCRIPTION     "the CCD amp gain"
	RANGE		1,2,4,8
    END_FIELD

    FIELD  opt_elem
        TYPE            C8
        DESCRIPTION     "Which optical element was used for the exposure"
    END_FIELD

    FIELD  cenwave
        TYPE            I4
        DESCRIPTION     "Central wavelength"
    END_FIELD

    FIELD  obstype
	TYPE		C16
	DESCRIPTION	"Mode of the current observation"
	RANGE		IMAGING, SPECTROSCOPIC
    END_FIELD

    FIELD  aperture
	TYPE		C16
	DESCRIPTION	"aperture used for the current observation"
    END_FIELD

    FIELD  binaxis1
        TYPE            I4
        DESCRIPTION     "binning factor for axis1"
    END_FIELD

    FIELD  binaxis2
        TYPE            I4
        DESCRIPTION     "binning factor for axis2"
    END_FIELD

    FIELD  ccdoffst
        TYPE            I4
        DESCRIPTION     "CCD Offset"
    END_FIELD

    FIELD  sclamp
	TYPE		C9
	DESCRIPTION	"which calibration lamp was used"
    END_FIELD

    FIELD  data_file           
        TYPE            C20
        DESCRIPTION     "Reference file name."
    END_FIELD

    FIELD  load_time           
        TYPE            C20
        DESCRIPTION	"Date when this record was added"
    END_FIELD

    FIELD  use_after           
        TYPE            C17
        DESCRIPTION     "Observations executed after this 'use_after' date
                         use this tuple in the relation."
        RANGE           YYYY.DDD:HH:MM:SS
    END_FIELD

END_RECORD

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


RELATION  ccao_stis_ref

    TYPE             CCAO_STIS

    DESCRIPTION      "STIS reference file selection criteria"

    SUBSYSTEM_USING  "OPUS"

    INDEX  ccao_stis_ref_1
        TYPE         nonclustered
        FIELDS       use_after
    END_INDEX

END_RELATION

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


INSTANCE  ccao_stis_ref

    GLOBAL

    TYPE        CCAO_STIS

END_INSTANCE