Object Type	Table
Datasource	IPMA
Database	icsa

This table holds the coordinates for every reference source used by CAM03 (beam switching). Columns of this table are derived directly form the uplink MDB table cam_coords.

Use and RelatedData

See the uplink mdb.ddl file for further details.

Population

This table is populated by the script uplink_data.csh. The script uses bcp dump files produced by the utility programs dump_mdb and dump_isolog.

The script can take one or more of the following arguments:

no args:

This assumes that all tables have been created in the database icsa, and that all temporary tables have been built and populated with the necessary uplink data.

-build:

Forces the building of the ISO Data Archive tables in the icsa database

-build_all:

Forces the building and population of all temporary tables needed.

-compress:

Is used to indicate that the datafiles have been compressed with the UNIX utility 'compress'. The data files will be re-compresses after use.

-nodrop:

Indicates that temporary tables should not be dropped after use.

Columns

Name	Datatype	Null

obsno	int	No

count_index	smallint	No

orgepoch	int	Yes

orgra	float	Yes

orgdec	float	Yes

orgalat	float	Yes

orgalon	float	Yes

ra	float	Yes

dec	float	Yes

column count_index

Index to distinguish between entries.

column dec

Declination in degrees in decimal format precessed to epoch 2000.

column obsno

Observation number constructed as follows:

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

Please see SCREW 385.

column orgalat

Galactic latitude in degrees in decimal form. If the user has entered galactic coordinates (in PGA) these are the values entered by the user. If the user enters equatorial coordinates these are the galactic coordinates calculated from the user entered equatorial coordinates. This is indicated by the compflag.

column orgalon

Galactic longitude in degrees in decimal form. If the user has entered galactic coordinates (in PGA) these are the values entered by the user. If the user enters equatorial coordinates these are the galactic coordinates calculated from the user entered equatorial coordinates. This is indicated by the compflag.

column orgdec

Declination in degrees in decimal form. If the user has entered equatorial coordinates (in PGA) these are the values entered by the user. If the user enters galactic coordinates these are the equatorial coordinates computed from the user entered galactic and precessed to the epoch entered by the user. This is indicated by the compflag field..

column orgepoch

Epoch entered by the user (in PGA). One of

1900, 1950, 2000

column orgra

Right ascension in hours in decimal form. If the user has entered equatorial coordinates (in PGA) these are the values entered by the user. If the user enters galactic coordinates these are the equatorial coordinates computed from the user entered galactic and precessed to the epoch entered by the user. This is indicated by the compflag field. Value entered by the user.

column ra

Right ascension hours in decimal format precessed to epoch 2000.

Table Usage (MB)

Distribution of Table Space

Data	0.04	Data	35.71 %
Indexes	0.02	Indexes	16.07 %
Unused	0.05	Unused	48.21 %
Total	0.11	Number of Rows	490

Dependencies

Referencing Objects

Object Name Object Type

dbo.cam_coords.cam_common_coords_fk INDEX

dbo.cam_coords.cam_coords_pk INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.cam_coords 
(
    obsno       int      NOT NULL,
    count_index smallint NOT NULL,
    orgepoch    int      NULL,
    orgra       float    NULL,
    orgdec      float    NULL,
    orgalat     float    NULL,
    orgalon     float    NULL,
    ra          float    NULL,
    dec         float    NULL
)
LOCK ALLPAGES
go

Object Name	Object Type
dbo.cam_coords.cam_common_coords_fk	INDEX
dbo.cam_coords.cam_coords_pk	INDEX