!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL:         constraint_windows.sddl
!
! Purpose:      This file defines the constraint_windows relation.
!
! Modification History:
!
!   Date       PR      Who                       Reason
! --------   -------   ---   -------------------------------------------------
! 07/18/94   27073     SSW   SPSS Planning Windows Support
! 02/02/95   28292     SK    Modified "REPLICATION" wording under 
!                             SUBSYSTEM_USING
! 03/14/95   28429     RJS   comments update
! 04/16/97   33890     MRB   Field names changed in ASSIST from wnd_ to _window
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
LANGUAGE        FORTRAN,SQL

INCLUDE         ZSPSS_USER_TYPES.SDDL

CONSTANT        WINDOW_TYPE_CONSTRAINT
	FILE
        VALUE   1
END_CONSTANT

RECORD  CON_WIN_TYPE

    DESCRIPTION	"
	 Constraint windows are time intervals in the proposal cycle where 
	 SPIKE thinks a scheduling unit (SU) can be scheduled. This is based 
	 on the target position, orientation requirements, links, locks, 
	 phase windows and the minimum visibility period. The windows are	
	 start-to-start, i.e., an SU must start before the window end, but 
	 may end after the window end.  

	 This relation defines constraint windows for a scheduling unit.  These
	 are verified by the CALOPT/VERIFY=SPIKE_CW command.  That command 
	 can be run to validate the schedulability of a SPIKE constraint window .
	 Feedback is provided to the user through reports and to SPIKE by 
	 populating the sister relation constraint_windows_ver.

	 This gives SPIKE feedback on the accuracy of its constraint windows and
	 with that information it can create a more accurate LRP comprised of 
	 plan windows known to be schedulable on SPSS calendars."

    FIELD sunit_id
	TYPE		SUNIT_ID_TYPE
    END_FIELD

    FIELD version_num
	TYPE		VERSION_NUM_TYPE
    END_FIELD

    FIELD create_date
        TYPE		TIME_STAMP_TYPE
	DESCRIPTION	"This is the date the window was generated."
    END_FIELD

    FIELD visit_id
        TYPE		VISIT_ID_TYPE
    END_FIELD

    FIELD prop_id
	TYPE		INT_PROPOSAL_ID_TYPE
    END_FIELD

    FIELD window_begin
	TYPE		SOGS_CHAR_TIME_TYPE
	DESCRIPTION	"This field is the start time of the constraint or 
			 verified constraint window."
    END_FIELD

    FIELD window_end
	TYPE		SOGS_CHAR_TIME_TYPE
	DESCRIPTION	"This field is the end time of the constraint or 
			 verified constraint window."
    END_FIELD

END_RECORD

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

RELATION constraint_windows

    TYPE             CON_WIN_TYPE
 
    DESCRIPTION      "Long Range Plan Constraint Windows Relation"
 
    SUBSYSTEM_USING  "SPSS", "SPIKE", "REPLICATION-TO-SOGS"

    RELATED_FIELDS   "constraint_windows_ver.*",
		     "constraint_win_ver_criteria.*",
		     "plan_windows.*",
		     "lrp_base_cat.*"

    INDEX  constraint_windows_1
        TYPE         unique, clustered
        FIELDS       sunit_id, version_num, create_date, window_begin
    END_INDEX
 
END_RELATION
 
!------------------------------------------------------------------------------
!
!   INSTANCE DECLARATION
!
!------------------------------------------------------------------------------
 
INSTANCE constraint_windows

!    FILE
    TYPE	CON_WIN_TYPE

END_INSTANCE