TABLE  TiledTargetAll

Keep track of why a Target was assigned to a Tile

This table is designed to be searched both ways - one can find the Targets assigned to a Tile or one can find all the Tiles a Target has been assigned to (objects can be assigned to more than one tile if they are QA objects). Information comes from plPlugMapP files, but only OBJECT hole info is stored. HoleObj can be used to find other holetypes that made it to a Plate.

tilesmallint2 ID_PLATEtile number
targetIDbigint8 ID_CATALOGID of Target
rafloat8degPOS_EQ_RAright ascension
htmIDbigint8 CODE_HTMhtm tree info
cxfloat8 POS_EQ_CART_Xx projection of vector on unit sphere
cyfloat8 POS_EQ_CART_Yy projection of vector on unit sphere
czfloat8 POS_EQ_CART_Zz projection of vector on unit sphere
objTypeLink to ObjTypeint4 CLASS_OBJECTplPlugMap style objType (only OBJECT holes)
duplicatetinyint1 CODE_MISCduplicate spectrum by mistake
untiledtinyint1 CODE_MISC1: this tile later untiled, 0: otherwise
loadVersionint4 ID_VERSIONLoad Version