DBPREP Output File Specification and Description (19 Nov 2009) [arc03 WSDC D-I140 version 3.2] Interface Name: Level 1b Calibration Match Data 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 match data table includes concatenated data for all frames 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_mch'), 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_mch_4_1.tbl.48823b /wise_i1bc_mch_4_1.bartbl.39582a The data dictionary defining the IPAC table format and the database table structure is below. \ Default Data Dictionary \ \ Date: 11-11-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 srcname srcname WISE unique source ID (scan ID, frame num, and source number) c 16s character(16) y 2 1 y y y 2 ra ra WISE right ascension (J2000) r 11.7f decimal(10,7) y 2 2 y y n 3 dec dec WISE declination (J2000) r 11.7f decimal(9,7) y 2 3 y y y 4 calname calname calibrator name c 17s character(17) y 2 4 y y y 5 ps ps primary or secondary indicator (p/s) c 1s character(1) y 2 5 y y n 6 ns ns hemisphere indicator (n/s) c 1s character(1) y 2 6 n n n 7 band band char flag indicating bands that have magnitudes for this calibrator (1/0) c 4s character(4) y 2 7 y y n 8 usecal usecal char flag indicating whether this match used in calibration (Y/N) c 1s character(1) y 2 8 y y n 9 ucnf ucnf confusion flag, 1 = there is confusion for this src and this is the best match i 3d integer y 2 9 y y n 10 ncnf ncnf confusion flag = the total number of additional apparitions for calibrator i 3d integer y 2 10 y y n 11 aacrj aacrj ap cal flag, 1 char / band: calibrator was NA(-), Accepted or Rejected in band c 4s character(4) y 2 11 y y n 12 pacrj pacrj PSF cal flag, 1 char / band: calibrator was NA(-), Accepted or Rejected in band c 4s character(4) y 2 12 y y n 13 w1caacrj w1caacrj reason for band 1 aacrj rejection: C,N,U,F,S,X,A,E,L i 10s character(10) y 1 13 n n n 14 w2caacrj w2caacrj reason for band 2 aacrj rejection: C,N,U,F,S,X,A,E,L i 10s character(10) y 1 14 n n n 15 w3caacrj w3caacrj reason for band 3 aacrj rejection: C,N,U,F,S,X,A,E,L i 10s character(10) y 1 15 n n n 16 w4caacrj w4caacrj reason for band 4 aacrj rejection: C,N,U,F,S,X,A,E,L i 10s character(10) y 1 16 n n n 17 w1cpacrj w1cpacrj reason for band 1 pacrj rejection: C,N,U,F,S,X,A,E,L i 10s character(10) y 1 17 n n n 18 w2cpacrj w2cpacrj reason for band 2 pacrj rejection: C,N,U,F,S,X,A,E,L i 10s character(10) y 1 18 n n n 19 w3cpacrj w3cpacrj reason for band 3 pacrj rejection: C,N,U,F,S,X,A,E,L i 10s character(10) y 1 19 n n n 20 w4cpacrj w4cpacrj reason for band 4 pacrj rejection: C,N,U,F,S,X,A,E,L i 10s character(10) y 1 20 n n n 21 w1psfdm w1psfdm PSF band 1 delta mag (catalog - instrumental) mag r 8.3f decimal(6,3) y 1 21 y y n 22 w2psfdm w2psfdm PSF band 2 delta mag (catalog - instrumental) mag r 8.3f decimal(6,3) y 1 22 y y n 23 w3psfdm w3psfdm PSF band 3 delta mag (catalog - instrumental) mag r 8.3f decimal(6,3) y 1 23 y y n 24 w4psfdm w4psfdm PSF band 4 delta mag (catalog - instrumental) mag r 8.3f decimal(6,3) y 1 24 y y n 25 w1apdm w1apdm standard aperture band 1 delta mag (catalog - instrumental) mag r 8.3f decimal(6,3) y 1 25 y y n 26 w2apdm w2apdm standard aperture band 2 delta mag (catalog - instrumental) mag r 8.3f decimal(6,3) y 1 26 y y n 27 w3apdm w3apdm standard aperture band 3 delta mag (catalog - instrumental) mag r 8.3f decimal(6,3) y 1 27 y y n 28 w4apdm w4apdm standard aperture band 4 delta mag (catalog - instrumental) mag r 8.3f decimal(6,3) y 1 28 y y n 29 w1pzp w1pzp PSF mag calibration zero point - band 1 mag r 8.4f decimal(6,4) y 1 29 y y n 30 w2pzp w2pzp PSF mag calibration zero point - band 2 mag r 8.4f decimal(6,4) y 1 30 y y n 31 w3pzp w3pzp PSF mag calibration zero point - band 3 mag r 8.4f decimal(6,4) y 1 31 y y n 32 w4pzp w4pzp PSF mag calibration zero point - band 4 mag r 8.4f decimal(6,4) y 1 32 y y n 33 w1azp w1azp aperture mag calibration zero point - band 1 mag r 8.4f decimal(6,4) y 1 33 y y n 34 w2azp w2azp aperture mag calibration zero point - band 2 mag r 8.4f decimal(6,4) y 1 34 y y n 35 w3azp w3azp aperture mag calibration zero point - band 3 mag r 8.4f decimal(6,4) y 1 35 y y n 36 w4azp w4azp aperture mag calibration zero point - band 4 mag r 8.4f decimal(6,4) y 1 36 y y n 37 scan_id scan_id scan ID c 6s character(6) n 2 37 y y y 38 load_id load_id unique load ID number i 4d integer n 2 38 n n n 39 cntr cntr unique entry counter (key) number i 12d serial8 n 2 39 n n y 40 x x unit sphere (x,y,z) position x value r 19.16f decimal(17,16) n 2 40 h h n 41 y y unit sphere (x,y,z) position y value r 19.16f decimal(17,16) n 2 41 h h n 42 z z unit sphere (x,y,z) position z value r 19.16f decimal(17,16) n 2 42 h h n 43 spt_ind spt_ind spatial (x,y,z) index key i 9d integer n 2 43 h h y