TABLE  Programme

Contains details of the WFCAM observation programmes.

This table contains details of the observation programmes undertaken
with WFCAM and for which observations are stored and curated in the WSA.
Names of the tables that store information for each programme are
recorded here.
The unique programme ID number (assigned internally within the WSA)
identifying all WFCAM observation programmes is as follows:
programme ID: description
        0: not a programme: used for calibration/confidence frames common to many programmes
        1: Commissioning data
      101: UKIDSS Large Area Survey (LAS)
      102: UKIDSS Galactic Plane Survey (GPS)
      103: UKIDSS Galactic Clusters Survey (GCS)
      104: UKIDSS Deep Extragalactic Survey (DXS)
      105: UKIDSS Ultra-Deep Survey (UDS)
   1000+: Open Time programmes (PI)
  10000+: Service programmes

Required constraints:
  • Primary key is (programmeID)

NameTypeLengthUnitDescriptionDefault ValueUnified Content Descriptor
programmeIDint4 UID of the archived programme coded as above ID_SURVEY
titlevarchar32 a short title for the programme, eg. "UKIDSS Large Area Survey" NOTE
descriptionvarchar256 a concise description of the programme NOTE
referencevarchar256 a reference for the programme, eg. "http://www.ukidss.org/surveys/surveys.html" REFER_CODE
propPeriodint4monthsthe proprietory period for any data taken for this programme in months, e.g. 12 for open time. TIME_PERIOD
dfsIDStringvarchar64 The description used within the data flow system (ie. the value of the appropriate FITS keyword) ??
catalogueSchemavarchar64 Script file that describes the catalogue schema ??
detectionTablevarchar64 Table name of detections ??
sourceTablevarchar64 Table name of merged sources ??
listRemeasTablevarchar64 Table name of individual passband list re-measurements ??
sourceRemeasTablevarchar64 Table name of co-located list re-measurements ??
mergeLogTablevarchar64 Table name of curation log for source merging ??
frameTablevarchar64 Name of table containing frame metadata ??
detectorTablevarchar64 Name of table containing frame detector metadata ??
frameSetTolerancereal4DegreesThe match tolerance for different passband frames ??
pairingCriterionreal4DegreesThe pairing criterion for associating detections into merged sources ??
detectionObjIDvarchar64 The attribute name(s) of the UID for detections ??
sourceObjIDvarchar64 The attribute name(s) of the UID for merged sources ??
rmOldFrameSetsSQLvarchar64 SQL script name for deprecating old frame sets during source merging ??
adjacentFrameTolerancereal4DegreesThe match tolerance for adjacent frames in the survey ??
neighboursSchemavarchar64 Script file that describes the neighbour tables schema for this programme ??
Total length1396