!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:    ARCHIVE_REQ.SDDL         
!
! Purpose:      This SDDL file defines relation ARCHIVE_REQ         
!
! Modification History:
!
!   Date       OPR      Who                    Reason
!----------------------------------------------------------------------
! 19-JAN-96             PHyde          Original Implementaton
! 22-JAN-96             Ken Steuerman  Add descriptions
! 01-AUG-96   31905     MARose         Add data_path
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!

LANGUAGE        SQL

RECORD  ARCREQ_TYPE 

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

   DESCRIPTION                 "Tracks archive insertion requests made
                               to the on-line archive system.  Entries
                               are removed from this table when processing
                               is completed."
 
!----------------------------------------------------------------------
!
!   FIELD INFORMATION
!
!----------------------------------------------------------------------

   FIELD  dataset_name        
       TYPE            C*23
       DESCRIPTION             "The name given to describe a group of files."
       UNITS
       RANGE
   END_FIELD

   FIELD  archclass           
       TYPE            C*3
       DESCRIPTION             "The classification used to archive the data."
       UNITS
       RANGE
   END_FIELD

   FIELD  archdate            
       TYPE            C*20
       DESCRIPTION             "The latest file date associated with the
                               dataset."
       UNITS
       RANGE
   END_FIELD

   FIELD  reqdate             
       TYPE            C*23
       DESCRIPTION             "The date when the archive insertion request
                               was generation"
        UNITS
       RANGE
   END_FIELD

   FIELD  reqtype             
       TYPE            C*4
       DESCRIPTION             "OPUS generates either TAPE or DISK archive
                               insertion requests."
       UNITS
       RANGE
   END_FIELD

   FIELD  arch_system         
       TYPE            C*4
       DESCRIPTION             "OPUS generates DADS archive insertion request,
                               previously DMF request were generated."
       UNITS
       RANGE
   END_FIELD

   FIELD  data_path
       TYPE            C*9
       DESCRIPTION             "The OPUS pipeline from which the archive
                               request was generated."
       UNITS
       RANGE
   END_FIELD

   FIELD  file_cnt
       TYPE            I*2
       DESCRIPTION             "The file count as determined by archive
                               insertion request generation."
       UNITS
       RANGE
   END_FIELD

END_RECORD

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!   RELATION DECLARATION
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

RELATION  archive_req

    TYPE            ARCREQ_TYPE 

    DESCRIPTION

    SUBSYSTEM_USING "OPUS"

    INDEX  archive_req_1     
        TYPE         nonclustered
        FIELDS       dataset_name,archclass,archdate
    END_INDEX

END_RELATION

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!   INSTANCE DECLARATION
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!


INSTANCE  archive_req         

    GLOBAL

    TYPE        ARCREQ_TYPE 

END_INSTANCE