Object Type	Table
Datasource	IPMA
Database	icsa

The columns of this table have been derived directly from the sglrate table of the IPA.

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

ott	int	No

detector	smallint	No

glitchrate	int	No

nresets_g	int	No

glitch_med	real	No

glitch_stdev	real	No

column detector

Detecor number.

column glitch_med

Median value of glitch height.

column glitch_stdev

Standard deviation of glitch height.

column glitchrate

Number of glitches during the observation.

column nresets_g

Number of resets affected by glitches.

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 ott

Lengthh of observation (On-Target Time (OTT)). Units: seconds.

Table Usage (MB)

Distribution of Table Space

Data	32.19	Data	99.02 %
Indexes	0.25	Indexes	0.76 %
Unused	0.07	Unused	0.22 %
Total	32.51	Number of Rows	1098888

Dependencies

Referencing Objects

Object Name Object Type

dbo.sglrate.sglrate_ucx INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.sglrate 
(
    obsno        int      NOT NULL,
    ott          int      NOT NULL,
    detector     smallint NOT NULL,
    glitchrate   int      NOT NULL,
    nresets_g    int      NOT NULL,
    glitch_med   real     NOT NULL,
    glitch_stdev real     NOT NULL
)
LOCK ALLPAGES
go