Go to the bottom.

!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:	PASS_RUN_NAMES.SDDL
!
! Purpose:      This SDDL file defines the pass_run_names relation.
!
! 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/12/96   31033      EGB   Modified to be consistent with all other SDDLs
! 05/06/96   31421      MRB   Related Field syntax correction
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!

LANGUAGE SQL

INCLUDE         ZSPSS_USER_TYPES.SDDL

RECORD  PASS_RUN_NM_TYPE

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

    DESCRIPTION      "This relation associates a PASS SMS identifier with
                      the initial and final run files generated during PASS
                      processing.

                      The command that populates and/or references this 
                      relation is MSCL.  MSCL is an STScI/SPST-developed shell
                      for the PASS Mission Scheduler and Command Loader." 


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


    FIELD  pass_sms_id
        TYPE PASS_SMS_ID_TYPE
    END_FIELD


    FIELD run_type
        DESCRIPTION    "This field specifies whether this is the initial or 
                        final run of PASS for the SMS."
        TYPE           C*6
        RELATED_FIELDS "pass_config_update.run_type"
    END_FIELD


    FIELD file_name
        DESCRIPTION    "The field holds filename created by PASS for this SMS 
                        during this run. This value is the filename of an 
                        output product from the Mission Scheduler or Command 
                        Loader. There are several files (records in this 
                        relation) for a given run. Typical values are: 
                        SA001G01, SA001G01_1, SA001G01_2, SA001G01_3,
                        SA001G01_F, SA001G01_F1, SA001G01_F2, SA001G01_FA3"
        TYPE           C*12
    END_FIELD

END_RECORD


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


RELATION  pass_run_names

    TYPE             PASS_RUN_NM_TYPE

    DESCRIPTION      "PASS Run Names Relation"

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

    RELATED_FIELDS  "pass_status.*" "pass_config_update.*" "pass_sms_edits.*"


    INDEX  pass_run_names_1
        TYPE         unique, clustered
        FIELDS       pass_sms_id, run_type, file_name
    END_INDEX

END_RELATION

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


INSTANCE  pass_run_names

    GLOBAL

    TYPE        PASS_RUN_NM_TYPE

END_INSTANCE

Go to the top.