Go to the bottom.
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:	SMS_CATALOG.SDDL
!
! Purpose:      This SDDL file defines the sms_catalog relation.
!
! Modification History:
!
!   Date       PR      Who                       Reason
! --------   -------   ---   -------------------------------------------------
! 11/15/94   27329     SXT   Original implementation
! 02/02/95   28292     SK    Modified "REPLICATION" wording under 
!                             SUBSYSTEM_USING
! 06/23/95   28910     NLC   Removed SPSS_NODE processing;
!			      the SMT_SITE field should be removed from this 
!			      relation the next time the relation is modified.
! 10/04/96   32300     MRB   Made directory fields larger, expand csh_fil_nm,
!                             and remove sms_site and sstl_fil_flg
! 01/27/96   16760     MRB   Removed OSS_FIL_FLG field and all OSS references
! 10/21/97   29733     MRB   Add fields end_sa_angle, eps_gen_time for EPS merge
! 08/27/99   39639     MRB   Removed two fields for obsolete command counting
! 08/27/99   38957     MRB   Removed two fields for cache file logging
! 09/29/99   32925     MRB   Removed 13 fields, mostly patch related:
!                             merge_start, merge_end, ptch_flg, patch_sms_id,
!                             patch_sms_v, patch_start, pass_sms_prv, 
!                             mrgl_fil_flg, mrgs_fil_flg, mrgt_fil_flg, 
!                             mms_fil_flg, mms_filnam, sms_tape_flg
! 01/21/00  33139      MRB   Restored pass_sms_prv
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!

LANGUAGE  C, FORTRAN, SQL

INCLUDE  ZSPSS_USER_TYPES.SDDL

