Go to the bottom.

!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:	ZQSLINK_SPEC.SDDL
!
! Purpose:      This SDDL file defines the qalink_spec relation.
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ---   -------------------------------------------------
! 10/21/94    27329     EGB   Original implementation
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
 
LANGUAGE	FORTRAN, SQL

INCLUDE         ZSPSS_USER_TYPES.SDDL
 
RECORD  LKSPEC_TYPE
 
!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------
 
    DESCRIPTION       "This record defines a link set specification.  A link
		       set specification record defines a unique timing 
		       relationship between a pair of scheduling units.  

		       For example, suppose you have two SUs:  SU00001 and
		       SU00002 that you want to link together.  You can define
		       a link specification between these scheduling units by
		       populating this relation with a record that defines
		       that timing relationship.  It might say:

			 'Scheduling unit SU00002 must be scheduled 4 days 
			  after	scheduling unit SU00001 with a tolerance of 
			  1 day.'

		       A given link set will have 1 or more of these records to 
		       comprise the full link set specifcation.  

		       There is an N to 1 relationship between the link
		       specification records and the housekeeping information
		       stored in qslink_info."  
 
!------------------------------------------------------------------------------
!
!   FIELD INFORMATION
!
!------------------------------------------------------------------------------
 

    FIELD  link_set_id
        TYPE LINK_SET_ID_TYPE
        FORM
            NAME         "LSD"
            LABEL        "LINK SET ID"
        END_FORM
        RELATED_FIELDS  "qslink_info.link_set_id"
    END_FIELD
 

    FIELD  sunit_id_1
        TYPE SUNIT_ID_TYPE
        DESCRIPTION     "This is the *first* SU in the link set specification 
			 pair.  It will have a timing relationship between
			 sunit_id_2 in this same relation as defined by the 
			 link_delta and link_tolerance fields."
        FORM
            NAME         "LSD"
            LABEL        "SU #1"
        END_FORM
    END_FIELD
 

    FIELD  vrs_num_1
        TYPE VERSION_NUM_TYPE
        FORM
            NAME         "LSD"
            LABEL        "VERS #2"
        END_FORM
    END_FIELD
 

    FIELD  sunit_id_2
        TYPE SUNIT_ID_TYPE
        DESCRIPTION     "This is the *second* SU in the link set specifcation 
			 pair.  It will have a timing relationship between
			 sunit_id_1 in this same relation as defined by the 
			 link_delta and link_tolerance fields."
        FORM
            NAME         "LSD"
            LABEL        "SU #2"
        END_FORM
    END_FIELD
 

    FIELD  vrs_num_2
        TYPE VERSION_NUM_TYPE
        FORM
            NAME         "LSD"
            LABEL        "VERS #2"
        END_FORM
    END_FIELD
 

    FIELD  link_delta
        TYPE            I4
        UNITS           "SEC"
        DESCRIPTION     "This is the minimum separation between the first and
                        second scheduling units above.  It is a signed value 
			that is applied to the start of the first science 
			activity of the first scheduling unit and to the start 
			of the first science activity of the second scheduling 
			unit."
        FORM
            NAME         "LSD"
            LABEL        "DELTA TIME"
        END_FORM
    END_FIELD
 

    FIELD  link_tol
        TYPE            I4
        UNITS           "SEC"
        DESCRIPTION     "This is the the separation tolerance that is applied 
			 to the link_delta timing value.  Specifically, it is a
                         positive value which, when added to link_delta, 
			 controls the separation range between the pair of 
			 scheduling units.  

			 Since link_delta is the the minimum signed separation 
			 between the pair, the maximum signed separation is
                         link_delta + link_tol.  

			 This field is ignored if the link_tol_flag is 'N' 
			 and there will be infinite tolerance.

			 If the link_tol_flag is 'Y' and this field is zero, 
			 then the separation between the pair of scheduling 
			 units must be exactly link_delta."
        FORM
            NAME         "LSD"
            LABEL        "TOLERANCE TIME"
        END_FORM
    END_FIELD
 

    FIELD  link_tol_flg
        TYPE YES_NO_FLAG_TYPE
        DESCRIPTION     "This flag indicates whether or not to apply the 
			 above tolerance when evaluating the link relationship.
			 If this flag is N, then the link tolerance is infinite 
			 or not bound."
    END_FIELD
 
END_RECORD
 
 
!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------
 
 
RELATION  qslink_spec
 
    TYPE             LKSPEC_TYPE
 
    DESCRIPTION      "Link Set Specification Description Relation"
 
    SUBSYSTEM_USING  "SPSS", "TRANS"

    RELATED_FIELDS  "qslink_info.*"

    FORM
        NAME         "LSD"
    END_FORM
 
    INDEX  qslink_spec_1
        TYPE         unique, clustered
        FIELDS       link_set_id, sunit_id_1, vrs_num_1, sunit_id_2, vrs_num_2
    END_INDEX
 
    INDEX  qslink_spec_2
        TYPE         nonclustered
        FIELDS       sunit_id_1, vrs_num_1
    END_INDEX
 
    INDEX  qslink_spec_3
        TYPE         nonclustered
        FIELDS       sunit_id_2, vrs_num_2
    END_INDEX
 
END_RELATION
 
!------------------------------------------------------------------------------
!
!   INSTANCE DECLARATION
!
!------------------------------------------------------------------------------
 
 
INSTANCE  qslink_spec
 
    GLOBAL
 
    TYPE        LKSPEC_TYPE
 
END_INSTANCE

Go to the top.