!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:	PRODUCT_ENG_MAP.SDDL
!
! Purpose:      This SDDL file defines the PRODUCT_ENG_MAP relation.
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ----   ------------------------------------------------
! 01/30/01    44862      Baum   Original implementation
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!
 
LANGUAGE	SQL

RECORD  PRODUCT_ENG_MAP_TYPE
 
!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------
 
 
DESCRIPTION       "This relation is used to identify the ENG files that may be
                   required for FGS, GSA or AST product generation. It is used
                   to simplify creation and collection of telemetry for 
                   processing.  When a product has no eng_ready = N flags, 
                   then the OSF for the product can be created using the
                   product rootname. "

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

    FIELD  product_rootname
        TYPE            C14
        DESCRIPTION     "IPPPSSOOT for jitter or astrometry products;
                         GYYYYDDDHHMMSS for GS acquisition data."
    END_FIELD

    FIELD  product_type
        TYPE            C3
        DESCRIPTION     "FGS for jitter, AST for astrometry, or GSA for GS 
                         acqusition data."
    END_FIELD

    FIELD  eng_rootname
        TYPE        C12
        DESCRIPTION "TYYYYDDDHHMM, rootname of the ENG file."
    END_FIELD

    FIELD eng_ready
        TYPE        C1
        UNITS       "Y/N flag"
        DESCRIPTION "N indicates the telemetry file eng_rootname is not yet
                     recognized as ready for this product_type. Y indicates
                     that the processing for this product type has recognized
                     the presence of eng_rootname. Having separate control for
                     each product type simplifies initiation of processing. "
    END_FIELD
END_RECORD
 
!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------
 
 
RELATION  product_eng_map
 
    TYPE             PRODUCT_ENG_MAP_TYPE
 
    DESCRIPTION      "Product to ENG File Mapping Relation"
 
    SUBSYSTEM_USING  "OPUS"

    INDEX  product_eng_map_1
        TYPE         unique, clustered
        FIELDS       eng_rootname, product_rootname, product_type
    END_INDEX

    INDEX  product_eng_map_2
        TYPE         nonclustered
        FIELDS       product_rootname, product_type
    END_INDEX

END_RELATION