Object Type	Table
Datasource	IPMA
Database	icsa

This information has been extracted from the LWS LGIF AA FITS product file.

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

This table has been populated during BKRP by db-import.

Columns

Name	Datatype	Null

obsno	int	No

lgifitks	int	No

lgifitke	int	No

lgifkr	int	No

lgifabs1	float	No

lgifabs2	float	No

lgifabs3	float	No

lgifabs4	float	No

lgifabs5	float	No

lgifabs6	float	No

lgifabs7	float	No

lgifabs8	float	No

lgifabs9	float	No

lgifabs10	float	No

lgifabsu1	float	No

lgifabsu2	float	No

lgifabsu3	float	No

lgifabsu4	float	No

lgifabsu5	float	No

lgifabsu6	float	No

lgifabsu7	float	No

lgifabsu8	float	No

lgifabsu9	float	No

lgifabsu10	float	No

lgifrsta1	smallint	No

lgifrsta2	smallint	No

lgifrsta3	smallint	No

lgifrsta4	smallint	No

lgifrsta5	smallint	No

lgifrsta6	smallint	No

lgifrsta7	smallint	No

lgifrsta8	smallint	No

lgifrsta9	smallint	No

lgifrsta10	smallint	No

lgif1rel1	float	No

lgif1rel2	float	No

lgif1rel3	float	No

lgif1rel4	float	No

lgif1rel5	float	No

lgif1rel6	float	No

lgif1rel7	float	No

lgif1rel8	float	No

lgif1rel9	float	No

lgif1rel10	float	No

lgif2rel1	float	No

lgif2rel2	float	No

lgif2rel3	float	No

lgif2rel4	float	No

lgif2rel5	float	No

lgif2rel6	float	No

lgif2rel7	float	No

lgif2rel8	float	No

lgif2rel9	float	No

lgif2rel10	float	No

lgifnscd	smallint	No

lgifnscg	smallint	No

lgifline	smallint	No

lgifpos	smallint	No

lgifadet	char(3)	No

lgifrpid1	smallint	No

lgifrpidy	smallint	No

utk_start	int	Yes

utk_end	int	Yes

position	smallint	Yes

column lgif1rel1
column lgif1rel10
column lgif1rel2
column lgif1rel3
column lgif1rel4
column lgif1rel5
column lgif1rel6
column lgif1rel7
column lgif1rel8
column lgif1rel9

1st coeff. of relative responsivity correction for each detector (Flux at reference ITK).

column lgif2rel1
column lgif2rel10
column lgif2rel2
column lgif2rel3
column lgif2rel4
column lgif2rel5
column lgif2rel6
column lgif2rel7
column lgif2rel8
column lgif2rel9

2nd coeff. of relative responsivity correction for each detector (Flux per ITK unit).

column lgifabs1
column lgifabs10
column lgifabs2
column lgifabs3
column lgifabs4
column lgifabs5
column lgifabs6
column lgifabs7
column lgifabs8
column lgifabs9

Absolute responsivity correction factor for each detector.

column lgifabsu1
column lgifabsu10
column lgifabsu2
column lgifabsu3
column lgifabsu4
column lgifabsu5
column lgifabsu6
column lgifabsu7
column lgifabsu8
column lgifabsu9

Uncertainties in absolute responsivity correction factors.

column lgifadet

Active detector, as string (only valid for L02 and L04).

column lgifitke

ITK of end of group.

column lgifitks

ITK of start of group.

column lgifkr

Reference ITK at which correction is calculated.

column lgifline

Line number for group (only valid for L02 and L04).

column lgifnscd

Number of scans used for calculation of drift correction.

column lgifnscg

Total number of scans in group.

column lgifpos

Grating measured position for group (only valid for L03 and L04).

column lgifrpid1

Raster point ID x for group.

column lgifrpidy

Raster point ID y for group.

