Object Type	Table
Datasource	IPMA
Database	icsa

Most of the information in this table is extracted from the LWS LSPD SPD FITS product file headers for each observation. Note that for CUS (L99) observations no SPD files are produced, and therefor no information will be available in this table. Note that this table is still 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

This table was to be populated during BKRP by db-import, but the exact definition of this table, and how to extract the values contained, was not yet complete when db-import was implemented and BKRP started. Therefor, this table will be populated using the UDF functionality of the ISO Data Archive.

Columns

Name	Datatype	Null

obsno	int	No

instra	float	No

instdec	float	No

instroll	float	No

leohfps	bit	No

leohfpl	bit	No

leohspct	int	Yes

leohsdet	int	Yes

leohedet	int	Yes

leohszne	int	Yes

leohezne	int	Yes

leohbzne	int	Yes

leohswav	float	Yes

leohewav	float	Yes

lphotom	bit	No

lsvers1	varchar(70)	No

lsvers2	varchar(70)	No

lsvers3	varchar(70)	No

lsvers4	varchar(70)	No

lsvers5	varchar(70)	No

lsvers6	varchar(70)	No

lsvers7	varchar(70)	No

lsvers8	varchar(70)	No

lsvers9	varchar(70)	No

lsvers10	varchar(70)	No

lsvers11	varchar(70)	No

lsvers12	varchar(70)	No

lswave	float	No

lewave	float	No

lbiass1	int	No

lbiass2	int	No

lbiass3	int	No

lbiass4	int	No

lbiass5	int	No

lbiasl1	int	No

lbiasl2	int	No

lbiasl3	int	No

lbiasl4	int	No

lbiasl5	int	No

lsrndat	int	No

lsrnrmp	int	No

lsrnitkj	int	No

lsrgrat0	float	No

lsrgrat1	float	No

lsrgrat2	float	No

lsrgrat3	float	No

lsrgrat4	float	No

lsrgrat5	float	No

lsrgrat6	float	No

lsrgrat7	float	No

lsrgrat8	float	No

lsrgrat9	float	No

lsrgtot	float	No

lsrdg1n0	int	No

lsrdg1n1	int	No

lsrdg1n2	int	No

lsrdg1n3	int	No

lsrdg1n4	int	No

lsrdg1n5	int	No

lsrdg1n6	int	No

lsrdg1n7	int	No

lsrdg1n8	int	No

lsrdg1n9	int	No

lsrmaxd0	int	No

lsrmaxd1	int	No

lsrmaxd2	int	No

lsrmaxd3	int	No

lsrmaxd4	int	No

lsrmaxd5	int	No

lsrmaxd6	int	No

lsrmaxd7	int	No

lsrmaxd8	int	No

lsrmaxd9	int	No

lsrmaxg0	int	No

lsrmaxg1	int	No

lsrmaxg2	int	No

lsrmaxg3	int	No

lsrmaxg4	int	No

lsrmaxg5	int	No

lsrmaxg6	int	No

lsrmaxg7	int	No

lsrmaxg8	int	No

lsrmaxg9	int	No

lsrmaxp0	int	No

lsrmaxp1	int	No

lsrmaxp2	int	No

lsrmaxp3	int	No

lsrmaxp4	int	No

lsrmaxp5	int	No

lsrmaxp6	int	No

lsrmaxp7	int	No

lsrmaxp8	int	No

lsrmaxp9	int	No

lsrmind0	int	No

lsrmind1	int	No

lsrmind2	int	No

lsrmind3	int	No

lsrmind4	int	No

lsrmind5	int	No

lsrmind6	int	No

lsrmind7	int	No

lsrmind8	int	No

lsrmind9	int	No

lsrming0	int	No

lsrming1	int	No

lsrming2	int	No

lsrming3	int	No

lsrming4	int	No

lsrming5	int	No

lsrming6	int	No

lsrming7	int	No

lsrming8	int	No

lsrming9	int	No

lsrminp0	int	No

lsrminp1	int	No

lsrminp2	int	No

lsrminp3	int	No

lsrminp4	int	No

lsrminp5	int	No

lsrminp6	int	No

lsrminp7	int	No

lsrminp8	int	No

lsrminp9	int	No

lsrnpnt0	int	No

lsrnpnt1	int	No

lsrnpnt2	int	No

lsrnpnt3	int	No

lsrnpnt4	int	No

lsrnpnt5	int	No

lsrnpnt6	int	No

lsrnpnt7	int	No

lsrnpnt8	int	No

lsrnpnt9	int	No

lsrdnr0	int	No

