DBPREP Output File Specification and Description (19 Nov 2009) [arc15 WSDC D-I179 version 1.0] Interface Name: Level 1b Master Load Metadata Table Archive DB Interface Specification Type of Interface: program I/O Written By: Database load utility Read By: DBPREP _________________________ T. L. Evans Description: Version 3.2 of DBPREP (dated 11-20-2009) The input Level 1b Master Load Metadata Table contains the load metadata for all level 1b data that has been entered into the DB. This table is created by dumping out the version of the table in the DB at the end of each load. DBPREP reads this table to see if a certain scan has previously been entered into the database, then writes out a different file containing similar data (SIS arc17) for the current DBPREP run. The table name follows the WISE/IRSA DB table naming convention and is determined by the input parameter 'load_info_dir', the access type ('i' for internal), data type ('l_lod'), data level ('1b'), DB table version number, and output format (bar-delimited). The table is normally contained in the DBPREP/IMGPREP processing output directory. For example: /wise_i1bl_lod_4.bartbl The data dictionary defining the IPAC table format and the database table structure 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