column lgifrsta1
column lgifrsta10
column lgifrsta2
column lgifrsta3
column lgifrsta4
column lgifrsta5
column lgifrsta6
column lgifrsta7
column lgifrsta8
column lgifrsta9

Relative responsivity status flag for each detector:
0 No valid relative responsivity information stored for this detector
1 Relative responsivity information stored for this detector.

column obsno

Observation number constructed as follows:
revolution number * 1000000 + target number * 1000 + observation sequence number * 10 + type.
Please see SCREW 385 for further details.

column position

Position of scan.

column utk_end

UTK of end of group.

column utk_start

UTK of start of group.

Table Usage (MB)

Distribution of Table Space

Data	2.03	Data	97.10 %
Indexes	0.02	Indexes	0.84 %
Unused	0.04	Unused	2.06 %
Total	2.09	Number of Rows	5188

Dependencies

Referencing Objects

Object Name Object Type

dbo.lgif.lgif_ucx INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.lgif 
(
    obsno      int      NOT NULL,
    lgifitks   int      NOT NULL,
    lgifitke   int      NOT NULL,
    lgifkr     int      NOT NULL,
    lgifabs1   float    NOT NULL,
    lgifabs2   float    NOT NULL,
    lgifabs3   float    NOT NULL,
    lgifabs4   float    NOT NULL,
    lgifabs5   float    NOT NULL,
    lgifabs6   float    NOT NULL,
    lgifabs7   float    NOT NULL,
    lgifabs8   float    NOT NULL,
    lgifabs9   float    NOT NULL,
    lgifabs10  float    NOT NULL,
    lgifabsu1  float    NOT NULL,
    lgifabsu2  float    NOT NULL,
    lgifabsu3  float    NOT NULL,
    lgifabsu4  float    NOT NULL,
    lgifabsu5  float    NOT NULL,
    lgifabsu6  float    NOT NULL,
    lgifabsu7  float    NOT NULL,
    lgifabsu8  float    NOT NULL,
    lgifabsu9  float    NOT NULL,
    lgifabsu10 float    NOT NULL,
    lgifrsta1  smallint NOT NULL,
    lgifrsta2  smallint NOT NULL,
    lgifrsta3  smallint NOT NULL,
    lgifrsta4  smallint NOT NULL,
    lgifrsta5  smallint NOT NULL,
    lgifrsta6  smallint NOT NULL,
    lgifrsta7  smallint NOT NULL,
    lgifrsta8  smallint NOT NULL,
    lgifrsta9  smallint NOT NULL,
    lgifrsta10 smallint NOT NULL,
    lgif1rel1  float    NOT NULL,
    lgif1rel2  float    NOT NULL,
    lgif1rel3  float    NOT NULL,
    lgif1rel4  float    NOT NULL,
    lgif1rel5  float    NOT NULL,
    lgif1rel6  float    NOT NULL,
    lgif1rel7  float    NOT NULL,
    lgif1rel8  float    NOT NULL,
    lgif1rel9  float    NOT NULL,
    lgif1rel10 float    NOT NULL,
    lgif2rel1  float    NOT NULL,
    lgif2rel2  float    NOT NULL,
    lgif2rel3  float    NOT NULL,
    lgif2rel4  float    NOT NULL,
    lgif2rel5  float    NOT NULL,
    lgif2rel6  float    NOT NULL,
    lgif2rel7  float    NOT NULL,
    lgif2rel8  float    NOT NULL,
    lgif2rel9  float    NOT NULL,
    lgif2rel10 float    NOT NULL,
    lgifnscd   smallint NOT NULL,
    lgifnscg   smallint NOT NULL,
    lgifline   smallint NOT NULL,
    lgifpos    smallint NOT NULL,
    lgifadet   char(3)  NOT NULL,
    lgifrpid1  smallint NOT NULL,
    lgifrpidy  smallint NOT NULL,
    utk_start  int      NULL,
    utk_end    int      NULL,
    position   smallint NULL
)
LOCK ALLPAGES
go