RECORD  SMSCAT_TYPE

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


    DESCRIPTION      "This relation contains general information about  
                     the generation of the Science Mission Specifications(SMS). 
                     It includes information of generating a Logical SMS(LSMS),
                     precedence checking the LSMS, formatting the LSMS into an
                     SMS, transfering the SMS to PASS and sending PASS products
                     to OPUS. 
    
                     Commands which populate and/or reference this 
                     relation include:
                          SMSG/*, OBSR/*, and OPUS/OMS NSPSMS.
                     Operations tools and reports also use this relation." 


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



    FIELD  sms_cpu_id
        DESCRIPTION     "This field holds the name of the physical CPU for
                        the SMS files."
        TYPE            C*7
    END_FIELD



    FIELD  sms_gen_dir
        TYPE            C*64
        DESCRIPTION     "This field holds the name of the directory which
                        contains the files created during SMS generation,
                        formatting and checking. These files include:
                              Logical SMS
                              Formatted SMS
                              Error Summary
                              OPUS Support Schedule
                              Expander Trace File
                              Precedence Checker Trace File
                        and various temporary files.   
                        
                        The name of the directory is obtained by translating 
                        the logical name: SPSS_SMS."
    END_FIELD



    FIELD  sms_xfer_dir
        TYPE            C*64
        DESCRIPTION     "This field holds the the name of the directory which
                        contains files to be transferred to PASS. These files 
                        consist of PASS SMS files (mission schedule, mission
                        timeline) needed by OPUS and OMS.
 
                        The name of the directory is obtained by translating 
                        the logical name SPSS_NIX."
    END_FIELD



    FIELD  sms_id
        TYPE SMS_ID_TYPE
    END_FIELD



    FIELD  sms_version
        TYPE SMS_VERSION_NUM_TYPE
    END_FIELD



    FIELD  cc_version
        TYPE CCLIST_VERSION_NUM_TYPE 
    END_FIELD



    FIELD  orb_evt_id
        TYPE            C*9
        DESCRIPTION     "This is the VMS filename of the orbit file
                        associated with the C&C List used to generate
                        this LSMS and other related SMS files. This file 
                        resides in the SPSSORB directory with a filetype 
                        of DAT. The version number described below uniquely 
                        identifies it."
    END_FIELD



    FIELD  orb_evt_ver
        TYPE            I*2
        DESCRIPTION     "This is the version number of the orbit file 
                        described above."
    END_FIELD



    FIELD  link_sms_id
        TYPE SMS_ID_TYPE
        DESCRIPTION     "This field holds a VMS file name, which is the ID
                        of a previously checked full SMS linked to this SMS. 
                        It has a scheduling period that ends where this SMS
                        starts.  This link SMS ID and the version number below
                        are specified on the SMSG/CHECK/LINK command and are 
                        recorded here.
      
                        The Precedence Checker is driven by internal tables. 
                        Most of these tables must be initialized prior to 
                        checking an SMS. By default, these tables are 
                        initialized with data from a file, called 'DEFAULT.INT'.
                        Alternate initial conditions can be selected from the
                        VMS file specified by this and the next field."
    END_FIELD



    FIELD  link_sms_ver
        TYPE SMS_VERSION_NUM_TYPE
        DESCRIPTION     "This is the VMS version number of the linked SMS ID
                        described above."
    END_FIELD



    FIELD  lsms_gen_tim
        TYPE FULL_SOGS_CHAR_TIME_TYPE 
        DESCRIPTION     "This field contains the LSMS generation time. 
			NSGEN sets this field at the completion of the LSMS."
    END_FIELD



    FIELD  start_time
        TYPE FULL_SOGS_CHAR_TIME_TYPE   
        DESCRIPTION     "This field contains the start time for this SMS.
                        The start time of an SMS is set to be the start 
                        time of the corresponding C&C List, which is input
                        by the user during C&C List creation. Typically an 
                        SMS covers a one week scheduling interval. See the     
                        description of nsment_end_time below for additional
                        information."
    END_FIELD



    FIELD  end_time
        TYPE FULL_SOGS_CHAR_TIME_TYPE   
        DESCRIPTION     "This field contains the end time for this SMS.
                        The end time of an SMS is set to be the end time of 
                        the corresponding C&C List, which is input by the user 
                        during C&C List creation.
                        
                        When combined with the nsmstt_start_time, a scheduling 
                        interval is defined for this SMS. Only a single SMS is
                        allowed to be baselined over this scheduling
                        period."
    END_FIELD



    FIELD  proposal_flg
        TYPE YES_NO_FLAG_TYPE
        DESCRIPTION     "This field is set to 'Y' if this SMS contains any
                        labels that indicate the statement was generated
                        from a proposal rather than a program. Otherwise,
                        it is set to 'N'."
    END_FIELD



    FIELD  sms_fmt_flg
        TYPE YES_NO_FLAG_TYPE
        DESCRIPTION     "This flag is set to 'Y' by the command SMSG/FORMAT 
                        when an attempt has been made to format this SMS.
                        SMSG/GEN initializes it to 'N'. It is set to 'Y' by 
                        SMSG/FORMAT regardless of how things went during the
                        formatting process. An SMS is sent to PASS only
                        when no formatting errors have occurred during
                        the processing."
    END_FIELD



    FIELD  fmt_gen_tim
        TYPE FULL_SOGS_CHAR_TIME_TYPE   
        DESCRIPTION     "This field holds the time the LSMS is formatted by
                        SMSG/FORMAT. It is set to the time of the completion 
                        of SMS formatting."
    END_FIELD



    FIELD  p_check_flg
        TYPE YES_NO_FLAG_TYPE
        DESCRIPTION     "This field is the precedence check flag. It is 
                        initialized by SMSG/GEN to 'N' and set to 'Y' by 
                        SMSG/CHECK after precedence checking."
    END_FIELD



    FIELD  p_check_time
        TYPE FULL_SOGS_CHAR_TIME_TYPE 
        DESCRIPTION     "This field holds the time the LSMS is precedence
                        checked by SMSG/CHECK. It is set the time at the 
                        completion of SMS precedence checking."
    END_FIELD



    FIELD  cc_cr_ovr
        TYPE YES_NO_FLAG_TYPE
        DESCRIPTION     "This flag is set to 'Y' by SMSG/GEN when the C&C List 
                        SMSG/GEN is using has some temporary constraints and/or
                        restrictions. For example, when an SU is not ready for
                        PASS or an SU is modified after it was added to the 
                        C&C List. Otherwise this field is set to 'N'."
    END_FIELD



    FIELD  sms_send_stt
        TYPE            C*1
        DESCRIPTION     "This field holds the SMS send status reflects 
                        conditions resulting from a request to SMSG/SEND to 
                        send this SMS to PASS. The following states are 
                        defined:
                             BLANK: this SMS has never been sent to PASS.
                             B    : baselined
                             R    : baseline replaced
                             T    : successful transfer
                             F    : error in transfer "
        DISCRETE        " ", "B", "R", "T", "F"
    END_FIELD



    FIELD  sms_send_tim
        TYPE FULL_SOGS_CHAR_TIME_TYPE   
        DESCRIPTION     "This field holds the time that SMSG/SEND transmitted 
                        this SMS to PASS."
    END_FIELD



    FIELD  alt_sms_code
        TYPE            C*1
        DESCRIPTION     "This is a single alphabetic character('A' - 'Z')
                        used to specify alternate SMSs to be transmitted to 
                        PASS.  The alternate code is the second character of 
                        the PASS_SMS_ID described below. The scheduling periods
                        of SMSs with different alternate codes may overlap.
                        This field is set by the /alternate qualifier
                        of command SMSG/SEND. The default value is 'A'."
        RANGE           "A .. Z"
    END_FIELD



    FIELD  pass_sms_id
        TYPE            C*6
        DESCRIPTION     "This field is the first 6 characters of the VMS
                        filename that gets sent to PASS. SMSG/SEND sets it at
                        send time to sadddn, where
                               S   = formerly source, now type of SMS
                                     S Science SMS, E EPS SMS, D DMS SMS
                               a   = alternate code('A' - 'Z'), default='A',
                                     set by SMSG/SEND command qualifier 
                                     /ALTERNATE.
                               ddd = day-of-year of SMS start time.
                               n   = year code (base 36: '0'-'9', 'A'-'Z')
                                     for SMS begin time. 0 means year 1980.
       RELATED_FIELDS  "pass_catalog.pass_sms_nm"
    END_FIELD



    FIELD  pass_sms_rev
        TYPE            C*1
        UNITS           "BASE_36"
        DESCRIPTION     "This field contains a single base-36 number that 
                        represents the revision number of this SMS. If an 
                        SMS with the same time interval and alternate code 
                        has already been sent to PASS, then this SMS revision 
                        number will be incremented.

                        Concatenating this field to the PASS_SMS_ID and 0
                        (formerly PASS_SMS_PRV) produces the VMS filename 
                        of the file that is sent to PASS, which is acturally
                        the field PASS_SMS_NM in relation PASS_CATALOG. 
 
                        This field is populated by SMSG/SEN at send time." 
    END_FIELD



    FIELD  pass_sms_prv
        TYPE            C*1
        UNITS           "BASE_36"
        DESCRIPTION     "This field contains a single base-36 number that 
                        is always zero.  Formerly it represented
                        the patch revision number of this SMS.  This field
                        is a PASS SMS ID possibly reusable value.  It is 
                        populated by SMSG/SEND at send time to 0."
    END_FIELD



    FIELD  obsr_gen_flg
        TYPE            C*1
        DESCRIPTION     "This field contains the PODPS/OPUS observation records 
                        generation flag.
 
                        It is initialized to 'N' by SMSG/GEN.

                        It is set to 'Y' by OBSR/GENERATE when a set of
                        observation records is generated for this SMS.

                        It is set to 'P' by OBSR/DELETE if part of the 
                        observation records for an SMS have been deleted.  
                        This is when a start and end time or an obset was 
                        specified. 

                        It is set to 'N' by OBSR/DELETE if all observation 
                        records for an SMS have been deleted." 
        DISCRETE        "Y", "P", "N"
    END_FIELD



    FIELD  obsr_gen_tim
        TYPE FULL_SOGS_CHAR_TIME_TYPE   
        DESCRIPTION     "This field holds the time that OBSR/GENERATE generated
                        the observation records."
    END_FIELD



    FIELD  expedite_flg
        TYPE YES_NO_FLAG_TYPE
        DESCRIPTION     "This flag is set to 'Y' indicating that this SMS 
                        should be transmitted to PASS without making 'Ready 
                        for PASS' checks. It is set by the qualifier /EXPEDITE
                        of the command SMSG/SEND."
    END_FIELD



    FIELD  lsms_fil_flg
        TYPE YES_NO_FLAG_TYPE
        DESCRIPTION     "This field is set to 'Y' by SMSG/GEN indicating 
                        a logical SMS has been created."
    END_FIELD



    FIELD  sms_fil_flg
        TYPE            C*1
        DESCRIPTION     "This flag is set to 'Y' by SMSG/FORMAT when an 
                        attempt has been made to format a Logical SMS." 
        DISCRETE        "Y", " "
    END_FIELD



    FIELD  pass_fil_flg
        TYPE YES_NO_FLAG_TYPE
        DESCRIPTION     "This flag is set to 'Y' by SMSG/SENG after it has
                        created a PASS SMS file. This field is initialized 
                        to 'N' by SMSG/GEN."
    END_FIELD



    FIELD  pdps_fil_flg
        TYPE YES_NO_FLAG_TYPE
        DESCRIPTION     "This field is set to 'Y' by SMSG/SCHEDULE indicating
                        an OPUS support schedule file has been created. It is 
                        initialized to 'N' by SMSG/GEN."
    END_FIELD



    FIELD  errs_fil_flg
        TYPE YES_NO_FLAG_TYPE
        DESCRIPTION     "This field is a set to 'Y' by SMSG/GEN indicating 
                        an error summary file has been created."
    END_FIELD



    FIELD  ms_fil_flg
        TYPE YES_NO_FLAG_TYPE
        DESCRIPTION     "This field is set to 'Y' by PASSFILE/RECEIVE
                        indicating a Mission Schedule file has received.
                        It is initialized to 'N' by SMSG/GEN."
    END_FIELD



    FIELD  ms_filnam
        TYPE            C*20
        DESCRIPTION     "This field holds the name of the Mission Schedule 
                        file received from PASS in Sadddnpr.MSC;vv format.
                        Sadddnpr is the corresponding PASS SMS name, which
                        is the field pass_sms_nm in relation PASS_CATALOG."
        RELATED_FIELDS  "pass_catalog.pass_sms_nm"
    END_FIELD



    FIELD  elog_fil_flg
        TYPE YES_NO_FLAG_TYPE
        DESCRIPTION     "This field is set to 'Y' by PASSFILE/RECEIVE
                        indicating an Error Log file has been received."
    END_FIELD



    FIELD  erlog_filnam
        TYPE            C*20
        DESCRIPTION     "This field holds the name of the PASS Error Log file 
                        in Sadddnpr.ERL;vv format. Sadddnpr is the 
                        corresponding PASS SMS name, which is the field 
                        pass_sms_nm in relation PASS_CATALOG."
        RELATED_FIELDS  "pass_catalog.pass_sms_nm"
    END_FIELD



    FIELD  gensms_cont
        TYPE            I*2
        DESCRIPTION     "This field contains the number of continuable errors 
                        reported while generating an SMS."
    END_FIELD



    FIELD  gensms_sevre
        TYPE            I*2
        DESCRIPTION     "This field contains the number of severe errors 
                        reported while generating an SMS."
    END_FIELD



    FIELD  chksms_cont
        TYPE            I*2
        DESCRIPTION     "This field contains the number of continuable errors 
                        detected while performing precedence checking."
    END_FIELD



    FIELD  chksms_sevre
        TYPE            I*2
        DESCRIPTION     "This field contains the number of severe errors 
                        detected while performing precedence checking."
    END_FIELD



    FIELD  fmtsms_cont
        TYPE            I*2
        DESCRIPTION     "This field contains the number of continuable errors 
                        detected while formatting an SMS."
        UNITS           
        RANGE           
    END_FIELD



    FIELD  fmtsms_sevre
        TYPE            I*2
        DESCRIPTION     "This field contains the number of severe errors 
                        detected while formatting an SMS."
    END_FIELD



    FIELD  errlog
        TYPE            I*2
        DESCRIPTION     "This field contains the number of errors returned 
                        from PASS in the error log file."
    END_FIELD



    FIELD  ms_run_name
        TYPE            C*20
        DESCRIPTION     "This field holds the Mission Schedule run name,
                        which is specified in the header of the Mission
                        Schedule file received from PASS."
    END_FIELD



    FIELD  err_max_sev
        TYPE            C*1
        DESCRIPTION     "This field holds the maximum severity level detected
                        by PASS in the processing of an SMS. A severity level
                        can have a value of one through five. Ones and twos
                        are generally ignorable. Fours or more cannot be 
                        ignored." 
    END_FIELD



    FIELD  tdrs_filnam
        TYPE            C*20
        DESCRIPTION     "This field holds the name of the PASS TDRS Needs 
                        Coverage Report file received by PASSFILE/RECEIVE
                        from PASS in Sadddnpr.TDRS;vv format. Sadddnpr is 
                        the corresponding PASS SMS name, which is the field 
                        pass_sms_nm in relation PASS_CATALOG."
        RELATED_FIELDS  "pass_catalog.pass_sms_nm"
    END_FIELD



    FIELD  tdrs_fil_flg
        TYPE YES_NO_FLAG_TYPE
        DESCRIPTION     "This field is set to 'Y' by PASSFILE/RECEIVE when 
                        the TDRS Needs Coverage Report file is received."
    END_FIELD



    FIELD  podps_filnam
        DESCRIPTION     "This field is the file name used when the SMS was
                        transferred to PODPS/OPUS."
        TYPE            C*13
    END_FIELD



    FIELD  podps_status
        TYPE            C*1
        DESCRIPTION     "This field is set to 'S' when a successful
                        transfer of the SMS to PODPS/OPUS is acknowledged."
    END_FIELD



    FIELD  podps_ms_fil
        TYPE            C*13
        DESCRIPTION     "This field is the file name used when the Mission
                        Schedule was transferred to PODPS/OPUS."
    END_FIELD



    FIELD  podps_ms_stt
        TYPE            C*1
        DESCRIPTION     "This field is set to 'S' when a successful
                        transfer of the Mission Schedule to PODPS/OPUS is 
                        acknowledged."
    END_FIELD



    FIELD  account_name
        TYPE            C*12
        DESCRIPTION     "This field identifies the account name of the
                        user of which the SMS generation products belong."
    END_FIELD



    FIELD  eps_gen_time
        TYPE FULL_SOGS_CHAR_TIME_TYPE 
        DESCRIPTION     "This is the Electrical Power System SMS generation 
                        time.  SMSG/EPS_MERGE sets this field when it is run."
    END_FIELD


    FIELD  end_sa_angle
        TYPE            R*8
        UNITS           "DEGREES"
        DESCRIPTION     "This stores the solar array angle (V1 to SA normal) 
                         at the end of this SMS, in degrees.  It is used to 
                         initialize SA slew minimization processing for the 
                         subsequent SMS. It is populated by SMSG/EPS_MERGE."
    END_FIELD

END_RECORD


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


RELATION  sms_catalog

    TYPE             SMSCAT_TYPE

    DESCRIPTION      "SMS Catalog Relation"

    SUBSYSTEM_USING  "SPSS", "SCS", "REPLICATION-FROM-SOGS"

    INDEX  sms_catalog_1
        TYPE         unique, clustered
        FIELDS       sms_id, sms_version
    END_INDEX

END_RELATION

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


INSTANCE  sms_catalog

    GLOBAL

    TYPE        SMSCAT_TYPE

END_INSTANCE

Go to the top.