Object Type	Table
Datasource	IPMA
Database	icsa

The columns of this table are derived directly from the SWS General Housekeeping FITS product file. Note that this table has still needs to be incorporated into the ISO Data Archive.

Use and Related Data

See the ISO Data Product Document, IDPD SAI/94-1266/Dc for a further description of the columns in this table.

Population

TBD. This table will, most likely, be populated from the SWGH product file using the UDF functionality.

Columns

Name	Datatype	Null

obsno	int	No

time_utk	int	No

bias_b1	smallint	Yes

bias_b2	smallint	Yes

bias_b3	smallint	Yes

bias_b4	smallint	Yes

bias_b5	smallint	Yes

bias_b6	smallint	Yes

temp_sw_blk	float	Yes

temp_lw_35u	float	Yes

temp_fp_blk	float	Yes

temp_fp_35u	float	Yes

temp_adc_1	float	Yes

temp_adc_2	float	Yes

temp_up_1	float	Yes

temp_up_2	float	Yes

mon_sw_15	float	Yes

mon_sw_m15	float	Yes

mon_lw_p15	float	Yes

mon_lw_m15	float	Yes

mon_com_p15	float	Yes

mon_com_m15	float	Yes

cal_fp_cal	float	Yes

cal_gracal	float	Yes

curr_fp_main	float	Yes

curr_fp_cor1	float	Yes

curr_fp_cor2	float	Yes

column bias_b1
column bias_b2
column bias_b3
column bias_b4
column bias_b5
column bias_b6

column cal_fp_cal

column cal_gracal

column curr_fp_cor1
column curr_fp_cor2

column curr_fp_main

column mon_com_m15

column mon_com_p15

column mon_lw_m15

column mon_lw_p15

column mon_sw_15

column mon_sw_m15

column obsno

column temp_adc_1

column temp_adc_2

column temp_fp_35u

column temp_fp_blk

column temp_lw_35u

column temp_sw_blk

column temp_up_1

column temp_up_2

column time_utk

Table Usage (MB)

Distribution of Table Space

Data	0.00	Data	4.17 %
Indexes	0.00	Indexes	8.33 %
Unused	0.04	Unused	87.50 %
Total	0.05	Number of Rows	0

Dependencies

Referencing Objects

Object Name Object Type

dbo.sgehk.sgehk_pk INDEX

dbo.sgehk.observations_sgehk_fk INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.sgehk 
(
    obsno        int      NOT NULL,
    time_utk     int      NOT NULL,
    bias_b1      smallint NULL,
    bias_b2      smallint NULL,
    bias_b3      smallint NULL,
    bias_b4      smallint NULL,
    bias_b5      smallint NULL,
    bias_b6      smallint NULL,
    temp_sw_blk  float    NULL,
    temp_lw_35u  float    NULL,
    temp_fp_blk  float    NULL,
    temp_fp_35u  float    NULL,
    temp_adc_1   float    NULL,
    temp_adc_2   float    NULL,
    temp_up_1    float    NULL,
    temp_up_2    float    NULL,
    mon_sw_15    float    NULL,
    mon_sw_m15   float    NULL,
    mon_lw_p15   float    NULL,
    mon_lw_m15   float    NULL,
    mon_com_p15  float    NULL,
    mon_com_m15  float    NULL,
    cal_fp_cal   float    NULL,
    cal_gracal   float    NULL,
    curr_fp_main float    NULL,
    curr_fp_cor1 float    NULL,
    curr_fp_cor2 float    NULL
)
LOCK ALLPAGES
go

Object Name	Object Type
dbo.sgehk.sgehk_pk	INDEX
dbo.sgehk.observations_sgehk_fk	INDEX