Object Type	Table
Datasource	IPMA
Database	icsa

Some PHT AOTs may use or require the chopper. This table holds the information needed to use the PHT chopper. The data attributes of this table are derived directly from the uplink MDB chop table.

Use and RelatedData

None.

Population

This table is populated by the script uplink_data.csh, together with other tables derived from uplink.

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 icsa, and that all temporary
tables have been built and populated with the necessary uplink data.

-build: Forces the building of the IDA 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 the UNIX utility 'compress'.
The data files will be re-compressed after use.

-nodrop: Indicates that temporary tables should not be dropped after use.

Columns

Name	Datatype	Null

obsno	int	No

chopmode	tinyint	No

chopthrow	int	Yes

avoidflg	tinyint	No

avoid1	int	Yes

avoid2	int	Yes

column avoid1

Avoidance region, defined as the sector between avoid1 and avoid2 for chopper mode rectangular, and the defined sector plus the opposite one for the other modes. The angles range from 0 to 360 counted North, East, South and West.

column avoid2

Avoidance region (see avoid1).

column avoidflg

TRUE if there is an avoidance region, FALSE otherwise.

column chopmode

PHOT chopper mode. This can take the following values:
0     chop staring: no chopper
1     chop rectangular: chop on source and one background
2     chop sawtooth: chop back1, source, back2, source, back1...
3     chop triangular: chop back1, source, back2, back1, ...

column chopthrow

Chopper throw. Units: arc seconds.

column obsno

Observation number constructed as follows:
revolution number * 1000000 + target number * 1000 + observation sequence number * 10 + type.
Please see SCREW 385.

Table Usage (MB)

Distribution of Table Space

Data	0.13	Data	61.61 %
Indexes	0.05	Indexes	24.11 %
Unused	0.03	Unused	14.29 %
Total	0.22	Number of Rows	4624

Dependencies

Referencing Objects

Object Name Object Type

dbo.pht_chopper.pht_chopper_pk INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.pht_chopper 
(
    obsno     int     NOT NULL,
    chopmode  tinyint NOT NULL,
    chopthrow int     NULL,
    avoidflg  tinyint NOT NULL,
    avoid1    int     NULL,
    avoid2    int     NULL
)
LOCK ALLPAGES
go

Object Name	Object Type
dbo.pht_chopper.pht_chopper_pk	INDEX