Go to the bottom.

!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:	QSBRANCHING.SDDL
!
! Purpose:      This SDDL file defines the qsbranching relation.
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ---   -------------------------------------------------
! 11-03-94    27329     EGB   Original implementation
! 02-02-95    28292     SK    Modified "REPLICATION" wording under 
!                             SUBSYSTEM_USING
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
 
LANGUAGE	FORTRAN, SQL

INCLUDE         ZSPSS_USER_TYPES.SDDL
 
RECORD  MAPOB2SU_TYPE
 
!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------
 
    DESCRIPTION       "This relation's major purpose is to map observation
		       sets into scheduling units.  

		       It is called qsbranching because historically this 
		       table contained much more information than it does
		       today including data related to a scheduling feature 
		       in SPSS called 'branching.'  The table would be more
		       appropriately named qobsets_to_su. "

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

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

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

    FIELD  proposal_id
        TYPE PROPOSAL_ID_TYPE
        FORM
            NAME         "SDP"
            LABEL        "PROPOSAL ID"
        END_FORM
    END_FIELD
 

    FIELD  obset_id
        TYPE OBSET_ID_TYPE
        FORM
            NAME         "SDP"
            LABEL        "OBSET ID"
        END_FORM
    END_FIELD
 

    FIELD  sequence_num
        TYPE            I2
        DESCRIPTION     "This field represents the order of the observation 
			 within the scheduling unit."
        FORM
            NAME         "SDP"
            LABEL        "OBSET SEQUENCE NUMBER"
        END_FORM
    END_FIELD
 
END_RECORD
 
!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------
 
RELATION  qsbranching
 
    TYPE             MAPOB2SU_TYPE
 
    DESCRIPTION      "Obset to Scheduling Unit Mapping Relation"
 
    SUBSYSTEM_USING  "SPSS", "SPIKE", "REPLICATION-FROM-SOGS", "TRANS"
    FORM
        NAME         "SDP"
    END_FORM
 
    INDEX  qsbranching_1
        TYPE         unique, clustered
        FIELDS       sunit_id, version_num, proposal_id, obset_id
    END_INDEX
 
    INDEX  qsbranching_2
        TYPE         nonclustered
        FIELDS       proposal_id, obset_id, version_num
    END_INDEX
 
END_RELATION
 
!------------------------------------------------------------------------------
!
!   INSTANCE DECLARATION
!
!------------------------------------------------------------------------------
 
INSTANCE  qsbranching
 
    GLOBAL
 
    TYPE        MAPOB2SU_TYPE
 
END_INSTANCE

Go to the top.