Object Type	Table
Datasource	IPMA
Database	icsa

These are the product levels associated with each product type.

Use and RelatedData

Indirectly related to the product catalogue; the first four characters of the filename in the product catalogue represent the product type. This table is used by RP and UI to determine which files should be delivered in a request.

Population

The values for all fields will be taken from the pdl bulk-copy file as generated by Richard Saxton (RDS).
The table is populated by the script pdl.csh. Note that this script populates the following tables: product_level

The script can take one or more of the following arguments:

no args:      This assumes that all IPA tables have been created in the database
     icsa, and that all temporary tables have been built and populated
     with the necessary IPA data.

-build: Forces the building of the IPA-related 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

ptype char(4) No

plevel varchar(14) Yes

column plevel

Product level. One of the following values:
Raw_Data
Fully_Proc
Quick_Look
Basic_Science.

column ptype

Product type (apph, cmap, cmos etc).

Table Usage (MB)

Distribution of Table Space

Data	0.01	Data	37.50 %
Indexes	0.00	Indexes	0.00 %
Unused	0.01	Unused	62.50 %
Total	0.02	Number of Rows	154

Dependencies

Referencing Objects

Object Name Object Type

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.pdl 
(
    ptype  char(4)     NOT NULL,
    plevel varchar(14) NULL
)
LOCK ALLPAGES
go

Name	Datatype	Null

ptype	char(4)	No

plevel	varchar(14)	Yes