Object Type	Table
Datasource	IPMA
Database	icsa

The information in this table is extracted from the ERD and SPD FITS file headers for each observation.

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

trefutk	int	No

trefutc1	int	No

trefutc2	int	No

trefitk	int	No

trefcor1	int	No

trefhel1	float	No

trefdop1	float	No

trefcor2	int	No

trefhel2	float	No

trefdop2	float	No

trefcor3	int	No

trefhel3	float	No

trefdop3	float	No

column obsno

Observation number constructed as follows:

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

Please see SCREW 385 for further information.

column trefcor1
column trefcor2
column trefcor3

The UTC time of the three reference times for which columns trefhel and trefdop have been calculated; usually the start, middle and end of the observation. Units: seconds since 1989.

column trefdop1
column trefdop2
column trefdop3

The velocity component in the line of sight towards the target, due to the combined motions of the spacecraft and of the Earth. Units: km/second.

column trefhel1
column trefhel2
column trefhel3

The interval to be added to all UTC values to convert Earth-received time to the solar system (helio)centre. Units: seconds.

column trefitk

The instrument Time Key value corresponding to column trefutk and trefutc1/2.

column trefutc1

The universal time corresponding with column trefutk, truncated to a whole number of seconds after the beginning of the year 1989.

column trefutc2

The remaining fraction of a second that had been truncated from the preceding UTC value, in units of 10**-7 seconds.

column trefutk

The time of an arbitrary telemetry format during the observation, expressed in terms of the "uniform time key" of ISO data analysis; will be divisible by 48 because it refers to the start of that format.

Table Usage (MB)

Distribution of Table Space

Data	5.79	Data	96.36 %
Indexes	0.05	Indexes	0.78 %
Unused	0.17	Unused	2.86 %
Total	6.01	Number of Rows	67453

Dependencies

Referencing Objects

Object Name Object Type

dbo.tref.tref_ucx INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.tref 
(
    obsno    int   NOT NULL,
    trefutk  int   NOT NULL,
    trefutc1 int   NOT NULL,
    trefutc2 int   NOT NULL,
    trefitk  int   NOT NULL,
    trefcor1 int   NOT NULL,
    trefhel1 float NOT NULL,
    trefdop1 float NOT NULL,
    trefcor2 int   NOT NULL,
    trefhel2 float NOT NULL,
    trefdop2 float NOT NULL,
    trefcor3 int   NOT NULL,
    trefhel3 float NOT NULL,
    trefdop3 float NOT NULL
)
LOCK ALLPAGES
go