lsrdnr1	int	No

lsrdnr2	int	No

lsrdnr3	int	No

lsrdnr4	int	No

lsrdnr5	int	No

lsrdnr6	int	No

lsrdnr7	int	No

lsrdnr8	int	No

lsrdnr9	int	No

lsrdg1r0	int	No

lsrdg1r1	int	No

lsrdg1r2	int	No

lsrdg1r3	int	No

lsrdg1r4	int	No

lsrdg1r5	int	No

lsrdg1r6	int	No

lsrdg1r7	int	No

lsrdg1r8	int	No

lsrdg1r9	int	No

lsrfewr0	int	No

lsrfewr1	int	No

lsrfewr2	int	No

lsrfewr3	int	No

lsrfewr4	int	No

lsrfewr5	int	No

lsrfewr6	int	No

lsrfewr7	int	No

lsrfewr8	int	No

lsrfewr9	int	No

lsrvltr0	int	No

lsrvltr1	int	No

lsrvltr2	int	No

lsrvltr3	int	No

lsrvltr4	int	No

lsrvltr5	int	No

lsrvltr6	int	No

lsrvltr7	int	No

lsrvltr8	int	No

lsrvltr9	int	No

lsrunr0	int	No

lsrunr1	int	No

lsrunr2	int	No

lsrunr3	int	No

lsrunr4	int	No

lsrunr5	int	No

lsrunr6	int	No

lsrunr7	int	No

lsrunr8	int	No

lsrunr9	int	No

lsrper0	int	No

lsrper1	int	No

lsrper2	int	No

lsrper3	int	No

lsrper4	int	No

lsrper5	int	No

lsrper6	int	No

lsrper7	int	No

lsrper8	int	No

lsrper9	int	No

lsrfit20	int	No

lsrfit21	int	No

lsrfit22	int	No

lsrfit23	int	No

lsrfit24	int	No

lsrfit25	int	No

lsrfit26	int	No

lsrfit27	int	No

lsrfit28	int	No

lsrfit29	int	No

lsrdg1a0	int	No

lsrdg1a1	int	No

lsrdg1a2	int	No

lsrdg1a3	int	No

lsrdg1a4	int	No

lsrdg1a5	int	No

lsrdg1a6	int	No

lsrdg1a7	int	No

lsrdg1a8	int	No

lsrdg1a9	int	No

lsrnspk0	int	No

lsrnspk1	int	No

lsrnspk2	int	No

lsrnspk3	int	No

lsrnspk4	int	No

lsrnspk5	int	No

lsrnspk6	int	No

lsrnspk7	int	No

lsrnspk8	int	No

lsrnspk9	int	No

column instdec

column instra

column instroll

column lbiasl1
column lbiasl2
column lbiasl3
column lbiasl4
column lbiasl5

column lbiass1
column lbiass2
column lbiass3
column lbiass4
column lbiass5

column leohbzne

column leohedet

column leohewav

column leohezne

column leohfpl

column leohfps

column leohsdet

column leohspct

column leohswav

column leohszne

column lewave

column lphotom

column lsrdg1n0
column lsrdg1n1
column lsrdg1n2
column lsrdg1n3
column lsrdg1n4
column lsrdg1n5
column lsrdg1n6
column lsrdg1n7
column lsrdg1n8
column lsrdg1n9

column lsrgrat0
column lsrgrat1
column lsrgrat2
column lsrgrat3
column lsrgrat4
column lsrgrat5
column lsrgrat6
column lsrgrat7
column lsrgrat8
column lsrgrat9

column lsrgtot

column lsrmaxd0
column lsrmaxd1
column lsrmaxd2
column lsrmaxd3
column lsrmaxd4
column lsrmaxd5
column lsrmaxd6
column lsrmaxd7
column lsrmaxd8
column lsrmaxd9

column lsrmaxg0
column lsrmaxg1
column lsrmaxg2
column lsrmaxg3
column lsrmaxg4
column lsrmaxg5
column lsrmaxg6
column lsrmaxg7
column lsrmaxg8
column lsrmaxg9

column lsrmaxp0
column lsrmaxp1
column lsrmaxp2
column lsrmaxp3
column lsrmaxp4
column lsrmaxp5
column lsrmaxp6
column lsrmaxp7
column lsrmaxp8
column lsrmaxp9

column lsrmind0
column lsrmind1
column lsrmind2
column lsrmind3
column lsrmind4
column lsrmind5
column lsrmind6
column lsrmind7

column lsrndat

column lsrnitkj

column lsrnrmp

