Object Type	Table
Datasource	IPMA
Database	icsa

Table to hold the names of co-investigators for a proposal. This information can be taken from the uplink MDB prp_cinv set.

Use and Related Data

Linked directly to the proposal entity in a many to one relationship.

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 ISO Data Archive 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

obsid char(8) No

propid char(8) No

name char(52) No

column name

Co-investigator name entered (in PGA) by the user for a given proposal.

column obsid

Observer identifier. Proposal Handling (PH) assigned identifier containing between one and eight characters (upper case, alpha-numeric or underscore; spaces are not allowed).

column propid

Proposal identifier assigned by Proposal Handling (PH). This is a user provided identifier of between one and eight characters (alpha-numeric or underscore, spaces not allowed). Note that the two character launch window extension:

' S' - for the Spring window

' A' - for the Autumn window

present in the uplink MDB has been dropped.

Table Usage (MB)

Distribution of Table Space

Data	0.11	Data	42.22 %
Indexes	0.13	Indexes	47.41 %
Unused	0.03	Unused	10.37 %
Total	0.26	Number of Rows	1555

Dependencies

Referencing Objects

Object Name Object Type

dbo.co_investigators.co_investigators_pk INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.co_investigators 
(
    obsid  char(8)  NOT NULL,
    propid char(8)  NOT NULL,
    name   char(52) NOT NULL
)
LOCK ALLPAGES
go

Name	Datatype	Null

obsid	char(8)	No

propid	char(8)	No

name	char(52)	No

Object Name	Object Type
dbo.co_investigators.co_investigators_pk	INDEX