dbo.lerd_hdr

 

Object Type

Table

Datasource

IPMA

Database

icsa

 


Most of the information in this table is extracted from the LWS LIER ERD FITS file headers for each observation, except for CUS (L99) observations the information is extracted from the LWS LXER ERD FITS file headers instead. 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

TBD. This table will be populated using the User Definable Function (UDF) functionality of the ISO Data Archive.
Columns
Name Datatype Null
obsno int No
equinox float No
aotvers char(8) No
tmrate int No
attotfth float No
attrorie int No
attguide int No
attsaang float No
atterror int No
atthighp bit No
column aotvers

column atterror

column attguide

column atthighp

column attotfth

column attrorie

column attsaang

column equinox

column obsno

column tmrate
 
 

Table Usage (MB)

Distribution of Table Space

 

Data

0.00

Data

12.50 %

Indexes

0.00

Indexes

0.00 %

Unused

0.01

Unused

87.50 %

Total

0.02

Number of Rows

0

Dependencies
Referencing Objects
Object Name Object Type
Referenced Objects
Object Name Object Type

DDL

CREATE TABLE dbo.lerd_hdr 
(
    obsno    int     NOT NULL,
    equinox  float   NOT NULL,
    aotvers  char(8) NOT NULL,
    tmrate   int     NOT NULL,
    attotfth float   NOT NULL,
    attrorie int     NOT NULL,
    attguide int     NOT NULL,
    attsaang float   NOT NULL,
    atterror int     NOT NULL,
    atthighp bit     NOT NULL
)
LOCK ALLPAGES
go