Go to the bottom.
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:	QOBSERVATION.SDDL
!
! Purpose:      This SDDL file defines the qobservation relation.
!
! Modification History:
!
!   Date      PR     Who                       Reason
! --------  -------  ---   -------------------------------------------------
! 12/01/94  27329    MRB   Original implementation
! 12/03/96  32741    SXT   Add new index: pred_strt_tm
! 12/09/96  32741.1  MRB   Add prime_aper prior to 31921 for OPUS release
! 01/07/96  16760    MRB   Remove most #48 fields - a_*, cms, cme.
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
 
LANGUAGE  C, FORTRAN, SQL

INCLUDE  ZSPSS_USER_TYPES.SDDL
 
RECORD  QOBSRV_TYPE
 
!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------
 
 
    DESCRIPTION       "Observation records in the PODPS Support Schedule
                       are stored in this relation. Post Observation Data 
                       Processing uses this data to convert and calibrate 
                       the observations sent from the spacecraft.

                       This data is from the logical SMS.  SMSG/Schedule
                       builds support schedule files for OPUS/PODPS from the
                       logical SMS. OBSR/Generate uses the PODPS support 
                       schedule files to populate this relation and QOLINK."
 
 
!------------------------------------------------------------------------------
!
!   FIELD INFORMATION
!
!------------------------------------------------------------------------------
 
 

    FIELD  proposal_id
        TYPE PROPOSAL_ID_TYPE
    END_FIELD
 
 

    FIELD  program_id
        TYPE PROGRAM_ID_TYPE
    END_FIELD
 
 

    FIELD  obset_id
        TYPE OBSET_ID_TYPE
    END_FIELD
 
 

    FIELD  ob_number
        DESCRIPTION     "Observations are numbered sequentially throughout
                         an observation set for PODPS use.  Please note an
                         ob_number is _NOT_ the same as an obset_ID."
        TYPE            C2
        UNITS           "BASE_36"
        RANGE           "00..ZZ"
    END_FIELD
 
 

    FIELD  version_num
        TYPE VERSION_NUM_TYPE
    END_FIELD
 
 

    FIELD  control_id
        DESCRIPTION     "This field controls what processing PODPS will do on
                         an observation. Each of the five character positions 
                         has significance.  The significance from left to 
                         right is calibration data flag (H/Y/N), 
                         output product type (P,F),
                         output format specification (2 bytes),
                         output product holding tank flag (Y/N)."
        TYPE            C*5
    END_FIELD
 
 

    FIELD  expected_pkt
        DESCRIPTION     "This is the expected number of source packets for
                         an observation for the science instrument data.
                         This value is used to determine whether data
                         collected by data partitioning has all been 
                         collected. The estimate includes science data, 
                         unique definition log (UDL), and science header 
                         packets."
        TYPE            I4
    END_FIELD
 
 

    FIELD  executed_flg
        DESCRIPTION     "This flag indicates the status of this observation
                        where U means unexecuted and E means executed."
        TYPE            C1
        DISCRETE        "E", "U"
    END_FIELD
 
 

    FIELD  duration
        DESCRIPTION     "This is the predicted observation duration time in 
                         seconds as calculated by OBSR/Generate."
        TYPE            I4
        UNITS           "SECONDS"
    END_FIELD
 
 

    FIELD  word_11_14
        DESCRIPTION     "This is word 11/14.  It is  a number assigned by
                         SMS generation for each observation. The word 11/14 
                         is a count which is kept for each instrument and 
                         updated for each observation using the instrument. 
                         It is used to provide a distinction between packets
                         from different observations.  The count is one byte
                         and rolls over every 255."
        TYPE            I2
    END_FIELD
 
 

    FIELD  target_id
        TYPE TARGET_ID_TYPE
        DESCRIPTION     "This is the unique astronomical identifier
                         for the primary target used."
    END_FIELD
 
 

    FIELD  ra_target
        DESCRIPTION     "This is the right ascension of the target position
                         in heliocentric J2000.0."
        TYPE            R*8
        UNITS           "DEGREES"
    END_FIELD
 
 

    FIELD  dec_target
        DESCRIPTION     "This is the declination of the target position
                         in heliocentric J2000.0."
        TYPE            R*8
        UNITS           "DEGREES"
    END_FIELD
 
 

    FIELD  ref_obj_ra
        DESCRIPTION     "This is the right ascension of the reference
                        target position in heliocentric J2000.0."
        TYPE            R*8
        UNITS           "DEGREES"
    END_FIELD
 
 

    FIELD  ref_obj_dec
        DESCRIPTION     "This is the declination of the reference target 
                         position; it is in heliocentric J2000.0."
        TYPE            R*8
        UNITS           "DEGREES"
    END_FIELD
 
 

    FIELD  annparra
        DESCRIPTION     "This is the magnitude of the parallactic shift in the
                        position of the non-solar system target at the time
                        of observation."
        TYPE            R*4
        UNITS           "ARCSECONDS"
    END_FIELD
 
 

    FIELD  si_id
        DESCRIPTION     "This is the science instrument mnemonic. It specifies 
                        which science instrument was used for the observation.
                        The instrument mnemonics are as defined in
                        ST-ICD-26 part III."
        TYPE            C*4
    END_FIELD
 
 

    FIELD  apersky
        DESCRIPTION     "This is the SI sky aperture and coordinate system 
                         identifier. It specifies the aperture and
                         coordinate system of the instrument to be
                         used for the sky background light observations
                         in conjunction with the observation of the target.
                         It is the aperture identifier concatenated with the
                         aperture coordinate system identifier.
                         These ids are defined in st_icd_26 part III."
        TYPE            C10
    END_FIELD
 
 

    FIELD  coord_id
        DESCRIPTION     "This is the SI object aperture and coordinate system 
                         identifier; it specifies the aperture and
                         coordinate system of the instrument to be
                         used for the observation of the target.
                         It is the aperture identifier concatenated with
                         the aperture coordinate system identifier.
                         These ids are defined in ST_ICD_26 part III.
                         They specify the location of the target within the
                         aperture."
        TYPE            C10
    END_FIELD
 
 

    FIELD  coord_typ
        DESCRIPTION     "This is the aperture coordinate system type.
                        where SICS = SI corrected system,
                        SIAS = SI aperture system,
                        SIDS = SI detector system."
        DISCRETE         "SIAS", "SICS", "SIDS"
        TYPE            C4
    END_FIELD
 
 

    FIELD  aperoffx
        DESCRIPTION     "This is the X component of the offset of the target 
                         from the center of the aperture.
                         If qobctp_coord_typ = SIAS, then units are lines;
                         If qobctp_coord_typ = SICS, then units are
                         arcseconds."
        TYPE            R*4
    END_FIELD
 
 

    FIELD  aperoffy
        DESCRIPTION     "This is the Y component of the offset of the target 
                         from the center of the aperture.
                         If qobctp_coord_typ = SIAS, then units are lines;
                         If qobctp_coord_typ = SICS, then units are
                         arcseconds."
        TYPE            R*4
    END_FIELD
 
 

    FIELD  v2v3_xcoord
        DESCRIPTION     "This is the X component of the aperture offset 
                         position in the ST coordinate system (the V2 offset 
                         of the target from the aperture center)."
        TYPE            R4
        UNITS           "ARCSECONDS"
    END_FIELD
 
 

    FIELD  v2v3_ycoord
        DESCRIPTION     "This is the Y component of the aperture offset 
                         position in the ST coordinate system (the V3 
                         offset of the target from the aperture center)."
        TYPE            R4
        UNITS           "ARCSECONDS"
    END_FIELD
 
 

    FIELD  aper_angle
        DESCRIPTION     "This is the position angle of the reference axis 
                         (Y-axis) of the aperture coordinate system used for 
                         the observation of the target. It is specified in the 
                         J2000.0 coordinate system and measured counterclockwise
                         (eastward) from north as seen looking toward the
                         the +V1 axis."
        TYPE            R*4
        UNITS           "DEGREES"
    END_FIELD
 
 

    FIELD  pred_strt_tm
        TYPE SOGS_CHAR_TIME_TYPE
        DESCRIPTION     "This is the predicted date and time of start 
                         of execution."
    END_FIELD
 
 

    FIELD  pred_stop_tm
        TYPE SOGS_CHAR_TIME_TYPE
        DESCRIPTION     "This is the predicted date and time of end of 
                         execution."
    END_FIELD



    FIELD  prime_aper
        DESCRIPTION     "This is the prime SI aperture and coordinate system
                         identifier. It specifies the aperture and
                         coordinate system that is used to calculate the
                         V1-axis position (see rtascnv1 and declnv1).
                         The first character of this aperture indicates the 
                         SI used to define the HST pointing. If this first
                         character is different than that in coord_id, then
                         this is a parallel observation."
        TYPE            C10
    END_FIELD

 

    FIELD  rtascnv1
        DESCRIPTION     "This is the right ascension of V1 axis of space 
                         telescope in geocentric J2000.0 coordinates.
                         The V1 axis is the optical axis of the space 
                         telescope (more or less the 'roll')."
        TYPE            R*8
        UNITS           "DEGREES"
    END_FIELD
 
 

    FIELD  declnv1
        DESCRIPTION     "This is the declination of V1 axis of space telescope 
                         in geocentric J2000.0 coordinates.
                         The v1 axis is the optical axis of the space telescope
                         (more or less the 'roll')."
        TYPE            R*8
        UNITS           "DEGREES"
    END_FIELD
 
 

    FIELD  psanglv3
        DESCRIPTION     "This is the position angle of the V3 axis of ST in 
                         a geocentric coordinate system J2000.0 measured 
                         counterclockwise from north as seen looking toward 
                         the +v1 axis (measured eastward from the north.)"
        TYPE            R*4
        UNITS           "DEGREES"
    END_FIELD
 
 

    FIELD  postnstx
        DESCRIPTION     "This is the Y axis coordinate of the space telescope 
                         position in orbit at the time of observation in 
                         geocentric J2000.0 inertial coordinate system.
                         This is a orthogonal right handed coordinate system 
                         centered in the Earth, with the X axis pointing 
                         towards the vernal equinox for the year 2000,
                         the Z axis pointing towards the north celestial pole 
                         for the year 2000, and the Y axis orthogonal to both."
        TYPE            R*8
        UNITS           "KILOMETERS"
    END_FIELD
 
 

    FIELD  postnsty
        DESCRIPTION     "This is the Y axis coordinate of the space telescope 
                         position in orbit at the time of observation in 
                         geocentric J2000.0 inertial coordinate system.
                         This is a orthogonal right handed coordinate system 
                         centered in the Earth, with the X axis pointing 
                         towards the vernal equinox for the year 2000,
                         the Z axis pointing towards the north celestial pole 
                         for the year 2000, and the Y axis orthogonal to both."
        TYPE            R*8
        UNITS           "KILOMETERS"
    END_FIELD
 
 

    FIELD  postnstz
        DESCRIPTION     "This is the Z axis coordinate of the space telescope 
                         position in orbit at the time of observation in 
                         geocentric J2000.0 inertial coordinate system.
                         This is a orthogonal right handed coordinate system 
                         centered in the Earth, with the X axis pointing 
                         towards the vernal equinox for the year 2000,
                         the Z axis pointing towards the north celestial pole 
                         for the year 2000, and the Y axis orthogonal to both."
        TYPE            R*8
        UNITS           "KILOMETERS"
    END_FIELD
 
 

    FIELD  velocstx
        DESCRIPTION     "This is the X component of the velocity of space 
                         telescope in geocentric J2000,0 inertial coordinates.
                         This is an orthogonal right handed coordinate system 
                         centered in the Earth, with the X axis pointing 
                         towards the vernal equinox for the year 2000,
                         the Z axis pointing towards the north celestial pole 
                         for the year 2000, and the Y axis orthogonal to both."
        TYPE             R*8
        UNITS           "KILOMETERS/SECOND"
    END_FIELD
 
 

    FIELD  velocsty
        DESCRIPTION     "This is the Y component of the velocity of space 
                         telescope in geocentric J2000,0 inertial coordinates.
                         This is an orthogonal right handed coordinate system 
                         centered in the Earth, with the X axis pointing 
                         towards the vernal equinox for the year 2000,
                         the Z axis pointing towards the north celestial pole 
                         for the year 2000, and the Y axis orthogonal to both."
        TYPE             R*8
        UNITS           "KILOMETERS/SECOND"
    END_FIELD
 
 

    FIELD  velocstz
        DESCRIPTION     "This is the Z component of the velocity of space 
                         telescope in geocentric J2000,0 inertial coordinates.
                         This is an orthogonal right handed coordinate system 
                         centered in the Earth, with the X axis pointing 
                         towards the vernal equinox for the year 2000,
                         the Z axis pointing towards the north celestial pole 
                         for the year 2000, and the Y axis orthogonal to both."
        TYPE            R*8
        UNITS           "KILOMETERS/SECOND"
    END_FIELD
 
 

    FIELD  rtascsun
        DESCRIPTION     "This is the right ascension of sun in geocentric 
                         J2000.0 coordinates."
        TYPE            R*8
        UNITS           "DEGREES"
    END_FIELD
 
 

    FIELD  declnsun
        DESCRIPTION     "This is the declination of sun in geocentric J2000.0
                         coordinates."
        TYPE            R*8
        UNITS           "DEGREES"
    END_FIELD
 
 

    FIELD  rtasmoon
        DESCRIPTION     "This is the right ascension of moon in geocentric 
                         J2000.0 coordinates."
        TYPE            R*8
        UNITS           "DEGREES"
    END_FIELD
 
 

    FIELD  declmoon
        DESCRIPTION     "This is the declination of moon in geocentric J2000.0
                         coordinates."
        TYPE            R*8
        UNITS           "DEGREES"
    END_FIELD
 
 

    FIELD  target_acqmd
        DESCRIPTION     "This is the target acquisition mode used for the
                         observation where
                         00 = null,
                         01 = ground assisted,
                         02 = onboard computer assisted,
                         03 = fixed simple pointing."
        DISCRETE        "00", "01", "02", "03"
        TYPE            C2
    END_FIELD
 
 

    FIELD  position_ang
        DESCRIPTION     "This is the position angle of the target offset from 
                         the reference object. This is measured counterclockwise 
                         from north as seen looking from the Earth. (The angle
                         measured eastward from the north direction
                         about the position of the reference object to locate
                         the target position, specified in the coordinate
                         system in which the target position is specified.)"
        TYPE            R4
        UNITS           "DEGREES"
    END_FIELD
 
 

    FIELD  angular_sep
        DESCRIPTION     "This is the angular separation of the target offset 
                         from the reference object."
        TYPE            R4
        UNITS           "ARCSECONDS"
    END_FIELD
 
 

    FIELD  saa_model
        DESCRIPTION     "This is the SAA model which was used by SPSS to 
                         schedule SAA avoidance."
        TYPE SAA_MODEL_TYPE
    END_FIELD
 
 

    FIELD  dominant_gs
        DESCRIPTION     "This is the FGS ID (f1, f2, f3) concatenated with the
                         dominant guide star identifier."
         TYPE            C12
         RELATED_FIELDS  "wguide_stars.gs_id" "wguide_stars.fgs_id" "wguide_stars.dom_sub_flag"

    END_FIELD
 
 

    FIELD  subdominant
        DESCRIPTION     "This is the FGS ID (f1, f2, f3) concatenated with the
                         subdominant guide star identifier."
        TYPE            C12
         RELATED_FIELDS  "wguide_stars.gs_id" "wguide_stars.fgs_id" "wguide_stars.dom_sub_flag"

    END_FIELD
 
 

    FIELD  velabbra
        DESCRIPTION     "This is the magnitude of aberration due to ST and Earth
                        velocities. This is the absolute angular correction
                        that must be applied to the apparent position of the 
                        target as seen from the ST to compensate for the 
                        velocity of the ST and the Earth."
        TYPE            R*4
        UNITS           "ARCSECONDS"
    END_FIELD
 
 

    FIELD  equ_radius
        DESCRIPTION     "In the planetographic coordinate system parameters
                         this is the equatorial radius of planetary target."
        TYPE            R*4
        UNITS           "KILOMETERS"
    END_FIELD
 
 

    FIELD  flattening
        DESCRIPTION     "In the planetographic coordinate system parameters
                         this is the flattening of planetary target, the 
                         difference between the equatorial and polar radius 
                         divided by the equatorial radius."
        TYPE            R*4
    END_FIELD
 
 

    FIELD  north_dec
        DESCRIPTION     "In the planetographic coordinate system parameters
                         this is the declination of north pole of planetary
                         target."
        TYPE            R*4
        UNITS           "DEGREES"
    END_FIELD
 
 

    FIELD  long_pm
        DESCRIPTION     "In the planetographic coordinate system parameters 
                         this is the longitude of prime meridian of planetary 
                         target."
        TYPE            R*4
        UNITS           "DEGREES"
    END_FIELD
 
 

    FIELD  epoch_pm
        DESCRIPTION     "In the planetographic coordinate system parameters
                        this is the epoch of longitude of prime meridian of 
                        planetary target."
        TYPE            R*4
        UNITS           "DEGREES/DAY"
    END_FIELD
 
 

    FIELD  feature_lat
        DESCRIPTION     "In the planetographic coordinate system parameters 
                         this is latitude of surface feature."
        TYPE            R*4
        UNITS           "DEGREES"
    END_FIELD
 
 

    FIELD  feature_long
        DESCRIPTION     "In the planetographic coordinate system parameters 
                         this is longitude of surface feature."
        TYPE            R*4
        UNITS           "DEGREES"
    END_FIELD
 
 

    FIELD  feature_alt
        DESCRIPTION     "In the planetographic coordinate system parameters
                         this is the altitude of surface feature."
        TYPE            R*4
        UNITS           "KILOMETERS"
    END_FIELD
 
 

    FIELD  north_ra
        DESCRIPTION     "In the planetographic coordinate system parameters
                         this is the right ascension of north pole of planetary
                         target."
        TYPE            R*4
        UNITS           "DEGREES"
    END_FIELD
 
 

    FIELD  long_rate
        DESCRIPTION     "This is a planetographic coordinate system parameter.
                         It is the rate of change of longitude."
        TYPE            R*4
        UNITS           "DEGREES/DAY"
    END_FIELD
 
 

    FIELD  mt_flag
        DESCRIPTION     "This is the moving target flag.
                         'T' indicates that this is a moving target."
        TYPE            C*1
        DISCRETE        "T", " "
    END_FIELD
 
 

    FIELD  so_inv
        DESCRIPTION     "This is the S0 inverse magnitude for the unused #48 
                         command. DELETE with 31333 and coordinate with OPUS.
			 OPUS will remove reference to this field with 32055."
        UNITS           "1/METERS"
        TYPE            R*8
    END_FIELD
 
 

    FIELD  sox_dir
        DESCRIPTION     "This is the S0 x direction for the unused #48 command.
                         DELETE with SCS PR 31333 and coordinate with OPUS.
			 OPUS will remove reference to this field with 32055."
        TYPE            R*8
    END_FIELD
 
 

    FIELD  soy_dir
        DESCRIPTION     "This is the S0 y direction for the unused #48 command.
                         DELETE with SCS PR 31333 and coordinate with OPUS.
			 OPUS will remove reference to this field with 32055."
        TYPE            R*8
    END_FIELD
 
 

    FIELD  soz_dir
        DESCRIPTION     "This is the S0 Z direction for the unused #48 command.
                         To be DELETED under 31333 after OPUS delivers 32055."
        TYPE            R*8

    END_FIELD 

