! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! ! ! SDDL Name: PASS_CATALOG.SDDL ! ! Purpose: This file defines the pass_catalog relation. ! ! Modification History: ! ! Date OPR Who Reason ! -------- ------- --- ------------------------------------------------- ! 10/18/94 27329 SXT Original implementation ! 06/23/95 28910 NLC Remove SPSS_NODE processing; ! the SITE field should be removed from this ! relation the next time the relation is modified. ! 04/12/96 30696 MRB Change index, increase pass_file_dir field size ! 04/26/96 30696 MRB Fix index so it is backwardly compatible ! 12/23/96 32823 MRB Create C structures ! 12/13/99 40241 MRB Remove field site, Sybase reserved word conflict !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! ! LANGUAGE C, FORTRAN, SQL INCLUDE ZSPSS_USER_TYPES.SDDL RECORD PASSCA_TYPE !------------------------------------------------------------------------------ ! ! RECORD INFORMATION ! !------------------------------------------------------------------------------ DESCRIPTION "This relation is populated by commands PASSFILE/RECEIVE and PASSFILE/UNSENT. It contains information about the files transferred from: PASS to SPSS and from SPSS to PODPS. The files that can be transferred from PASS to SPSS include the Mission Schedule, the Mission Timeline, the TDRS Need Coverage Report, and the Error Log Report. The files that can be transferred from SPSS to PODPS include the Science Mission Specification(SMS), the Mission Schedule and the Mission Timeline. Note the TDRS report does not seem to be used operationally and is never cataloged in this relation. When PASSFILE/RECEIVE is run, PASS generated files are copied to SOGS and are cataloged in this relation. Much of the information stored in each pass_catalog entry is based on data within the file headers as defined in ST-ICD-11. When PASSFILE/UNSENT is run certain PASS products are transferred to PODPS for archival purposes and the pass_catalog records can be updated with that information." !------------------------------------------------------------------------------ ! ! FIELD INFORMATION ! !------------------------------------------------------------------------------ FIELD pass_filnam DESCRIPTION "This is the name of the file that has been received from PASS. The name is extracted from the PASS file (and will be the the same as the pass_sms_nm field below). An extension representing the file type is concatenated onto the end. Possible file types and extensions are the following: Mission Schedule - .MSC - S.RMS Mission Timeline - .MTL - CTMLINE.RPT TDRS Needs Coverage Report - .TDRS Error Log Report - .ERL The version number of the file may also be stored in this name." TYPE C*20 END_FIELD FIELD file_type DESCRIPTION "This is the type associated with each file returned by PASS. This is similar to the extension that is concatenated into the pass_filnam field above, but is not exactly the same. The types are the following: Mission Schedule - MS Mission Timeline - MTL TDRS Needs Coverage Report - TDRS Error Log Report - EL" TYPE C*6 END_FIELD FIELD pass_sms_nm DESCRIPTION "This is the PASS SMS name or id, and is the concatenation of pass_sms_id, pass_sms_prv and pass_sms_rev found in the sms_catalog relation. It is used to associate the received PASS files with the SMS from which they were produced. The format is Sadddnpr where: S = source 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. p = patch number(base 36), default='0', for a given alternate code, day-of-year and same year code, incremented for each patch of an SMS. Set by SMSG/SEND. r = revision number(base 36), default='0', for a given alternate code,day-of-year, and same year code, incremented for each revision of an initial or alternate SMS. " TYPE C*8 END_FIELD FIELD date_recv DESCRIPTION "This is the date that the PASS file was received (in fact the time when the command PASSFILE/RECEIVE was run)." TYPE FULL_TIME_STAMP_TYPE END_FIELD FIELD start_time DESCRIPTION "This is the start time of the PASS file. PASSFILE/RECEIVE extracts this time from the file header. The 'date' section character position in the header is given by ST-ICD-11. See end_time field below." TYPE FULL_SOGS_CHAR_TIME_TYPE END_FIELD FIELD end_time DESCRIPTION "This is the end time of the PASS file. PASSFILE/RECEIVE extracts this time from the file header. The 'date' section character positions in the header is given by ST-ICD-11. See start_time field below." TYPE FULL_SOGS_CHAR_TIME_TYPE END_FIELD FIELD pass_fil_dir DESCRIPTION "This is the name of directory containing files from PASS. It was defined by logical name SPSS_NIB, and the translation of that logical name was stored here. When PASSFILE/RECEIVE is run, the PASS file is copied to this directory. With PASS running at STScI (PASSFILE/PReceive this will be the actual output directory used by PASS. " TYPE C*64 END_FIELD FIELD gen_time DESCRIPTION "This is the time that the PASS file was generated. It is extracted from the PASS file header as given by ST-ICD-11." TYPE FULL_TIME_STAMP_TYPE END_FIELD FIELD podps_filnam DESCRIPTION "When PASSFILE/UNSENT is run, the user inputs the name of the catalog file to be created. The files which are being sent to PODPS are listed in this catalog file. PASSFILE/UNSET will then ship the catalog file and its listed data files to PODPS. For each file sent to PODPS, the last character of the catalog file name(before the extension) is changed by PASSFILE/UNSENT. This can be used to track how many files were sent to PODPS of this type. If no files have been sent to PODPS (i.e. the podps_status below is 'N'), this field will be blank." TYPE C*13 END_FIELD FIELD podps_status DESCRIPTION "This field is set to 'S' when the file has been sent to and acknowledged by PODPS via PASSFILE/UNSENT. If no files have been sent, this is set to 'N', and the podps_filnam will be blank. If an error occurs within PASSFILE/UNSENT this field gets set to 'F' designating a fatal error." TYPE C*1 DISCRETE "S", "N", "F" END_FIELD END_RECORD !------------------------------------------------------------------------------ ! ! RELATION DECLARATION ! !------------------------------------------------------------------------------ RELATION pass_catalog TYPE PASSCA_TYPE DESCRIPTION "PASS Catalog Relation" SUBSYSTEM_USING "SPSS" INDEX pass_catalog_1 TYPE unique, clustered FIELDS pass_fil_dir, pass_filnam END_INDEX END_RELATION !------------------------------------------------------------------------------ ! ! INSTANCE DECLARATION ! !------------------------------------------------------------------------------ INSTANCE pass_catalog GLOBAL TYPE PASSCA_TYPE END_INSTANCE