DBPREP Output File Specification and Description (19 Nov 2009) [arc17 WSDC D-I181 version 1.0] Interface Name: Level 1b 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 1b incremental load metadata tables contain the load metadata for the scan in the current DBPREP run. DBPREP reads the Level 1b Master Load Metadata Table (SIS arc15) table to see if this scan has previously been entered into the database; if so, it writes load metadata, with a null IMGPREP run date 'date_imgprep', for this scan to an "update" file. If not, it writes the same data to an "insert" file. Then when IMGPREP runs on the same scan, 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 ('1b'), 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_i1bl_lod_4_1.insert.bartbl.93502b /wise_i1bl_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 scan_id scan_id scan ID c 6s character(6) 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