END_RECORD
 
 
!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------
 
 
RELATION  qobservation
 
    TYPE             QOBSRV_TYPE
 
    DESCRIPTION      "Observation Data Relation"
 
    SUBSYSTEM_USING  "TRANS", "SCS", "PODPS"
 
    RELATED_FIELDS  "qolink.*"
 
    INDEX  qobservation_1
        TYPE         unique, clustered
        FIELDS       proposal_id, program_id, obset_id, ob_number
    END_INDEX
 
    INDEX  qobservation_2
        TYPE         nonclustered
        FIELDS       program_id, obset_id, ob_number
    END_INDEX
 
    INDEX  qobservation_3
        TYPE         nonclustered
        FIELDS       si_id, pred_strt_tm, pred_stop_tm
    END_INDEX
 
    INDEX  qobservation_4
        TYPE         nonclustered
        FIELDS       word_11_14, si_id, pred_strt_tm, pred_stop_tm
    END_INDEX
 
    INDEX  qobservation_5
        TYPE         nonclustered
        FIELDS       pred_strt_tm
    END_INDEX

END_RELATION
 
!------------------------------------------------------------------------------
!
!   INSTANCE DECLARATION
!
!------------------------------------------------------------------------------
 
 
INSTANCE  qobservation
 
    GLOBAL
 
    TYPE        QOBSRV_TYPE
 
END_INSTANCE

Go to the top.