This table contains information relating to the wavelength ranges covered by each observation.

Use and Related Data

Population

Filter position is stored in the CAM Compact Status table (CCSHFLTW). Andy Pollock has written a piece of software (known as the Post-Processor) that extracts this value and generates a wavelength range for each observation (as well as providing other information). A script has been written to import the output of this program into the database.

LWS and SWS

IPAC has written the software to extract the wavelengths informations for all AOTs for LWS (except L03) and all AOT for SWS instruments. This has been incorporated into the Browse Product Generator.

AOT L03 observations will take their wavelength range as the requested wavelength. These can be copied directly from the uplink table lws_common manually.

PHT

A script has been written that will extract the wheel position from the PHT Compact Status table (pht_cstat) and then use the table below that give the wheel positions / filters for the values stored. The filter will then directly relate to a wavelength range.

CHWn pht_cstat I The position of wheel n, n=1,2,3

0 cannot find corresponding CHW
step number in the table

Wheel 1
1 P_POL000 polarizer
2 P_POL120 polarizer
3 P_POL240 polarizer
4 flat
5 flat
6 C-cut quartz with reticle
7 free aperture
8 free aperture
9 free aperture
10 flat (redundant)
11 C_POL000 polarizer
12 C_POL120 polarizer
13 C_POL240 polarizer
14 free aperture

Wheel 2 (inner circle - PHT-P apertures)
1 stop 52" = 2.3mm
2 stop 79" = 3.4mm
3 stop 99" = 4.3mm
4 stop 120" = 5.2mm
5 stop 127"x127" = 5.5x5.5mm
6 stop 180" = 7.85mm
7 stop 180" + leak blocker
8 stop 5" = 0.22mm + S. mirror
9 stop 7.6" = 0.33mm
10 stop 10" = 0.44mm
11 stop 13.8" = 0.60mm
12 stop 18" = 0.77mm
13 stop 20"x32" = 0.87x1.4mm
14 stop 23" = 1.0mm

Wheel 2 (outer circle - PHT-C filters)
1 free aperture
2 C_90 filter + flat (back up)
3 C_50 filter + flat
4 C_60 filter + flat
5 C_70 filter + flat
6 C_100 filter + flat
7 C_105 filter + flat
8 C_90 filter + flat
9 C_160 filter
10 C_200 filter
11 C_180 filter
12 C_135 filter
13 C_120 filter
14 C cut quartz with reticle

Wheel 3 (PHT-P filters)
1 P_3.29 filter + lens
2 P_3.6 filter + lens
3 P_4.85 filter + lens
4 P_7.3 filter + lens
5 P_7.7 filter + lens
6 P_10 filter + lens
7 P_11.3 filter + lens
8 P_12.8 filter + lens
9 P_16 filter + lens
10 P_11.5 filter + lens
11 P_20 filter + elliptical mirror
12 P_25 filter + elliptical mirror
13 P_60 filter + elliptical mirror
14 P_100 filter + elliptical mirror

Columns

Name	Datatype	Null
obsno	int	No
countno	int	No
lower	int	No
upper	int	No

column countno

     Index to distinguish between different entries for one observation.

column lower

     Lower wavelength. Units:microns/1000 (values are divided by 1000 to safe space, but in the ISO Data Archive UI, these values are shown in microns).

column obsno

     Observation number constructed as follows:

revolution number * 1000000 + target number * 1000 + observation sequence number * 10 + type.

column upper

     Upper wavelength. Units: microns/1000 (values are divided by 1000 to safe space, but in the ISO Data Archive UI, these values are shown in microns).
 

Dependencies

Referencing Objects

Object Name	Object Type
dbo.wavelengths.wavelengths_cx	INDEX
dbo.wavelengths.wavelengths_ix	INDEX
dbo.wavelengths.wavelengths_upper_ix	INDEX

Referenced Objects

Object Name

Object Type

DDL

CREATE TABLE dbo.wavelengths 
(
    obsno   int NOT NULL,
    countno int NOT NULL,
    lower   int NOT NULL,
    upper   int NOT NULL
)
LOCK ALLPAGES
go