Object Type	Table
Datasource	IPMA
Database	icsa

This information has been extracted from the LWS LSCA 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

lscarpid1	smallint	No

lscapid2	smallint	No

lscaadet	char(3)	No

lscaitks	int	No

lscaitke	int	No

lscaitkr	int	No

lscanrmt	smallint	No

lscanrmf1	smallint	No

lscanrmf2	smallint	No

lscanrmf3	smallint	No

lscanrmf4	smallint	No

lscanrmf5	smallint	No

lscanrmf6	smallint	No

lscanrmf7	smallint	No

lscanrmf8	smallint	No

lscanrmf9	smallint	No

lscanrmf10	smallint	No

lscaline	smallint	No

lscagpos	smallint	No

lscacnt	smallint	No

lscadir	smallint	No

lscautks	int	Yes

lscautke	int	Yes

lscaord1	float	No

lscaord2	float	No

lscaord3	float	No

lscaord4	float	No

lscaord5	float	No

lscaord6	float	No

lscaord7	float	No

lscaord8	float	No

lscaord9	float	No

lscaord10	float	No

lscabk1	float	No

lscabk2	float	No

lscabk3	float	No

lscabk4	float	No

lscabk5	float	No

lscabk6	float	No

lscabk7	float	No

lscabk8	float	No

lscabk9	float	No

lscabk10	float	No

lscabku1	float	No

lscabku2	float	No

lscabku3	float	No

lscabku4	float	No

lscabku5	float	No

lscabku6	float	No

lscabku7	float	No

lscabku8	float	No

lscabku9	float	No

lscabku10	float	No

position	smallint	Yes

column lscaadet

Active detector as string. Detector name for AOTs L02 and L04, PHT=L02 photometric observation, ALL=L01, ???=L03.

column lscabk1
column lscabk10
column lscabk2
column lscabk3
column lscabk4
column lscabk5
column lscabk6
column lscabk7
column lscabk8
column lscabk9

Background/straylight subtracted from scan for each detector.

column lscabku1
column lscabku10
column lscabku2
column lscabku3
column lscabku4
column lscabku5
column lscabku6
column lscabku7
column lscabku8
column lscabku9

Uncertainties in background/straylight for each detector.

column lscacnt

scan count (0,1...).

column lscadir

scan direction:
forward
reverse
-999 error.

column lscagpos

Grating measured position at start of scan (L03 and L04 only). Set to -1 for L01 and L02.

column lscaitke

ITK time of end of scan.

column lscaitkr

ITK time of reference point in scan scan.

column lscaitks

ITK of start of scan.

column lscaline

line number (L02 and L04 only).

column lscanrmf1
column lscanrmf10
column lscanrmf2
column lscanrmf3
column lscanrmf4
column lscanrmf5
column lscanrmf6
column lscanrmf7
column lscanrmf8
column lscanrmf9

Number of ramps used in calculation of average flux, for each detector.

column lscanrmt

Total number of ramps in scan.

column lscaord1
column lscaord10
column lscaord2
column lscaord3
column lscaord4
column lscaord5
column lscaord6
column lscaord7
column lscaord8
column lscaord9

Order numbers (L03, L04) for each detector.

column lscapid2

Raster point ID 2.

column lscarpid1

Raster point ID 1.

column lscautke

UTK time of end of scan.

column lscautks

UTK time of start of scan.

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.

Table Usage (MB)

Distribution of Table Space

Data	67.54	Data	89.97 %
Indexes	0.79	Indexes	1.05 %
Unused	6.74	Unused	8.98 %
Total	75.07	Number of Rows	185536

Dependencies

Referencing Objects

Object Name Object Type

dbo.lsca.lcsa_ucx INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.lsca 
(
    obsno      int      NOT NULL,
    lscarpid1  smallint NOT NULL,
    lscapid2   smallint NOT NULL,
    lscaadet   char(3)  NOT NULL,
    lscaitks   int      NOT NULL,
    lscaitke   int      NOT NULL,
    lscaitkr   int      NOT NULL,
    lscanrmt   smallint NOT NULL,
    lscanrmf1  smallint NOT NULL,
    lscanrmf2  smallint NOT NULL,
    lscanrmf3  smallint NOT NULL,
    lscanrmf4  smallint NOT NULL,
    lscanrmf5  smallint NOT NULL,
    lscanrmf6  smallint NOT NULL,
    lscanrmf7  smallint NOT NULL,
    lscanrmf8  smallint NOT NULL,
    lscanrmf9  smallint NOT NULL,
    lscanrmf10 smallint NOT NULL,
    lscaline   smallint NOT NULL,
    lscagpos   smallint NOT NULL,
    lscacnt    smallint NOT NULL,
    lscadir    smallint NOT NULL,
    lscautks   int      NULL,
    lscautke   int      NULL,
    lscaord1   float    NOT NULL,
    lscaord2   float    NOT NULL,
    lscaord3   float    NOT NULL,
    lscaord4   float    NOT NULL,
    lscaord5   float    NOT NULL,
    lscaord6   float    NOT NULL,
    lscaord7   float    NOT NULL,
    lscaord8   float    NOT NULL,
    lscaord9   float    NOT NULL,
    lscaord10  float    NOT NULL,
    lscabk1    float    NOT NULL,
    lscabk2    float    NOT NULL,
    lscabk3    float    NOT NULL,
    lscabk4    float    NOT NULL,
    lscabk5    float    NOT NULL,
    lscabk6    float    NOT NULL,
    lscabk7    float    NOT NULL,
    lscabk8    float    NOT NULL,
    lscabk9    float    NOT NULL,
    lscabk10   float    NOT NULL,
    lscabku1   float    NOT NULL,
    lscabku2   float    NOT NULL,
    lscabku3   float    NOT NULL,
    lscabku4   float    NOT NULL,
    lscabku5   float    NOT NULL,
    lscabku6   float    NOT NULL,
    lscabku7   float    NOT NULL,
    lscabku8   float    NOT NULL,
    lscabku9   float    NOT NULL,
    lscabku10  float    NOT NULL,
    position   smallint NULL
)
LOCK ALLPAGES
go