!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:    PNMFOF_TABLE.SDDL     
!
! Purpose:      This SDDL file defines the PNMFOF_TABLE relation
!
! Modification History:
!
!   Date       OPR      Who                    Reason
!----------------------------------------------------------------------
! 07/09/98     36119    JSCHULTZ               original
! 12/07/98     37507    Ken S.		Add fof_complete_date.
! 08/29/00     42336    J.Baum          Supply index.           
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!

LANGUAGE        SQL

RECORD  SUB_TYPE 

!----------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!----------------------------------------------------------------------
!
   DESCRIPTION  "This SDDL file defines the PNMFOF_TABLE relation. It is
                 used to track the transfer and processing of FOF files
                 designated by a PNM (Product Notification Message) from
                 CCS. "
!  
!----------------------------------------------------------------------
!
!   FIELD INFORMATION
!
!----------------------------------------------------------------------
   FIELD  pnm_name
       TYPE            C*17
       DESCRIPTION     "PNM File Name"
       UNITS
   END_FIELD

   FIELD  pnm_notification_date
       TYPE            C*22
       DESCRIPTION     "PNM File notification Date in yyyy.ddd:hh:mm:ss.sss"
       UNITS
   END_FIELD

   FIELD  pnm_receipt_date
       TYPE            C*22
       DESCRIPTION     "PNM File receipt Date in yyyy.ddd:hh:mm:ss.sss"
       UNITS
   END_FIELD

   FIELD  fof_name
       TYPE            C*15
       DESCRIPTION     "FOF File Name"
       UNITS
   END_FIELD

   FIELD  fof_transfer_date
       TYPE            C*22
       DESCRIPTION     "FOF File transfer Date in yyyy.ddd:hh:mm:ss.sss"
       UNITS
   END_FIELD

   FIELD  fof_complete_date
       TYPE            C*22
       DESCRIPTION     "FOF File competion Date in yyyy.ddd:hh:mm:ss.sss"
       UNITS
   END_FIELD

END_RECORD

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

RELATION  pnmfof_table

    TYPE            SUB_TYPE

    DESCRIPTION     "A historical account of what Subset Files were generated
                     from what FOF Files and when."

    SUBSYSTEM_USING "OMS"

    INDEX  pnmfof_table_1
        TYPE         unique, clustered
        FIELDS       pnm_name, pnm_receipt_date, fof_name
    END_INDEX

    INDEX  pnmfof_table_2
        TYPE         nonclustered
        FIELDS       fof_name, pnm_receipt_date
    END_INDEX

END_RELATION

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

INSTANCE  pnmfof_table

    GLOBAL

    TYPE        SUB_TYPE

END_INSTANCE