! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! ! ! 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 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! ! 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 prob_pair TYPE R4 DESCRIPTION "This field specifies the probability of successful pair acquisition." FORM NAME "GSS" LABEL "PROBABILITY OF SUCCESSFUL PAIR ACQ" END_FORM 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