Object Type	Table
Datasource	IPMA
Database	icsa

These are the values taken from the instrument station report.

Use and Related Data

Related to an observation. The events of the Instrument Station Report information are stored within the ISR Events entity.

Population

The ISR report values have been taken directly from the instrument station reports, which are flat ASCII files.

Columns

Name	Datatype	Null

obsno	int	No

noosl	int	Yes

noohl	int	Yes

nmw	int	Yes

ncvw	int	Yes

nbtw	int	Yes

nmvw	int	Yes

nsqla	int	Yes

rsev	int	Yes

qsev	int	Yes

obt	int	Yes

rwarn	char(8)	Yes

column nbtw

Number of bad telemetry errors.

column ncvw

Number of command verification errors.

column nmvw

Number of memory verification errors.

column nmw

Number of monitor warnings.

column noohl

Number of out-of-hard-limit errors.

column noosl

Number of out-of-soft-limit errors.

column nsqla

Number of severe QLA errors.

column obsno

Observation number constructed as follows:

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

Please see SCREW 385.

column obt

s/c clock at the start of the observation.

column qsev

QLA maximum severity level = WA.

column rsev

RTA maximum severity level = WA.

column rwarn

RA-warning flag from IS user.

Table Usage (MB)

Distribution of Table Space

Data	3.99	Data	99.80 %
Indexes	0.00	Indexes	0.00 %
Unused	0.01	Unused	0.20 %
Total	4.00	Number of Rows	63324

Dependencies

Referencing Objects

Object Name Object Type

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.isreports 
(
    obsno int     NOT NULL,
    noosl int     NULL,
    noohl int     NULL,
    nmw   int     NULL,
    ncvw  int     NULL,
    nbtw  int     NULL,
    nmvw  int     NULL,
    nsqla int     NULL,
    rsev  int     NULL,
    qsev  int     NULL,
    obt   int     NULL,
    rwarn char(8) NULL
)
LOCK ALLPAGES
go