Object Type	Table
Datasource	IPMA
Database	icsa

This table is used to contain information about institutes, relating the instrument identifier to a name.

Use and Related Data

The data attributes for this entity are derived directly from the IPA OAF table. It is linked to the proposals table through the institute_id field.

Population

This table will be populated from a bcp file which is a dump of the IPA oaf
table. A script has been written to populate a temporary oaf table and then
copy the relevant fields across into this table.

Columns

Name	Datatype	Null

institid	char(8)	No

name	char(52)	No

grouping	char(1)	No

column grouping

The grouping flag states whether observations with the same owner but a different proposer may be put onto the same CD during Product Distribution. This flag will by default be `Y', but will be set to `N' manually in some cases.

column institid

Institute identifier.

column name

The name of the institute.

Table Usage (MB)

Distribution of Table Space

Data	0.03	Data	66.67 %
Indexes	0.00	Indexes	0.00 %
Unused	0.02	Unused	33.33 %
Total	0.05	Number of Rows	443

Dependencies

Referencing Objects

Object Name Object Type

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.institutes 
(
    institid char(8)  NOT NULL,
    name     char(52) NOT NULL,
    grouping char(1)  NOT NULL
)
LOCK ALLPAGES
go