Object Type	Table
Datasource	IPMA
Database	icsa

This information has been extracted from the LIAC AA FITS product.

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

liaciks int No

liacike int No

liacuks int No

liacuke int No

liactype int No

liacwhap int No

liacres1 float No

liacres2 float No

liacres3 float No

liacres4 float No

liacres5 float No

liacres6 float No

liacres7 float No

liacres8 float No

liacres9 float No

liacres10 float No

liacresu1 float No

liacresu2 float No

liacresu3 float No

liacresu4 float No

liacresu5 float No

liacresu6 float No

liacresu7 float No

liacresu8 float No

liacresu9 float No

liacresu10 float No

liacbk1 float No

liacbk2 float No

liacbk3 float No

liacbk4 float No

liacbk5 float No

liacbk6 float No

liacbk7 float No

liacbk8 float No

liacbk9 float No

liacbk10 float No

liacbku1 float No

liacbku2 float No

liacbku3 float No

liacbku4 float No

liacbku5 float No

liacbku6 float No

liacbku7 float No

liacbku8 float No

liacbku9 float No

liacbku10 float No

liacnr1 smallint No

liacnr2 smallint No

liacnr3 smallint No

liacnr4 smallint No

liacnr5 smallint No

liacnr6 smallint No

liacnr7 smallint No

liacnr8 smallint No

liacnr9 smallint No

liacnr10 smallint No

liacnb1 smallint No

liacnb2 smallint No

liacnb3 smallint No

liacnb4 smallint No

liacnb5 smallint No

liacnb6 smallint No

liacnb7 smallint No

liacnb8 smallint No

liacnb9 smallint No

liacnb10 smallint No

position smallint Yes

column liacbk1
column liacbk10
column liacbk2
column liacbk3
column liacbk4
column liacbk5
column liacbk6
column liacbk7
column liacbk8
column liacbk9

Background photocurrent for each detector.

column liacbku1
column liacbku10
column liacbku2
column liacbku3
column liacbku4
column liacbku5
column liacbku6
column liacbku7
column liacbku8
column liacbku9
Uncertainty in background photocurrent for each detector.

column liacike
ITK of end of flash.

column liaciks
UTK of start of flash.

column liacnb1
column liacnb10
column liacnb2
column liacnb3
column liacnb4
column liacnb5
column liacnb6
column liacnb7
column liacnb8
column liacnb9

Number of points used in calculation of background per detector.

column liacnr1
column liacnr10
column liacnr2
column liacnr3
column liacnr4
column liacnr5
column liacnr6
column liacnr7
column liacnr8
column liacnr9

Number of points used in calculation of correction factor per detector.

column liacres1
column liacres10
column liacres2
column liacres3
column liacres4
column liacres5
column liacres6
column liacres7
column liacres8
column liacres9

Absolute responsivity correction factor for each detector.

column liacresu1
column liacresu10
column liacresu2
column liacresu3
column liacresu4
column liacresu5
column liacresu6
column liacresu7
column liacresu8
column liacresu9

Uncertainty in absolute responsivity correction factors.

column liactype

Illuminator flash type identifier (0,1...).

column liacuke

UTK of end of flash.

column liacuks

UTK of start of flash.

column liacwhap

Wheel absolute position, one of:\
FPS
GR
FPL
BLANK

column obsno

Observation number constructed as follows:

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

Please see SCREW 385.

column position

Position of Flash.

Table Usage (MB)

Distribution of Table Space

Data	3.25	Data	97.59 %
Indexes	0.03	Indexes	0.76 %
Unused	0.05	Unused	1.64 %
Total	3.33	Number of Rows	8305

Dependencies

Referencing Objects

Object Name Object Type

