!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:	QBACQD_DEF.SDDL
!
! Purpose:      This SDDL file defines the qbacqd_def relation.
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ---   -------------------------------------------------
! 11/11/94    27329     RJS   Original implementation
! 05/23/96    27745     bao   Eliminate two-step GS acquisition support 
!			      from database and SPSS
! 11/12/97    35442     sfs   Add C to language list.  Add d_over_nr_off,
!                             d_over_nr_limit, and d_max_time_pts.
! 04/15/99    37931     sfs   Removed d_min_prob.
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!

LANGUAGE	C, FORTRAN, SQL

RECORD  QBACQD_TYPE

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


    DESCRIPTION       "The fields in relation QBACQD_DEF mirror the fields 
                      in relation QBACQS.  If an obset does not have a record
                      in QBACQS where
                          qbs_obset.scenario_acq = qbacqs.scenario_acq,
                      then the record in QBACQD_DEF with the matching
                      qbacqd_def.d_scenar_acq will be used.  An obset cannot
                      have a qbs_obset.scenario_acq that does not exist
                      in QBACQS or QBACQD_DEF.  The relation QBACQD_DEF
                      therefore specifies the default scenario acquisition
                      parameters for an obset."


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


    FIELD  d_scenar_acq
        TYPE            C8
        RELATED_FIELDS  "qbacqs.scenario_acq"
    END_FIELD


    FIELD  d_acq_mode
        TYPE            C1
        RELATED_FIELDS  "qbacqs.acq_mode"
    END_FIELD


    FIELD  d_use_fgs_1
        TYPE            C1
        RELATED_FIELDS  "qbacqs.use_fgs_1"
    END_FIELD


    FIELD  d_use_fgs_2
        TYPE            C1
        RELATED_FIELDS  "qbacqs.use_fgs_2"
    END_FIELD


    FIELD  d_use_fgs_3
        TYPE            C1
        RELATED_FIELDS  "qbacqs.use_fgs_3"
    END_FIELD


    FIELD  d_num_fgs
        TYPE            I4
        RELATED_FIELDS  "qbacqs.num_fgs"
    END_FIELD


    FIELD  d_sel_flag
        TYPE            C1
        RELATED_FIELDS  "qbacqs.select_flag"
    END_FIELD


    FIELD  d_pre_use
        TYPE            C1
        RELATED_FIELDS  "qbacqs.pre_use_flag"
    END_FIELD


    FIELD  d_min_gs_pr
        TYPE            I4
        RELATED_FIELDS  "qbacqs.min_gs_pair"
    END_FIELD


    FIELD  d_max_gs_pr
        TYPE            I4
        RELATED_FIELDS  "qbacqs.max_gs_pair"
    END_FIELD


    FIELD  d_max_spoil
        TYPE            R4
        RELATED_FIELDS  "qbacqs.max_spoiler"
    END_FIELD


    FIELD  d_mn_s_spl_p
        TYPE            R4
        RELATED_FIELDS  "qbacqs.min_s_spl_pr"
    END_FIELD


    FIELD  d_mn_d_spl_p
        TYPE            R4
        RELATED_FIELDS  "qbacqs.min_d_spl_pr"
    END_FIELD


    FIELD  d_mn_s_spl_s
        TYPE            R4
        RELATED_FIELDS  "qbacqs.min_s_spl_sc"
    END_FIELD


    FIELD  d_f1_min_gs_mag
        TYPE            R4
        RELATED_FIELDS  "qbacqs.f1_min_gs_mag"
    END_FIELD


    FIELD  d_f2_min_gs_mag
        TYPE            R4
        RELATED_FIELDS  "qbacqs.f2_min_gs_mag"
    END_FIELD


    FIELD  d_f3_min_gs_mag
        TYPE            R4
        RELATED_FIELDS  "qbacqs.f3_min_gs_mag"
    END_FIELD


    FIELD  d_min_gs_sep
        TYPE            R4
        RELATED_FIELDS  "qbacqs.f3_min_gs_sep"
    END_FIELD


    FIELD  d_min_roll
        TYPE            R8
        RELATED_FIELDS  "qbacqs.min_roll_rng"
    END_FIELD


    FIELD  d_min_usbl
        TYPE            C17
        RELATED_FIELDS  "qbacqs.min_usbl_wnd"
    END_FIELD


    FIELD  d_p_sea_rad
        TYPE            R4
        RELATED_FIELDS  "qbacqs.p_sea_rad"
    END_FIELD


    FIELD  d_s_sea_rad
        TYPE            R4
        RELATED_FIELDS  "qbacqs.s_sea_rad"
    END_FIELD


    FIELD  d_st_att_unc
        TYPE            R4
        RELATED_FIELDS  "qbacqs.st_att_unc"
    END_FIELD


    FIELD  d_rr_opt
        TYPE            C1
        RELATED_FIELDS  "qbacqs.rr_opt"
    END_FIELD


    FIELD  d_rr_lvl
        TYPE            C1
        RELATED_FIELDS  "qbacqs.rr_lvl"
    END_FIELD


    FIELD  d_rr_ff
        TYPE            R4
        RELATED_FIELDS  "qbacqs.rr_ff"
    END_FIELD

    FIELD  d_over_nr_off
        TYPE            I4
        RELATED_FIELDS  "qbacqs.over_nr_off"
    END_FIELD

    FIELD  d_over_nr_limit
        TYPE            R8
        RELATED_FIELDS  "qbacqs.over_nr_limit"
    END_FIELD

    FIELD  d_max_time_pts
        TYPE            I4
        RELATED_FIELDS  "qbacqs.max_time_pts"
    END_FIELD

END_RECORD


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


RELATION  qbacqd_def

    TYPE             QBACQD_TYPE

    DESCRIPTION      "Guide Star Acquisition Criteria Defaults Data Relation"

    SUBSYSTEM_USING  "SPSS", "SCIOPSDB"

    RELATED_FIELDS   "qbacqs.*"

    INDEX  qbacqd_def_1
        TYPE         unique, clustered
        FIELDS       d_scenar_acq
    END_INDEX

END_RELATION

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


INSTANCE  qbacqd_def

    GLOBAL

    TYPE        QBACQD_TYPE

END_INSTANCE