! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! ! ! SDDL Name: WGUIDE_STARS.SDDL ! ! Purpose: This SDDL file defines the wguide_stars relation. ! ! Modification History: ! ! Date OPR Who Reason ! -------- ------- --- ------------------------------------------------- ! 11/14/94 27329 RSL Original implementation ! 01/30/98 35442 sss Removed several unused fields. ! 02/07/98 35442 bao New GS_REQUEST command required to perform Guide ! Star Processing ! 11/02/98 37306 bao Delete remnants of GSSS interface from SPSS !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! ! LANGUAGE FORTRAN, SQL, C INCLUDE ZSPSS_USER_TYPES.SDDL RECORD GSTARS_TYPE !------------------------------------------------------------------------------ ! ! RECORD INFORMATION ! !------------------------------------------------------------------------------ DESCRIPTION "The wguide_stars relation stores positional, magnitude, and acquisition related data pertaining to the guide stars of a potentially usable guide star pair. Usage of the relation in SPSS programs is described below. The GS_REQUEST program populates the wguide_stars table. When PMDB/UPDATE/TYPE=SU is run, it deletes observation set specific data for observation sets other than the first in a previous acquisition sequence. When this occurs, it deletes records from wguide_stars. The GS_REQUEST command uses the positional data for centerlining. It uses many of the fields to identify guide stars which may be used to create acquisition datasets. An Operations tool sets the filter position. SMSG/SCHEDULE selects pair ids from the relation." !------------------------------------------------------------------------------ ! ! FIELD INFORMATION ! !------------------------------------------------------------------------------ FIELD proposal_id TYPE PROPOSAL_ID_TYPE FORM NAME "GSP" LABEL "PROPOSAL ID" END_FORM END_FIELD FIELD obset_id TYPE OBSET_ID_TYPE FORM NAME "GSP" LABEL "OBSET ID" END_FORM END_FIELD FIELD version_num TYPE VERSION_NUM_TYPE FORM NAME "GSP" LABEL "VERSION NUM" END_FORM END_FIELD FIELD gs_pair_id TYPE GS_PAIR_ID_TYPE RELATED_FIELDS "wggs_pairs.gs_pair_id", "wguide_stars.gs_id", "wguide_stars.fgs_id" FORM NAME "GSP" LABEL "GS PAIR ID " END_FORM END_FIELD FIELD gs_id TYPE GS_ID_TYPE RELATED_FIELDS "wguide_stars.gs_pair_id" END_FIELD FIELD fgs_id TYPE C1 RELATED_FIELDS "wguide_stars.gs_pair_id" DESCRIPTION "This field specifies the FGS to be used." RANGE "1", "2", "3" END_FIELD FIELD preusage TYPE C1 DESCRIPTION "'Y' means that this guide star has been used successfully in the past. 'N' means that this guide star has not been used successfully. The field is not being used currently." END_FIELD FIELD nom_pos_ra TYPE R8 UNITS "DEGREES" DESCRIPTION "This is the nominal position in right ascension." END_FIELD FIELD nom_pos_dec TYPE R8 UNITS "DEGREES" DESCRIPTION "This is the nominal position in declination." END_FIELD FIELD plate_pos_ra TYPE R8 UNITS "DEGREES" DESCRIPTION "This is the plate nominal position in right ascension. It is the nominal position of the guide star as obtained from the plate specified by the guide star catalog plate id, or from a plate overlap solution if a plate overlap solution was required." END_FIELD FIELD plate_pos_dc TYPE R8 UNITS "DEGREES" DESCRIPTION "This is the plate nominal position in declination. It is the nominal position of the guide star as obtained from the plate specified by the guide star catalog plate id, or from a plate overlap solution if a plate overlap solution was required." END_FIELD FIELD pos_uncr_ra UNITS "ARCSECONDS" TYPE R8 DESCRIPTION "This is the positional uncertainty for the guide star in right ascension." END_FIELD FIELD pos_uncr_dec UNITS "ARCSECONDS" TYPE R8 DESCRIPTION "This is the position uncertainty for the guide star in declination." END_FIELD FIELD proper_ra UNITS "ARCSEC/YEAR" TYPE R8 DESCRIPTION "This field specifies the right ascension component of proper motion at the guide star nominal position." END_FIELD FIELD proper_dec UNITS "ARCSEC/YEAR" TYPE R8 DESCRIPTION "This field specifies the declination component of proper motion at the guide star nominal position." END_FIELD FIELD epoch TYPE C15 DESCRIPTION "This field specifies the epoch for the nominal position." END_FIELD FIELD parallax UNITS "ARCSECONDS" TYPE R8 DESCRIPTION "This field specifies the change in direction of the star." END_FIELD FIELD magnitude TYPE R4 DESCRIPTION "This field is the magnitude of the star, which is specified in the FGS system." UNITS "MAGNITUDE" END_FIELD FIELD est_acq_prob TYPE C4 DESCRIPTION "This field specifies an estimate of the success in acquiring the guide star, using the upper magnitude limit." RELATED_FIELDS "wguide_stars.upper_magn" END_FIELD FIELD single_spoil TYPE R4 DESCRIPTION "This field specifies an estimate of the smallest search radius for which there is a significant probability that, before the guide star is encountered, there lies within the search area at least one spoiler object that has a magnitude of less than the guide star upper magnitude setting. A spoiler object is one which can be mistaken for the guide star." RELATED_FIELDS "wguide_stars.upper_magn" END_FIELD FIELD double_spoil TYPE R4 DESCRIPTION "This field specifies an estimate of the smallest search radius for which there is a significant probability that, before the guide star is encountered, there lies within the search area at least two spoiler objects that have a magnitude of less than the guide star upper magnitude setting. A spoiler object is one which can be mistaken for the guide star." RELATED_FIELDS "wguide_stars.upper_magn" END_FIELD FIELD upper_magn TYPE R4 DESCRIPTION "This is the threshold magnitude corresponding to the acquisition probability. The stars with greater magnitude uncertainty have dimmer thresholds." RELATED_FIELDS "wguide_stars.est_acq_prob" UNITS "MAGNITUDE" END_FIELD FIELD filter_pos TYPE C3 DESCRIPTION "This field is set by an Operations tool that is executed at the time GSSELECT is run. The filter is set based on the PCS mode for the scenario being used by the observation set. Currently there are only two modes: course track and fine lock. For for coarse track the clear (CLR) filter is used, while for finelock the pupil (APS) filter is used. This field is only used if this star is associated with a guide star pair that has been selected for use in guide star acquisition." RELATED_FIELDS "qbpcs_def.scenario_acq", "qbpcs_def.pcs_mode" FORM NAME "GSP" LABEL "FILTER POS." END_FORM DISCRETE "APS", "CLR" END_FIELD FIELD dom_sub_flag TYPE C1 DESCRIPTION "This flag indicates if the guide star is the dominant or subdominant star in the pair. 'D' means this star is the dominant star in the pair. 'S' means it is the subdominant star. FORM NAME "GSP" LABEL "D/S/N" END_FORM DISCRETE "D", "S" END_FIELD END_RECORD !------------------------------------------------------------------------------ ! ! RELATION DECLARATION ! !------------------------------------------------------------------------------ RELATION wguide_stars TYPE GSTARS_TYPE DESCRIPTION "Guide Star Description Relation" SUBSYSTEM_USING "SPSS" FORM NAME "GSP" END_FORM INDEX wguide_stars_1 TYPE clustered FIELDS gs_pair_id ATTRIBUTES ignore_dup_row END_INDEX INDEX wguide_stars_2 TYPE nonclustered FIELDS proposal_id, obset_id, version_num END_INDEX INDEX wguide_stars_3 TYPE unique, nonclustered FIELDS gs_id, proposal_id, obset_id, version_num, gs_pair_id END_INDEX END_RELATION !------------------------------------------------------------------------------ ! ! INSTANCE DECLARATION ! !------------------------------------------------------------------------------ INSTANCE wguide_stars GLOBAL TYPE GSTARS_TYPE END_INSTANCE