This is information for ippToPsps for ingesting the PV2 version of the 3pi database. Substantial changes have been made.

Batch types

There are now 8 types of batches, currently based off of SchemaNew16.0.tar - there are only minor corrections of typos / datatypes / addition of gcobjID

2 digit	type	schema
IN	init batch	ippToPspsPV2_IN
P2	single detections	ippToPspsPV2_P2
ST	stack	ippToPspsPV2_ST
OB	object	ippToPspsPV2_OB
FW	forced warp measurement	ippToPspsPV2_FW
FO	forced object	ippToPspsPV2_FO
DF	diff detection	ippToPspsPV2_DF
DO	diff object	ippToPspsPV2_DO

Schema Manipulation

There are multiple versions / types of the schema

• (schemaNewXX.0.tar ) - These are not complete ( the filters are not expanded), there is extra text, units/datatypes may not be consistent. This is what Heather works from when editing the VO Tables. The column names and orders are definitely correct, use caution with definitions/datatypes/etc.

• VO Tables - What ipptopsps uses - Heather has edited them to contain all the new types of batches, edited the descriptions to make them more accurate, this is the definitive list of everything.

• wiki /csv file - generated from a parsing script using VO Tables as input. These are what conrad/thomas work from