Go to the bottom.
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name: QBGSP_SELECT.SDDL
!
! Purpose: This SDDL file defines the qbgsp_select relation.
!
! Modification History:
!
! Date PR Who Reason
! -------- ------- --- -------------------------------------------------
! 11/16/94 27329 RJS Original implementation, J. Baum provided
! additional comments.
! 05/17/96 27745 bao Eliminate two-step GS acquisition support
! from database and SPSS
! 05/08/98 36870 MRB Add C output
! 10/30/98 37306 BAO Delete remnants of GSSS interface from SPSS
! 02/02/99 37931 sfs Deleted prob_pair.
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
LANGUAGE C, FORTRAN, SQL
INCLUDE ZSPSS_USER_TYPES.SDDL
RECORD QBGSPS_TYPE
!------------------------------------------------------------------------------
!
! RECORD INFORMATION
!
!------------------------------------------------------------------------------
DESCRIPTION "In this relation, groups of records for each obset
are generated by the SPSS GSSELECT command. QBGSP_SELECT
provides the list of GS pairs for a particular acquisi-
tion dataset that satisfies the constraints in the
relations QBACQD_DEF or QBACQS."
!------------------------------------------------------------------------------
!
! FIELD INFORMATION
!
!------------------------------------------------------------------------------
FIELD proposal_id
TYPE PROPOSAL_ID_TYPE
FORM
NAME "GSM"
LABEL "PROPOSAL ID"
END_FORM
END_FIELD
FIELD obset_id
TYPE OBSET_ID_TYPE
FORM
NAME "GSM"
LABEL "OBSET ID"
END_FORM
END_FIELD
FIELD version_num
TYPE VERSION_NUM_TYPE
FORM
NAME "GSM"
LABEL "OBSET VERSION"
END_FORM
END_FIELD
FIELD ccl_name
TYPE CCLIST_ID_TYPE
FORM
NAME "GSM"
LABEL "CCLIST FILE"
END_FORM
END_FIELD
FIELD ccl_version
TYPE CCLIST_VERSION_NUM_TYPE
FORM
NAME "GSM"
LABEL "CCLIST VERSION"
END_FORM
END_FIELD
FIELD gsp_id
TYPE GS_PAIR_ID_TYPE
FORM
NAME "GSM"
LABEL "GS PAIR ID"
END_FORM
END_FIELD
FIELD select_order
TYPE I2
DESCRIPTION "This field replaces the field WGGS_PAIRS.SELECTED.
SPST Operations has a procedure that sets the SELECTED
valued based on QBGSP_SELECT data but ignoring
SELECT_ORDER.
Additional comment from SEB/J. Baum:
If we ever automate the setting of SELECT_ORDER we will
probably use it but I think SMS generation still
depends on WGGS_PAIRS.SELECTED. If we use it in the
future, we would probably only need to support a single
GS pair acquistion (e.g. ACQ_SCENARIO = BASE1), and
the only allowed values for SELECT_ORDER would be 0
or 1, where only one record can have the value 1."
RELATED_FIELDS "wggs_pairs.selected"
FORM
NAME "GSM"
LABEL "SEL ORDER"
END_FORM
END_FIELD
FIELD slew_end_ra
TYPE R8
DESCRIPTION "This field is the right ascension of the first
targeted alignment of the obset."
UNITS "DEGREES"
END_FIELD
FIELD slew_end_dec
TYPE R8
DESCRIPTION "This field is the declination of the first
targeted alignment of the obset."
UNITS "DEGREES"
END_FIELD
FIELD data_set_id
TYPE C3
DESCRIPTION "A guide star dataset is a group of guide stars that
have the same guide star acquisition, timing, and
roll constraints.
This field identifies the data set and links
this record to the acquisition data set record
in the relation WGACQUIS. The WGACQUIS record
contains the PCS data actually used for scheduling
the obset on a calendar."
RELATED_FIELDS "wgacquis.*"
END_FIELD
FIELD pos_uncert
TYPE R4
DESCRIPTION "This field specifies the position uncertainty of
first PCS ACQ for scheduled obset."
END_FIELD
FIELD sel_seq
TYPE I2
DESCRIPTION "This field specifies the recommended guide star pair
selection sequence. This is the preferred order of
guide star pair usage. The field contains a sequence
counter, unique to the response, with the most
preferred guide star pair numbered one and the least
preferred numbered sequentially. This field is copied
from wggs_pairs.sel_seq."
RELATED_FIELDS "wggs_pairs.sel_seq"
FORM
NAME "GSM"
LABEL "SEL SEQ NUMBER"
END_FORM
END_FIELD
FIELD acq_sequence
TYPE I4
DESCRIPTION "This field refers to the type of GS acquisition
associated with this GS pair:
0 for primary acquisition
1-n for successive handoff acquisitions "
FORM
NAME "GSM"
LABEL "ACQUISITION SEQUENCE NUMBER"
END_FORM
END_FIELD
FIELD acq_order
TYPE C1
DESCRIPTION "This field specifies which star in the pair is
to be acquired first (GS pair acquisition order),
where 'D' = the dominant star should be acquired first,
'S' = the subdominant star should be acquired
first.
data is copied from wggs_pairs. "
FORM
NAME "GSM"
LABEL "ACQ ORDER"
END_FORM
DISCRETE "D", "S"
END_FIELD
END_RECORD
!------------------------------------------------------------------------------
!
! RELATION DECLARATION
!
!------------------------------------------------------------------------------
RELATION qbgsp_select
TYPE QBGSPS_TYPE
DESCRIPTION "Guide Star Pair Selection Relation"
SUBSYSTEM_USING "SPSS"
FORM
NAME "GSM", "GSS"
END_FORM
INDEX qbgsp_select_1
TYPE unique, clustered
FIELDS proposal_id, obset_id, version_num, ccl_name,
ccl_version, gsp_id, acq_sequence
END_INDEX
INDEX qbgsp_select_2
TYPE nonclustered
FIELDS ccl_name, ccl_version
END_INDEX
END_RELATION
!------------------------------------------------------------------------------
!
! INSTANCE DECLARATION
!
!------------------------------------------------------------------------------
INSTANCE qbgsp_select
GLOBAL
TYPE QBGSPS_TYPE
END_INSTANCE
Go to the top.