column lsvers1
column lsvers10
column lsvers11
column lsvers12
column lsvers2
column lsvers3
column lsvers4
column lsvers5
column lsvers6
column lsvers7
column lsvers8
column lsvers9

column lswave

column lsrdg1a0
column lsrdg1a1
column lsrdg1a2
column lsrdg1a3
column lsrdg1a4
column lsrdg1a5
column lsrdg1a6
column lsrdg1a7
column lsrdg1a8
column lsrdg1a9

column lsrdg1r0
column lsrdg1r1
column lsrdg1r2
column lsrdg1r3
column lsrdg1r4
column lsrdg1r5
column lsrdg1r6
column lsrdg1r7
column lsrdg1r8
column lsrdg1r9

column lsrdnr0
column lsrdnr1
column lsrdnr2
column lsrdnr3
column lsrdnr4
column lsrdnr5
column lsrdnr6
column lsrdnr7
column lsrdnr8
column lsrdnr9

column lsrfewr0
column lsrfewr1
column lsrfewr2
column lsrfewr3
column lsrfewr4
column lsrfewr5
column lsrfewr6
column lsrfewr7
column lsrfewr8
column lsrfewr9

column lsrfit20
column lsrfit21
column lsrfit22
column lsrfit23
column lsrfit24
column lsrfit25
column lsrfit26
column lsrfit27
column lsrfit28
column lsrfit29

column lsrmind8
column lsrmind9
column lsrming0
column lsrming1
column lsrming2
column lsrming3
column lsrming4
column lsrming5
column lsrming6
column lsrming7
column lsrming8
column lsrming9

column lsrminp0
column lsrminp1
column lsrminp2
column lsrminp3
column lsrminp4
column lsrminp5
column lsrminp6
column lsrminp7
column lsrminp8
column lsrminp9

column lsrnpnt0
column lsrnpnt1
column lsrnpnt2
column lsrnpnt3
column lsrnpnt4
column lsrnpnt5
column lsrnpnt6
column lsrnpnt7
column lsrnpnt8
column lsrnpnt9

column lsrnspk0
column lsrnspk1
column lsrnspk2
column lsrnspk3
column lsrnspk4
column lsrnspk5
column lsrnspk6
column lsrnspk7
column lsrnspk8
column lsrnspk9

column lsrper0
column lsrper1
column lsrper2
column lsrper3
column lsrper4
column lsrper5
column lsrper6
column lsrper7
column lsrper8
column lsrper9

column lsrunr0
column lsrunr1
column lsrunr2
column lsrunr3
column lsrunr4
column lsrunr5
column lsrunr6
column lsrunr7
column lsrunr8
column lsrunr9

column lsrvltr0
column lsrvltr1
column lsrvltr2
column lsrvltr3
column lsrvltr4
column lsrvltr5
column lsrvltr6
column lsrvltr7
column lsrvltr8
column lsrvltr9

column obsno

Table Usage (MB)

Distribution of Table Space

Data	0.00	Data	6.25 %
Indexes	0.00	Indexes	6.25 %
Unused	0.03	Unused	87.50 %
Total	0.03	Number of Rows	0

Dependencies

Referencing Objects

Object Name Object Type

