DBPREP Output File Specification and Description (19 Nov 2009) [arc05 WSDC D-I142 version 3.2] Interface Name: Level 1b Calibration Scan Metadata Table Archive DB Interface Specification Type of Interface: program I/O Written By: DBPREP _________________________ T. L. Evans Read By: Database load utility Description: Version 3.2 of DBPREP (dated 11-20-2009) The output level 1b calibration scan metadata table includes concatenated data for all scans included in the DBPREP run. The table name follows the WISE/IRSA DB table naming convention and is determined by the input parameters 'out_dir' and 'out_base', the access type ('i' for internal), data type ('c_scn'), data level ('1b'), DB table version number, load ID number, output format (bar-delimited or IPAC table), and the scan ID string. For example: /wise_i1bc_scn_4_1.tbl.30477a /wise_i1bc_scn_4_1.bartbl.83752a The data dictionary defining the IPAC table format and the database table structure is below. \ Default Data Dictionary \ \ Date: 11-12-2009 \ \ \fixlen = T \alias = none \longitude = ra \latitude = dec \primary = cntr \spt_ind = spt_ind \x = x \y = y \z = z |cntr| name | original_name | description | units | intype | format | dbtype |nulls|tableflg|groupid|irsadef| sel |indx| notes | | i | c | c | c | c | c | c | c | c | i | i | c | c | c | c | 1 scan_id scan_id scan ID c 6s character(6) n 2 1 y y y 2 pcalvrs pcalvrs PCAL version number r 5.2f decimal(4,2) n 2 2 y y n 3 zptype zptype zero point type to use (PSF or AP) c 3s character(3) y 2 3 y y n 20 zpmethod zpmethod method used for computing final zero point offsets c 20s character(20) y 2 20 y y n 21 t2mcut t2mcut threshold on # srcs for switching from median method to trimmed average method i 4d integer y 2 21 y y n 22 sigmult sigmult sigma multiple for outlier threshold in trimmed average method i 4d integer y 2 22 y y n 4 w1pzp w1pzp PSF mag calibration zero point - band 1 mag r 8.4f decimal(6,4) y 2 4 y y n 5 w2pzp w2pzp PSF mag calibration zero point - band 2 mag r 8.4f decimal(6,4) y 2 5 y y n 6 w3pzp w3pzp PSF mag calibration zero point - band 3 mag r 8.4f decimal(6,4) y 2 6 y y n 7 w4pzp w4pzp PSF mag calibration zero point - band 4 mag r 8.4f decimal(6,4) y 2 7 y y n 8 w1azp w1azp aperture mag calibration zero point - band 1 mag r 8.4f decimal(6,4) y 2 8 y y n 9 w2azp w2azp aperture mag calibration zero point - band 2 mag r 8.4f decimal(6,4) y 2 9 y y n 10 w3azp w3azp aperture mag calibration zero point - band 3 mag r 8.4f decimal(6,4) y 2 10 y y n 11 w4azp w4azp aperture mag calibration zero point - band 4 mag r 8.4f decimal(6,4) y 2 11 y y n 12 w1pzpsig w1pzpsig PSF mag calibration zero point error - band 1 mag r 8.4f decimal(6,4) y 2 12 y y n 13 w2pzpsig w2pzpsig PSF mag calibration zero point error - band 2 mag r 8.4f decimal(6,4) y 2 13 y y n 14 w3pzpsig w3pzpsig PSF mag calibration zero point error - band 3 mag r 8.4f decimal(6,4) y 2 14 y y n 15 w4pzpsig w4pzpsig PSF mag calibration zero point error - band 4 mag r 8.4f decimal(6,4) y 2 15 y y n 16 w1azpsig w1azpsig aperture mag calibration zero point error - band 1 mag r 8.4f decimal(6,4) y 2 16 y y n 17 w2azpsig w2azpsig aperture mag calibration zero point error - band 2 mag r 8.4f decimal(6,4) y 2 17 y y n 18 w3azpsig w3azpsig aperture mag calibration zero point error - band 3 mag r 8.4f decimal(6,4) y 2 18 y y n 19 w4azpsig w4azpsig aperture mag calibration zero point error - band 4 mag r 8.4f decimal(6,4) y 2 19 y y n 23 w1phcn w1phcn PSF ZP flag, band 1 (#=# srcs contributing, h=historic, d=default used) c 4s character(4) y 2 23 y y n 24 w2phcn w2phcn PSF ZP flag, band 2 (#=# srcs contributing, h=historic, d=default used) c 4s character(4) y 2 24 y y n 25 w3phcn w3phcn PSF ZP flag, band 3 (#=# srcs contributing, h=historic, d=default used) c 4s character(4) y 2 25 y y n 26 w4phcn w4phcn PSF ZP flag, band 4 (#=# srcs contributing, h=historic, d=default used) c 4s character(4) y 2 26 y y n 27 w1ahcn w1ahcn aperture ZP flag, band 1 (#=# srcs contributing, h=historic, d=default used) c 4s character(4) y 2 27 y y n 28 w2ahcn w2ahcn aperture ZP flag, band 2 (#=# srcs contributing, h=historic, d=default used) c 4s character(4) y 2 28 y y n 29 w3ahcn w3ahcn aperture ZP flag, band 3 (#=# srcs contributing, h=historic, d=default used) c 4s character(4) y 2 29 y y n 30 w4ahcn w4ahcn aperture ZP flag, band 4 (#=# srcs contributing, h=historic, d=default used) c 4s character(4) y 2 30 y y n 31 w1potlr w1potlr number of outliers in PSF avg/median calculation, band 1 i 4d integer y 2 31 y y n 32 w2potlr w2potlr number of outliers in PSF avg/median calculation, band 2 i 4d integer y 2 32 y y n 33 w3potlr w3potlr number of outliers in PSF avg/median calculation, band 3 i 4d integer y 2 33 y y n 34 w4potlr w4potlr number of outliers in PSF avg/median calculation, band 4 i 4d integer y 2 34 y y n 35 w1aotlr w1aotlr number of outliers in aperture avg/median calculation, band 1 i 4d integer y 2 35 y y n 36 w2aotlr w2aotlr number of outliers in aperture avg/median calculation, band 2 i 4d integer y 2 36 y y n 37 w3aotlr w3aotlr number of outliers in aperture avg/median calculation, band 3 i 4d integer y 2 37 y y n 38 w4aotlr w4aotlr number of outliers in aperture avg/median calculation, band 4 i 4d integer y 2 38 y y n 39 load_id load_id unique load ID number i 4d integer n 2 39 n n n 40 cntr cntr unique entry counter (key) number i 9d serial8 n 2 40 n n y