!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:    QSWINDOWS.SDDL
!
! Purpose:      This SDDL file defines the qswindows relation.
!
! Modification History:
!
!   Date       PR      Who                       Reason
! --------   -------   ---   -------------------------------------------------
! 11/05/99   36836     rjs   Created.
! 08/23/00   36836     jjb   Added range_id to index qswindows_1
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
 
LANGUAGE  C, FORTRAN, SQL

INCLUDE  ZSPSS_USER_TYPES.SDDL
 
RECORD  QSWINDOWS_TYPE
 
!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------
 
 
    DESCRIPTION       "The QSWINDOWS relation is used to store QSORIENT_RANGE
                       restricted window data for a scheduling unit
                       set, including the associated QSORIENT_RANGE.range_id.

                       It is populated by PMDB/UPDATE/TYPE=SU. The commands
                       CALENDAR/ADDCAND, CANDLIST/ADDSUS, CANDLIST/DELSU, and
                       CANDLIST/UPDATE retrieve windows from this relation."
 
!------------------------------------------------------------------------------
!
!   FIELD INFORMATION
!
!------------------------------------------------------------------------------
 
    FIELD sunit_id
	TYPE	SUNIT_ID_TYPE
    END_FIELD

    FIELD version_num
	TYPE    VERSION_NUM_TYPE
    END_FIELD

    FIELD range_id
	TYPE		I4
	DESCRIPTION	"This field is the orientation range
                         identifier for the corresponding QSORIENT_RANGE
                         record for the window."
    END_FIELD

    FIELD  window_beg
        TYPE            SOGS_INT_TIME_TYPE
        DESCRIPTION     "This field indicates when the window begins."
    END_FIELD
 
 
    FIELD  window_end
        TYPE            SOGS_INT_TIME_TYPE
        DESCRIPTION     "This field indicates when the window ends."
    END_FIELD
 
 
END_RECORD
 
 
!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------
 
 
RELATION  qswindows
 
    TYPE             QSWINDOWS_TYPE
 
    DESCRIPTION      "SU Orientation Range Restricted Windows Data Relation"
 
    SUBSYSTEM_USING  "SPSS"
 
    INDEX  qswindows_1
        TYPE         unique, clustered
        FIELDS       sunit_id, version_num, range_id, window_beg, window_end
    END_INDEX
 
END_RELATION
 
!------------------------------------------------------------------------------
!
!   INSTANCE DECLARATION
!
!------------------------------------------------------------------------------
 
 
INSTANCE  qswindows
 
    GLOBAL
 
    TYPE        QSWINDOWS_TYPE
 
END_INSTANCE