Go to the bottom.

!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:	PASS_SMS_EDITS.SDDL
!
! Purpose:      This SDDL file defines the pass_sms_edits relation used in PASS
!               processing.
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ---   -------------------------------------------------
! 02/13/96   30697      MRB   Original implementation
! 02/22/96   30697      MRB   Incorporated Taylor, Chandler, and Owens comments
! 03/13/96   31033      EGB   Modified to be consistent with all other SDDLs
! 05/06/96   31421      MRB   Language was only FORTRAN; it did not include SQL
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!

LANGUAGE FORTRAN, SQL

INCLUDE  ZSPSS_USER_TYPES.SDDL

RECORD  SMS_EDITS_TYPE

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

    DESCRIPTION      "This relation associates a PASS SMS identifier with any 
                      SMS edits performed on that SMS. SMS edits are necessary 
                      from time to time to correct or modify dumps, tape usage, 
                      guide stars, etc.

                      Commands which populate and/or reference this 
                      relation are TOOL5, a to be named and written tool."


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


    FIELD  pass_sms_id
        TYPE PASS_SMS_ID_TYPE
    END_FIELD


    FIELD sms_edit_done
        DESCRIPTION    "The field contains the date on which the SMS was 
                        editted.  If this field is blank then no SMS edit 
                        was done!"
        TYPE SOGS_CHAR_TIME_TYPE
    END_FIELD


    FIELD comments
        DESCRIPTION    "The field contains a one-liner from the user that 
                        explains the reasons for or summarizes the editing 
                        changes."
        TYPE COMMENT_LINE_TYPE
    END_FIELD

END_RECORD


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


RELATION  pass_sms_edits

    TYPE             SMS_EDITS_TYPE

    DESCRIPTION      "PASS SMS Edits Relation"

    SUBSYSTEM_USING  "SPSS", "SCS", "PASS"

    RELATED_FIELDS  "pass_status.*" "pass_run_names.*" "pass_config_update.*"


    INDEX  pass_sms_edits_1
        TYPE         unique, clustered
        FIELDS       pass_sms_id, sms_edit_done
    END_INDEX

END_RELATION

!------------------------------------------------------------------------------
!
!   INSTANCE DECLARATION
!
!------------------------------------------------------------------------------


INSTANCE  pass_sms_edits

    GLOBAL

    TYPE        SMS_EDITS_TYPE

END_INSTANCE

Go to the top.