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

RECORD  PRODUCT_STATUS_TYPE
 
!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------
 
 
DESCRIPTION       "This relation is used to identify the completion status of
                   all FGS, AST, and GSA products in order to control 
                   telemetry file cleanup.  The records are created with N for
                   complete_flag. This relation is designed to be joined to
                   product_eng_map to determined when all the products, 
                   identified in product_eng_map by product_type and 
                   product_rootname, have been marked completed.

                   For reprocessing, all the products to be reprocessed should
                   have the complete_flag interactively reset to N. For 
                   replans, any records for dataset no longer present in 
                   qolink. must be deleted. Only one record for each product 
                   and type is allowed. "

!------------------------------------------------------------------------------
!
!   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  complete_flag
        TYPE            C1
        DESCRIPTION     "(Y/N) set to Y by cleanup software indicating
                         this dataset has been processed and no longer prevents
                         cleanup of telemetry files. "
    END_FIELD

END_RECORD
 
 
!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------
 
 
RELATION  product_status
 
    TYPE             PRODUCT_STATUS_TYPE
 
    DESCRIPTION      "FGS, GSA, or AST Product Completion Relation"
 
    SUBSYSTEM_USING  "OPUS"

    INDEX  product_status_1
        TYPE         unique, clustered
        FIELDS       product_rootname, product_type
    END_INDEX

END_RELATION