SIDARCHIVE Field Descriptions

You may submit queries using any of the fields listed below. The "Column label" is the name displayed on the search forms and in search results. The "Column name" is the actual column name in the table and needs to be specified in GET requests. (See the MAST Services web page for information on submitting GET requests.) If the "Column name" is in italics, it means the table is indexed on that field and queries with that field will run faster. Clicking on "Data Type" entries will display information on search options.

When using the "user-specified field" form element on a MAST search form, simply select the column "label" in the forms pulldown menu and type in the qualification in the adjacent box. If you specify constraints on the same column in more than one form element, they will all be included in the query and you may not get results you expect. Note the entries in the table below may be sorted by clicking on the column headings.

Catalog Description of the Scientific Instrument and Integration Testing (SID) Table
Last Update: December 13, 2010

Column Name	Column Label	Description	Examples/Valid Values	Data Type
Column Name	Column Label	Description	Examples/Valid Values	Data Type
pki_submission_type	Retrieval Type	Submission type; either 'Package' indicating data was delivered as a tar file containing files of various formats, or 'File' implying data was delivered as individual FITS files.	File, Package	string
afi_data_set_name	Data Set Name	Root name of the observation set (note several files may have same root name)	FGSFITSTEST003071	string
afi_file_name	File Name	Full File Name	ingest-test-1_0-f.tar	string
pki_test_title	Test Name	Title of test as specified in the test plan	VM2T00003812	string
pki_test_number	Test Number	Number of test (stored as a string) as specified in test plan	FGS#1, NIRCAM#1	string
fii_targname	Target Name	Target name initially populated by FITSWriter but the tester is responsible for updating value (not defined for packages)	NIR_LAMP, OSIM, UNKNOWN, (null values also allowed)	string
fii_instrument	Instrument	Identifier for instrument used to acquire data	NIRCAM, TF1	string
fii_detector	Detector	Detector (not defined for packages)	TF1, NRCA1, NRS1	string
fii_datamode	Data Mode	Reference number used to specify ground data processing requirements for this data	1, 31, 25, 79	string
pki_area	Area	Facility where test is being conducted	TestArea	string
pki_phase	Phase	Ambient, Cyro, etc.	TestPhase	string
pki_test_description	Test Description	Short description of purpose and content of test. Note if a data package needs to be subdivided, the parameters will all be the same except for the description.	Test Description	string
pki_organization	Organization	Organization conducting test	The FBI, Test Org	string
pki_responsible_engineer	Engineer	Point of contact for test	Richie Kay	string
fii_obs_id	Obs ID	Observation ID from the science data package image header (not defined for packages)	V12348001001P0000000000000	string
fii_exptime	Exposure time	Exposure duration of observation (only defined for FITS files entries)	current range: 0.00128 to 1677.7216 or null	float
pki_start_time	Start Time	Start date and time of test	Mar 2 2009 11:11:00:000PM current range: 2008-09-17 to 2009-12-04	datetime
pki_end_time	Stop Time	Date and time of end of test	Mar 2 2009 11:11:00:000PM current range: 2008-09-17 to 2009-12-04	datetime
afi_generation_date	Generation Date	Date file was ingested	May 7 2009 07:02:16:000PM current range: 2009-06-17 to 2010-02-04	datetime
fii_date	Date	Date and time of I&T calibration/activity	May 1 2009 07:29:39:000PM current range: 2008-09-17 to 2009-05-05	datetime
fii_rootname	FITS rootname	rootname for FITS files (may be identical to root name)	FGSFITSTEST003071	string
ads_release_date	Release Date	Date on which data becomes public	2009-12-16 15:05:40 current range: 2009-12-25 to 2038-01-01	datetime