dbo.liac.liac_ucx INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.liac 
(
    obsno      int      NOT NULL,
    liaciks    int      NOT NULL,
    liacike    int      NOT NULL,
    liacuks    int      NOT NULL,
    liacuke    int      NOT NULL,
    liactype   int      NOT NULL,
    liacwhap   int      NOT NULL,
    liacres1   float    NOT NULL,
    liacres2   float    NOT NULL,
    liacres3   float    NOT NULL,
    liacres4   float    NOT NULL,
    liacres5   float    NOT NULL,
    liacres6   float    NOT NULL,
    liacres7   float    NOT NULL,
    liacres8   float    NOT NULL,
    liacres9   float    NOT NULL,
    liacres10  float    NOT NULL,
    liacresu1  float    NOT NULL,
    liacresu2  float    NOT NULL,
    liacresu3  float    NOT NULL,
    liacresu4  float    NOT NULL,
    liacresu5  float    NOT NULL,
    liacresu6  float    NOT NULL,
    liacresu7  float    NOT NULL,
    liacresu8  float    NOT NULL,
    liacresu9  float    NOT NULL,
    liacresu10 float    NOT NULL,
    liacbk1    float    NOT NULL,
    liacbk2    float    NOT NULL,
    liacbk3    float    NOT NULL,
    liacbk4    float    NOT NULL,
    liacbk5    float    NOT NULL,
    liacbk6    float    NOT NULL,
    liacbk7    float    NOT NULL,
    liacbk8    float    NOT NULL,
    liacbk9    float    NOT NULL,
    liacbk10   float    NOT NULL,
    liacbku1   float    NOT NULL,
    liacbku2   float    NOT NULL,
    liacbku3   float    NOT NULL,
    liacbku4   float    NOT NULL,
    liacbku5   float    NOT NULL,
    liacbku6   float    NOT NULL,
    liacbku7   float    NOT NULL,
    liacbku8   float    NOT NULL,
    liacbku9   float    NOT NULL,
    liacbku10  float    NOT NULL,
    liacnr1    smallint NOT NULL,
    liacnr2    smallint NOT NULL,
    liacnr3    smallint NOT NULL,
    liacnr4    smallint NOT NULL,
    liacnr5    smallint NOT NULL,
    liacnr6    smallint NOT NULL,
    liacnr7    smallint NOT NULL,
    liacnr8    smallint NOT NULL,
    liacnr9    smallint NOT NULL,
    liacnr10   smallint NOT NULL,
    liacnb1    smallint NOT NULL,
    liacnb2    smallint NOT NULL,
    liacnb3    smallint NOT NULL,
    liacnb4    smallint NOT NULL,
    liacnb5    smallint NOT NULL,
    liacnb6    smallint NOT NULL,
    liacnb7    smallint NOT NULL,
    liacnb8    smallint NOT NULL,
    liacnb9    smallint NOT NULL,
    liacnb10   smallint NOT NULL,
    position   smallint NULL
)
LOCK ALLPAGES
go

Name	Datatype	Null

obsno	int	No

liaciks	int	No

liacike	int	No

liacuks	int	No

liacuke	int	No

liactype	int	No

liacwhap	int	No

liacres1	float	No

liacres2	float	No

liacres3	float	No

liacres4	float	No

liacres5	float	No

liacres6	float	No

liacres7	float	No

liacres8	float	No

liacres9	float	No

liacres10	float	No

liacresu1	float	No

liacresu2	float	No

liacresu3	float	No

liacresu4	float	No

liacresu5	float	No

liacresu6	float	No

liacresu7	float	No

liacresu8	float	No

liacresu9	float	No

liacresu10	float	No

liacbk1	float	No

liacbk2	float	No

liacbk3	float	No

liacbk4	float	No

liacbk5	float	No

liacbk6	float	No

liacbk7	float	No

liacbk8	float	No

liacbk9	float	No

liacbk10	float	No

liacbku1	float	No

liacbku2	float	No

liacbku3	float	No

liacbku4	float	No

liacbku5	float	No

liacbku6	float	No

liacbku7	float	No

liacbku8	float	No

liacbku9	float	No

liacbku10	float	No

liacnr1	smallint	No

liacnr2	smallint	No

liacnr3	smallint	No

liacnr4	smallint	No

liacnr5	smallint	No

liacnr6	smallint	No

liacnr7	smallint	No

liacnr8	smallint	No

liacnr9	smallint	No

liacnr10	smallint	No

liacnb1	smallint	No

liacnb2	smallint	No

liacnb3	smallint	No

liacnb4	smallint	No

liacnb5	smallint	No

liacnb6	smallint	No

liacnb7	smallint	No

liacnb8	smallint	No

liacnb9	smallint	No

liacnb10	smallint	No

position	smallint	Yes