Go to the bottom.
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! 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
! 02/02/99    37931     sfs   Deleted est_acq_prob.
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
 
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  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."
        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

Go to the top.