!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:	QTMWINDOWS.SDDL
!
! Purpose:      This SDDL file defines the QTMWINDOWS relation.
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ---   -------------------------------------------------
! 12/02/97   34376      SBA   Original version
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
 
LANGUAGE	FORTRAN, SQL

INCLUDE         ZSPSS_USER_TYPES.SDDL
 
RECORD  QTMWIND_TYPE
 
!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------
    DESCRIPTION      "This relation stores the start and end times of
                      moving target windows for a target. The moving target
		      windows are generated by MOSS subsystem. These data
		      are populated into QTMWINDOWS fields by SPSS command

                      PMDB/WINDOWS/TYPE=MT target_id MOSS_genarated_window_file

                      The command checks for validity of window times and
                      overlaps. Once succesfully populated, it updates the
                      mtwindow_update field in relation QTARGETS with the
                      current time. The data in the relation QTMWINDOWS are
                      copied into QBWINDOWS for window_type=MT during obset
                      update"

    RELATED_FIELDS     "qbwindows.*",
		       "qtargets.target_id", "qtargets.mtwindow_update"
!
!------------------------------------------------------------------------------
!
!   FIELD INFORMATION
!
!------------------------------------------------------------------------------
 
    FIELD  target_id
        TYPE            TARGET_ID_TYPE
        DESCRIPTION     "This field is unique name assigned to the moving
			  target"
        RELATED_FIELDS  "qalignment.prim_target",
                        "qalignment.ref_target",
			"qaposition.target_ref"
    END_FIELD
 
    FIELD  window_beg
        TYPE            SOGS_INT_TIME_TYPE
        DESCRIPTION     "This field is the moving target window begin time."
    END_FIELD
 
    FIELD  window_end
        TYPE            SOGS_INT_TIME_TYPE
        DESCRIPTION     "This field is the moving target window end time."
    END_FIELD
 
END_RECORD
 
!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------
 
RELATION  qtmwindows
 
    TYPE             QTMWIND_TYPE
 
    DESCRIPTION      "Moving targets Windows Data Relation"
 
    SUBSYSTEM_USING  "SPSS"

 
END_RELATION

    INDEX  qtmwindows_1
        TYPE         unique, clustered
        FIELDS       target_id, window_beg, window_end
    END_INDEX
 
!------------------------------------------------------------------------------
!
!   INSTANCE DECLARATION
!
!------------------------------------------------------------------------------
 
INSTANCE  qtmwindows
 
    GLOBAL
 
    TYPE        QTMWIND_TYPE

END_INSTANCE