!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:	SICS_SIAS_COEF.SDDL
!
! Purpose:      This SDDL file defines the sics_sias_coef relation.
!
! Modification History:
!
!   Date       PR      Who                       Reason
! --------   -------   ---   -------------------------------------------------
! 11/21/99   34586     MSwam OPUS copy of SPSS relation qatrans_coef
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!

LANGUAGE  SQL

RECORD  SICS_SIAS_COEF

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

    DESCRIPTION       "This relation defines the coefficients that are used
                       to transform data from between the Science Instrument
                       Coordinate System (SICS) and the Science Aperture
                       Coordinate System (SIAS).  The command that primarily
                       performs this transformation is PMDB/UPDATE, as
                       transformations between the V1-V2-V3, SICS, and
                       SIAS are commonly required.  See the description for
                       the relation QAAPERTURES (or aperture_def) for more 
                       details on the
                       various aperture coordinate systems."


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

    FIELD  coord_id
        TYPE            C10
        DESCRIPTION     "This field specifies the aperture coordinate system
                        ID.  It is the ID of the aperture coordinate system
                        used to specify the location of the target within the
                        aperture. It is the aperture id concatenated
                        with the aperture coordinate system id.
                        Defined in ST-ICD-26 part III appendix A.
                        Field 1 of the first aj record if assigned by IMTOOL."
    END_FIELD

    FIELD  valid_date
        TYPE            C*17
        DESCRIPTION     "effective date (YYYY.DDD:HH:MM:SS) before which the
                        data for this aperture must not be used"
    END_FIELD

    FIELD  record_index
        TYPE            I*2
        DESCRIPTION     "This field is the index of the record for the aperture
                        coord. ID. The max. value is 21 because of
                        the max. poly. degree n (qaapol) is 5. These coeff.
                        are subscripted jk (j = 0 to n, k = 0 to j).
                        for a 5th degree poly. jk are ordered as: 00, 10,
                        11, 20, 21, 22, 30, 31, 32, 33, 40, 41, 42, 43, 44,
                        50, 51, 52, 53, 54, and 55. This id is 1 for
                        jk = 00, ... 21 for jk = 55. It is the record
                        number of the ak type record when assigned by IMTOOL."
    END_FIELD


    FIELD  x_sias_sics
        TYPE            R*8
        DESCRIPTION     "This field is the coefficient ajk for transforming
                        the x coordinate from SIAS to SICS.
                        The value of jk is determined by record_index.
                        field 1 of the <i>th ak record if assigned by IMTOOL."
    END_FIELD

    FIELD  y_sias_sics
        TYPE            R*8
        DESCRIPTION     "This field is the coefficient bjk for transforming
                        the y coordinate from SIAS to SICS.
                        The value of jk is determined by record_index.
                        Field 2 of the <i>th ak record if assigned by IMTOOL."
    END_FIELD

    FIELD  x_sics_sias
        TYPE            R*8
        DESCRIPTION     "This field is the coefficient cjk for transforming
                        the x coordinate from SICS to SIAS.  The value of jk 
                        is determined by record_index.  Field 3 of the <i>th ak
                        record if assigned by IMTOOL."
    END_FIELD

    FIELD  y_sics_sias
        TYPE            R*8
        DESCRIPTION     "This field is the coefficient djk for transforming
                        the y coordinate from SICS to SIAS.  It is
                        the value of jk is determined by record_index.
                        Field 4 of the <i>th ak record if assigned by IMTOOL."
    END_FIELD

END_RECORD

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

RELATION  sics_sias_coef

    TYPE             SICS_SIAS_COEF

    DESCRIPTION      "Coefficients For Transform Between Aperture Coord. Relation"

    RELATED_FIELDS   "qaapertures.*"

    SUBSYSTEM_USING  "OPUS"

    INDEX  sics_sias_coef_1
        TYPE         unique, clustered
        FIELDS       coord_id, valid_date, record_index
    END_INDEX

END_RELATION

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

INSTANCE  sics_sias_coef

    GLOBAL

    TYPE        SICS_SIAS_COEF

END_INSTANCE