dbo.pof_extract

 

Object Type

Table

Datasource

IPMA

Database

icsa

 


Information extracted from the POF relating to ICS used and times uplinked.

Use and Related Data

Linked directly to an observation. From each ICS number you shall be able to access the ICS commands and parameters through the ICS extract data item. Full SQL search capabilities provided.

Population

This information is directly extracted from the POF.
Columns
Name Datatype Null
obsno int No
ics char(12) No
time char(11) No
time_utk int Yes
comment char(50) No


column ics

     ICS name.

column obsno

     Observation number constructed as follows:
 

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


     See SCREW 385 for further details.

column time

     POF time.

column time_utk

     POF time in UTK.
 
 

Table Usage (MB)

Distribution of Table Space

 

Data

49.28

Data

51.20 %

Indexes

45.63

Indexes

47.42 %

Unused

1.33

Unused

1.38 %

Total

96.24

Number of Rows

550923

Dependencies
Referencing Objects
Object Name Object Type
dbo.pof_extract.pof_extract_pk INDEX
dbo.pof_extract.pof_extract_ix1 INDEX
dbo.pof_extract.pof_extract_ix2 INDEX
dbo.pof_extract.pof_extract_ixs INDEX
Referenced Objects
Object Name Object Type

DDL 

CREATE TABLE dbo.pof_extract 
(
    obsno    int      NOT NULL,
    ics      char(12) NOT NULL,
    time     char(11) NOT NULL,
    time_utk int      NULL,
    comment  char(50) NOT NULL
)
LOCK ALLPAGES
go