science
Same field as in our current hstmisc..science but:
- dataset_name is identical to asn_id for N,O,U associations
- asn_id ends with the letter 'A' for WFPC2 associations
- asn_id is NULL for single exposures
- actual_duration is the total exposure time for exposures flagged as 'P' (see hst_association_members.member_type)
| Field | Type | Null | Units | Mapping column (hst_associations) |
|---|---|---|---|---|
| num_members | smallint | null | - | no_members |
| assoc_type | tinyint | null | - | ass_type |
NOTE:
Excluding WFPC2, the num_members field will always assume
the default value of 1, even for STIS or NICMOS associations.
| Field | Type | Null | Mapping column (hst_associations) |
Meaning |
|---|---|---|---|---|
| actual_duration | real(4) | not null | exptime | Exposure time sum of member_type='P' exposure times |
| start_time_dmf | int | not null | ass_start_time_dmf | Minimum Start time of all the exposures in the association |
| release_date_dmf | int | not null | ass_release_date_dmf | Maximum release date of all the exposures in the association |
Same field as our current hstmisc..science
* ass_type is arbitrarily set to 0 for WFPC2 single exposures and for ALL other instruments as well.
*** max_time_span is the time elapsed
between the first and the last exposure (start time difference).
Note: assoc_id ends with an 'A' for associations,
Note: There are NO entries for single exposures in this table.
science_member
hst_associations
assoc_id varchar(9) not null targname varchar(30) null pep_id int not null ra_science int null dec_science int null roll_science float null ra_jit int null dec_jit int null roll_jit int null exptime float not null filter varchar(23) not null min_distance int not null max_distance int not null max_time_span*** int null no_members smallint not null ass_type * tinyint not null ass_start_time_dmf int not null ass_release_date_dmf int not null gen_date_str ** char(12) not null gen_date datetime not null
** gen_date_str is computed as follows:
while assoc_id = dataset_name for single exposures.
hst_association_members
pep_id int not null targname varchar(30) null dataset_name varchar(9) not null assoc_id varchar(9) not null aperture varchar(10) null exptime float not null ra_jit int null dec_jit int null roll_jit int null dx int not null dy int not null delta_ra int not null delta_dec int not null sub_assoc_id int null member_flag char(1) not null start_time_dmf int not null release_date_dmf int not null parallel varchar(18) null gen_date_str char(12) not null gen_date datetime not null
Unsolved problems
The fields member_type and
parallel, available in science_member,
are not available in science.
Therefore single exposures, being listed only in science,
will loose the relative information.
Related Documents
Please, see also the WFPC2 Associations Maintenance document.