! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! ! ! 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