!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL:         QSORIENT_RANGES.SDDL
!
! Purpose:      This defines the qsorient_ranges relation.
!
! Modification History:
!
!   Date       PR      Who                       Reason
! --------   -------   ---   -------------------------------------------------
! 03/22/99   36853     mmd   Original version
! 11/05/99   36836     rjs   define second uniqueness index
! 09/19/00   36836     jjb   Change index names to follow SPSS convention
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!

LANGUAGE  C, FORTRAN,SQL

INCLUDE  ZSPSS_USER_TYPES.SDDL

RECORD  QSORANGES_TYPE

!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------

    DESCRIPTION		

	"This relation contains single and multiple proposal orientation
         angle range data for visits with sr ORIENTation.  It is populated
         by TRANS."

!------------------------------------------------------------------------------
!
!   FIELD INFORMATION
!
!------------------------------------------------------------------------------
 
    FIELD sunit_id
	TYPE	SUNIT_ID_TYPE
    END_FIELD

    FIELD version_num
	TYPE    VERSION_NUM_TYPE
    END_FIELD

    FIELD v3_min_ang
	TYPE		R8
	DESCRIPTION	"This field is the starting point of the v3 
                         position angle range for the scheduling unit 
                         corresponding to the orientaion specified in the 
                         proposal.  The angle specifies the minimum V3
                         position angle at the target for the first 
                         targeted alignment of the SU."
        RELATED_FIELDS  "qsorient_ranges.v3_max_ang",
                        "plan_orient.v3_min_ang"
        RANGE           0.0 360.0
    END_FIELD

    FIELD v3_max_ang
	TYPE		R8
	DESCRIPTION	"This field is the ending point of the v3 
                         position angle range for the scheduling unit 
                         corresponding to the orientaion specified in the 
                         proposal.  The angle specifies the maximum V3
                         position angle at the target for the first 
                         targeted alignment of the SU."
        RELATED_FIELDS  "qsorient_ranges.v3_min_ang",
                        "plan_orient.v3_max_ang"
        RANGE           0.0 360.0
    END_FIELD

    FIELD range_id
	TYPE		I4
	DESCRIPTION	"This field is a proposal orientation range
                         identifier, provided for single and multiple
                         angle ranges."
    END_FIELD


END_RECORD

 
!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------
 
RELATION  qsorient_ranges
 
    TYPE             QSORANGES_TYPE
 
    DESCRIPTION      "Scheduling Unit Orient Ranges Relation"
 
    SUBSYSTEM_USING  "SPSS", "TRANS"

    RELATED_FIELDS   "plan_orient.*",
		     "qaposition.*"

    INDEX  qsorient_ranges_1
        TYPE         unique, clustered
        FIELDS       sunit_id, version_num, range_id
    END_INDEX

    INDEX  qsorient_ranges_2
        TYPE         unique, nonclustered
        FIELDS       sunit_id, version_num, v3_min_ang, v3_max_ang
    END_INDEX
 
END_RELATION
 
!------------------------------------------------------------------------------
!
!   INSTANCE DECLARATION
!
!------------------------------------------------------------------------------
 
INSTANCE qsorient_ranges

    TYPE QSORANGES_TYPE

END_INSTANCE