Object Type	Table
Datasource	IPMA
Database	icsa

The information contained in this table is taken directly from the IPA csource table in the IPA database.

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

utk	int	No

obsno	int	No

nsrc	int	No

ra	numeric(13,9)	No

dec	numeric(13,9)	No

y	real	No

z	real	No

fluxj	real	No

fluxa	real	No

waveleng	real	No

stat	real	Yes

readouts	int	Yes

prime	char(1)	Yes

parallel	char(1)	Yes

column dec

Declination (celestial position of source). Units: decimal degrees.

column fluxa

Source fluxs. Units: ADUs.

column fluxj

Source flux. Units: jansky.

column nsrc

Source number.

column obsno

Observation number constructed as follows:

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

Please see SCREW 385.

column ra

Right ascension (celestial position of source). Units: decimal degrees.

column utk

UTK time.

column waveleng

Wavelength.

column y

Y position. Units: pixels ( range zero to 32).

column z

Z position. Units: pixels (range zero to 32).

Table Usage (MB)

Distribution of Table Space

Data	14.70	Data	85.16 %
Indexes	2.45	Indexes	14.21 %
Unused	0.11	Unused	0.63 %
Total	17.27	Number of Rows	218270

Dependencies

Referencing Objects

Object Name Object Type

dbo.csource.csource_ucx INDEX

dbo.csource.csource_ix INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.csource 
(
    utk      int           NOT NULL,
    obsno    int           NOT NULL,
    nsrc     int           NOT NULL,
    ra       numeric(13,9) NOT NULL,
    dec      numeric(13,9) NOT NULL,
    y        real          NOT NULL,
    z        real          NOT NULL,
    fluxj    real          NOT NULL,
    fluxa    real          NOT NULL,
    waveleng real          NOT NULL,
    stat     real          NULL,
    readouts int           NULL,
    prime    char(1)       NULL,
    parallel char(1)       NULL
)
LOCK ALLPAGES
go

Object Name	Object Type
dbo.csource.csource_ucx	INDEX
dbo.csource.csource_ix	INDEX