!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:    CCAJ_ACS_REF
!
! Purpose:      This SDDL file defines the CCAJ_ACS_REF relation.
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ---   -------------------------------------------------
! 01/12/99    37347     Rose  Original implementation
! 09/07/00    42184     MSwam Add FLASHCUR, SHUTRPOS for ACS post-flash
! 11/20/01    44785     MSwam Add OBSTYPE
! 04/17/02    45590     MSwam Add NAXIS1,2 and LTV1,2
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!

LANGUAGE        SQL

RECORD  CCAJ_ACS

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

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

		Each reference file keyword in the primary header of the
		ACS 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  detector
        TYPE            C3
        DESCRIPTION     "Which detector was used for the exposure"
        RANGE           WFC, HRC, SBC
    END_FIELD

    FIELD  ccdamp
        TYPE            C4
        DESCRIPTION     "Which CCD amp was used for the readout"
        RANGE           A---, -B--, --C-, ---D, A-C-, A--D, -BC-, -B-D, ABCD
    END_FIELD

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

    FIELD  filter1
        TYPE            C10
        DESCRIPTION     "Which was the first filter used for the exposure"
    END_FIELD

    FIELD  filter2
        TYPE            C10
        DESCRIPTION     "Which was the second filter used for the exposure"
    END_FIELD

    FIELD  flashcur
        TYPE            C4
        DESCRIPTION     "Post flash current level"
        RANGE           OFF, LOW, MED, HIGH
    END_FIELD

    FIELD  shutrpos
        TYPE            C5
        DESCRIPTION     "Post flash shutter position"
        RANGE           A, B, LEFT, RIGHT
    END_FIELD          

    FIELD  obstype
        TYPE            C14
        DESCRIPTION     "Observation type"
        RANGE           IMAGING, INTERNAL, CORONAGRAPHIC
    END_FIELD          

    FIELD  naxis1
        TYPE            I4
        DESCRIPTION     "the first axis dimension"
    END_FIELD

    FIELD  naxis2
        TYPE            I4
        DESCRIPTION     "the second axis dimension"
    END_FIELD

    FIELD  ltv1
        TYPE            R4
        DESCRIPTION     "offset in X to subsection start"
    END_FIELD

    FIELD  ltv2
        TYPE            R4
        DESCRIPTION     "offset in Y to subsection start"
    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  ccaj_acs_ref

    TYPE             CCAJ_ACS

    DESCRIPTION      "ACS reference file selection criteria"

    SUBSYSTEM_USING  "OPUS"

    INDEX  ccaj_acs_ref_1
        TYPE         nonclustered
        FIELDS       use_after
    END_INDEX

END_RELATION

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


INSTANCE  ccaj_acs_ref

    GLOBAL

    TYPE        CCAJ_ACS

END_INSTANCE