!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:    QSBO_UNSAFE_TRACK.SDDL
!
! Purpose:      This SDDL file defines the qsbo_unsafe_track relation.
!
! Modification History:
!
!   Date       PR     Who                       Reason
! --------   -------  ---   -------------------------------------------------
! 02/27/99   35645    MMD   Original Implementation
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!
 
LANGUAGE  C, FORTRAN, SQL

INCLUDE  ZSPSS_USER_TYPES.SDDL
 
RECORD  BO_UNSAFE_TYPE
 
!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------
 
    DESCRIPTION    "This is the relation used for tracking Bright Object unsafe 
                    window data that is supplied by the Contact Scientist(CS). 
                    The CS supplies Bright Object window data for Moving Target
                    SUs using detectors which are more sensitive than the 
                    Guide Star Catalog.

                    An SU can have only one qsbo_unsafe_track record.

                    It stores the date of the last time the Bright Object unsafe
                    window data was loaded into the pmdb and whether the default
                    windows were loaded."
 
!------------------------------------------------------------------------------
!
!   FIELD INFORMATION
!
!------------------------------------------------------------------------------
 
 
    FIELD  sunit_id
        TYPE            SUNIT_ID_TYPE
    END_FIELD
 
    FIELD  version_num
        TYPE            VERSION_NUM_TYPE
    END_FIELD
 

    FIELD  af_load_date
        TYPE            TIME_STAMP_TYPE
        DESCRIPTION     "This field contains the date that the Bright Object unsafe 
                         window data was loaded into the PMDB via pmdb -load or 
                         pmdb -windows.  There is no af associated with this 
                         data, the name is a convenience for the software."
       RELATED_FIELDS  "qsbo_unsafe_track.bo_unsafe_defaults_loaded",
                        "wsi_bo_check.*", "wgbrit_obj.*"
    END_FIELD

    FIELD bo_unsafe_defaults_loaded
        TYPE            YES_NO_FLAG_TYPE
        DESCRIPTION     "This field will only be populated for Scheduling Units which
                         need to have an additional Bright Object window constraint.  
                         These Scheduling Units will have an exposure configuration  
                         that matches a configuration in the wsi_bo_check relation.
                         For such visits this field will be set to 'Y' when
                         the Bright Object unsafe default windows have been loaded.  It
                         will be set to 'N' when the Contact Scientist supplied windows 
                         have  been loaded.  Either the pmdb -load or pmdb -windows
                         tools can populate this field."
       RELATED_FIELDS  "qsbo_unsafe_track.bo_unsafe_load_date",
                        "wsi_bo_check.*",  "wgbrit_obj.*"
    END_FIELD

END_RECORD
 
 
!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------
 
RELATION  qsbo_unsafe_track
 
    TYPE             BO_UNSAFE_TYPE
 
    DESCRIPTION      "Bright Object Unsafe Windows Tracking Relation"
 
    SUBSYSTEM_USING  "SPSS"

    RELATED_FIELDS   "wgbrit_object.*",
                     "wgbo_waiver.*",
                     "wsi_bo_check.*"

    INDEX  qsbo_unsafe_track_1
        TYPE         unique, clustered
        FIELDS       sunit_id, version_num
    END_INDEX
 
END_RELATION
 
!------------------------------------------------------------------------------
!
!   INSTANCE DECLARATION
!
!------------------------------------------------------------------------------
 
 
INSTANCE  QSBO_UNSAFE_TRACK
 
    GLOBAL
 
    TYPE        BO_UNSAFE_TYPE
 
END_INSTANCE