Object Type	Table
Datasource	IPMA
Database	icsa

Position information for each 'fixed' pointing observation. Note that the Aperture Shape can either be a 'R'ectangle or a 'C'ircle. Multiple pointing entries can exist for observations (e.g in case of raster maps, beam switching and chopping). These entries are distinguished by the Pointing Identifier (pid) column.

Use and Related Data

See SCREW 357: Population of the PMA Pointing Table.

Population

This table has been populated during BKRP by the OLP Post Processor (PPR).

Columns

Name	Datatype	Null

obsno	int	No

pid	int	No

ra	float	No

dec	float	No

roll	float	No

rpid	int	No

mjd1	float	No

mjd2	float	No

utc1	int	No

utc2	int	No

utk1	int	No

utk2	int	No

aid	char(3)	No

shape	char(1)	No

column aid

Aperture id. Three characters: (i) instrument, (ii) aperture and (iii) aperture modifier. See table aperture id for more information about possible values etc.

column dec

Center point declination. Units: degrees.

column mjd1

Expected start of pointing in Modified Julian Day.

column mjd2

Expected end of pointing in Modified Julian Day.

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 pid

Pointing identifier. To distinguish multiple pointing entries for the same observation (counting fromzero).

column ra

Center point right ascension. Units: hours.

column roll
Center point roll angle. Units: degrees.
column rpid

Raster point identifier ; first two digits corresponding to raster-points along the horizontal axis, second two digits corresponding to raster-points along the vertical axis (will be set to '0101' for standard, non-raster pointings).

column shape

Shape of the aperture used, one of:
C - Circular
R - Rectangular.

column utc1

Expected start of pointing in UTC.

column utc2

Expected end of pointing in UTC.

column utk1

Expected start of pointing in UTK. Calculated from utc1.

column utk2

Expected end of pointing in UTK. Calculated from utc2.

Table Usage (MB)

Distribution of Table Space

Data	131.96	Data	55.39 %
Indexes	99.18	Indexes	41.63 %
Unused	7.09	Unused	2.98 %
Total	238.23	Number of Rows	1386398

Dependencies

Referencing Objects

Object Name Object Type

dbo.pointing.pointing_cx INDEX

dbo.pointing.pointing_ux INDEX

dbo.pointing.pointing_utc1_ix INDEX

dbo.pointing.pointing_utc2_ix INDEX

dbo.pointing.pointing_dec_ix INDEX

dbo.pointing.pointing_ix2 INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.pointing 
(
    obsno int     NOT NULL,
    pid   int     NOT NULL,
    ra    float   NOT NULL,
    dec   float   NOT NULL,
    roll  float   NOT NULL,
    rpid  int     NOT NULL,
    mjd1  float   NOT NULL,
    mjd2  float   NOT NULL,
    utc1  int     NOT NULL,
    utc2  int     NOT NULL,
    utk1  int     NOT NULL,
    utk2  int     NOT NULL,
    aid   char(3) NOT NULL,
    shape char(1) NOT NULL
)
LOCK ALLPAGES
go

Object Name	Object Type
dbo.pointing.pointing_cx	INDEX
dbo.pointing.pointing_ux	INDEX
dbo.pointing.pointing_utc1_ix	INDEX
dbo.pointing.pointing_utc2_ix	INDEX
dbo.pointing.pointing_dec_ix	INDEX
dbo.pointing.pointing_ix2	INDEX