DBPREP Output File Specification and Description (19 Nov 2009) [arc18 WSDC D-I182 version 1.0] Interface Name: Level 3o Incremental Load Metadata Table Archive DB Interface Specification Type of Interface: program I/O Written By: DBPREP _________________________ T. L. Evans IMGPREP_________________________ T. L. Evans Read By: Database load utility Description: Version 3.2 of DBPREP (dated 11-20-2009) Version 3.2 of IMGPREP (dated 11-19-2009) The output level 3o incremental load metadata tables contain the load metadata for the coadd in the current DBPREP run. DBPREP reads the Level 3o Master Load Metadata Table (SIS arc16) table to see if this coadd has previously been entered into the database; if so, it writes load metadata, with a null IMGPREP run date 'date_imgprep', for this coadd to an "update" file. If not, it writes the same data to an "insert" file. Then when IMGPREP runs on the same coadd, it locates the file output from DBPREP and adds the IMGPREP run date value. 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 ('l_lod'), data level ('3o'), DB table version number, load ID number, and output format (bar-delimited, including 'insert.' or 'update.'). The table is contained in the DBPREP/IMGPREP processing output directory. For example: /wise_i3ol_lod_4_1.insert.bartbl.93502b /wise_i3ol_lod_4_1.update.bartbl.80242b The data dictionary defining the IPAC table format and the database table structure for both these output files and the master input file is below. \ Default Data Dictionary \ \ Date: 11-18-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 load_id load_id load ID d 4d integer n 2 1 y y y 2 coadd_id coadd_id coadd ID c 20s character(20) n 2 2 y y y 3 date_dbprep date_dbprep date and time of DBPREP processing, UTC datetimeZ c 20s character(20) n 2 3 n n n 4 date_imgprep date_imgprep date and time of IMGPREP processing, UTC datetimeZ c 20s character(20) n 2 4 n n n 5 cntr cntr unique entry counter (key) number i 12d serial8 n 2 5 n n n