!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:	OMS_SCHF.SDDL
!
! Purpose:      This SDDL file defines the OMS_SCHF relation.
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ---   -------------------------------------------------
! 10/14/98    31487     Baum   Original implementation
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!
 
LANGUAGE	SQL

RECORD  OMS_SCHF_TYPE
 
!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------
 
 
DESCRIPTION       "This relation is used to contain all versions of the arrays
                   of Spacecraft Characteristics data used by OMS. Each 
                   version is identified by the SMS usage date. The description
                   of each array is found in the comments of the PDB:SCHF.DAT
                   file which contains one version of these arrays. Each array
                   has either one or two dimensions. The first dimension is the
                   FGS number. In this table, one dimensional data has a single
                   element per FGS which is given the array index of 1. Two
                   dimensional data will have sequential values of the array
                   index from 1 to the size of the second dimension of the
                   array. There is one record for each array element. Each
                   array is assigned a sequence number so that the data can
                   be retrieved in the same order as the data in the SCHF file.
                   All the values are stored as double precision floating point
                   data. "

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

    FIELD  version_date
        TYPE            C17
        DESCRIPTION     "YYYY.DDD:HH:MM:SS - set to the same value for each
                         PDB version. The default value should be set to 
                         9999.999:00:00:00 until the time of the start time of
                         the SMS that first uses that PDB is known. "
    END_FIELD
	
    FIELD  sequence
        TYPE            I2
        DESCRIPTION     "A unique value for each array which is used to
                         maintain the same order of arrays as found in the
                         PDB:SCHF.DAT file which is the source of all the
                         data. "
    END_FIELD
 
    FIELD  fgs_num
        TYPE            I2
        DESCRIPTION     "1, 2, or 3: used to indicate for which FGS the values
                         apply. "
    END_FIELD
 
    FIELD  array_index
        TYPE            I2
        DESCRIPTION     "An array index identifying each element of the array.
                         The first element has an array_index of one and the
                         last element has an an array_index that is the 
                         array dimension. "
    END_FIELD
 
    FIELD array_value
	TYPE		R8
        DESCRIPTION	"The value of the element of the array that is accessed
                         by fgs_num and index. "

    END_FIELD

    FIELD array_name
	TYPE		C6
        DESCRIPTION	"The name of the array as found in PDB:SCHF.DAT. "

    END_FIELD

END_RECORD
 
 
!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------
 
 
RELATION  oms_schf
 
    TYPE             OMS_SCHF_TYPE
 
    DESCRIPTION      "OMS Spacecraft Characteristics Relation"
 
    SUBSYSTEM_USING  "OMS"

    INDEX  oms_schf_1
        TYPE         unique, clustered
        FIELDS       version_date, sequence, fgs_num, array_index
    END_INDEX

END_RELATION