!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:	SCD_SAVE_DATE.SDDL
!
! Purpose:      This SDDL file defines the SCD_SAVE_DATE table.
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ---   -------------------------------------------------
! 06/09/99    39231     Baum   Original implementation
! 03/14/00    40435     Ken S. Changed su_name to schdunit.
! 05/12/00    40435.1   MARose change it in the index, too.
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!
 
LANGUAGE	SQL

RECORD  SCD_SAVE_TYPE
 
!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------
 
 
DESCRIPTION       "This table is used to map all the save files generating by
                   the SCD class process SAVGEN. The table will be populated
                   by XTRACT as it writes OPEN commands to the combined save 
                   file that is input to SAVGEN."

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

    FIELD  schdunit
        TYPE            C*23
        DESCRIPTION     "Scheduling Unit name that was used to
                        process the observation.  It is of the form
                        YYDDDHHMMSS_YYDDDHHMMSS for the start and
                        stop times of the OMS scheduling unit."
    END_FIELD

    FIELD  save_date
        TYPE            C*9
        DESCRIPTION     "The time of used in the file name of SAVE files.
                         SAVE files have the format 
                         AAAAAAAAAAAAAYYDDDHHMM.OMS_<su_name>, where
                         AAAAAAAAAAAAA is a fixed-size 13-character field,
                         padded with trailing underscores. The save_date is
                         the the value YYDDDHHMM which matches the first
                         9-characters of the su_name or the next day 
                         boundary, YYDDD0000."
    END_FIELD

END_RECORD

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


RELATION  scd_save_date

    TYPE             SCD_SAVE_TYPE

    DESCRIPTION      "Mapping SU to SAVE datasets"

    SUBSYSTEM_USING  "OMS"
 
    INDEX  scd_save_date_1      
        TYPE          unique clustered
        FIELDS        schdunit, save_date
    END_INDEX

END_RELATION