Go to the bottom.

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:	ms_merge_sms.sddl
!
! Purpose:      This SDDL file defines the ms_merge_sms relation.
!
! Modification History:
!
!   Date       PR      Who                       Reason
! --------   -------   ---   -------------------------------------------------
! 11/13/01   44750     MRB   Original implementation
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

LANGUAGE  SQL

INCLUDE  ZSPSS_USER_TYPES.SDDL

RECORD  ms_merge_sms_type

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

    DESCRIPTION      "This relation associates the various SMSes for a given
                      week that went into a PASS processing run.  For a given
                      week there is always a science SMS and usually an EPS 
                      SMS and DMS SMS.  An EPS SMS is a series of SASLWLIM 
                      statements to manage Solar Array positions and minimize
                      solar array drive electronics use.  A DMS SMS is a data 
                      management system SMS to manage SSR usage via TAPEDUMP
                      statements.

                      The file names stored here clearly record what went into 
                      a given run.  This information is helpful to document 
                      what a run consisted of and very helpful when cleaning up
                      after runs.  More information about the input file fields 
                      can be gleaned from PASS documentation.  

                      No SPSS software populates this relations.  SPST
                      operations tools are planned to populate and read 
                      this relation. "

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


    FIELD ms_name
        DESCRIPTION    "Mission Scheduler Name details? "
        TYPE PASS_MS_NAME_TYPE
    END_FIELD


    FIELD type
        DESCRIPTION    "Tells whether this is from an EPS, DMS, or other SMS."
        TYPE           C*1
    END_FIELD


    FIELD  pass_sms_id
        TYPE PASS_SMS_ID_TYPE
    END_FIELD


    FIELD merge_sms
        DESCRIPTION    "Contains the EPS or DMS SMS name as created by 
                        smsg -send."
        TYPE           C*16
    END_FIELD


END_RECORD


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


RELATION  ms_merge_sms

    TYPE             ms_merge_sms_type

    DESCRIPTION      "PASS Run Configuration By SMS Relation"

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

    RELATED_FIELDS  "pass_status.*" "pass_run_names.*" "pass_sms_edits.*" "cl_catalog.*" "ms_catalog.*"


    INDEX  ms_merge_sms_1
        TYPE         unique, clustered
        FIELDS       merge_sms
    END_INDEX

END_RELATION

Go to the top.