!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:	PDB_TELEMETRY_XREF.SDDL
!
! Purpose:      This SDDL file defines the PDB_TELEMETRY_XREF relation.
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ----   ------------------------------------------------
! 10/19/99    39940     Baum   Original implementation
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!
 
LANGUAGE	SQL

RECORD  PDB_TELEMETRY_XREF_TYPE
 
!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------
 
 
DESCRIPTION       "This relation is used to define the values OMS needs to
                   process AEDP-derived telemetry files. Each telemetry file
                   has a header containing a three character PDB version id.
                   For each PDB version there is a mapping for all telemetry
                   format codes of PDB telemetry numbers to the unique
                   telemetry menonics found in the table oms_telemetry. The
                   table maps the AEDP PDB numbers to the CCS number used in
                   the oms_telemetry table. "



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

    FIELD  pdb_number
        TYPE            I4
        DESCRIPTION     "A positive value less than 10,000 defined for each
                         PDB version. Generally a particular telemetry item
                         referenced uniquely by the ccs_number in this table,
                         has different pdb_number values for each PDB version. "
    END_FIELD
	
    FIELD  ccs_number
        TYPE            I4
        DESCRIPTION     "A positive value less than 64K defined by CCS for
                         every unique telemetry item in the engineering 
                         warehouse. It is the Numeric ID described in the
                         definition of FOF elements (see Appendix A of 
                         HST-ICD-T2). "
    END_FIELD

    FIELD  pdb_version
        TYPE            C4
        DESCRIPTION     "The version name is usually two digits and an 
                         uppercase character starting with A. "

    END_FIELD

END_RECORD
 
 
!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------
 
 
RELATION  pdb_telemetry_xref
 
    TYPE             PDB_TELEMETRY_XREF_TYPE
 
    DESCRIPTION      "PDB Telemetry Cross-Reference Relation"
 
    SUBSYSTEM_USING  "OMS"

    INDEX  pdb_telemetry_xref_1
        TYPE         unique, clustered
        FIELDS       pdb_version, pdb_number 
    END_INDEX

    INDEX  pdb_telemetry_xref_2
        TYPE         unique
        FIELDS       ccs_number, pdb_version, pdb_number 
    END_INDEX

END_RELATION