Go to the bottom.

!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:	WTDRS_LINK.SDDL
!
! Purpose:      This SDDL file defines the wtdrs_link relation.
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ---   -------------------------------------------------
! 11/ 3/94    27329     EGB   Original implementation
! 12/15/94    27329     EGB   Add in transid - in DB, but not in original DDL.
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!

LANGUAGE	FORTRAN, SQL

RECORD  WTDRS_TYPE

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


    DESCRIPTION       "This relation defines a set of possible TDRS link 
		       configurations. Each record defines a unique TDRS link 
		       configuration.  The record will also provide a link
		       to other compatible records within this table.  

		       This information is pulled into the SPSS Orbit file
		       and is used during calendar scheduling to lay down
		       TDRS contact activities.  These activities are based
		       on readout requests specified in the alignment level
		       qreadout relation."

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


    FIELD  code
        TYPE            I2
        DESCRIPTION     "Each entry in this table will be assigned a unique 
			 integer code starting at 1 and incremented by 1."
    END_FIELD


    FIELD  direction
        TYPE            C1
        DESCRIPTION     "This field lists the direction of TDRS link requested:
                                 F = forward (or UPLINK) 
                                 R = return (or DOWNLINK)."
        RELATED_FIELDS  "qreadout.tdrs_link"
        DISCRETE        "F",  "R"
    END_FIELD


    FIELD  service
        TYPE            C3
        DESCRIPTION     "This field defines the type of TDRS service requested. 

			 'MA' implies Multi Access service is requested, meaning
			 the TDRS connection will be shared with other 'users'.

			 'SSA' implies Single Source Access which means the HST
			 is the sole user of the TDRS connection.  The latter
			 implies a higher rate."
        RELATED_FIELDS  "qreadout.tdrs_service"
        DISCRETE        "MA",  "SSA"
    END_FIELD


    FIELD  rate
        TYPE            C5
        DESCRIPTION     "This is the actual data rate of the TDRS connection.
                         The lower rates (<= 1K) are mostly used for vehicle 
                         commanding (some engineering data transfer).  The 
                         higher (4K up to 1024K) are used mainly for science
                         and engineering data transfer from the HST."
        UNITS            "KILOBITS/SECOND"
        DISCRETE         "0.125",  "0.5",  "1",  "1024",  "32",  "4"
    END_FIELD


    FIELD  data_type
        TYPE            C1
        DESCRIPTION     "This field specifies the datatype of the TDRS
                         connection:
     	                        'S' designates a SCIENCE data transfer via
                                    a return connection.
     	                        'E' designates an ENGINEERING data transfer via
                                    a return connection.
	                        'C' designates HST commanding via a forward
                                    (or uplink) connection."
        RELATED_FIELDS  "qreadout.data_type"
        DISCRETE         "C",  "E",  "S"
    END_FIELD


    FIELD  transid
        TYPE            C3
        DESCRIPTION     "Unsure of the purpose of this field.  Not used in 
			 any software, but there are values in the database."
        DISCRETE        "MA",  "SSA"
    END_FIELD


    FIELD  sub_link1
        TYPE            I2
        DESCRIPTION     "This field defines the first viable link to another
                         record (based on code field) in this table that is
                         compatible with this record.  It must be set before 
                         fields sub_link2 .. sub_link6.  If it is 0 then there
                         are no higher compatible entries. " 
    END_FIELD


    FIELD  sub_link2
        TYPE            I2
        DESCRIPTION     "This field defines the second viable link to another
                         record (based on code field) in this table that is
                         compatible with this record.  It must be set before 
                         fields sub_link3 .. sub_link6.  If it is 0 then there
                         are no higher compatible entries. "
    END_FIELD


    FIELD  sub_link3
        TYPE            I2
        DESCRIPTION     "This field defines the third viable link to another
                         record (based on code field) in this table that is
                         compatible with this record.  It must be set before 
                         fields sub_link4 .. sub_link6.  If it is 0 then there
                         are no higher compatible entries."
    END_FIELD


    FIELD  sub_link4
        TYPE            I2
        DESCRIPTION     "This field defines the fourth viable link to another
                         record (based on code field) in this table that is
                         compatible with this record.  It must be set before 
                         fields sub_link5 .. sub_link6.  If it is 0 then there
                         are no higher compatible entries."
    END_FIELD


    FIELD  sub_link5
        TYPE            I2
        DESCRIPTION     "This field defines the fifth viable link to another
                         record (based on code field) in this table that is
                         compatible with this record.  It must be set before 
                         fields sub_link6.  If it is 0 then there are no 
                         higher compatible entries."
    END_FIELD


    FIELD  sub_link6
        TYPE            I2
        DESCRIPTION     "This field defines the last viable link to another
                         record (based on code field) in this table that is
                         compatible with this record.  It must be set after
                         all other sub_link fields. "
    END_FIELD

END_RECORD

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


RELATION  wtdrs_link

    TYPE             WTDRS_TYPE

    DESCRIPTION      "TDRS Link Configuration Relation"

    RELATED_FIELDS  "qreadout.*"

    SUBSYSTEM_USING  "SPSS", "SCIOPSDB"
 
    INDEX  wtdrs_link_1
        TYPE         unique, clustered
        FIELDS       code
    END_INDEX

    INDEX  wtdrs_link_2
        TYPE         unique 
        FIELDS       direction, service, rate, data_type
    END_INDEX

END_RELATION

!------------------------------------------------------------------------------
!
!   INSTANCE DECLARATION
!
!------------------------------------------------------------------------------

INSTANCE  wtdrs_link

    GLOBAL

    TYPE        WTDRS_TYPE

END_INSTANCE

Go to the top.