!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! ! ! SDDL Name: EXECUTED.SDDL ! ! Purpose: This SDDL file defines the EXECUTED relation. ! ! Modification History: ! ! Date OPR Who Reason ! -------- ------- --- ------------------------------------------------- ! 08/24/99 39260 Baum Original implementation !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! ! LANGUAGE SQL RECORD EXECUTED_TYPE !------------------------------------------------------------------------------ ! ! RECORD INFORMATION ! !------------------------------------------------------------------------------ DESCRIPTION "This relation is used to replace the executed_flg in qobservation. That table will be replicated and OPUS cannot update it. Some additional data is also supplied but only the executed_flg is updated by OPUS software. The additional fields can be used to distinguish dumps from science observations." !------------------------------------------------------------------------------ ! ! FIELD INFORMATION ! !------------------------------------------------------------------------------ FIELD program_id TYPE C3 DESCRIPTION "When a proposal is accepted into the PMDB by SPSS it must be assigned a unique 3 character base 36 program identifier. This is done by the PMDB/ACCEPT_PROP command. This program identifier is tagged as 'program_id' in most PMDB relations. Is is used for identification of proposals by spacecraft and OPUS software. It is also used in the OPUS and DADS rootname for all archived science data files. Because of flight design software, program_id must be three characters." END_FIELD FIELD obset_id TYPE C2 DESCRIPTION "An observation set is a collection of one or more alignments that are grouped together based on FGS pointing requirements. That is, if multiple alignments can all be executed using the same guide star pair, they are grouped into the same observation set. An observation set is identified by a 2 character base 36 string. This field, typically called 'obset_id', will often contribute to the index on relation together with a proposal_id, version_num, and possibly other fields. OBSET is an abbreviation for observation set." END_FIELD FIELD ob_number TYPE C2 DESCRIPTION "For exposures, observations are numbered sequentially throughout an observation set and are assigned by SMS/Gen. The connection between ob_number and the PMDB alignment and exposure ids is in the table qolink." END_FIELD FIELD proposal_id TYPE C5 DESCRIPTION "A proposal consists of many individual observations submitted as a package by a proposer. When a proposal is processed by the proposal entry system (RPS2), it is assigned a proposal identifier. That identifier is an integer that is converted into a 5 character base 36 string." END_FIELD FIELD si_id TYPE C4 DESCRIPTION "This is the identifier type for a Science Instrument (SI). The SI list includes the following: FOC - Faint Object Camera FOS - Faint Object Spectrograph WFPC - Wide Field Planetary Camera 1 WFII - Wide Field Planetary Camera 2 WF3 - Wide Field Camera 3 HRS - High Resloution Spectrograph CSTR - COSTAR 1 - Fine Guidance Sensor 1 2 - Fine Guidance Sensor 2 3 - Fine Guidance Sensor 3 NIC - NICMOS STIS - Space Telescope Infrared Spectrograph ACS - Advanced Camera for Surveys COS - Cosmic Origins Spectrometer" END_FIELD FIELD control_id TYPE C5 DESCRIPTION "This is information on how OPUS is supposed to process the data. The data is stored in five bytes: H/Y/N : Calibration data flag F/P : Output product type (film/plot) - unused 2 bytes: Output format spec - unused Y/N : Output product holding tank flag" END_FIELD FIELD coord_id TYPE C10 DESCRIPTION "This is the SI 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. They specify the default location of the target within the aperture." END_FIELD FIELD executed_flg TYPE C1 DESCRIPTION "When the record is created this value is blank. When the observation has been executed on board HST, OPUS receives a science POD file or OMS generates an astrometry file from engineering data, and this field is updated to the Type (ninth) character of the dataset rootname." END_FIELD END_RECORD !------------------------------------------------------------------------------ ! ! RELATION DECLARATION ! !------------------------------------------------------------------------------ RELATION executed TYPE EXECUTED_TYPE DESCRIPTION "Execution status data" SUBSYSTEM_USING "OPUS" INDEX executed_1 TYPE unique, clustered FIELDS program_id, obset_id, ob_number END_INDEX INDEX executed_2 TYPE nonclustered FIELDS proposal_id, obset_id, ob_number END_INDEX END_RELATION