!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:	OMS_STATUS_MESSAGE.SDDL
!
! Purpose:      This SDDL file defines the OMS_STATUS_MESSAGE relation.
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ----   ------------------------------------------------
! 11/15/99    39941     Baum   Original implementation
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!
 
LANGUAGE	SQL

RECORD  OMS_STATUS_MESSAGE_TYPE
 
!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------
 
 
DESCRIPTION       "This relation is used to define the values OMS needs to
                   identify SI status buffer messages. This file must be
                   complete for all SIs and all servicing missions. For each
                   SI or for EXEC each message number is unique. The message
                   lines have the most up-to-date values. Generally, older
                   superceded messages have out of date ACTION specifications. "


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

    FIELD  name
        TYPE            C6
        DESCRIPTION     "Either EXEC, FOC, FOS, HRS, HSP, WFPC, COSTAR, 
                         WFPC2, NICMOS, STIS, ACS, COS, or WFPC3. Always
                         upper case. "

    END_FIELD
	
    FIELD  message_number
        TYPE            I4
        DESCRIPTION     "This is the message number used by NSSC-1 computer
                         for the status condition. It starts at 0 and can be
                         as large as 9999. "

    END_FIELD
	
    FIELD  line_number
        TYPE            I4
        DESCRIPTION     "The line number of this part of the message. Starts 
                         at 1. "

    END_FIELD

    FIELD  line
        TYPE            C69
        DESCRIPTION     "This is a single mixed case line of the status buffer
                         message. Some messages use all uppercase but this is
                         not a standard format. Message often include place
                         keepers for reported data values but OMS does not
                         use this feature. It also contains ACTION suggestions
                         that are meant for CCS not OMS users. The lines are
                         broken at column 69 to support OMS products. "
                                   
    END_FIELD


END_RECORD
 
 
!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------
 
 
RELATION  oms_status_message
 
    TYPE             OMS_STATUS_MESSAGE_TYPE
 
    DESCRIPTION      "OMS Status Message Definition Relation"
 
    SUBSYSTEM_USING  "OMS"

    INDEX  oms_status_message_1
        TYPE         unique, clustered
        FIELDS       name, message_number, line_number 
    END_INDEX

END_RELATION