Go to the bottom.

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

INCLUDE         ZSPSS_USER_TYPES.SDDL
 
RECORD  SUSI_TYPE
 
!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------
 
    DESCRIPTION       "This relation lists information about science instruments
		       and how they related to a scheduling unit.  It will 
		       contain information on all of the SIs that a scheduling 
		       unit uses, and it will also contain data on all of the 
		       SIs that cannot be interleaved within this scheduling 
		       unit.  

                       A given SU will likely have multiple records in this 
		       table.  This would happen if an SU used more than one 
                       SI, or used one SI and disallow the interleaving of 
                       other SIs.

		       The relation is read during PMDB/UPDATE/TYPE=SU 
		       and is used for setting the qscheduling SI bitmap 
		       fields. "

!------------------------------------------------------------------------------
!
!   FIELD INFORMATION
!
!------------------------------------------------------------------------------
 

    FIELD  sunit_id
        TYPE SUNIT_ID_TYPE
        FORM
            NAME         "SIU"
            LABEL        "SCHEDULING UNIT ID"
        END_FORM
    END_FIELD
 

    FIELD  version_num
        TYPE VERSION_NUM_TYPE
        UNITS
        FORM
            NAME         "SIU"
            LABEL        "VERSION NUM"
        END_FORM
    END_FIELD
 

    FIELD  si_id
        TYPE SI_ID_TYPE
	DESCRIPTION	"This is the science instrument that is used by this
			 scheduling unit.  Or, this could be an SI that is not 
			 allowed for interleaving in this SU. See the 
			 si_usage field below to determine which category the 
			 SI falls into."
        FORM
            NAME         "SIU"
            LABEL        "USAGE"
        END_FORM
    END_FIELD
 

    FIELD  si_usage
        TYPE            C1
        DESCRIPTION     "This is a tri-state flag that designates how the
			 SI is used by this scheduling unit.  In particular,
			 'U' designates the SI is USED by the SU; 'I' means
			 that this SI cannot be INTERLEAVed within this SU; and 
			 'L' designates the SI is not allowed for any 
			 interleaving between this SU a LINKED SU in a 
			 linked set (assumes this SU is in a linked set, not
			 enforced by SPSS software). '
        FORM
            NAME         "SIU"
            LABEL        "USAGE"
        END_FORM
        DISCRETE        "U",  "I",  "L"
    END_FIELD
  
END_RECORD
 
 
!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------
 
 
RELATION  qsinstrument
 
    TYPE             SUSI_TYPE
 
    DESCRIPTION      "Scheduling Unit Instruments Relation"
 
    SUBSYSTEM_USING  "SPSS"

    RELATED_FIELDS  "qscheduling.sis_used" "qscheduling.si_intrlv"

 
    FORM
        NAME         "SIU"
    END_FORM
 
    INDEX  qsinstrument_1
        TYPE         unique, clustered
        FIELDS       sunit_id, version_num, si_id, si_usage
    END_INDEX
 
END_RELATION
 
!------------------------------------------------------------------------------
!
!   INSTANCE DECLARATION
!
!------------------------------------------------------------------------------
 
 
INSTANCE  qsinstrument
 
    GLOBAL
 
    TYPE        SUSI_TYPE
 
END_INSTANCE

Go to the top.