Object Type	Table
Datasource	IPMA
Database	icsa

A table containing consolidated information about ISO proposals. The proposal table in IDA contains many errors due to the fact that there was no homogenization done. This is the consolidated data, and is placed in a separate table so that the user-entered data is still available (in the proposals table). These are known as meta-proposals (or programmes).

See SPR 3007 for further information.

Use and Related Data

See proposals table and SPR 3007.

Population

Data provided byT.Prusti:
http://isowww.vilspa.esa.es:1909/popsact/recvd/tprusti/edited.txt

Columns

Name	Datatype	Null

progid	char(8)	No

obsid	char(8)	No

propid	char(8)	No

title	char(132)	No

pi	char(24)	No

country	char(16)	No

time	int	No

science_cat	int	Yes

column progid

The programme ID. A 'programme' is a type of meta-proposal - a programme can consist of many proposals.

column obsid

The observer ID. See observers table.

column propid

The proposal ID. See proposals table

column title

The title of the programme.

column pi

The name of the prime investigator.

column country

The country of the prime investigator.

column time

Specifies whether the observations in the proposals contained in the meta-proposal (or programme) are 'open' or 'gauranteed'. The following values are used:
1 - Gauranteed time
5 - Open time

Table Usage (MB)

Distribution of Table Space

Data	0.44	Data	70.22 %
Indexes	0.09	Indexes	15.05 %
Unused	0.09	Unused	14.73 %
Total	0.62	Number of Rows	2014

Dependencies

Referencing Objects

Object Name Object Type

dbo.metaprop.metaprop_ux INDEX

dbo.metaprop.metaprop_ix INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.metaprop 
(
    progid      char(8)   NOT NULL,
    obsid       char(8)   NOT NULL,
    propid      char(8)   NOT NULL,
    title       char(132) NOT NULL,
    pi          char(24)  NOT NULL,
    country     char(16)  NOT NULL,
    time        int       NOT NULL,
    science_cat int       NULL
)
LOCK ALLPAGES
go

Object Name	Object Type
dbo.metaprop.metaprop_ux	INDEX
dbo.metaprop.metaprop_ix	INDEX