Go to the bottom.

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL:         constraint_windows_ver.sddl
!
! Purpose:      This file defines the constraint_windows_ver 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_
! 04/16/98   31837     MRB   Added C output
! 07/25/01   38736     DPJ   Add orient field
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!

LANGUAGE  C, FORTRAN, SQL

INCLUDE  ZSPSS_USER_TYPES.SDDL

RECORD  CON_WIN_VER_TYPE

    DESCRIPTION	"
	 Verified constraint windows are time intervals in the proposal cycle 
	 where SPIKE thinks a scheduling unit (SU) can be scheduled and SPSS
	 CALOPT scheduling has proved this by actually scheduling it in that 
	 timeframe.

	 When the CALOPT/VERIFY_WINDOWS is run each SU's constraint
	 window is evaluated (i.e. CALOPT tries to scheule the SU during the
	 constraint window timeframe).  If the window evaluates successfully
	 based on criteria defined in the constraint_win_ver_criteria relation,
	 then the constraint window is considered to be `verified' and a record
	 is added to this relation with the verification information.

	 The structure of this relation parallels the constraint_windows 
	 relation.  All field definitions can be found in that relation.

	 The verified constraint windows provides SPIKE feedback on the 
	 accuracy of its constraint windows. With that information SPIKE
	 can create a more accurate long range plan (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 constraint window was verified."
	RELATED_FIELDS  "constraint_windows.create_date"
    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
	RELATED_FIELDS  "constraint_windows.window_begin"
    END_FIELD


    FIELD window_end
	TYPE SOGS_CHAR_TIME_TYPE
        RELATED_FIELDS  "constraint_windows.window_end"
    END_FIELD


    FIELD orient
        TYPE            R8
        UNITS           "DEGREES"
        DESCRIPTION     "This field contains the V3 position angle at the 
                         target at the start of the first targeted (on sky)
                         alignment of the scheduling unit as scheduled 
                         by calopt -verify_windows at the _beginning_ of
                         this verified constraint window.  This orientation
                         is valid at this time only and may not be valid at
                         any other time within the window."
    END_FIELD


END_RECORD

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

RELATION constraint_windows_ver

    TYPE             CON_WIN_VER_TYPE
 
    DESCRIPTION      "Long Range Plan Verified Constraint Windows Relation"
 
    SUBSYSTEM_USING  "SPSS", "SPIKE", "REPLICATION-FROM-SOGS"

    RELATED_FIELDS  "constraint_windows.*" "constraint_win_ver_criteria.*" "plan_windows.*" "lrp_base_cat.*"


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

    TYPE	CON_WIN_VER_TYPE

END_INSTANCE

Go to the top.