Object Type	Table
Datasource	IPMA
Database	icsa

The columns of this table are derived directly from the cdiags table of the IPA database.

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

utk	int	No

obsno	int	Yes

swcpol1	tinyint	No

swcpol2	tinyint	No

swcpol3	tinyint	No

swcpol4	tinyint	No

swcpol5	tinyint	No

swcpol6	tinyint	No

swcpol7	tinyint	No

swmpol1	smallint	No

swmpol2	smallint	No

swmpol3	smallint	No

swmpol4	smallint	No

swmpol5	smallint	No

swmpol6	smallint	No

swmpol7	smallint	No

swmpol8	smallint	No

swmpol9	smallint	No

lwcpol1	smallint	No

lwcpol2	smallint	No

lwcpol3	smallint	No

lwcpol4	smallint	No

lwcpol5	smallint	No

lwcpol6	smallint	No

lwcpol7	smallint	No

lwmpol1	smallint	No

lwmpol2	smallint	No

lwmpol3	smallint	No

lwmpol4	smallint	No

lwmpol5	smallint	No

lwmpol6	smallint	No

lwmpol7	smallint	No

lwmpol8	smallint	No

lwmpol9	smallint	No

lwmpol10	smallint	No

templw1	smallint	No

templw2	smallint	No

cam1temp1	smallint	No

cam1temp2	smallint	No

cam1temp3	smallint	No

cam1temp4	smallint	No

cam2temp1	tinyint	No

cam2temp2	tinyint	No

cam3temp1	tinyint	No

vgenall1	smallint	No

vgenall2	smallint	No

vgenall3	smallint	No

swvgen1	smallint	No

swvgen2	smallint	No

swvgen3	smallint	No

swvgen4	smallint	No

swvgen5	smallint	No

swvgen6	smallint	No

lwvgen1	smallint	No

lwvgen2	smallint	No

lwvgen3	smallint	No

lwvgen4	smallint	No

lwvgen5	smallint	No

bbcur	smallint	No

bbvolt	int	No

column bbcur

Selected black body current.

column bbvolt

Black body voltage measure.

column cam1temp1

FPU temperature 1 for CAM1.

column cam1temp2

FPU temperature 2 for CAM1.

column cam1temp3

FPU temperature 3 for CAM1.

column cam1temp4

FPU temperature 4 for CAM1.

column cam2temp1

FPU temperature 1 for CAM2.

column cam2temp2

FPU temperature 2 for CAM2.

column cam3temp1

FPU temperature 1 for CAM3.

column lwcpol1
column lwcpol2
column lwcpol3
column lwcpol4
column lwcpol5
column lwcpol6
column lwcpol7

LW detector commanded polarizations.

column lwmpol1
column lwmpol10
column lwmpol2
column lwmpol3
column lwmpol4
column lwmpol5
column lwmpol6
column lwmpol7
column lwmpol8
column lwmpol9

LW detector measured polarizations.

column lwvgen1
column lwvgen2
column lwvgen3
column lwvgen4
column lwvgen5

LW general voltages.

column obsno

Observation number constructed as follows:

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

Please see SCREW 385.

column swcpol1
column swcpol2
column swcpol3
column swcpol4
column swcpol5
column swcpol6
column swcpol7

SW detector commanded polarizations.

column swmpol1
column swmpol2
column swmpol3
column swmpol4
column swmpol5
column swmpol6
column swmpol7
column swmpol8
column swmpol9

SW detector measured polarizations.

column swvgen1
column swvgen2
column swvgen3
column swvgen4
column swvgen5
column swvgen6

SW general voltages.

column templw1

LW temperature 1.

column templw2

LW temperature 2.

column utk

Universal Time Key.

column vgenall1
column vgenall2
column vgenall3

General voltages.

Table Usage (MB)

Distribution of Table Space

Data	279.32	Data	85.69 %
Indexes	46.51	Indexes	14.27 %
Unused	0.13	Unused	0.04 %
Total	325.96	Number of Rows	2288200

Dependencies

Referencing Objects

Object Name Object Type

dbo.cdiags.cdiags_ucx INDEX

dbo.cdiags.cdiags_ux INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.cdiags 
(
    utk       int      NOT NULL,
    obsno     int      NULL,
    swcpol1   tinyint  NOT NULL,
    swcpol2   tinyint  NOT NULL,
    swcpol3   tinyint  NOT NULL,
    swcpol4   tinyint  NOT NULL,
    swcpol5   tinyint  NOT NULL,
    swcpol6   tinyint  NOT NULL,
    swcpol7   tinyint  NOT NULL,
    swmpol1   smallint NOT NULL,
    swmpol2   smallint NOT NULL,
    swmpol3   smallint NOT NULL,
    swmpol4   smallint NOT NULL,
    swmpol5   smallint NOT NULL,
    swmpol6   smallint NOT NULL,
    swmpol7   smallint NOT NULL,
    swmpol8   smallint NOT NULL,
    swmpol9   smallint NOT NULL,
    lwcpol1   smallint NOT NULL,
    lwcpol2   smallint NOT NULL,
    lwcpol3   smallint NOT NULL,
    lwcpol4   smallint NOT NULL,
    lwcpol5   smallint NOT NULL,
    lwcpol6   smallint NOT NULL,
    lwcpol7   smallint NOT NULL,
    lwmpol1   smallint NOT NULL,
    lwmpol2   smallint NOT NULL,
    lwmpol3   smallint NOT NULL,
    lwmpol4   smallint NOT NULL,
    lwmpol5   smallint NOT NULL,
    lwmpol6   smallint NOT NULL,
    lwmpol7   smallint NOT NULL,
    lwmpol8   smallint NOT NULL,
    lwmpol9   smallint NOT NULL,
    lwmpol10  smallint NOT NULL,
    templw1   smallint NOT NULL,
    templw2   smallint NOT NULL,
    cam1temp1 smallint NOT NULL,
    cam1temp2 smallint NOT NULL,
    cam1temp3 smallint NOT NULL,
    cam1temp4 smallint NOT NULL,
    cam2temp1 tinyint  NOT NULL,
    cam2temp2 tinyint  NOT NULL,
    cam3temp1 tinyint  NOT NULL,
    vgenall1  smallint NOT NULL,
    vgenall2  smallint NOT NULL,
    vgenall3  smallint NOT NULL,
    swvgen1   smallint NOT NULL,
    swvgen2   smallint NOT NULL,
    swvgen3   smallint NOT NULL,
    swvgen4   smallint NOT NULL,
    swvgen5   smallint NOT NULL,
    swvgen6   smallint NOT NULL,
    lwvgen1   smallint NOT NULL,
    lwvgen2   smallint NOT NULL,
    lwvgen3   smallint NOT NULL,
    lwvgen4   smallint NOT NULL,
    lwvgen5   smallint NOT NULL,
    bbcur     smallint NOT NULL,
    bbvolt    int      NOT NULL
)
LOCK ALLPAGES
go

Object Name	Object Type
dbo.cdiags.cdiags_ucx	INDEX
dbo.cdiags.cdiags_ux	INDEX