Go to the bottom.
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! 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
Go to the top.