Object Type	Table
Datasource	IPMA
Database	icsa

Planned details of PHT observations using the following AOTs:
PHT P AOTs: P03, P04, P05, P17, P18, P19
PHT C AOTs: P22, P25, P37, P38, P29
PHT S AOTs: P40

The data attributes of this entity have been directly derived from the uplink MDB table pht_pcs_common.

Use and Related Data

None.

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 icsa 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-compressed after use.

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

Columns

Name Datatype Null

obsno int No

extcomp int Yes

fcs_on int Yes

refflx float Yes

expectpol float Yes

ss_or_sl smallint Yes

line_cont smallint Yes

column expectpol

Expected polarization for P50 and P51.

column extcomp

Extended component p04.

column fcs_on

Calibration source state as follows:
0     Source 1 off
1     Source 1 on
2     Source 2 off
3     source 2 on.

column line_cont

Line or continuum flux flag for P40:
0 Line flux
1 Continuum flux.

column obsno

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

column refflx

Reference flux level for P05 and P25.

column ss_or_sl

Calibration source flag to use as follows:
1     use SS
2     use SL
3     use both SS and SL.

Table Usage (MB)

Distribution of Table Space

Data	0.63	Data	92.05 %
Indexes	0.01	Indexes	0.85 %
Unused	0.05	Unused	7.10 %
Total	0.69	Number of Rows	13893

Dependencies

Referencing Objects

Object Name Object Type

dbo.pht_pcs.pht_pcs_pk INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.pht_pcs 
(
    obsno     int      NOT NULL,
    extcomp   int      NULL,
    fcs_on    int      NULL,
    refflx    float    NULL,
    expectpol float    NULL,
    ss_or_sl  smallint NULL,
    line_cont smallint NULL
)
LOCK ALLPAGES
go

Name	Datatype	Null

obsno	int	No

extcomp	int	Yes

fcs_on	int	Yes

refflx	float	Yes

expectpol	float	Yes

ss_or_sl	smallint	Yes

line_cont	smallint	Yes