Go to the bottom.
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:	QELOGSHEET.SDDL
!
! Purpose:      This SDDL file defines the qelogsheet relation.
!
! Modification History:
!
!   Date       PR      Who                       Reason
! --------   -------   ---   -------------------------------------------------
! 11/16/94   27329     NLC/   Original implementation
!                      RSL
! 04/27/97   19751     MRB    Improve indicies, add infor about obsolete fields
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!
 
LANGUAGE	C, FORTRAN, SQL

INCLUDE         ZSPSS_USER_TYPES.SDDL
 
RECORD  QELGSH_TYPE
 
!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------
 
   DESCRIPTION    "This relation is closely related to the fields (columns) 
                  on the proposal Exposure Logsheet. The Logsheet is used
                  to define the proposed exposures for the Scientific 
                  Instruments (SI)s. An exposure consists of the events and 
                  data resulting from a single execution of the observation 
                  defined on a Logsheet line. For each Logsheet line there
                  may be many qelogsheet records. Every qelogsheet record
                  has a corresponding qexposure record.

		  This relation is used in SI commanding. It is populated
                  by TRANS, and used by SPSS and Instruction Management 
		  during SMS generation. 

                  The ORBIT program accesses the relation when selecting
                  the target name for an alignment.
 
                  The FOV program also accesses the relation when selecting
                  the target name for an alignment.

		  For more information refer to the Phase II Proposal 
                  Instructions and the TRANS Scripting Guide."

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

    FIELD  proposal_id
        TYPE PROPOSAL_ID_TYPE
        FORM
            NAME         "EEL"
            LABEL        "Proposal Id:"
        END_FORM
    END_FIELD
 

    FIELD  obset_id
        TYPE OBSET_ID_TYPE
        FORM
            NAME         "EEL"
            LABEL        "Obset Id:"
        END_FORM
    END_FIELD
 

    FIELD  alignment_id
        TYPE ALIGN_ID_TYPE
        FORM
            NAME         "EEL"
            LABEL        "Alignment Id:"
        END_FORM
    END_FIELD
 

    FIELD  exposure_id
        TYPE EXPOSURE_ID_TYPE
        RELATED_FIELDS  "qexposure.exposure_id" "qelogsheet.exp"

        FORM
            NAME         "EEL"
            LABEL        "Exposure Id:"
        END_FORM
    END_FIELD
 

    FIELD  version_num
        TYPE VERSION_NUM_TYPE
        FORM
            NAME         "EEL"
            LABEL        "Version Num:"
        END_FORM
    END_FIELD
 

    FIELD  id
        TYPE            I4
        DESCRIPTION     "This field is the proposal identifier assigned 
                         by the proposal entry system (PEPSI, RPS2)."
        FORM
            NAME         "EEL"
            LABEL        "PEP Id:"
        END_FORM
    END_FIELD
 

    FIELD  exp
        TYPE            C15
        DESCRIPTION     "This field is the unique exposure identifier assigned 
                         by the proposal entry system (PEPSI, RPS2)."
        FORM
            NAME         "EEL"
            LABEL        "PEP Exp:"
        END_FORM
        RELATED_FIELDS  "qelogsheet.exposure_id"
    END_FIELD
 

    FIELD  linenum
        TYPE            C15
        DESCRIPTION     "This field is the logsheet line assigned by TRANS.
			 It is a unique key at the exposure level."
        FORM
            NAME         "EEL"
            LABEL        "Logsheet Line:"
        END_FORM
    END_FIELD
 

    FIELD  targname
        TYPE            C30
        DESCRIPTION     "This field is the name of the astronomical target 
                         for this exposure.                          

			 This field is set from the value on the proposal 
			 Exposure Logsheet. "
        FORM
            NAME         "EEL"
            LABEL        "Target Name:"
        END_FORM
    END_FIELD
 

    FIELD  seqname
        TYPE            C15
        DESCRIPTION     "This is an obsolete field. (but referenced by OPUS)"
    END_FIELD
 

    FIELD  seqline
        TYPE            C15
        DESCRIPTION     "This is an obsolete field. (but referenced by OPUS)"
    END_FIELD
 

    FIELD  config
        TYPE            C15
        DESCRIPTION     "This field specifies the instrument configuration
                         to be used for the execution of this exposure.  This
			 includes the instrument and (optionally) the 
                         instrument path.

                         This field is set from the value on the 
                         proposal Exposure Logsheet. "
        FORM
            NAME         "EEL"
            LABEL        "Instr. Config:"
        END_FORM
    END_FIELD
 

    FIELD  opmode
        TYPE            C15
        DESCRIPTION     "This field specifies the SI operating mode to be used
                         for the execution of this exposure.  The SI operating
			 mode must be one of the valid modes defined for the 
			 instrument configuration (config) to be used for 
			 this exposure.

			 This field is set from the value on the 
                         proposal Exposure Logsheet. "
        FORM
            NAME         "EEL"
            LABEL        "Operating Mode:"
        END_FORM
    END_FIELD
 

    FIELD  ap_1
        TYPE            C15
        DESCRIPTION     "This field is the first aperture, or field
                         of view, to be used for the execution of this
                         exposure.  

                         This field is set from the value on the 
                         proposal Exposure Logsheet. "
        FORM
            NAME         "EEL"
            LABEL        "Aperture No 1:"
        END_FORM
    END_FIELD
 

    FIELD  ap_2
        TYPE            C15
        DESCRIPTION     "This field is the second aperture, or field 
			 of view, to be used for the execution of this 
                         exposure.                          

                         This field is set from the value on the 
                         proposal Exposure Logsheet. "
        FORM
            NAME         "EEL"
            LABEL        "Aperture No 2:"
        END_FORM
    END_FIELD
 

    FIELD  ap_3
        TYPE            C15
        DESCRIPTION     "This field is the third aperture, or field 
			 of view, to be used for the execution of this 
                         exposure.

                         This field is set from the value on the 
                         proposal Exposure Logsheet. "
        FORM
            NAME         "EEL"
            LABEL        "Aperture No 3:"
        END_FORM
    END_FIELD
 

    FIELD  ap_4
        TYPE            C15
        DESCRIPTION     "This field is the fourth aperture, or field 
			 of view, to be used for the execution of this 
                         exposure.

                         This field is set from the value on the 
                         proposal Exposure Logsheet. "
        FORM
            NAME         "EEL"
            LABEL        "Aperture No. 4:"
        END_FORM
    END_FIELD
 

    FIELD  sp_1
        TYPE            C20
        DESCRIPTION     "This field is the first spectral element to be used
                         for the execution of this exposure.  A spectral 
                         element is one of the following: 
                              a filter, grating, prism, polarizer, or mirror.

                         This field is set from the value on the 
                         proposal Exposure Logsheet. "
        FORM
            NAME         "EEL"
            LABEL        "Element No 1:"
        END_FORM
    END_FIELD
 

    FIELD  sp_2
        TYPE            C20
        DESCRIPTION     "This field is the second spectral element to be 
			 used for the execution of this exposure.  

                         This field is set from the value on the 
                         proposal Exposure Logsheet. "
        FORM
            NAME         "EEL"
            LABEL        "Element No 2:"
        END_FORM
    END_FIELD
 

    FIELD  sp_3
        TYPE            C20
        DESCRIPTION     "This field is the third spectral element to be 
			 used for the execution of this exposure.  

                         This field is set from the value on the 
                         proposal Exposure Logsheet. "
        FORM
            NAME         "EEL"
            LABEL        "Element No 3:"
        END_FORM
    END_FIELD
 

    FIELD  sp_4
        TYPE            C20
        DESCRIPTION     "This field is the fourth spectral element to be used
			 for the execution of this exposure.  

                         This field is set from the value on the 
                         proposal Exposure Logsheet. "
        FORM
            NAME         "EEL"
            LABEL        "Element No 4:"
        END_FORM
    END_FIELD
 

    FIELD  minwave
        TYPE            R*8
        DESCRIPTION     "This field is the minimum wavelength to be used
			 for the spectral observation.

                         This field is set from the value on the 
                         proposal Exposure Logsheet. "
        UNITS		 "ANGSTROMS"
        FORM
            NAME         "EEL"
            LABEL        "Min Wavelength:"
        END_FORM
    END_FIELD
 

    FIELD  maxwave
        TYPE            R*8
        DESCRIPTION     "This field is the maximum wavelength to be used 
			 for the spectral observation.

                         This field is set from the value on the 
                         proposal Exposure Logsheet. "
        UNITS		 "ANGSTROMS"
        FORM
            NAME         "EEL"
            LABEL        "Max Wavelength:"
        END_FORM
    END_FIELD
 

    FIELD  nexp
        TYPE            I4
        DESCRIPTION     "This field is the number of times the exposure
                         is to be iterated."
        FORM
            NAME         "EEL"
            LABEL        "One of _____ exposures"
       END_FORM
    END_FIELD
 

    FIELD  exptime
        TYPE            R*8
        DESCRIPTION     "This field is the total time, in seconds, for 
                         one execution of this exposure.  The time is
                         dependant on the particular SI, and includes:  
			     actual exposure time, 
			     dead time (for the FOS), and 
                             exposure overhead times (i.e. the time to 
			     execute the commands to start and stop the 
			     exposure)."  
        UNITS		"SECONDS"
        FORM
            NAME         "EEL"
            LABEL        "exposure time = _____ .  (sec) ."
        END_FORM
    END_FIELD
 

    FIELD  sn
        TYPE            R*8
        DESCRIPTION     "Taken from observer-specified signal-to-noise. 
                         This is an obsolete field."
    END_FIELD
 

    FIELD  sn_time
        TYPE            R*8
        DESCRIPTION     "sn_time is normally set to the exposure time.
                         This is an obsolete field."
    END_FIELD
 

    FIELD  flxn_1
        TYPE            I4
        DESCRIPTION     "This is an obsolete field. Refer to PR 34055."
    END_FIELD
 

    FIELD  flxn_2
        TYPE            I4
        DESCRIPTION     "This is an obsolete field. Refer to PR 34055."
    END_FIELD
 

    FIELD  flxn_3
        TYPE            I4
        DESCRIPTION     "This is an obsolete field. Refer to PR 34055."
    END_FIELD
 

    FIELD  flxn_4
        TYPE            I4
        DESCRIPTION     "This is an obsolete field. Refer to PR 34055."
    END_FIELD
 

    FIELD  prio
        TYPE            I4
        DESCRIPTION     "This is an obsolete field. Refer to PR 34055."
    END_FIELD
 
END_RECORD
 
!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------
 
RELATION  qelogsheet
 
    TYPE             QELGSH_TYPE
 
    DESCRIPTION      "Exposure Logsheet Relation"
 
    SUBSYSTEM_USING  "SPSS", "PEPSI", "TRANS"

    RELATED_FIELDS  "qexposure.*"

    FORM
        NAME         "EEL"
    END_FORM
 
    INDEX  qelogsheet_1
        TYPE         unique, clustered
        FIELDS       proposal_id, obset_id, alignment_id, 
                     exposure_id, version_num
    END_INDEX
 
    INDEX  qelogsheet_2
        TYPE         unique, nonclustered
        FIELDS       id, exp, proposal_id, version_num, obset_id, 
                     alignment_id, exposure_id
        ATTRIBUTES   ignore_dup_key
    END_INDEX
 
END_RELATION
 
!------------------------------------------------------------------------------
!
!   INSTANCE DECLARATION
!
!------------------------------------------------------------------------------
 
INSTANCE  qelogsheet
 
    GLOBAL
 
    TYPE        QELGSH_TYPE
 
END_INSTANCE

Go to the top.