TABLE  Multiframe

Contains details of all multiframes stored in the archive.


Required constraints:
  • Primary key is (multiframeID)
  • (filterID) references Filter(filterID)
  • (julianDayNum,filterID) references MultiframeSetUp(julianDayNum,filterID)
  • (darkID) references Multiframe(multiframeID)n
  • (confID) references Multiframe(multiframeID)n
  • (flatID) references Multiframe(multiframeID)n
  • (frinID) references Multiframe(multiframeID)n
  • (skyID) references Multiframe(multiframeID)n
  • (maskID) references Multiframe(multiframeID)n

NameTypeLengthUnitDescriptionDefault ValueUnified Content Descriptor
multiframeIDbigint8 UID of the multiframe (assigned sequentially by the archive ingest process) ID_FRAME
ukirtRunNoint4 Original UKIRT run number (from filename) REFER_CODE
utDatedatetime8MM-DD-YYYYObservation date (MM-DD-YYYY) {image primary HDU keyword: UTDATE}12-31-9999TIME_DATE
frameTypevarchar64 The type of multiframe (eg. stack|tile|mosaic|difference|calibration|interleaved etc)normalmeta.code.class
cuEventIDint4 UID of curation event yielding ingest of these data REFER_CODE
julianDayNumint4Julian daysthe Julian Day number of the UKIRT night TIME_DATE
fileTimeStampbigint8 Time stamp digits (from the original CASU directory name and file time stamp) for enforcing uniqueness ??
observervarchar64 Observers names {image primary HDU keyword: OBSERVER}NONEID_HUMAN
useridvarchar64 Userid logged in as {image primary HDU keyword: USERID}NONEID_HUMAN
obsrefvarchar64 PATT or other reference {image primary HDU keyword: OBSREF}NONEREFER_CODE
projectvarchar64 Time-allocation code {image primary HDU keyword: PROJECT}NONEREFER_CODE
surveyvarchar64 Survey description {image primary HDU keyword: SURVEY}NONE??
pointingIDvarchar64 Pointing ID within survey {image primary HDU keyword: SURVEY_I}NONE??
msbIDvarchar64 Id min.-schedulable block {image primary HDU keyword: MSBID}NONEID_NUMBER
objectvarchar64 Object name from telescope {image primary HDU keyword: OBJECT}NONEID_TARGET
numDetectorstinyint1 The number of "detectors" (=image extensions in FITS file) ??
recipevarchar64 Data reduction recipe to be used {image primary HDU keyword: RECIPE}NONEREDUCT_METHOD
obstypevarchar32 Type (BIAS|DARK|ARC|FLAT|OBJECT|SKY) {image primary HDU keyword: OBSTYPE} ??
obsNumint4 Observation number {image primary HDU keyword: OBSNUM}-99999999NUMBER
grpNumint4 Group number applied to all members {image primary HDU keyword: GRPNUM}-99999999NUMBER
grpMemtinyint1 Group membership (0=F, 1=T) {image primary HDU keyword: GRPMEM}0CODE_MEM
tileNumint4 Tile number applied to all members {image primary HDU keyword: TILENUM}-99999999 
standardtinyint1 Is target a standard star observation (0=no, 1=yes)? {image primary HDU keyword: STANDARD} OBS_ID
njittersmallint2 Number of positions in telescope pattern {image primary HDU keyword: NJITTER}-9999NUMBER
jitterIDsmallint2 Serial number in this telescope jitter pattern {image primary HDU keyword: JITTER_I}-9999ID_NUMBER
jitterXreal4arcsecX (RA) offset in tel jitter pattern {image primary HDU keyword: JITTER_X}-0.9999995e9POS_EQ_RA_OFF
jitterYreal4arcsecY (Dec) offset in tel jitter pattern {image primary HDU keyword: JITTER_Y}-0.9999995e9POS_EQ_DEC_OFF
nuStepsmallint2 Number of positions in microstep pattern {image primary HDU keyword: NUSTEP}-9999NUMBER
uStepIDsmallint2 Serial number in this microstep pattern {image primary HDU keyword: USTEP_I}-9999ID_NUMBER
uStepXreal4arcsecX (RA) offset in microstep pattern {image primary HDU keyword: USTEP_X}-0.9999995e9POS_EQ_RA_OFF
uStepYreal4arcsecY (Dec) offset in microstep pattern {image primary HDU keyword: USTEP_Y}-0.9999995e9POS_EQ_DEC_OFF
nFocsmallint2 Number of positions in focus scan {image primary HDU keyword: NFOC}-9999NUMBER
nFocScansmallint2 Number of focus scans in focus test {image primary HDU keyword: NFOCSCAN}-9999NUMBER
dateObsdatetime8 Date and time (UTC) of start of obs {image primary HDU keyword: DATE-OBS}12-31-9999TIME_DATE
dateEnddatetime8 Date and time (UTC) of end of obs {image primary HDU keyword: DATE-END}12-31-9999TIME_DATE
mjdObsfloat8 Modified Julian Date of the observation {image primary HDU keyword: MJD-OBS}-0.9999995e9TIME_DATE
wcsAxestinyint1 Number of axes in world co-ordinate system {image primary HDU keyword: WCSAXES}0??
raDecSysvarchar4 Mean equator of co-ordinates {image primary HDU keyword: RADESYS}NONEVAR_MEAN
equinoxreal4yearsEquinox of object position {image primary HDU keyword: EQUINOX}-0.9999995e9TIME_EQUINOX
raBasefloat8hoursRight ascension of base position {image primary HDU keyword: RABASE} POS_EQ_RA_MAIN
decBasefloat8degreesDeclination of base position {image primary HDU keyword: DECBASE} POS_EQ_DEC_MAIN
raTelOffreal4arcsecRight ascension telescope offset {image primary HDU keyword: TRAOFF}-0.9999995e9POS_EQ_RA_OFF
decTelOffreal4arcsecDeclination telescope offset {image primary HDU keyword: TDECOFF}-0.9999995e9POS_EQ_DEC_OFF
amStartreal4 Airmass at start of observation {image primary HDU keyword: AMSTART}-0.9999995e9PHOT_ATM_AIRMASS
amEndreal4 Airmass at end of observation {image primary HDU keyword: AMEND}-0.9999995e9PHOT_ATM_AIRMASS
telRafloat8hoursCurrent telescope right ascension {image primary HDU keyword: TELRA}-0.9999995e9POS_EQ_RA_MAIN
telDecfloat8degreesCurrent telescope declination {image primary HDU keyword: TELDEC}-0.9999995e9POS_EQ_DEC_MAIN
gsRafloat8hoursRight ascension of guide star {image primary HDU keyword: GSRA}-0.9999995e9POS_EQ_RA_MAIN
gsDecfloat8degreesDeclination of guide star {image primary HDU keyword: GSDEC}-0.9999995e9POS_EQ_DEC_MAIN
expTimereal4secondsIntegration time per exposure {image primary HDU keyword: EXP_TIME}-0.9999995e9TIME_EXPTIME
numExpsmallint2 Number of exposures in integration {image primary HDU keyword: NEXP}-9999NUMBER
readIntervalreal4secondsInterval between reads {image primary HDU keyword: READINT}-0.9999995e9TIME_INTERVAL
numReadssmallint2 Number of reads per exposure {image primary HDU keyword: NREADS}-9999NUMBER
filterNamevarchar8 WFCAM combined filter name {image primary HDU keyword: FILTER} ??
filterIDtinyint1 UID of combined filter (assigned in WSA) INST_FILTER_CODE
focusPosreal4millimetresFocus position {image primary HDU keyword: FOC_MM}-0.9999995e9INST_PARAM
airTempreal4degrees_CelsiusAir temperature {image primary HDU keyword: AIRTEMP}-0.9999995e9PHYS_TEMP_MISC
ambiPressurereal4 Ambient pressure {image primary HDU keyword: BARPRESS}-0.9999995e9PHYS_PRESS_GAS
dewPointreal4degrees_CelsiusDewpoint {image primary HDU keyword: DEWPOINT}-0.9999995e9PHYS_TEMP_MISC
domeTempreal4degrees_CelsiusDome temperature {image primary HDU keyword: DOMETEMP}-0.9999995e9PHYS_TEMP_MISC
humidityreal4 Relative Humidity {image primary HDU keyword: HUMIDITY}-0.9999995e9OBS_CONDITIONS
mirrTempBSWreal4degrees_CelsiusMirror temperature B SW {image primary HDU keyword: MIRRBSW}-0.9999995e9PHYS_TEMP_MISC
mirrTempNEreal4degrees_CelsiusMirror temperature NE {image primary HDU keyword: MIRRNE}-0.9999995e9PHYS_TEMP_MISC
mirrTempNWreal4degrees_CelsiusMirror temperature NW {image primary HDU keyword: MIRRNW}-0.9999995e9PHYS_TEMP_MISC
mirrTempSEreal4degrees_CelsiusMirror temperature SE {image primary HDU keyword: MIRRSE}-0.9999995e9PHYS_TEMP_MISC
mirrTempSWreal4degrees_CelsiusMirror temperature SW {image primary HDU keyword: MIRRSW}-0.9999995e9PHYS_TEMP_MISC
mirrBottTempNWreal4degrees_CelsiusMirror bottom temp. NW {image primary HDU keyword: MIRRBTNW}-0.9999995e9PHYS_TEMP_MISC
mirrTopTempNWreal4degrees_CelsiusMirror top temp. NW {image primary HDU keyword: MIRRTPNW}-0.9999995e9PHYS_TEMP_MISC
secondaryTempreal4degrees_CelsiusTemperature of secondary {image primary HDU keyword: SECONDAR}-0.9999995e9PHYS_TEMP_MISC
topAirTempNWreal4degrees_CelsiusTop air NW {image primary HDU keyword: TOPAIRNW}-0.9999995e9PHYS_TEMP_MISC
trussTempENEreal4degrees_CelsiusTruss leg ENE {image primary HDU keyword: TRUSSENE}-0.9999995e9PHYS_TEMP_MISC
trussTempWSWreal4degrees_CelsiusTruss leg WSW {image primary HDU keyword: TRUSSWSW}-0.9999995e9PHYS_TEMP_MISC
windDirectionreal4degWind direction, azimuth {image primary HDU keyword: WIND_DIR}-0.9999995e9OBS_CONDITIONS
windSpeedreal4km/hWind speed {image primary HDU keyword: WIND_SPD}-0.9999995e9VELOC_WIND
tauCSOreal4 Tau at 225 GHz from CSO {image primary HDU keyword: CSOTAU}-0.9999995e9PHYS_OPTICAL-DEPTH
tauDatedatetime8MM-DD-YYYYTime and date opf Tau reading {image primary HDU keyword: TAUDATE}12-31-9999TIME_DATE
tauSourcevarchar64 Source of opacity data {image primary HDU keyword: TAUSRC}NONEDATA_LINK
configIndexint4 Configuration index {image primary HDU keyword: CNFINDEX}-99999999SPECT_INDEX_MISC
fileNamevarchar256 the filename for the multiframe, eg. server:/path/filename.fit ID_FILE
catNamevarchar256 the filename of the associated catalogue MEF, eg. server:/path/filename.fits ID_CATALOG
versionNumreal4 a version number for this frame (if available)-0.9999995e9VERSNUM
darkIDbigint8 UID of library calibration dark frame {image extension keyword: DARKCOR}-99999999ID_FRAME
confIDbigint8 UID of library calibration confidence frame {image extension keyword: CIR_CPM}-99999999ID_FRAME
flatIDbigint8 UID of library calibration flatfield frame {image extension keyword: FLATCOR}-99999999ID_FRAME
frinIDbigint8 UID of library calibration fringe frame-99999999ID_FRAME
skyIDbigint8 UID of library calibration sky sub frame {image extension keyword: SKYSUB}-99999999ID_FRAME
maskIDbigint8 UID of library object mask frame {image extension keyword: CIR_OPM}-99999999ID_FRAME
deprecatedtinyint1 Is the frame superseded by reprocessing (0=no, 1=yes)?0??
newlyIngestedtinyint1 Curation flag for internal use only (0=no, 1=yes)1??
Total length1591