! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! ! ! SDDL Name: QTARGETS.SDDL ! ! Purpose: This SDDL file defines the qtargets relation. ! ! Modification History: ! ! Date PR Who Reason ! -------- ------- --- ------------------------------------------------- ! 11/15/94 27329 SSS Original implementation ! 01/20/95 27329 SXT Add new fields: af_rev_number, af_load_date ! 08/20/97 35059 MRB Added C output ! 12/02/97 34376 SBA Added new field mtwindow_update ! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! ! LANGUAGE C, FORTRAN, SQL INCLUDE ZSPSS_USER_TYPES.SDDL RECORD QTARGT_TYPE DESCRIPTION "This relation contains the primary information related to fixed and moving targets. In general it contains the target type (i.e. fixed, moving, area, etc.), fixed target positions, surface feature target locations, magnitudes, etc." FIELD target_id TYPE TARGET_ID_TYPE DESCRIPTION "This field is a unique name assigned to the target." FORM NAME "TCD" LABEL "TARGET ID" END_FORM END_FIELD FIELD same_target TYPE TARGET_ID_TYPE DESCRIPTION "This field identifies another record in the relation, by target name/id which is considered to be the same target (i.e. this is a duplicate entry which cannot be deleted)." UNITS FORM NAME "TCD" LABEL "SAME TARGET AS" END_FORM END_FIELD FIELD last_update TYPE TIME_STAMP_TYPE DESCRIPTION "This field is the time of the last update to the target data." FORM NAME "TCD" LABEL "TARGET DATE OF LAST UPDATE" END_FORM END_FIELD FIELD mtwindow_update TYPE TIME_STAMP_TYPE DESCRIPTION "This field is the time of the last update to the windows data stored in qtmwindows" FORM NAME "TCD" LABEL "MOVING TARGET DATE OF LAST UPDATE" END_FORM RELATED_FIELDS "qtmwindows.*" END_FIELD FIELD gsss_update TYPE C1 DESCRIPTION "This flag indicates the status of a guide star request for a position update. N implies a position update was not requested. Q implies a position update was requested. C implies a position update was received." FORM NAME "TCD" LABEL "GSSS POSITION UPDATE (N/Q/C)" END_FORM DISCRETE "C", "N", "Q" END_FIELD FIELD allow_update TYPE YES_NO_FLAG_TYPE DESCRIPTION "This is a flag to indicate if further updates are to be allowed to this target data. 'Y' implies updates are allowed, 'N' implies that no updates allowed. Only the privileged OA can reset an 'N' to 'Y'. FORM NAME "TCD" LABEL "TARGET UPDATE ALLOWED (Y/N)" END_FORM END_FIELD FIELD prev_observ TYPE YES_NO_FLAG_TYPE DESCRIPTION "This is a flag to indicate if this target has been successfully observed. 'Y' implies that the target was previously observed." FORM NAME "TCD" LABEL "PREVIOUSLY OBSERVED(Y/N)" END_FORM END_FIELD FIELD gs_pair_id TYPE GS_PAIR_ID_TYPE DESCRIPTION "This field is the guide star pair id of the gs pair that was used to acquire the target successfully. This field is only significant if field 'prev_observ' is set to 'Y'." FORM NAME "TCD" LABEL "GUIDE STAR PAIR ID" END_FORM RELATED_FIELDS "wggs_pairs.*" END_FIELD FIELD gsc_plate_id TYPE C4 DESCRIPTION "This field is the Guide Star Catalog plate id which specifies the plate which was used to determine the target position." FORM NAME "TCD" LABEL "GUIDE STAR PLATE ID" END_FORM END_FIELD FIELD target_type TYPE C1 DESCRIPTION "This field specifies the target type. The possible choices are a point target ('P'), an area target ('A'), a generic target ('G'), or a moving target ('M')." FORM NAME "TCD" LABEL "TARGET TYPE (P/A/M/G)" END_FORM DISCRETE "A", "G", "M", "P" END_FIELD FIELD target_size TYPE R8 UNITS "KILOMETERS" DESCRIPTION "This field is the target size (disk diameter). It is specified for moving targets only." FORM NAME "TCD" LABEL "MOVING TARGET SIZE" END_FORM END_FIELD FIELD id_method TYPE I2 DESCRIPTION "This field indicated the target identification method. '0' indicates the method is not relevant. '1' implies the Guide Star Catalog plates were used. '2' indicates that special plates where requested." FORM NAME "TCD" LABEL "TARGET ID METHOD" END_FORM END_FIELD FIELD binary_star TYPE YES_NO_FLAG_TYPE DESCRIPTION "This is a flag to indicate if the target is a binary star. 'Y' implies the target is a binary star." FORM NAME "TCD" LABEL "BINARY STAR (Y/N)" END_FORM END_FIELD FIELD mag_band_sys TYPE C10 DESCRIPTION "This field is the name of the system of stellar magnitudes to which the magnitude band designator applies (Johnson extension of the UBV system)." FORM NAME "TCD" LABEL "MAGNITUDE BAND SYSTEM" END_FORM END_FIELD FIELD mag_band TYPE C2 DESCRIPTION "This field is a measure of the relative brightness of stars and celestial objects (Johnson extension of the UBV system). The possible choices are the following : 'UN' is unknown, 'U' is 3650a, 'B' is 4400a, 'V' is 5500a, 'R' is 7000a, 'I' is 8800a, 'J' is 1.25u, 'K' is 2.2u, 'L' is 3.4u, 'M' is 5.0u, and 'N' is 10.4u." FORM NAME "TCD" LABEL "MAGNITUDE BAND" END_FORM DISCRETE "UN","U","B","V","R","I","J","K","L","M","N" END_FIELD FIELD nominal_mag TYPE R4 DESCRIPTION "This field is the nominal magnitude of the target. It is a measure of the brightness of the object as viewed from the earth. The value depends on the object's luminosity, the distance, and the amount of light absorption by intersteller matter between the object and the earth. " FORM NAME "TCD" LABEL "NOMINAL MAGNITUDE" END_FORM END_FIELD FIELD minimum_mag TYPE R4 DESCRIPTION "This field is the minimum magnitude of the target. It is a measure of the brightness of the object as viewed from the earth. The value depends on the objec'ts luminosity, the distance, and the amount of light absorption by intersteller matter between the object and the earth. " FORM NAME "TCD" LABEL "MINIMUM MAGNITUDE" END_FORM END_FIELD FIELD maximum_mag TYPE R4 DESCRIPTION "This field is the maximum magnitude of the target. It is a measure of the brightness of the object as viewed from the earth. The value depends on the object's luminosity, the distance, and the amount of light absorption by intersteller matter between the object and the earth. " FORM NAME "TCD" LABEL "MAXIMUM MAGNITUDE" END_FORM END_FIELD FIELD mag_unc TYPE R4 DESCRIPTION "This is the magnitude uncertainty of the target. It is a measure of the brightness of the object as viewed from the earth. The value depends on the object's luminosity, the distance, and the amount of light absorption by intersteller matter between the object and the earth. " FORM NAME "TCD" LABEL "MAGNITUDE UNCERTAINTY" END_FORM END_FIELD FIELD col_band_sys TYPE C10 DESCRIPTION "This field is the name of the system of stellar color to which color band designator applies." FORM NAME "TCD" LABEL "COLOR BAND SYSTEM" END_FORM END_FIELD FIELD color_band TYPE C2 DESCRIPTION "This field is the color band of the target. The possible choices are 'UN' (unknown), 'UB', or 'BV'. This is the difference between the apparent magnitude of a star measured at one standard wavelength and the apparent magnitude at another (always longer) standard wavelength. 'B' is magnitude measured with blue starlight. 'V' is the magnitude measured with greenish/yellow starlight. 'U' is the apparent magnitude measured in with ultraviolet radiation." FORM NAME "TCD" LABEL "COLOR BAND" END_FORM END_FIELD FIELD color_nom TYPE R4 DESCRIPTION "This field is the nominal color index (1 x 10e-4 precision). The value depends on the spectral distribution of the starlight, i.e. predominantly blue, red, etc." FORM NAME "TCD" LABEL "COLOR INDEX" END_FORM END_FIELD FIELD color_unc TYPE R4 DESCRIPTION "This field is the color uncertainty (1 x 10e-4 precision)." FORM NAME "TCD" LABEL "INDEX UNCERTAINTY" END_FORM END_FIELD FIELD redshift TYPE R4 DESCRIPTION "This field is the redshift; a displacement of the spectral lines toward longer wavelength values due the doppler effect." FORM NAME "TCD" LABEL "REDSHIFT" END_FORM END_FIELD FIELD spectral_typ TYPE C15 DESCRIPTION "This field is the stellar spectral type." FORM NAME "TCD" LABEL "SPECTRAL TYPE" END_FORM END_FIELD FIELD epoch TYPE C7 DESCRIPTION "This field is the epoch date for the target position It takes the form 'eyyyy.f'; where 'e' indicates the coordinate system (B or J), 'yyyy' indicates the year and 'f' indicates a fraction of a year." FORM NAME "TPS" LABEL "EPOCH OF TARGET" END_FORM END_FIELD FIELD equinox TYPE C7 DESCRIPTION "This field is the epoch of equinox for the target coordinate system used to specify the target position. It takes the form 'eyyyy.f'; where 'e' indicates the coordinate system (B or J), 'yyyy' indicates the year and 'f' indicates a fraction of a year." FORM NAME "TPS" LABEL "MEAN EQUINOX AND EQUATOR AT" END_FORM END_FIELD FIELD radial_vel TYPE R8 UNITS "KILOMETERS/SECOND" DESCRIPTION "This the radial velocity of a star along the line of sight of an observer. It is calculated directly from the doppler shift in the lines of the stars spectrum." FORM NAME "TPS" LABEL "RADIAL VELOCITY(km/sec)" END_FORM END_FIELD FIELD right_ascsn TYPE R8 UNITS "DEGREES" DESCRIPTION "This is the proposer supplied right ascension of the target position reference point in input equinox and epoch. For circular area targets, the reference point is the circle center. It is arbitrary for quadrilateral or rectangular targets. For point targets it is the target position." FORM NAME "TPS" LABEL "RIGHT ASCENSION" END_FORM END_FIELD FIELD declination TYPE R8 UNITS "DEGREES" DESCRIPTION "This is the proposer supplied right declination of the target position reference point in input equinox and epoch. For circular area targets, the reference point is the circle center. It is arbitrary for quadrilateral or rectangular targets. For point targets it is the target position." FORM NAME "TPS" LABEL "DECLINATION" END_FORM END_FIELD FIELD ra_uncer TYPE R8 UNITS "ARCSECONDS" DESCRIPTION "This field is the uncertainty in the target right ascension. It is measured along the great circle orthogonal to the constant RA great circle at the nominal position." FORM NAME "TPS" LABEL "RIGHT ASCENSION" END_FORM END_FIELD FIELD dec_uncer TYPE R8 UNITS "ARCSECS" DESCRIPTION "This field is the uncertainty in the target declination. It is measured along the RA great circle at the nominal position and the J2000 North Celestial pole." FORM NAME "TPS" LABEL "DECLINATION" END_FORM END_FIELD FIELD ra_proper_mo TYPE R8 UNITS "ARCSECONDS/YEAR" DESCRIPTION "This field is the target right ascension proper motion." FORM NAME "TPS" LABEL "RIGHT ASCENSION" END_FORM END_FIELD FIELD dc_proper_mo TYPE R8 UNITS "ARCSECONDS/YEAR" DESCRIPTION "This field is the target declination proper motion." FORM NAME "TPS" LABEL "DECLINATION" END_FORM END_FIELD FIELD ra_proper_un TYPE R8 UNITS "ARCSECONDS/YEAR" DESCRIPTION "This field is the uncertainty in the right ascension of the target proper motion." FORM NAME "TPS" LABEL "ACQUISITION UNCERTAINTY" END_FORM END_FIELD FIELD dc_proper_un TYPE R8 UNITS "ARCSEC/YEAR" DESCRIPTION "This field is the uncertainty in the declination of the target proper motion." FORM NAME "TPS" END_FORM END_FIELD FIELD ra_j2000 TYPE R8 UNITS "DEGREES" DESCRIPTION "This field is the right ascension of the target position expressed in the J2000 coordinate system." FORM NAME "TPS" END_FORM END_FIELD FIELD dec_j2000 TYPE R8 UNITS "DEGREES" DESCRIPTION "This field is the declination of the target position expressed in the J2000 coordinate system." FORM NAME "TPS" END_FORM END_FIELD FIELD j2ra_prop_mo TYPE R8 UNITS "ARCSECONDS/YEAR" DESCRIPTION "This field is the right ascension proper motion of the target expressed in the J2000 coordinate system." FORM NAME "TPS" END_FORM END_FIELD FIELD j2dc_prop_mo TYPE R8 UNITS "ARCSECONDS/YEAR" DESCRIPTION "This field is the declination proper motion of the target expressed in the J2000 coordinate system." FORM NAME "TPS" END_FORM END_FIELD FIELD parallax TYPE R8 UNITS "ARCSECONDS" DESCRIPTION "This field represents the apparent change in position of the target due to the motion of the earth around the sun." FORM NAME "TPS" LABEL "PARALLAX(arcsecs)" END_FORM END_FIELD FIELD geometry_flg TYPE C1 DESCRIPTION "This is a flag to indicate the geometric shape of the target where 'Q' is a quadrilateral target area, 'C' is a circular target area, and ' ' is not an area target." FORM NAME "TPS" LABEL "GEOMETRIC SHAPE OF THE TARGET" END_FORM DISCRETE " ", "C", "Q" END_FIELD FIELD defref_pnt TYPE YES_NO_FLAG_TYPE DESCRIPTION "This is a flag to indicate if the target reference point for the quadrilateral target is to be determined by the software. 'Y' indicates the software is to calculate it. 'N' implies user input." FORM NAME "TPS" LABEL "TARGET POSITION OVERRIDE (Y/N)" END_FORM END_FIELD FIELD radius TYPE R*4 UNITS "ARCSECONDS" DESCRIPTION "This field is the circular target radius for circular targets." FORM NAME "TPS" LABEL "CIRCLE RADIUS(arcsecs)" END_FORM END_FIELD FIELD vertex1_ra TYPE R8 UNITS "DEGREES" DESCRIPTION "This field is the right ascension of vertex1 of a quadrilateral target at the input epoch/equinox." FORM NAME "TPS" LABEL "RA VERTEX 1" END_FORM END_FIELD FIELD vertex1_dec TYPE R8 UNITS "DEGREES" DESCRIPTION "This field is the declination of vertex1 of a quadrilateral target at the input epoch/equinox." FORM NAME "TPS" LABEL "DEC VERTEX 1" END_FORM END_FIELD FIELD vertex2_ra TYPE R8 UNITS "DEGREES" DESCRIPTION "This field is the right ascension of vertex2 of a quadrilateral target at the input epoch/equinox." FORM NAME "TPS" LABEL "RA VERTEX 2" END_FORM END_FIELD FIELD vertex2_dec TYPE R8 UNITS "DEGREES" DESCRIPTION "This field is the declination of vertex2 of a quadrilateral target at the input epoch/equinox." FORM NAME "TPS" LABEL "DEC VERTEX 2" END_FORM END_FIELD FIELD vertex3_ra TYPE R8 UNITS "DEGREES" DESCRIPTION "This field is the right ascension of vertex3 of a quadrilateral target at the input epoch/equinox." FORM NAME "TPS" LABEL "RA VERTEX 3" END_FORM END_FIELD FIELD vertex3_dec TYPE R8 UNITS "DEGREES" DESCRIPTION "This field is the declination of vertex3 of a quadrilateral target at the input epoch/equinox." FORM NAME "TPS" LABEL "DEC VERTEX 3" END_FORM END_FIELD FIELD vertex4_ra TYPE R8 UNITS "DEGREES" DESCRIPTION "This field is the right ascension of vertex4 of a quadrilateral target at the input epoch/equinox." FORM NAME "TPS" LABEL "RA VERTEX 4" END_FORM END_FIELD FIELD vertex4_dec TYPE R8 UNITS "DEGREES" DESCRIPTION "This field is the declination of vertex4 of a quadrilateral target at the input epoch/equinox." FORM NAME "TPS" LABEL "DEC VERTEX 4" END_FORM END_FIELD FIELD j2vertex1_ra TYPE R*8 UNITS "DEGREES" DESCRIPTION "This field is the right ascension of vertex1 of a quadrilateral target at epoch J2000." END_FIELD FIELD j2vertex1_dc TYPE R*8 UNITS "DEGREES" DESCRIPTION "This field is the declination of vertex1 of a quadrilateral target at epoch J2000." FORM NAME "TPS" END_FORM END_FIELD FIELD j2vertex2_ra TYPE R*8 UNITS "DEGREES" DESCRIPTION "This field is the right ascension of vertex2 of a quadrilateral target at epoch J2000." FORM NAME "TPS" END_FORM END_FIELD FIELD j2vertex2_dc TYPE R*8 UNITS "DEGREES" DESCRIPTION "This field is the declination of vertex2 of a quadrilateral target at epoch J2000." FORM NAME "TPS" END_FORM END_FIELD FIELD j2vertex3_ra TYPE R*8 UNITS "DEGREES" DESCRIPTION "This field is the right ascension of vertex3 of a quadrilateral target at epoch J2000." FORM NAME "TPS" END_FORM END_FIELD FIELD j2vertex3_dc TYPE R*8 UNITS "DEGREES" DESCRIPTION "This field is the declination of vertex3 of a quadrilateral target at epoch J2000." FORM NAME "TPS" END_FORM END_FIELD FIELD j2vertex4_ra TYPE R*8 UNITS "DEGREES" DESCRIPTION "This field is the right ascension of vertex4 of a quadrilateral target at epoch J2000." FORM NAME "TPS" END_FORM END_FIELD FIELD j2vertex4_dc TYPE R*8 UNITS "DEGREES" DESCRIPTION "This field is the declination of vertex4 of a quadrilateral target at epoch J2000." FORM NAME "TPS" END_FORM END_FIELD FIELD motn_spc_typ TYPE C1 DESCRIPTION "This field is the motion specification type. The possible choices are 'P' is a primary, 'S' is a secondary, and 'F' is a surface feature." FORM NAME "TCD" END_FORM DISCRETE "F", "P", "S" END_FIELD FIELD ref_targ_id TYPE TARGET_ID_TYPE DESCRIPTION "This field is the reference target id." FORM NAME "TCD" END_FORM END_FIELD FIELD north_ra TYPE R4 UNITS "DEGREES" DESCRIPTION "This field is the right ascension of the north pole of a planetary target." FORM NAME "TRD" LABEL "ELEMENT 1 (North Pole RA)" END_FORM END_FIELD FIELD north_dec TYPE R4 UNITS "DEGREES" DESCRIPTION "This field is the declination of the north pole of a planetary target." FORM NAME "TRD" LABEL "ELEMENT 2 (North Pole DEC)" END_FORM END_FIELD FIELD long_prim_me TYPE R4 UNITS "DEGREES" DESCRIPTION "This field is the longitude of the prime meridian of a planetary target." FORM NAME "TRD" LABEL "planetary target)" END_FORM END_FIELD FIELD epo_prim_mer TYPE SOGS_INT_TIME_TYPE DESCRIPTION "This field is the epoch of the longitude of the prime meridian of a planetary target." FORM NAME "TRD" LABEL "meridian of planetary target)" END_FORM END_FIELD FIELD long_rate TYPE R4 UNITS "DEGREES/DAY" DESCRIPTION "This is the rate of change of longitude for a planetary target." FORM NAME "TRD" LABEL "ELEMENT 5 (Rate of change of longitude)" END_FORM END_FIELD FIELD equ_radius TYPE R4 UNITS "KILOMETERS" DESCRIPTION "This field is the equatorial radius of a planetary target." FORM NAME "TRD" LABEL "target)" END_FORM END_FIELD FIELD flattening TYPE R4 DESCRIPTION "This field is the flattening of planetary target. It is the difference between the equatorial and polar radius divided by the equatorial radius." FORM NAME "TRD" LABEL "ELEMENT 7 (Flattening)" END_FORM END_FIELD FIELD feature_lat TYPE R4 UNITS "DEGREES" DESCRIPTION "This field is the latitude of the surface feature for surface feature targets." FORM NAME "TRD" LABEL "ELEMENT 8 (Latitude of surface feature)" END_FORM END_FIELD FIELD feature_long TYPE R4 UNITS "DEGREES" DESCRIPTION "This field is the longitude of the surface feature for surface feature targets." FORM NAME "TRD" LABEL "ELEMENT 9 (Longitude of surface feature)" END_FORM END_FIELD FIELD feature_alt TYPE R4 UNITS "KILOMETERS" DESCRIPTION "This field is the altitude of the surface feature for surface feature targets." FORM NAME "TRD" LABEL "ELEMENT 10 (Altitude of surface feature)" END_FORM END_FIELD FIELD r_planet TYPE R8 UNITS "ASTRONOMICAL UNITS" DESCRIPTION "This field is the mean distance from a planetary target to the sun." FORM NAME "TCD" END_FORM END_FIELD FIELD w_planet TYPE R8 UNITS "DEGREES/DAY" DESCRIPTION "This field is the rotation rate of a planetary target around the sun." FORM NAME "TCD" END_FORM END_FIELD FIELD fk4fk5_flag TYPE C1 DESCRIPTION "This is the parallax radial velocity and default reference flag. It indicates whether to do an fk4 to fk5 conversion. 'Y' indicates that the conversion is to be done." FORM NAME "TPS" END_FORM END_FIELD FIELD eph_unc_units TYPE C4 DESCRIPTION "This field specifies the units of the ephemeris uncertainty of a moving target. The choices are 'KM' (kilometers) or 'SEC' (seconds). FORM NAME "TPS" END_FORM DISCRETE "KM", "SEC" END_FIELD FIELD eph_uncert TYPE R8 DESCRIPTION "This field is the ephemeris uncertainty of a moving target in the units specified by eph_unc_units." FORM NAME "TPS" END_FORM END_FIELD FIELD acq_unc_units TYPE C4 DESCRIPTION "This field specifies the units of the target acquisition uncertainty of a moving target. The choices are 'KM' (kilometers) or 'ASEC' (arcseconds)." FORM NAME "TPS" END_FORM DISCRETE "ASEC", "KM" END_FIELD FIELD acq_uncert TYPE R8 DESCRIPTION "This field is the target acquisition uncertainty of a moving target in the units specified by acq_unc_units." FORM NAME "TPS" END_FORM END_FIELD FIELD af_rev_number TYPE AF_REVISION_NUMBER_TYPE RELATED_FIELDS "qscheduling.af_rev_number", "qpdescrip.af_rev_number" END_FIELD FIELD af_load_date TYPE TIME_STAMP_TYPE DESCRIPTION "This field holds the date the assignment file was loaded. " RELATED_FIELDS "qslink_info.af_load_date" END_FIELD FIELD catalog_alias TYPE C16 DESCRIPTION "This field specifies the target guide star catalog alias name." END_FIELD FIELD nonstellar_type TYPE C28 DESCRIPTION "This field specifies the type of the target as returned from the guide star request software." END_FIELD END_RECORD RELATION qtargets TYPE QTARGT_TYPE DESCRIPTION "Target Catalog Relation" SUBSYSTEM_USING "SPSS", "TRANS", "PODPS" FORM NAME "TCD", "TPS", "TRD" END_FORM INDEX qtargets_1 TYPE unique, clustered FIELDS target_id END_INDEX RELATED_FIELDS "qtarget_flux.*", "qtmchebychev.*", "qtsynonyms.*" END_RELATION INSTANCE qtargets GLOBAL TYPE QTARGT_TYPE END_INSTANCE