TABLE  PreviousZP

Contains previous zeropoint coefficients of the photometric calibration.

This table contains, for every combination of detector/filter,
previous zeropoint coefficients of the photometric calibration

Required constraints:
  • Primary key is (filterID,deviceID,versNum)
  • (versNum) references PhotCalVers(versNum)

NameTypeLengthUnitDescriptionDefault ValueUnified Content Descriptor
filterIDtinyint1 the internal WSA filter UID INST_FILTER_CODE
deviceIDtinyint1 the device UID ID_PLATE
cuEventIDint4 UID of curation event giving rise to this record REFER_CODE
versNumint4 the version number of the calibration ID_VERSION
zp0float8 the zeroth-order zeropoint coefficient PHOT_ZP
izp0tinyint1 Is zp0 FIXED or FITTED1 
zp1float8 the first-order zeropoint coefficient wrt time during night PHOT_ZP
izp1tinyint1 Is zp1 FIXED or FITTED1 
zp2float8 the second-order zeropoint coefficient wrt time during night PHOT_ZP
izp2tinyint1 Is zp2 FIXED or FITTED1 
zp3float8 the first-order zeropoint coefficient wrt time across nights (long-term decay of detector) PHOT_ZP
izp3tinyint1 Is zp3 FIXED or FITTED1 
zp4float8 the second-order zeropoint coefficient wrt time across nights (long-term decay of detector) PHOT_ZP
izp4tinyint1 Is zp4 FIXED or FITTED1 
Total length55