!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:	ENG_DATASET_PADS.SDDL
!
! Purpose:      This SDDL file defines the ENG_DATASET_PADS relation.
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ----   ------------------------------------------------
! 06/21/01    44862     Baum   Original implementation
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!
 
LANGUAGE	SQL

RECORD  ENG_DATASET_PADS_TYPE
 
!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------
 
 
DESCRIPTION       "This relation is used to store constant parameters for each
                   SI and exposure type, used to pad time boundaries based
                   on planned exposure times in qolink_sms. For any SI or 
                   exposure type not in this table, the values will all be 
                   defaulted to zero, which will cause the telemetry to be
                   selected only on the planned time. The general formula
                   for padded start or end time is:
                     padded_time = planned_time + pad*60
                   The pad value is in integer minutes and it is negative
                   for start times and positive for end times. No pads are 
                   defined for CAL exposures since these are internal. "

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

    FIELD  inst
        TYPE            C1
        DESCRIPTION     "Instrument code: same as first character of rootname."

    END_FIELD

    FIELD  exp_type
        TYPE            C3
        DESCRIPTION     "Values used in qexposure.type: SCI, TAQ."
    END_FIELD


    FIELD  start_pad
        TYPE            I4
        DESCRIPTION     "Minutes to be added to determine the padded start
                         time. Usually a negative value added to planned
                         time."

    END_FIELD


    FIELD  end_pad
        TYPE            I4
        DESCRIPTION     "Minutes to be added to determine the padded end
                         time. Usually a positive value added to planned
                         time."

    END_FIELD

END_RECORD
 
!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------
 
 
RELATION  eng_dataset_pads
 
    TYPE             ENG_DATASET_PADS_TYPE
 
    DESCRIPTION      "Time pads to support mapping ENG telemetry to datasets."
 
    SUBSYSTEM_USING  "OPUS"

    INDEX  eng_dataset_pads_1
        TYPE         unique, clustered
        FIELDS       inst, exp_type
    END_INDEX

END_RELATION