dbo.lspd_hdr.lspd_hdr_pk INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.lspd_hdr 
(
    obsno    int         NOT NULL,
    instra   float       NOT NULL,
    instdec  float       NOT NULL,
    instroll float       NOT NULL,
    leohfps  bit         NOT NULL,
    leohfpl  bit         NOT NULL,
    leohspct int         NULL,
    leohsdet int         NULL,
    leohedet int         NULL,
    leohszne int         NULL,
    leohezne int         NULL,
    leohbzne int         NULL,
    leohswav float       NULL,
    leohewav float       NULL,
    lphotom  bit         NOT NULL,
    lsvers1  varchar(70) NOT NULL,
    lsvers2  varchar(70) NOT NULL,
    lsvers3  varchar(70) NOT NULL,
    lsvers4  varchar(70) NOT NULL,
    lsvers5  varchar(70) NOT NULL,
    lsvers6  varchar(70) NOT NULL,
    lsvers7  varchar(70) NOT NULL,
    lsvers8  varchar(70) NOT NULL,
    lsvers9  varchar(70) NOT NULL,
    lsvers10 varchar(70) NOT NULL,
    lsvers11 varchar(70) NOT NULL,
    lsvers12 varchar(70) NOT NULL,
    lswave   float       NOT NULL,
    lewave   float       NOT NULL,
    lbiass1  int         NOT NULL,
    lbiass2  int         NOT NULL,
    lbiass3  int         NOT NULL,
    lbiass4  int         NOT NULL,
    lbiass5  int         NOT NULL,
    lbiasl1  int         NOT NULL,
    lbiasl2  int         NOT NULL,
    lbiasl3  int         NOT NULL,
    lbiasl4  int         NOT NULL,
    lbiasl5  int         NOT NULL,
    lsrndat  int         NOT NULL,
    lsrnrmp  int         NOT NULL,
    lsrnitkj int         NOT NULL,
    lsrgrat0 float       NOT NULL,
    lsrgrat1 float       NOT NULL,
    lsrgrat2 float       NOT NULL,
    lsrgrat3 float       NOT NULL,
    lsrgrat4 float       NOT NULL,
    lsrgrat5 float       NOT NULL,
    lsrgrat6 float       NOT NULL,
    lsrgrat7 float       NOT NULL,
    lsrgrat8 float       NOT NULL,
    lsrgrat9 float       NOT NULL,
    lsrgtot  float       NOT NULL,
    lsrdg1n0 int         NOT NULL,
    lsrdg1n1 int         NOT NULL,
    lsrdg1n2 int         NOT NULL,
    lsrdg1n3 int         NOT NULL,
    lsrdg1n4 int         NOT NULL,
    lsrdg1n5 int         NOT NULL,
    lsrdg1n6 int         NOT NULL,
    lsrdg1n7 int         NOT NULL,
    lsrdg1n8 int         NOT NULL,
    lsrdg1n9 int         NOT NULL,
    lsrmaxd0 int         NOT NULL,
    lsrmaxd1 int         NOT NULL,
    lsrmaxd2 int         NOT NULL,
    lsrmaxd3 int         NOT NULL,
    lsrmaxd4 int         NOT NULL,
    lsrmaxd5 int         NOT NULL,
    lsrmaxd6 int         NOT NULL,
    lsrmaxd7 int         NOT NULL,
    lsrmaxd8 int         NOT NULL,
    lsrmaxd9 int         NOT NULL,
    lsrmaxg0 int         NOT NULL,
    lsrmaxg1 int         NOT NULL,
    lsrmaxg2 int         NOT NULL,
    lsrmaxg3 int         NOT NULL,
    lsrmaxg4 int         NOT NULL,
    lsrmaxg5 int         NOT NULL,
    lsrmaxg6 int         NOT NULL,
    lsrmaxg7 int         NOT NULL,
    lsrmaxg8 int         NOT NULL,
    lsrmaxg9 int         NOT NULL,
    lsrmaxp0 int         NOT NULL,
    lsrmaxp1 int         NOT NULL,
    lsrmaxp2 int         NOT NULL,
    lsrmaxp3 int         NOT NULL,
    lsrmaxp4 int         NOT NULL,
    lsrmaxp5 int         NOT NULL,
    lsrmaxp6 int         NOT NULL,
    lsrmaxp7 int         NOT NULL,
    lsrmaxp8 int         NOT NULL,
    lsrmaxp9 int         NOT NULL,
    lsrmind0 int         NOT NULL,
    lsrmind1 int         NOT NULL,
    lsrmind2 int         NOT NULL,
    lsrmind3 int         NOT NULL,
    lsrmind4 int         NOT NULL,
    lsrmind5 int         NOT NULL,
    lsrmind6 int         NOT NULL,
    lsrmind7 int         NOT NULL,
    lsrmind8 int         NOT NULL,
    lsrmind9 int         NOT NULL,
    lsrming0 int         NOT NULL,
    lsrming1 int         NOT NULL,
    lsrming2 int         NOT NULL,
    lsrming3 int         NOT NULL,
    lsrming4 int         NOT NULL,
    lsrming5 int         NOT NULL,
    lsrming6 int         NOT NULL,
    lsrming7 int         NOT NULL,
    lsrming8 int         NOT NULL,
    lsrming9 int         NOT NULL,
    lsrminp0 int         NOT NULL,
    lsrminp1 int         NOT NULL,
    lsrminp2 int         NOT NULL,
    lsrminp3 int         NOT NULL,
    lsrminp4 int         NOT NULL,
    lsrminp5 int         NOT NULL,
    lsrminp6 int         NOT NULL,
    lsrminp7 int         NOT NULL,
    lsrminp8 int         NOT NULL,
    lsrminp9 int         NOT NULL,
    lsrnpnt0 int         NOT NULL,
    lsrnpnt1 int         NOT NULL,
    lsrnpnt2 int         NOT NULL,
    lsrnpnt3 int         NOT NULL,
    lsrnpnt4 int         NOT NULL,
    lsrnpnt5 int         NOT NULL,
    lsrnpnt6 int         NOT NULL,
    lsrnpnt7 int         NOT NULL,
    lsrnpnt8 int         NOT NULL,
    lsrnpnt9 int         NOT NULL,
    lsrdnr0  int         NOT NULL,
    lsrdnr1  int         NOT NULL,
    lsrdnr2  int         NOT NULL,
    lsrdnr3  int         NOT NULL,
    lsrdnr4  int         NOT NULL,
    lsrdnr5  int         NOT NULL,
    lsrdnr6  int         NOT NULL,
    lsrdnr7  int         NOT NULL,
    lsrdnr8  int         NOT NULL,
    lsrdnr9  int         NOT NULL,
    lsrdg1r0 int         NOT NULL,
    lsrdg1r1 int         NOT NULL,
    lsrdg1r2 int         NOT NULL,
    lsrdg1r3 int         NOT NULL,
    lsrdg1r4 int         NOT NULL,
    lsrdg1r5 int         NOT NULL,
    lsrdg1r6 int         NOT NULL,
    lsrdg1r7 int         NOT NULL,
    lsrdg1r8 int         NOT NULL,
    lsrdg1r9 int         NOT NULL,
    lsrfewr0 int         NOT NULL,
    lsrfewr1 int         NOT NULL,
    lsrfewr2 int         NOT NULL,
    lsrfewr3 int         NOT NULL,
    lsrfewr4 int         NOT NULL,
    lsrfewr5 int         NOT NULL,
    lsrfewr6 int         NOT NULL,
    lsrfewr7 int         NOT NULL,
    lsrfewr8 int         NOT NULL,
    lsrfewr9 int         NOT NULL,
    lsrvltr0 int         NOT NULL,
    lsrvltr1 int         NOT NULL,
    lsrvltr2 int         NOT NULL,
    lsrvltr3 int         NOT NULL,
    lsrvltr4 int         NOT NULL,
    lsrvltr5 int         NOT NULL,
    lsrvltr6 int         NOT NULL,
    lsrvltr7 int         NOT NULL,
    lsrvltr8 int         NOT NULL,
    lsrvltr9 int         NOT NULL,
    lsrunr0  int         NOT NULL,
    lsrunr1  int         NOT NULL,
    lsrunr2  int         NOT NULL,
    lsrunr3  int         NOT NULL,
    lsrunr4  int         NOT NULL,
    lsrunr5  int         NOT NULL,
    lsrunr6  int         NOT NULL,
    lsrunr7  int         NOT NULL,
    lsrunr8  int         NOT NULL,
    lsrunr9  int         NOT NULL,
    lsrper0  int         NOT NULL,
    lsrper1  int         NOT NULL,
    lsrper2  int         NOT NULL,
    lsrper3  int         NOT NULL,
    lsrper4  int         NOT NULL,
    lsrper5  int         NOT NULL,
    lsrper6  int         NOT NULL,
    lsrper7  int         NOT NULL,
    lsrper8  int         NOT NULL,
    lsrper9  int         NOT NULL,
    lsrfit20 int         NOT NULL,
    lsrfit21 int         NOT NULL,
    lsrfit22 int         NOT NULL,
    lsrfit23 int         NOT NULL,
    lsrfit24 int         NOT NULL,
    lsrfit25 int         NOT NULL,
    lsrfit26 int         NOT NULL,
    lsrfit27 int         NOT NULL,
    lsrfit28 int         NOT NULL,
    lsrfit29 int         NOT NULL,
    lsrdg1a0 int         NOT NULL,
    lsrdg1a1 int         NOT NULL,
    lsrdg1a2 int         NOT NULL,
    lsrdg1a3 int         NOT NULL,
    lsrdg1a4 int         NOT NULL,
    lsrdg1a5 int         NOT NULL,
    lsrdg1a6 int         NOT NULL,
    lsrdg1a7 int         NOT NULL,
    lsrdg1a8 int         NOT NULL,
    lsrdg1a9 int         NOT NULL,
    lsrnspk0 int         NOT NULL,
    lsrnspk1 int         NOT NULL,
    lsrnspk2 int         NOT NULL,
    lsrnspk3 int         NOT NULL,
    lsrnspk4 int         NOT NULL,
    lsrnspk5 int         NOT NULL,
    lsrnspk6 int         NOT NULL,
    lsrnspk7 int         NOT NULL,
    lsrnspk8 int         NOT NULL,
    lsrnspk9 int         NOT NULL
)
LOCK ALLPAGES
go