This is Heather's page to track PSPS verification.

== Table Verifications ==

The following tables are listed in the PSPS ODM. Legend of colors:

 * black = all is well
 * [[span(style=color: #FF0000, red)]] = completely unpopulated table
 * [[span(style=background: yellow, table has some unpopulated columns)]]

Ideally we want to fix the [[span(style=color: #FF0000, red)]] and [[span(style=background: yellow, bumblebee)]] colored items.

 * Fundamental IPP Data Products
   * [[span(style=background: yellow,Detection)]] -- only a few unfilled columns: activeFlag, historyModNum
   * !DetectionCalib - this looks lovely, all filled
   * !DetectionFull - this looks lovely, all filled
   * [[span(style=color: #FF0000,!DetectionOrphan)]]
   * [[span(style=background: yellow, Object )]] some unfilled columns: projectionCellID, stackVer, objInfoFlag, updated = -999 varFlag = 0, consistencyFlag = 0 when no detections, and -999 otherwise. 
   * [[span(style=background: yellow,!ObjectCalColor)]] some unfilled columns: calColor, calColorErr, calibModNum
   * [[span(style=background: yellow,!StackApFlx)]] piles of unfilled columns: primaryF = 0, isophotmag, isophotmagerr, isophotmajaxis, isophotmagaxiserr, .. Heather gave up recording them... 
   * [[span(style=color: #FF0000,StackB2DFit)]]
   * [[span(style=background: yellow,!!StackDetection)]] a few unfilled columns: primaryF, activeFlag, historymodnum = 0 apmagerr, kronraderr = -999
   * !StackDetectionCalib -- looks fine
   * [[span(style=background: yellow,!StackDetectionFull)]] a few unfilled columns: primarF, activeflag,historymodnum =0, apmagerr, kronraderr =-999
   * [[span(style=background: yellow,!StackModelFit)]] - lots of unfilled columns: primaryF , devcovar[12,13,14,15,16,17], expcovar[12,13,14,15,16,17], activeflag= 0 deVradiusErr,deVAbErr, deVPhiErr, raDeVoff, decDevoff, radevofferr, decdevofferr, devcf, devlikelihood, expRadiusErr,expAbErr, expPhiErr,raexpoff, decexpoff, raexpofferr, decexpofferr,expcf,explikelihood, serradiuserr,seraberr,serphierr, raseroff,decseroff,raserofferr,decserofferr,sercf,serlikelihood,  = -999
   * [[span(style=color: #FF0000,!StackOrphan)]] - currently unpopulated
 * Derived Data Products
   * [[span(style=color: #FF0000,PPM)]] -currently unpopulated
   * [[span(style=color: #FF0000,Photoz)]] - currently unpopulated
 * Observational Metadata and Supporting System Metadata tables
   * [[span(style=background: yellow,!CameraConfig)]] -- doubt ConfigDetails is accurate at all... this looks just like it was testing only
   * !DetectionFlags -- looks fine 
   * Filter -- [[span(style=background: yellow,we need to add w to this)]]
   * [[span(style=color: #FF0000, !FitModel)]]
   * !FrameMeta --looks fine
   * !ImageFlags - looks fine- why can't we have this for all the flags?
   * [[span(style=background: yellow,!ImageMeta)]] --magSat and completeMag are 0 , psfModelID is -999, qaFlags, crval1,crval2, calibModNum are 0
   * !PhotoCal -- looks fine except  [[span(style=background: yellow,missing w stuff (how does that get updated?))]]
   * !PhotozRecipe -looks fine
   * [[span(style=background: yellow,!StackMeta)]] unfilled: magSat, analVer,completMag, astroScat, photoScat, nAstroRef,nPhoRef,photoColor, calibModNum 
   * !StackToImage - no problems here!
   * Survey - no problems here!
 * Object-Detection Modifications History
   * [[span(style=color: #FF0000,!ObjectModHistory)]]  - currently unpopulated
 * Internal Tables
   * [[span(style=color: #FF0000,!PsConstant)]]  - currently unpopulated
 * Difference Image Detection
   * [[span(style=color: #FF0000,!StackDeltaAltFit)]]  - currently unpopulated
   * [[span(style=color: #FF0000, !StackHighSigDelta)]] - currently unpopulated