ERT Data Dictionary Wednesday, May 04, 2016 10:17:43 AM Table Name: tbIRunHeader Table Description: Instrumental Methods Header Data Field Name Field Description Field Type Size Key Required PercCOHDR This is the carbon monoxide percentage which defaults to zero (0). ... not used for method 5 or 202 Double 8 NozzleCkPost This is a pull-down selection for nozzle inspections for dents, nicks, etc. This field is present only on the single train "Header Data" tab. Text 20 Impinit2 This is the initial volume or weight of impinger number 2. The ERT uses the value in this field in the calculation to produce the sum of the differences of all of the impingers and populate this value into the VIcHDR field. Double 8 Impinitl This is the initial volume or weight of impinger number 1. The ERT uses the value in this field in the calculation to produce the sum of the differences of all of the impingers and populate this value into the VIcHDR field. Double 8 FcHDR The value "Fc" is the ratio of the theoretical carbon dioxide produced during combustion to the higher heating value of the fuel combusted. With carbon dioxide, the emission rate in Ib/MMBtu can be calculated from wet or dry emissions concentration. Long Integer 4 FwHDR The value "Fw" is the ratio of the quantity of wet effluent gas generated by combustion to the gross calorific value of the fuel. With wet oxygen and moisture concentration, the emission rate in Ib/MMBtu can be calculated. Long Integer 4 RunStatus added 9/28/05 - Accepted/Rejected Text 20 Impinit4 This is the initial volume or weight of impinger number 4. The ERT uses the value in this field in the calculation to produce the sum of the differences of all of the impingers and populate this value into the VIcHDR field. Double 8 FuelType This is a pull-down selection of the Fuel Type which also populates the three F-factor fields FdHDR, FwHDR and FcHDR with the values presented in Table 19-2 of EPA Method 19. In addition, the user may select "Override" and enter fuel specific F- factors. Text 25 Page 1 of 54 ------- Table Name: tbIRunHeader Table Description: Instrumental Methods Header Data Field Name Field Description Field Type Size Key Required Impinit5 This is the initial volume or weight of impinger number 5. The ERT uses the value in this field in the calculation to produce the sum of the differences of all of the impingers and populate this value into the VIcHDR field. Double 8 PstdHDR This is the standard pressure which defaults to EPA standard of 29.92 inches of mercury. When the test method performed requires the use of a different standard pressure, the user can change the "29.92" in this field to the pressure specified. Double 8 tstdHDR This is the standard temperature which defaults to EPA standard of 68 degrees F. When the test method performed requires the use of a different standard temperature, the user can change the "68" in this field to the temperature specified. Double 8 Location This is the unique sampling location name, such as inlet, stack, ESP inlet, scrubber outlet, etc. which was provided during the Test Plan preparation. Text 50 Personnel Not Used. This is left in for compatibility with old project data sets. Text 50 StackTCCKPost This is a pull-down selection for the post-test results of the thermocouple check, as applicable. Paired sampling trains also requires the recording of sorbent trap and probe temperatures, there are checks for these thermocouples. Text 25 StackTCCKMid This is a pull-down selection for the mid-test results of the thermocouple check, as applicable. Paired sampling trains also require the recording of sorbent trap and probe temperatures, there are checks for these thermocouples. Text 25 StackTCCKPre This is a pull-down selection for the pre-test results of the thermocouple check, as applicable. Paired sampling trains also require the recording of sorbent trap and probe temperatures, there are checks for these thermocouples. Text 20 FdHDR The value "Fd" is the ratio of the quantity of dry effluent gas generated by combustion to the gross calorific value of the fuel. With oxygen concentration, the emission rate in Ib/MMBtu can be calculated from the dry pollutant emissions concentration. Long Integer 4 Page 2 of 54 ------- Table Name: tbIRunHeader Table Description: Instrumental Methods Header Data Field Name Field Description Field Type Size Key Required Impfin6 This is the final volume or weight of impinger number 6 determined after the test. The ERT uses the value in this field in the calculation to produce the sum of the differences of all of the impingers and populate this value into the VIcHDR field. Double 8 RunNumber PK- This is for the Run Number of the test. This number is assigned by the test company. Generally, the run number is an integer value which indicates the sequence order for the performance of the test method for the location. Text 50 Primary ProcRunID This is the run id of the process parameter associatied with the same time the test was performed. The user uses a drop down menu to select the process parameter which is stored in the "Process ParamID" field of table "tbIProcessRunData". Text 75 PercC02Runld This is the run id of a Method 3A test for C02 if the users selects the C02 run from the pull down menu, (if pulled from that method) Text 75 Probe This is the sample probe and or Pitot equipment identification number. The Pitot is the piece of hardware used to measure the velocity pressure of the stack gas. The ID is necessary for calibration documentation purposes. Text 50 Ambient Ambient Temperature in degrees F. The ambient temperature field is present only on the single train "Header Data" tab. Long Integer 4 Mansense This is the sensitivity of the micromanometer if one was used. The units for this field is inches of water column. Double 8 Impinit3 This is the initial volume or weight of impinger number 3. The ERT uses the value in this field in the calculation to produce the sum of the differences of all of the impingers and populate this value into the VIcHDR field. Double 8 Silicafin This is the final weight of impinger containing Silica Gel determined after the test. The ERT uses the value in this field in the calculation to produce the sum of the differences of all of the impingers and populate this value into the VIcHDR field. Double 8 Perc02Runld This is the run id of a Method 3A test for 02 if the users selects the 02 run from the pull down menu, (if pulled from that method) Text 75 Page 3 of 54 ------- Table Name: tbIRunHeader Table Description: Instrumental Methods Header Data Field Name Field Description Field Type Size Key Required Impfin5 This is the final volume or weight of impinger number 5 determined after the test. The ERT uses the value in this field in the calculation to produce the sum of the differences of all of the impingers and populate this value into the VIcHDR field. Double 8 Impfin4 This is the final volume or weight of impinger number 4 determined after the test. The ERT uses the value in this field in the calculation to produce the sum of the differences of all of the impingers and populate this value into the VIcHDR field. Double 8 Impfin3 This is the final volume or weight of impinger number 3 determined after the test. The ERT uses the value in this field in the calculation to produce the sum of the differences of all of the impingers and populate this value into the VIcHDR field. Double 8 Impfin2 This is the final volume or weight of impinger number 2 determined after the test. The ERT uses the value in this field in the calculation to produce the sum of the differences of all of the impingers and populate this value into the VIcHDR field. Double 8 Impfinl This is the final volume or weight of impinger number 1 determined after the test. The ERT uses the value in this field in the calculation to produce the sum of the differences of all of the impingers and populate this value into the VIcHDR field. Double 8 Silicainit This is the initial weight of impinger containing Silica Gel. The ERT uses the value in this field in the calculation to produce the sum of the differences of all of the impingers and populate this value into the VIcHDR field. Double 8 Impinit6 This is the initial volume or weight of impinger number 6. The ERT uses the value in this field in the calculation to produce the sum of the differences of all of the impingers and populate this value into the VIcHDR field. Double 8 Manused This is the identification number of the micromanometer if used. Text 50 FilterNum2 This is the specific identifier for the second filter used for the test run if used. The value provided is the filter's unique identification number and is used for associating laboratory analyses with a specific test. Text 20 Pitot This is the Pitot tube ID. Used with the spreadsheet import Text 25 Page 4 of 54 ------- Table Name: tbIRunHeader Table Description: Instrumental Methods Header Data Field Name Field Description Field Type Size Key Required TCReadOut This is the Thermocouple read out. Used with the spreadsheet import Text 25 MeterBox This is the identification number of the Dry Gas Meter. The dry gas meter is the piece of hardware responsible for quantifying the volume of gas passing through the meter. The ID is necessary for calibration documentation purposes. Text 25 SampBox This is the ID of the sample box. Used with the spreadsheet import. Text 25 TedlarBag This is the ID of a Tedlar bag, if used. The Tedlar bag ID is present only on the "Single Train" header tab. Text 25 Umbical This is the identificatin number of the sample transport line either from the sample probe to the filter and impinger box or from the exit of the impingers to the Meter Box console. The Umbilical ID is present only on the "Single Train" header tab. Text 25 Nozzle The nozzle ID is necessary for calibration documentation purposes. Method 5 requires the measurement of the diameter of each probe nozzle before use and a permanent unique identifier. The Nozzle ID is present only on the "Single Train" header tab. Text 25 FilterNum3 This is the specific identifier for the third filter used for the test run if used. The value provided is the filter's unique identification number and is used for associating laboratory analyses with a specific test. Text 20 OrasatPump This is the ID of the pump used for filling a Tedlar bag, for example. The Orsat Pump ID is present only on the "Single Train" header tab. Text 25 FilterNuml This is the specific identifier for the first filter used for the test run. The value provided is the filter's unique identification number and is used for associating laboratory analyses with a specific test. Text 20 PgHDR This is the static pressure (inches of water), of the sampling location. Some screens show Pstatic or Pg. Static pressure is typically measured with a Pitot tube. The value is the difference between the stack and local atmospheric pressure. Double 8 Page 5 of 54 ------- Table Name: tbIRunHeader Table Description: Instrumental Methods Header Data Field Name Field Description Field Type Size Key Required PbHDR The barometric pressure of the sampling location. The pressure is reported in units of inches of mercury at the sampling platform. User obtained weather service pressures are adjusted for the differences in pressure due to differences in elevation. Double 8 Method PK- The field identifies the method used to measure the analyte emissions. The test method was one of the user selected isokinetic or manual sampling methods which were entered in Item 2a of the Test Plan. Text 20 Primary RunDate PK- This is the date that the test was performaned. Date/Time 8 Primary JobNumber This is the contractor's internal job or project number. Used with the spreadsheet import Text 25 NozzleCkMid This is a pull-down selection for nozzle inspections for dents, nicks, etc. This field is present only on the single train "Header Data" tab. Text 20 ReagBox This is the identification number of the Control Console. The control console is the combination of the dry gas meter, pumps, temperature controllers, manometers, etc. The ID is necessary for calibration documentation purposes. Text 25 LeakRtPost The post-test sampling train leak check rate. The post-test leak rate must be less than or equal to 4 percent of the average sampling rate or 0.02 acfm whichever is less. Double 8 NozzleCkPre This is a pull-down selection for nozzle inspections for dents, nicks, etc. This field is present only on the single train "Header Data" tab. Text 20 PitotCkPost This is a pull-down selection for the mandatory post- test leak check result. This is a pass or fail assessment against the specifications in EPA Method 2. Text 20 StackTC This is the ID of the thermocouple device used for monitoring the stack gas temperature. The ID is necessary for calibration documentation purposes. Text 25 PitotCkPre This is a pull-down selection for the pre-test leak check result, if performed. This is a pass or fail assessment against the specifications in EPA Method 2. Text 20 Page 6 of 54 ------- Table Name: tbIRunHeader Table Description: Instrumental Methods Header Data Field Name Field Description Field Type Size Key Required VIcHDR This is the sum of the volume or weight of the moisture condensed in each of the impingers to the nearest milliliter. In the ERT application this field is shown as "Vic". Double 8 LeakRtPre The pre-test sampling train leak check rate. The post-test leak rate must be less than or equal to 4 percent of the initial sampling rate or 0.02 acfm whichever is less. Double 8 FinalDGM For single sampling trains, this is the total volume recorded by the dry gas meter (DGM) during all leak checks performed between the pre test and post test leak checks. This volume is subtracted from the total sample volume recorded for the test run. Double 8 InitDGM This is the initial volume or the dry gas meter prior to any of the leak checks conducted between the pre test and post test leak checks. This value is set at 0. Double 8 VacCkPost The vacuum at which the post sampling train leak checks was performed. Double 8 Perc02HDR The oxygen percent of the gas stream tested. The pull-down to the right of the field for the 02 concentration provides access to the results of instrumental measurements of 02. Double 8 PercC02HDR The carbon dioxide percent of the gas stream tested. The pull-down to the right of the field for the C02 concentration provides access to the results of instrumental measurements of C02. Double 8 DnHDR This is the nozzle diameter. The nozzle diameter is measured in inches. Double 8 CpHDR This is the Pitot tube coefficient which is dimensionless. The Pitot tube coefficient for an S- type Pitot can range from 0.80 to 0.88 but is usually between 0.84 and 0.864. The Cp for a standard Pitot is 0.99. Double 8 DH@HDR Delta H @ (AH@) is the orifice pressure differential in inches of H20 of an isokinetic sampling train meterbox (such as used for Method 5 sampling) that correlates to 0.75 cfm at 5282R and 29.92 in Hg. Double 8 Page 7 of 54 ------- Table Name: tbIRunHeader Table Description: Instrumental Methods Header Data Field Name Field Description Field Type Size Key Required YHDR This is the dry gas meter correction coefficient, gamma, of an isokinetic sampling train meterbox (such as used for Method 5 sampling). In the displayed header screen, gamma is shown as "Y". The units of gamma are dimensionless. Double 8 VacCkPre The vacuum at which the pre sampling train leak checks was performed. Double 8 PitotCkMid This is a pull-down selection for the mid-test leak check result, if performed. This is a pass or fail assessment against the specifications in EPA Method 2. Text 20 Table Name: tbIRunPoints Table Description: Manual Methods Point Run Data Field Name Field Description Field Type Size Key Required FinalExitTemp This is the temperature of sample gas exiting silica gel impinger, degrees F. Long Integer 4 PumpVac This is the vacuum of the sampling pump, measured in inches mercury. Double 8 Notes These are any observations or comments concerning the test run. Text 255 Location RF- This is the unique sampling location name, such as inlet, stack, ESP inlet, scrubber outlet, etc. which was provided during the Test Plan preparation. Text 50 Req. Point RF- This is the sampling point label used by the test company, such as Al, A-l, D-2, etc. Text 8 Req. JobNumber This is the contractors project or job number. Used with the spreadsheet import. Text 25 Method RF- The field identifies the method used to measure the analyte emissions. The test method was one of the user selected isokinetic or manual sampling methods which were entered in Item 2a of the Test Plan. Text 20 Req. FilTempOut This is the gas temperature exiting the filter box or compartment, degrees F. Where a sampling protocol requires the monitoring of two filter temperatures, this may be used as the exit gas temperature for the second filter. Long Integer 4 SampleRate This is the sampling rate, measured in cubic ft per min. Double 8 Page 8 of 54 ------- Table Name: tbIRunPoints Table Description: Manual Methods Point Run Data Field Name Field Description Field Type Size Key Required RunNumber RF- This is for the Run Number of the test. This number is assigned by the test company. Generally, the run number is an integer value which indicates the sequence order for the performance of the test method for the location. Text 20 Req. ImpingTemp This field is left in for backwards compatibility with older project data sets. Double 8 FilTempIn This is the gas temperature entering the filter box or compartment, degrees F. Where a sampling protocol requires the monitoring of two filter temperatures, this may be used as the exit gas temperature for the first filter. Long Integer 4 GasMeter RF- The dry gas meter volume reading at the beginning (or end) of the sampling at a point. This means that the final (or initial) volume reading is recorded in a row without a point label and no other recorded point data. Double 8 Req. FilterTemp This field is left in for backwards compatibility with older project data sets. Double 8 RunDate RF- This is the date that the test was performaned. Date/Time 8 Req. BeginTime This is the number of minutes of cumulative sampling time prior to the beginning of sampling at the sample point. Double 8 Clock This is the actual local clock time at the start of sampling at a point. Date/Time 8 Velocity RF- This is the velocity pressure (Ap) expressed in inches of water. Values in "AP" are used in the calculation of isokinetics, average delta p, velocity of gas stream and actual and standard stack gas flow. Double 8 Req. StackTemp RF- This is the measured stack temperature of the effluent gas at the sampling point and is expressed as degrees F. The values in the stack temp are used in subsequent calculations. Double 8 Req. DryGaslnlet RF- This is the dry gas meter intlet gas temperature, expressed as degrees F. The values in the dry gas intlet are used in subsequent calculations. Double 8 Req. DryGasOutlet RF- This is the dry gas meter outlet gas temperature, expressed as degrees F. The values in the dry gas outlet are used in subsequent calculations. Double 8 Req. Page 9 of 54 ------- Table Name: tbIRunPoints Table Description: Manual Methods Point Run Data Field Name Field Description Field Type Size Key Required OrificePresDesired This is the orifice pressure setting required for sampling isokinetically, measured by inches water. Double 8 OrificePresActual RF- Orifice pressure actually sampled or reached, measured in inches of water. The values in the "Orifice Pressure Actual" are used in subsequent calculations. Double 8 Req. ProbeTemp This is the temperature of the sampling probe, degrees F. Double 8 EndTime RF- This is the number of minutes of cumulative sampling time at the end of sampling at the sample point. Double 8 Req. Table Name: tbIRunLab Table Description: Manual Methods Lab Data Field Name Field Description Field Type Size Key Required Units This is the mass units, including: gm (grams), mg (milligrams), ug (micrograms), ng (nanograms) or pg (picograms). Text 10 Mass This is the numerical value of the sample catch weight reported from the lab. This value may be the sum of multiple analytical components. Double 8 Compliance added 9/28/05 - Yes/No/Indeterminate Text 20 RunDate PK- This is the date that the test was performaned. Date/Time 8 Primary Flag Lab qualifier for the sample data. EPA guidance requests the following flags: BDL (all components are below detection level); DLL (not all components are less than the detection level); and ADL (all components are above the detection level). Text 50 PlantID FK- This number provides a link to tbltestplan. Text 50 Foreign Method PK- The field identifies the method used to measure the analyte emissions. The test method was one of the user selected isokinetic or manual sampling methods which were entered in Item 2a of the Test Plan. Text 50 Primary RunNumber PK- This is for the Run Number of the test. This number is assigned by the test company. Generally, the run number is an integer value which indicates the sequence order for the performance of the test method for the location. Text 50 Primary Page 10 of 54 ------- Table Name: tbIRunLab Table Description: Manual Methods Lab Data Field Name Field Description Field Type Size Key Required Location PK-This is the unique sampling location name, such as inlet, stack, ESP inlet, scrubber outlet, etc. which was provided during the Test Plan preparation. Text 50 Primary Compound PK- Analyte name from the Test Plan "Setup" window. Text 50 Primary Comments Observations or comments. EPA guidance recommends the reporting of individual components and laboratory detection level(s) in the comment field. Memo 0 Table Name: tblRunHeader30B Table Description: Method 30 B Header Run Data Field Name Field Description Field Type Size Key Required tsHDR This is the calculated stacktemperature based upon the method selected in TemperatureRunlD. If the user selected "User Entered" the value is the number entered. Double 8 FlowRateRunID This is the flow rate run identification for the period corresponding to the time for the emissions test documented in this record. It is selected from a list of available flow rate runs by the user. The user also has the option to select "User Entered". Text 75 QsdHDR This is the calculated stack flow in dscfm based upon the method selected in FlowRateRunID. If the user selected "User Entered" the value is the number entered. Double 8 SorbentT rapCkPostA This is a pull-down selection for the A train post-test results of the sorbent trap check, as applicable. Text 20 SorbentTrapCkPreA This is a pull-down selection for the A train pre-test results of the sorbent trap check, as applicable. Text 20 ProbeCkPostB This is a pull-down selection for the B train post-test results of the probe check, as applicable. Text 20 ProbeCkPostA This is a pull-down selection for the A train post-test results of the probe check, as applicable. Text 20 ProbeCkPreB This is a pull-down selection for the B train pre-test results of the probe check, as applicable. Text 20 ProbeCkPreA This is a pull-down selection for the A train pre-test results of the probe check, as applicable. Text 20 Page 11 of 54 ------- Table Name: tblRunHeader30B Table Description: Method 30 B Header Run Data Field Name Field Description Field Type Size Key Required StackTCCKPostB This is a pull-down selection for the B train post-test results of the thermocouple check, as applicable. Text 25 StackTCCKPostA This is a pull-down selection for the A train post-test results of the thermocouple check, as applicable. Text 25 StackTCCKPreB This is a pull-down selection for the B train pre-test results of the thermocouple check, as applicable. Text 25 StackTCCKPreA This is a pull-down selection for the A train pre-test results of the thermocouple check, as applicable. Text 20 LeakRtPostB The B train post-test sampling train leak check rate. The post-test leak rate must be less than or equal to 4 percent of the average sampling rate. Double 8 TemperatureRunID This is a drop down menu to select the method for determining temperature and moisture. Available selections include using calculated data from the test, using data from another manual test method or allowing manually entered data by the user. Text 75 GasMeterUnits This is the units that the dry gas meter displays. The ERT limits selection to liters, cubic meters and cubic feet. Text 15 LeakRtPostA The A train post-test sampling train leak check rate. The post-test leak rate must be less than or equal to 4 percent of the average sampling rate. Double 8 HighPointCalibration This is the highest mass which the technician selects for calibration of the analytical instrument. Double 8 LeakRtPreB The B train pre-test sampling train leak check rate. The pre-test leak rate must be less than or equal to 4 percent of the initial sampling rate. Double 8 SorbentTrapCkPreB This is a pull-down selection for the B train pre-test results of the sorbent trap check, as applicable. Text 20 H20HDR This is the calculated moisture percent based upon the method selected in tsHDR unless the user selected "User Entered". Double 8 H20RunlD This is the H20 run identification for the period corresponding to the time for the emissions test documented in this record. It is selected from a list of available H20 runs by the user. The user also has the option to select "User Entered". Text 75 Page 12 of 54 ------- Table Name: tblRunHeader30B Table Description: Method 30 B Header Run Data Field Name Field Description Field Type Size Key Required MercuryMassUnits This field provides the metric units associated with all the reported mass values used in the sample data tab. Metric mass values available range from grams (g) to nanograms (ng). Text 10 ProcRunID This is the run id of the process parameter associatied with the same time the test was performed. The user uses a drop down menu to select the process parameter which is stored in the "Process ParamID" field of table "tbIProcessRunData". Text 75 CpHDRB This is the train B (if used) Pitot tube coefficient which is dimensionless. The Pitot tube coefficient for an S-type Pitot can range from 0.80 to 0.88 but is usually between 0.84 and 0.864. The Cp for a standard Pitot is 0.99. Double 8 ExpectedMassHg This is the mass value of Hg expected to be collected in Section 1 of the sample trap. The expected mass is used to assess the acceptability of the spike level used during the field recovery test. Double 8 VIcComA This is the sample train A sum of the volume or weight of the moisture condensed in each of the impingers or otherwise measured to the nearest milliliter. In the ERT application this field is shown as "Vic Components". Double 8 LowPointCalibration This is the lowest mass which the technician selects for calibration of the analytical instrument. Double 8 LabReportMDL The laboratory must establish their minimum detection limit (MDL). Method 30B requires that the MDL must be determined at least once for the analytical system using an MDL study. Double 8 FcHDR The value "Fc" is the ratio of the theoretical carbon dioxide produced during combustion to the higher heating value of the fuel combusted. With carbon dioxide, the emission rate in Ib/MMBtu can be calculated from wet or dry emissions concentration. Long Integer 4 FwHDR The value "Fw" is the ratio of the quantity of wet effluent gas generated by combustion to the gross calorific value of the fuel. With wet oxygen and moisture concentration, the emission rate in Ib/MMBtu can be calculated. Long Integer 4 Page 13 of 54 ------- Table Name: tblRunHeader30B Table Description: Method 30 B Header Run Data Field Name Field Description Field Type Size Key Required FdHDR The value "Fd" is the ratio of the quantity of dry effluent gas generated by combustion to the gross calorific value of the fuel. With oxygen concentration, the emission rate in Ib/MMBtu can be calculated from the dry pollutant emissions concentration. Long Integer 4 FuelType This is a pull-down selection of the Fuel Type which also populates the three F-factor fields FdHDR, FwHDR and FcHDR with the values presented in Table 19-2 of EPA Method 19. In addition, the user may select "Override" and enter fuel specific F- factors. Text 25 VIcComB This is the sample train A sum of the volume or weight of the moisture condensed in each of the impingers or otherwise measured to the nearest milliliter. In the ERT application this field is shown as "Vic Components". Double 8 CpHDRA This is the train A Pitot tube coefficient which is dimensionless. The Pitot tube coefficient for an S- type Pitot can range from 0.80 to 0.88 but is usually between 0.84 and 0.864. The Cp for a standard Pitot is 0.99. Double 8 MeterBoxB This is the identification number of Dry Gas Meter B. The dry gas meter is the piece of hardware responsible for quantifying the volume of gas passing through the meter. The ID is necessary for calibration documentation purposes. Text 25 DH@HDRB The Delta H @ (AH@) for sample train B. The AH@ is the orifice pressure differential in inches of H20 of an isokinetic sampling train meterbox (such as used for Method 5 sampling) that correlates to 0.75 cfm at 5282R and 29.92 in Hg. Double 8 YHDRB This is the dry gas meter correction coefficient, gamma, of sampling train A meterbox. In the displayed header screen, gamma is shown as "Y". The units of gamma are dimensionless. Double 8 DH@HDRA The Delta H @ (AH@) for sample train A. The AH@ is the orifice pressure differential in inches of H20 of an isokinetic sampling train meterbox (such as used for Method 5 sampling) that correlates to 0.75 cfm at 5282R and 29.92 in Hg. Double 8 YHDRA This is the dry gas meter correction coefficient, gamma, of sampling train A meterbox. In the displayed header screen, gamma is shown as "Y". The units of gamma are dimensionless. Double 8 Page 14 of 54 ------- Table Name: tblRunHeader30B Table Description: Method 30 B Header Run Data Field Name Field Description Field Type Size Key Required ProbeA This is the sample probe identification number. The ID is necessary for calibration documentation purposes. Text 50 StackTCA This is the ID of the A thermocouple used for monitoring the stack gas temperature. The ID is necessary for calibration documentation purposes. Text 25 PbHDR The barometric pressure of the sampling location. The pressure is reported in units of inches of mercury at the sampling platform. User obtained weather service pressures are adjusted for the differences in pressure due to differences in elevation. Double 8 ReagBoxA This is the identification number of Control Console A. The control console is the combination of the dry gas meter, pumps, temperature controllers, manometers, etc. The ID is necessary for calibration documentation purposes. Text 25 ProbeB This is the sample probe identification number. The ID is necessary for calibration documentation purposes. Text 50 MeterBoxA This is the identification number of Dry Gas Meter A. The dry gas meter is the piece of hardware responsible for quantifying the volume of gas passing through the meter. The ID is necessary for calibration documentation purposes. Text 25 TechnicianName This field is the name of the person that operated the equipment used to collect the sample. Text 25 RunDate PK- This is the date that the test was performaned. Date/Time 8 Primary RunNumber PK- This is for the Run Number of the test. This number is assigned by the test company. Generally, the run number is an integer value which indicates the sequence order for the performance of the test method for the location. Text 50 Primary JobNumber This is the contractors project or job number. Used with the spreadsheet import. Text 25 Method PK- The field identifies the method used to measure the analyte emissions. The test method was one of the user selected isokinetic or manual sampling methods which were entered in Item 2a of the Test Plan. Text 20 Primary SorbentTrapCkPostB This is a pull-down selection for the B train post-test results of the sorbent trap check, as applicable. Text 20 Page 15 of 54 ------- Table Name: tblRunHeader30B Table Description: Method 30 B Header Run Data Field Name Field Description Field Type Size Key Required ReagBoxB This is the identification number of Control Console B if used. The control console is the combination of the dry gas meter, pumps, temperature controllers, manometers, etc. The ID is necessary for calibration documentation purposes. Text 25 AnalysisMethod This is information to identify the method used extract, prepare and analyze the collected samples. Text 50 VacCkPostB The vacuum at which the B train post sampling train leak checks was performed. Double 8 VacCkPostA The vacuum at which the A train post sampling train leak checks was performed. Double 8 StackTCB This is the ID of the B thermocouple used for monitoring the stack gas temperature. The ID is necessary for calibration documentation purposes. Text 25 VacCkPreA The vacuum at which the A train pre sampling train leak checks was performed. Double 8 PgHDR This is the static pressure (inches of water), of the sampling location. Some screens show Pstatic or Pg. Static pressure is typically measured with a Pitot tube. The value is the difference between the stack and local atmospheric pressure. Double 8 AnalysisTechnician This is the name of the person operating the trap analysis equipment. Text 50 TrapAnalysisSource This is the combined equipment and apparatus used to perform sample analyses. This includes any associated sample preparation apparatus e.g., digestion equipment, spiking systems, reduction devices, etc., as well as analytical instrumentation. Text 50 TrapManufacturer This is the manufacturer of the sample cartridge or sleeve containing a sorbent media (typically activated carbon treated with iodine or some other halogen) with multiple sections separated by an inert material such as glass wool. Text 50 PercCOHDR This is the carbon monoxide percentage which defaults to zero (0). ... not used for method 5 or 202 Double 8 LeakRtPreA The A train pre-test sampling train leak check rate. The pre-test leak rate must be less than or equal to 4 percent of the initial sampling rate. Double 8 VacCkPreB The vacuum at which the B train pre sampling train leak checks was performed. Double 8 Page 16 of 54 ------- Table Name: tblRunHeader30B Table Description: Method 30 B Header Run Data Field Name Field Description Field Type Size Key Required PstdHDR This is the standard pressure which defaults to EPA standard of 29.92 inches of mercury. When the test method performed requires the use of a different standard pressure, the user can change the "29.92" in this field to the pressure specified. Double 8 Perc02HDR The oxygen percent of the gas stream tested. The pull-down to the right of the field for the 02 concentration provides access to the results of instrumental measurements of 02. Double 8 PercC02Runld This is the run id of a Method 3A test for C02 if the users selects the C02 run from the pull down menu. Text 75 Location PK-This is the unique sampling location name, such as inlet, stack, ESP inlet, scrubber outlet, etc. which was provided during the Test Plan preparation. Text 50 Primary Perc02Runld This is the run id of a Method 3A test for 02 if the users selects the 02 run from the pull down menu. Text 75 tstdHDR This is the standard temperature which defaults to EPA standard of 68 degrees F. When the test method performed requires the use of a different standard temperature, the user can change the "68" in this field to the temperature specified. Double 8 PercC02HDR The carbon dioxide percent of the gas stream tested. The pull-down to the right of the field for the C02 concentration provides access to the results of instrumental measurements of C02. Double 8 Table Name: tblRunPoints30B Table Description: Method 30 B Point Run Data Field Name Field Description Field Type Size Key Required DryGasB RF- This is the inlet or outlet temperature of sample gas at Dry Gas Meter B, degrees F. Double 8 Req. Method RF- The field identifies the method used to measure the analyte emissions. The test method was one of the user selected isokinetic or manual sampling methods which were entered in Item 2a of the Test Plan. Text 20 Req. SampleRateB RF- This is the train B sampling rate, measured in the units of measure selected on the "Header Data" tab. Double 8 Req. DryGasA RF- This is the inlet or outlet temperature of sample gas at Dry Gas Meter A, degrees F. Double 8 Req. Page 17 of 54 ------- Table Name: tblRunPoints30B Table Description: Method 30 B Point Run Data Field Name Field Description Field Type Size Key Required PumpVacA This is train A sampling pump vacuum, measured in inches mercury. Double 8 PumpVacB This is train B sampling pump vacuum, measured in inches mercury. Double 8 SampleRateA RF- This is the train A sampling rate, measured in the units of measure selected on the "Header Data" tab. Double 8 Req. Notes These are any observations or comments concerning the test run. Text 255 RunNumber RF- This is for the Run Number of the test. This number is assigned by the test company. Generally, the run number is an integer value which indicates the sequence order for the performance of the test method for the location. Text 20 Req. Location RF- This is the unique sampling location name, such as inlet, stack, ESP inlet, scrubber outlet, etc. which was provided during the Test Plan preparation. Text 50 Req. JobNumber This is the contractor's project or job number. Used with the spreadsheet import. Text 25 EndTime RF- This is the number of minutes of cumulative sampling time at the end of sampling at the sample point. Double 8 Req. TrapTempB This is the temperature of the sampling trap B, degrees F. Double 8 RunDate RF- This is the date that the test was performaned. Date/Time 8 Req. Clock This is the actual local clock time at the start of sampling at a point. Date/Time 8 ProbeTempB This is the temperature of the sampling probe B, degrees F. Double 8 ProbeTempA This is the temperature of the sampling probe A, degrees F. Double 8 StackTempB RF- This is the train B measured stack temperature of the effluent gas at the sampling point and is expressed as degrees F. The values in the stack temp are used in subsequent calculations. Double 8 Req. StackTempA RF- This is the train A measured stack temperature of the effluent gas at the sampling point and is expressed as degrees F. The values in the stack temp are used in subsequent calculations. Double 8 Req. Page 18 of 54 ------- Table Name: tblRunPoints30B Table Description: Method 30 B Point Run Data Field Name Field Description Field Type Size Key Required OrificePresActual Orifice pressure actually sampled or reached, measured in inches of water. The values in the "Orifice Pressure Actual" are used in subsequent calculations. Double 8 OrificePresDesired This is the orifice pressure setting required for sampling isokinetically, measured by inches water. Double 8 Velocity This is the velocity pressure (Ap) expressed in inches of water. Values in "AP" are used in the calculation of isokinetics, average delta p, velocity of gas stream and actual and standard stack gas flow. Double 8 GasMeterB RF- The dry gas meter B volume reading at the beginning (or end) of the sampling at a point. This means that the final (or initial) volume reading is recorded in a row without a point label and no other recorded point data. Double 8 Req. Point RF- This is the sampling point label used by the test company, such as Al, A-l, D-2, etc. Text 8 Req. BeginTime This is the number of minutes of cumulative sampling time prior to the beginning of sampling at the sample point. Double 8 GasMeterA RF- The dry gas meter A volume reading at the beginning (or end) of the sampling at a point. This means that the final (or initial) volume reading is recorded in a row without a point label and no other recorded point data. Double 8 Req. TrapTempA This is the temperature of sampling trap A, degrees F. Double 8 Table Name: tblRunLab30B Table Description: Method 30 B Lab Data Field Name Field Description Field Type Size Key Required AM If This is used to enter an aggregate Hg Mass. Totals to AMI. Double 8 AMle This is used to enter an aggregate Hg Mass. Totals to AMI. Double 8 AMlc This is used to enter an aggregate Hg Mass. Totals to AMI. Double 8 BMlh This is used to enter an aggregate Hg Mass. Totals to BM1. Double 8 Page 19 of 54 ------- Table Name: tblRunLab30B Table Description: Method 30 B Lab Data Field Name Field Description Field Type Size Key Required AMlg This is used to enter an aggregate Hg Mass. Totals to AMI. Double 8 BSpikePen This is for backward compatibility... this field is not used. Yes/No 1 BMlf This is used to enter an aggregate Hg Mass. Totals to BM1. Double 8 AMla This is used to enter an aggregate Hg Mass. Totals to AMI. Double 8 AMlh This is used to enter an aggregate Hg Mass. Totals to AMI. Double 8 BMla This is used to enter an aggregate Hg Mass. Totals to BM1. Double 8 BMlb This is used to enter an aggregate Hg Mass. Totals to BM1. Double 8 BMlc This is used to enter an aggregate Hg Mass. Totals to BM1. Double 8 BMle This is used to enter an aggregate Hg Mass. Totals to BM1. Double 8 BMlg This is used to enter an aggregate Hg Mass. Totals to BM1. Double 8 AMlb This is used to enter an aggregate Hg Mass. Totals to AMI. Double 8 BBreakthroughPen This is for backward compatilbility... this field is not used. Yes/No 1 BMld This is used to enter an aggregate Hg Mass. Totals to BM1. Double 8 Location PK-This is the unique sampling location name, such as inlet, stack, ESP inlet, scrubber outlet, etc. which was provided during the Test Plan preparation. Text 50 Primary BM3 This is the mass determined by the analysis of the third section of sorbent trap B. The units of measure displayed after the entry fields are the units selected on the "Header Data" screen. Currently the ERT does not accommodate a three part trap. Double 8 PlantID FK- This field is not used. Text 50 Foreign Page 20 of 54 ------- Table Name: tblRunLab30B Table Description: Method 30 B Lab Data Field Name Field Description Field Type Size Key Required Method PK- The field identifies the method used to measure the analyte emissions. The test method was one of the user selected isokinetic or manual sampling methods which were entered in Item 2a of the Test Plan. Text 50 Primary RunNumber PK- This is for the Run Number of the test. This number is assigned by the test company. Generally, the run number is an integer value which indicates the sequence order for the performance of the test method for the location. Text 50 Primary RunDate PK- This is the date that the test was performaned. Date/Time 8 Primary ATrapID This is the alphanumeric code for trap A as required by section 6.1.1 of Method 30B which uniquely identifies a cartridge or sleeve containing a sorbent media with two sections separated by an inert material. Text 50 AMI This is the mass determined by the analysis of the first section of sorbent trap A and the inert separation material. The units of measure displayed after the date entry fields are the units selected on the paired train "Header Data" screen. Double 8 AM2 This is the mass determined by the analysis of the second section of sorbent trap A. The units of measure displayed after the entry fields are the units selected on the "Header Data" screen. Double 8 BMS This is the mass which was spiked (added) to "Section 1" of one of the pairs of traps used for the Field Recovery Test. If the B train of this run was spiked, it would have a value entered. Double 8 AM3 This is the mass determined by the analysis of the third section of sorbent trap A. The units of measure displayed after the entry fields are the units selected on the "Header Data" screen. Currently the ERT does not accommodate a three part trap. Double 8 ABreakthroughPen This is for backward compatilbility... this field is not used. Yes/No 1 ASpikePen This is for backward compatilbility... this field is not used. Yes/No 1 BTrapID This is the alphanumeric code for trap B as required by section 6.1.1 of Method 30B which uniquely identifies a cartridge or sleeve containing a sorbent media with two sections separated by an inert material. Text 50 Page 21 of 54 ------- Table Name: tblRunLab30B Table Description: Method 30 B Lab Data Field Name Field Description Field Type Size Key Required BM1 This is the mass determined by the analysis of the first section of sorbent trap B and the inert separation material. The units of measure displayed after the date entry fields are the units selected on the paired train "Header Data" screen. Double 8 BM2 This is the mass determined by the analysis of the second section of sorbent trap B. The units of measure displayed after the entry fields are the units selected on the "Header Data" screen. Double 8 AMS This is the mass which was spiked (added) to "Section 1" of one of the pairs of traps used for the Field Recovery Test. If the A train of this run was spiked, it would have a value entered. Double 8 AMld This is used to enter an aggregate Hg Mass. Totals to AMI. Double 8 Table Name: tbIRunDatalTM Table Description: Instrumental Methods Run Data Field Name Field Description Field Type Size Key Required FuelType This is a pull-down selection of the Fuel Type which also populates the three F-factor fields FdHDR, FwHDR and FcHDR with the values presented in Table 19-2 of EPA Method 19. In addition, the user may select "Override" and enter fuel specific F- factors. Text 50 CgasUnits This is the measurment units (typically the same as the measured units but corrected to dry conditions). Text 50 Cgas This is the calculated emissions concentration corrected for bias and drift and in the proper measurement units. Double 8 Cavg Units This is the measurement units (ppmvd, ppmvw, ppbvd, %vd, %vw etc.) for Cavg. Text 50 Cavg This is the Average concentration from the instrumant during the test run. Double 8 CalPostH Drift This is a value calculated by the ERT and is the post run calibration high level system drift. Double 8 CalPostHSysBias This is a value calculated by the ERT and is the post run calibration high level system bias. Double 8 Page 22 of 54 ------- Table Name: tbIRunDatalTM Table Description: Instrumental Methods Run Data Field Name Field Description Field Type Size Key Required CalPostHRV This is the post run calibration high level results value and is the instrument response when challenged with the high level gas. Double 8 CalPostHCyllD Cylinder identification number on the gas cylinder for the post run high level calibration gas. This is populated by selecting the previously entered information from a drop down menu of the calibration cylinder informaion entered in the Test Plan. Text 50 CalPostZSysBias This is a value calculated by the ERT and is the post run calibration zero bias. Double 8 CalPostZRV This is the post run calibration Zero Results Value and is the instrument response when challenged with the zero gas. Double 8 Fd The value "Fd" is the ratio of the quantity of dry effluent gas generated by combustion to the gross calorific value of the fuel. With oxygen concentration, the emission rate in Ib/MMBtu can be calculated from the dry pollutant emissions concentration. Long Integer 4 CEMSLbMMBTU This is the facilities as indicated CEMS value recorded in pounds per million British Thermal Units (BTU) and for the same time period as performed by the instrumental test method. Added 3/12 Double 8 CalPostZDrift This is a value calculated by the ERT and is the post run calibration zero drift. Double 8 CEMSLbHR This is the facilities indicated CEMS value recorded in pounds per hour units and for the same time period as performed by the instrumental test method. Added 3/12 Double 8 CEMS02Corr This is the facilities recorded 02 correction perc Double 8 Exclude This is a check box for the user to indicate that the test run is to be excluded from the Performance Specification Test (PST) Relative Accuracy Test Assessment (RATA) calculation. Yes/No 1 ProcRunID This is a drop down menu selection of the Process run ID documenting the process rate during the same time measurements for the reference test method. Process based emissions are the test method emission rate divided by the associated process rate. Text 50 Page 23 of 54 ------- Table Name: tbIRunDatalTM Table Description: Instrumental Methods Run Data Field Name Field Description Field Type Size Key Required MMBTUHrCERMS This is the facilities indicated CEMS fuel combustion rate in British Thermal Units (BTU) per hour and for the same time period as performed by the instrumental test method. Added 5/11 Double 8 FlowCERMS This is the facilities as measured CEMS stack gas flow value recorded in the same units and for the same time period as performed by the instrumental test method. Added 5/11 Double 8 CEMSPPM This is the facilities as measured CEMS value recorded in parts per million (PPM) units and for the same time period as performed by the instrumental test method. Added 3/12 Double 8 CalPreHCyllD Cylinder identification number on the gas cylinder for the pre run high level calibration gas. This is populated by selecting the previously entered information from a drop down menu of the calibration cylinder informaion entered in the Test Plan. Text 50 Fw The value "Fw" is the ratio of the quantity of wet effluent gas generated by combustion to the gross calorific value of the fuel. With wet oxygen and moisture concentration, the emission rate in Ib/MMBtu can be calculated. Long Integer 4 CalPostZCyllD Cylinder identification number on the gas cylinder for the post run zero calibration gas. This is populated by selecting the previously entered information from a drop down menu showing calibration cylinder informaion entered in the Test Plan. Text 50 RunStatus added 3/6/07 - Accepted/Rejected Text 20 CgaswUnits This is the measurment units (typically the same as the measured units but wet concentration basis). Text 50 Cgasw This is the calculated emissions concentration corrected for bias and drift but on a wet basis. Double 8 Fo This is the Fo and is the ratio of excess Oxygen and Carbon Dioxide. Calculation uses (20.9 - %02)/%C02. calc'd (20.9 - %02)/%C02 Double 8 Fc The value "Fc" is the ratio of the theoretical carbon dioxide produced during combustion to the higher heating value of the fuel combusted. With carbon dioxide, the emission rate in Ib/MMBtu can be calculated from wet or dry emissions concentration. Long Integer 4 CEMSValue This is the facilities indicated CEMS value Double 8 Page 24 of 54 ------- Table Name: tbIRunDatalTM Table Description: Instrumental Methods Run Data Field Name Field Description Field Type Size Key Required FlowRateRunID This is a drop down menu to select the method for determining the stack flow rate. Available selections include using data from a manual test method or allowing manually entered data by the user. Text 50 Location PK-This is the unique sampling location name, such as inlet, stack, ESP inlet, scrubber outlet, etc. which was provided during the Test Plan preparation. Text 50 Primary Method PK- The field identifies the method used to measure the analyte emissions. The test method was one of the user selected isokinetic or manual sampling methods which were entered in Item 2a of the Test Plan. Text 50 Primary Run PK- This is for the Run Number of the test. This number is assigned by the test company. Generally, the run number is an integer value which indicates the sequence order for the performance of the test method for the location. Text 50 Primary RunDate This is the date that the test was performaned. Date/Time 8 StartTime Hour-minute-second AM/PM that run was performed. Time can be entered as 24 hour time or 12 hour time with the AM/PM extension and the time will revert to the latter time format. Date/Time 8 CalPreHSysBias This is a value calculated by the ERT and is the pre run calibration high level bias. Double 8 Qsd This is the calculated stack flow in dscfm based upon the method selected in FlowRateRunID. If the user selected "User Entered" the value is the number entered. Double 8 CalPreHDrift Drift in Percent Double 8 MoisturePerc The moisture percent of the gas stream tested. The pull-down to the right of the field for the moisture provides access to the results of instrumental measurements of moisture. Double 8 MoistureRunID This is the run ID of method used for moisture (if pulled from that method) Text 50 PercC02 The carbon dioxide percent of the gas stream tested. The pull-down to the right of the field for the C02 concentration provides access to the results of instrumental measurements of C02. Double 8 C02RunlD This is the run ID of method used for C02 (if pulled from that method) Text 50 Page 25 of 54 ------- Table Name: tbIRunDatalTM Table Description: Instrumental Methods Run Data Field Name Field Description Field Type Size Key Required Perc02 The oxygen percent of the gas stream tested. The pull-down to the right of the field for the 02 concentration provides access to the results of instrumental measurements of 02. Double 8 CalPreZCyllD Cylinder identification number on the gas cylinder for the pre run zero calibration gas. This is populated by selecting the previously entered information from a drop down menu showing calibration cylinder informaion entered in the Test Plan. Text 50 EndTime Hour-minute-second AM/PM that run was completed. Time can be entered as 24 hour time or 12 hour time with the AM/MP extension and the time will revert to the latter time format. Date/Time 8 02RunlD This is the run ID of method used for 02 (if pulled from that method) Text 50 CalPreZDrift Drift in Percent Double 8 CalPreZRV This is the pre run calibration Zero Results Value and is the instrument response when challenged with the zero gas. Double 8 CalPreHRV This is the pre run calibration high results value and is the instrument response when challenged with the high level gas. Double 8 CalSet The number assigned to the set of readings. The number used to associate this data to the data entered in "Calibrations" tab Long Integer 4 Timelnterval This is the time interval between readings. Text 50 Readings This is the number of readings or average number of readings for the Time Interval specified in Timelnterval. Long Integer 4 OperUnits This is the units used for the operating range. Text 25 OperRange This is the acceptable operating range or fluctuation of concentrations for the analytes being measured. Double 8 AnalyzerSN This is the serial numbet of the Instrument Analyzer. Text 50 AnalyzerModel This is the Instrument Analyzer Model. Text 50 AnalyzerMake This is the Instrument Analyzer Make. Text 50 CalPreZSysBias This is a value calculated by the ERT and is the pre run calibration zero level system bias. Double 8 Page 26 of 54 ------- Table Name: tbIRunDatalTM Table Description: Instrumental Methods Run Data Field Name Field Description Field Type Size Key Required Table Name: tbICals Table Description: Instrument Methods Calibration Data Field Name Field Description Field Type Size Key Required DZError This is a value calculated by the ERT and is the Direct zero level calibration Error Text 50 DHCyllD Cylinder identification number on the gas cylinder for the high calibration gas. This is populated by selecting the previously entered information from a drop down menu showing all the calibration cylinder informaion originaly entered in the Test Plan. Text 50 DMCyllD Cylinder identification number on the gas cylinder for the mid calibration gas. This is populated by selecting the previously entered information from a drop down menu showing all the calibration cylinder informaion originaly entered in the Test Plan. Text 50 DIError This is a value calculated by the ERT and is the Direct low level calibration Error Text 50 DLRV This is the Direct Low Level Results Value and is the instrument response when challenged with the low level calibration gas. Double 8 DLCyllD Cylinder identification number on the gas cylinder for the low calibration gas. This is populated by selecting the previously entered information from a drop down menu showing all the calibration cylinder informaion originaly entered in the Test Plan. Text 50 DZRV This is the Direct Zero Results Value and is the instrument response when challenged with the zero gas. Double 8 DZCyllD Cylinder identification number on the gas cylinder for the zero calibration gas. This is populated by selecting the previously entered information from a drop down menu showing all the calibration cylinder informaion originaly entered in the Test Plan. Text 50 Span Calibration Span for this set Double 8 Set PK- The number assigned by the user to the set of readings. The number is used to associate this data to the run calibration data. Long Integer 4 Primary Page 27 of 54 ------- Table Name: tbICals Table Description: Instrument Methods Calibration Data Field Name Field Description Field Type Size Key Required Method PK- The field identifies the method used to measure the analyte emissions. The test method was one of the user selected isokinetic or manual sampling methods which were entered in Item 2a of the Test Plan. Text 50 Primary DMError This is a value calculated by the ERT and is the Direct mid level calibration Error Text 50 Location PK-This is the unique sampling location name, such as inlet, stack, ESP inlet, scrubber outlet, etc. which was provided during the Test Plan preparation. Text 50 Primary DHRV This is the Direct High Level Results Value and is the instrument response when challenged with the high level calibration gas. Double 8 DHError This is a value calculated by the ERT and is the Direct high level calibration Error Text 50 SZCyllD Cylinder identification number on the gas cylinder for the zero calibration gas. This is populated by selecting the previously entered information from a drop down menu showing all the calibration cylinder informaion originaly entered in the Test Plan. Text 50 SZRV This is the System Zero Results Value and is the instrument response when challenged with the zero gas. Double 8 SZError This is a value calculated by the ERT and is the system zero level calibration Error Text 50 SHCyllD Cylinder identification number on the gas cylinder for the high calibration gas. This is populated by selecting the previously entered information from a drop down menu showing all the calibration cylinder informaion originaly entered in the Test Plan. Text 50 SHRV This is the System High Level Results Value and is the instrument response when challenged with the high level calibration gas. Double 8 SHError This is a value calculated by the ERT and is the system high level calibration Error Text 50 DMRV This is the Direct Mid Level Results Value and is the instrument response when challenged with the mid level calibration gas. Double 8 Page 28 of 54 ------- Table Name: tbIPSTCals Table Description: Performance Standard Test Calibration Drift Data Field Name Field Description Field Type Size Key Required Location PK- This identifies the test location for the calibration drift data. Text 50 Primary High This is the high value for the calibration for the day. Double 8 Low This is the low value for the calibration for the day. Double 8 Method PK- This identifies the test method for the calibration drift data. Text 50 Primary Day PK- This identifies the day sequence for the calibration drift data. Long Integer 4 Primary Table Name: tbIPSTHeader Table Description: Performance Standard Test Header Data Field Name Field Description Field Type Size Key Required PPMvStandard If specified in the applicable regulation, this is the emission limit in units of actual parts per million (PPM) by volume. Double 8 Lb/Hr This is the ERT calculated emissions in pounds per hour for the concurent time period of the CEMS run. Double 8 Lb/MMBTU This is the ERT calculated emissions in pounds per million BTU for the concurent time period of the CEMS run. Double 8 Lb/MMBTUStandard If specified in the applicable regulation, this is the emission limit in units of pounds per million BTU. Double 8 Lb/HrStandard If specified in the applicable regulation, this is the emission limit in units of pounds per hour. Double 8 PPM@02Corr If specified in the applicable regulation, this is the emission limit in units of parts per million (PPM) by volume corrected to the 02 concentration required by the emission standard. Double 8 02Corr If specified in the applicable regulation, this is the oxygen concentration for correcting the actual measured concentration. Double 8 RAStartDate This is the start date for the calibration drift test. Date/Time 8 CDEndDate This is the end date for the calibration drift test. Date/Time 8 HighCal This is the high calibration value for the CEMS instrument. Double 8 LoCal This is the low calibration value for the CEMS instrument. Double 8 Page 29 of 54 ------- Table Name: tbIPSTHeader Table Description: Performance Standard Test Header Data Field Name Field Description Field Type Size Key Required Span This is the span for the CEMS instrument. Double 8 Method PK- This the reference test method used to assess the relative accuracy of the CEMS. Text 50 Primary mmBTUTollse This can be "C02" or "02" and determines which one is used for the calculations. Text 3 Location PK- This is the test location for the reference test method used to assess the relative accuracy of the CEMS. Text 50 Primary RAEndDate This is the end date for the relative accuracy test audit evaluation. Date/Time 8 Table Name: tbITestPlan Table Description: Test Plan Data Field Name Field Description Field Type Size Key Required TestRepEmail This is the email of the test company representative that reviewed the test plan. Added 1/30/12 Text 255 TestSchedule This field is a text field for the test company or the source to advise the regulatory agency of the proposed schedulet for the performance test. Memo 0 Comments This field is a text field for the test company or the source to provide additional inforamtion on details of the test program. Memo 0 FacRepName The person authorized to represent the facility being tested that reviewed the test plan or report. Text 50 FacRepEmail This is the email of the Facility representative that reviewed the test plan. Added 1/30/12 Text 255 FacRepTitle The corporate title of the person authorized to represent the facility being tested. Text 50 FacRepCompany The public or commercial name of the company owning the facility (i.e., the full name that commonly appears on invoices, signs, or other business documents). Text 50 CalibGasConcSummar y This is used for backward compatibility with old project data sets and is not used now. Memo 0 TestRepName The person in the test company that reviewed the source test plan or report. Text 50 Page 30 of 54 ------- Table Name: tbITestPlan Table Description: Test Plan Data Field Name Field Description Field Type Size Key Required EPASampleAuditDesc This is used for backward compatibility with old project data sets and is not used now. Memo 0 TestRepTitle The corporate title of the person in the test company that reviewed the source test plan or report. Text 50 TestRepCompany The public or commercial name of the test company that commonly appears on invoices, signs or other business documents. Text 50 FacRepSignDate The date that the authorized person reviewed the test plan or report. Date/Time 8 DilutionProposedYN This is a set of check boxes indicating if a Method 205 dilution system for calibration gases will be used. l=Yes, 2=No, 3=NA Text 1 CalibGasCertProcedur e The text box contains an explanation for any negative response or supplementary detail for certification per EPA Traceability Protocol procedures. Memo 0 CalibGasCertifiedYN This checkbox indicates whether or not all calibration gases have a valid certification per EPA Traceability Protocol procedures. l=Yes, 2=No, 3=NA Text 1 EqupCalibrationYN This checkbox indicates whether or not all testing equipment been calibrated within the past 12 months. Yes/No 1 EPASampleAuditYN This checkbox indicates whether or not audit samples are required. Yes/No 1 OxygenConcDet3or3a This is a drop down menu to select the method used to determine the gas molecular weight, oxygen concentration or carbon dioxide concentration. Selection options include Method 3 or Method 3A Text 40 OxygenConcDetYN This is used for backward compatibility with old project data sets and is not used now. Yes/No 1 CyclonicFlowDesc This field is for summary information on the documentation of the presence or absence of cyclonic flow and what the test company did to correct the issues that precludes collecting a represenative sampld. Memo 0 CyclonicFlowYN This field is for the user to indicate the availability of documentation on the presence or absence of cyclonic flow. Yes/No 1 Page 31 of 54 ------- Table Name: tbITestPlan Table Description: Test Plan Data Field Name Field Description Field Type Size Key Required MeetMinReq This field is for the user to explain why the methods used at the sampling location provide a representative sample and document any approval, as applicable. Memo 0 MeetMinReqYN This checkbox indicates whether the test location meets Method 1 criteria. Yes/No 1 TestRepSignDate The date that the authorized person for the test company reviewed the test plan or report. Date/Time 8 HrsPerYear Normal hours the facility operates in a year. Added 6/8/2011 Long Integer 4 EquipCalibrationDesc The text box contains an explanation for any negative response for equipment not being calibrated within 12 months.. Memo 0 TRTestRepTitle This is the title of the Test Companies Representative that performed the Final Test Report Verification. Added 9/20/05 Text 50 PDSiDDate This is the date which the PDS ID was originally assigned to this file. Added 4/14 Date/Time 8 PDSiD This is an alphanumeric value assigned by the ERT to provide a unique indicator for this electronic report to differentiate this report from all other submitted reports. Added 4/14 Text 40 OpenExpandedQAQ This is a check box field which is used to open the visible Completeness and Quality Assessment Review pages to full screen or the colapse it to a smaller size. Added 3/20/13 Yes/No 1 OpenExpandedPD This is a check box field which is used to open the visible process data entry page to full screen or the colapse it to a smaller size. Added 3/13/13 Yes/No 1 OpenExpandedTR This is a check box field which is used to open the visible regulatory agency test report review page to full screen or the colapse it to a smaller size. Added 3/1/13 Yes/No 1 OpenExpandedSA This is a check box field which is used to open the visible test plan review page to full screen or the colapse it to a smaller size. Added 2/21/13 Yes/No 1 OpenExpandedRun This is a check box field which is used to open the visible run data page to full screen or the colapse it to a smaller size. Added 2/21/13 Yes/No 1 OpenExpanded This is a check box field which is used to open the test plan visible page to full screen or the colapse it to a smaller size. Added 2/19/13 Yes/No 1 Page 32 of 54 ------- Table Name: tbITestPlan Table Description: Test Plan Data Field Name Field Description Field Type Size Key Required TestCoProjNum The assigned project number for the testing project by the test. Added 10/19/11 - nj request Text 25 StateFacID The state identification number as provided by a state air pollution control agency. Added 10/19/11 - nj request Text 25 RATA This is a checkbox indicating that the purpose of the test was to satisfy a regulatory requirement to perform a Relative Accuracy Test Audit comparing installed Continuous Emissions Monitiring results with results of a reference test method. Yes/No 1 TRTestRepSignDate This is the date that the Test Companies Representative performed the Final Test Report Verification. Added 9/20/05 Date/Time 8 TestlnAccordanceDes c This field is for summary details about the test method used which are not readily available. Information included include modifications and/or alternative methods used. Attachments with greater detail are suggested to supplement the summary informaion. Memo 0 PPE This field is a text field for the test company or the source to provide inforamtion on details of the personal protective equipment that would be needed for the test program. Memo 0 TRTestRepCompany This is the name of the Company that employs the Test Companies Representitive that performed the Final Test Report Verification. Added 9/20/05 Text 50 TRTestRepEMail This is the email address of the Test Companies Representitive that performed the Final Test Report Verification. Added 1/30/12 Text 50 TRTestRepName This is the name of the Test Companies Representative that performed the Final Test Report Verification. Added 9/20/05 Text 50 TRFacRepSignDate This is the date that the Permitted Facilities Representative performed the Final Test Report review and verified that the report was true, accurate and complete. Added 9/20/05 Date/Time 8 TRFacRepTitle This is the title of the Permitted Facilities Representative that performed the Final Test Report Verification. Added 9/20/05 Text 50 TRFacRepCompany This is the name of the Company that employs the Permitted Facilities Representitive that performed the Final Test Report Verification. Added 9/20/05 Text 50 Page 33 of 54 ------- Table Name: tbITestPlan Table Description: Test Plan Data Field Name Field Description Field Type Size Key Required TRFacRepEmail This is the email address of the Permitted Facilities Representative that performed the Final Test Report Verification. Added 1/30/12 Text 50 TRFacRepName This is the name of the Permitted Facilities Representative that performed the Final Test Report review and verified that the report was true, accurate and complete. Added 9/20/05 Text 50 AFSid EPA AIRS Facility System (AFS) number, added 9/8/05 Text 25 TesterComments This is used for backward compatibility with old project data sets and is not used now. Memo 0 AgencyComments This is used for backward compatibility with old project data sets and is not used now. Memo 0 see RF-The eight digit Source Classification Code (SCC) is selected through the use of the "Select SCC from list" button. Added 1/19/06 Text 11 Req. FacZip RF- The mailing zip code in which the facility resides. Text 50 Req. TestCoCity RF- The state in which the source test company resides. Text 50 Req. TestCoAddress2 This is the continuation line for the physical address of the test company. Text 50 TestCoAddressl RF- The standard address used to send mail to an individual with the source test company. Text 50 Req. TestCoAddressFull This is used for backward compatibility with old project data sets and is not used now. Memo 0 TestCoName RF- The public or commercial name that commonly appears on invoices, signs or other business documents. Text 50 Req. TestlnAccordanceYN This is used for backward compatibility with old project data sets and is not used now. Yes/No 1 FacLatitude RF- Latitude of emission release point (typically the stack), with a minimum of 5 decimal places. Text 50 Req. ApplRegs This is used for backward compatibility with old project data sets and is not used now. Memo 0 FaclndustryType North American Industry Classification System numerical identifier. The digits designate the economic sector, the subsector, the industry group, the NAICS industry, and the national industry. Text 100 Page 34 of 54 ------- Table Name: tbITestPlan Table Description: Test Plan Data Field Name Field Description Field Type Size Key Required FacEmail RF- A working email address of the contact which can be used to assist the reviewers. Text 50 Req. FacFax The facsimile number of the facility through which the contact can assist the reviewers. Text 50 TestCoState RF- The two letter state and mailing zip code of the source test company. Text 50 Req. FacPOC RF- The person with knowledge of the facility's operations during the test program who can assist reviewers of the test plan or test report if they have questions. Text 50 Req. FacLongitude RF- Longitude of emission release point (typically the stack), with a minimum of 5 decimal places. Text 50 Req. FacState RF- The two letter state and mailing zip code in which the facility resides. Use the drop down menu to select the two letter postal code for the State. Text 50 Req. FacCounty RF- The county or parish in which the facility is located. Use the drop down menu to select the county. These will be available after the postal code for the State is selected. Added 1/30/12 Text 50 Req. FacCity RF- The city in which the facility resides. Text 50 Req. FacAddress2 This is the continuation line for the physical address of the facility. Text 50 FacAddressl RF- The address that describes the physical (geographical) location of the front door or main entrance of a facility site, including urban-style street address or rural address. Text 50 Req. FacAddressFull This is used for backward compatibility with old project data sets and is not used now. Memo 0 FacName RF- The public or commercial name of the facility site (i.e., the full name that commonly appears on invoices, signs, or other business documents). Text 50 Req. TestPlanTitle RF- This is the title chosen by the test company or tested facility for the test program. Text 100 Req. TestPlanDate RF- The date which the test report was initially created. This date may be associated with the test plan preparation. Date/Time 8 Req. TestPlanNumber This field is for backwards compatibility and is not used now. Text 50 TestPlanID PK- This is a unique ID for the Testplan record. AutoNumber 4 Primary Page 35 of 54 ------- Table Name: tbITestPlan Table Description: Test Plan Data Field Name Field Description Field Type Size Key Required FacPhone RF- The phone number of the contact or the facility. Text 50 Req. Sectionll4 This is a checkbox indicating that the purpose of the test was to satisfy a requirement under Section 114 of the Clean Air Act to perform the emission test. Yes/No 1 SampLocDesc This is used for backward compatibility with old project data sets and is not used now. Memo 0 SourceDesc In this text box the user provides a summary description of the source, a description of the control equipment. Memo 0 HowDataDocumented This is used for backward compatibility with old project data sets and is not used now. Memo 0 OtherRegPurposeDes c List the secondary reasons for performing this emissions test. Memo 0 FINS RF- EPA Facility Registry System number (FRS) is a twelve digit number. The FRS number is a centrally managed database that identifies facilities, sites or places subject to environmental regulations or of environmental interest. Text 50 Req. TestCoZip RF- The mailing zip code of the source test company. Text 50 Req. StateRule This is a checkbox indicating that the purpose of the test was to satisfy a regulatory emission limit requirement in a State Rule. Yes/No 1 TestPurpose This text box is to provide additional information on the purpose for the test. The text box may also contain information on those pollutants that are of primary interest, DQO's, DQI's, and criteria to determine if the test program met the DQO's. Memo 0 SIP This is a checkbox indicating that the purpose of the test was to satisfy a regulatory emission limit requirement in a State Implementation Plan. Yes/No 1 NSRPSD This is a checkbox indicating that the purpose of the test was to satisfy a regulatory emission limit requirement in a New Source Review or Prevention of Significand Deterioration Permit. Yes/No 1 Part65 This is a checkbox indicating that the purpose of the test was to satisfy a regulatory emission limit requirement in 40CFR Part 65. Yes/No 1 Part63 This is a checkbox indicating that the purpose of the test was to satisfy a regulatory emission limit requirement in 40CFR Part 63. Yes/No 1 Page 36 of 54 ------- Table Name: tbITestPlan Table Description: Test Plan Data Field Name Field Description Field Type Size Key Required Test Co Fax RF- The facsimile number of the source test company through which the contact can assist the reviewers. Text 50 Req. TestCoPOC RF-The person with knowledge of the design and conduct of the source test program. Text 50 Req. Other This is a checkbox indicating that there was some other purpose for the test than one of the other check boxes. Yes/No 1 TestCoPhone RF- The phone number of the source test company through which the contact can assist the reviewers. Text 50 Req. Part61 This is a checkbox indicating that the purpose of the test was to satisfy a regulatory emission limit requirement in 40CFR Part 61. Yes/No 1 TestCoEmail RF- A working email address through which the contact can assist the reviewers. Text 50 Req. AirPermitNumber State or Federal Permit Number. Text 50 Part60 This is a checkbox indicating that the purpose of the test was to satisfy a regulatory emission limit requirement in 40CFR Part 60. Yes/No 1 PermittedSourcelD This is the official State ID number of the emission source as listed in the Title 5 permit. Many state and local agencies have alphanumeric identifiers for individual process operating units with an associated name describing the unit. Text 50 PermittedMaxProcess Rate Permitted Maximum Process Rate as listed in Title V or state permit. Text 50 MaxNormalOpRate Maximum Normal Operation Process Rate as listed in Title V or state permit. Text 50 TargetProcessTestRat e Value of the target process rate for the test program. Text 50 PermittedSourceNam e This is the official name of the emission source as listed in the Title 5 permit. Many state and local agencies have alphanumeric identifiers for individual process operating units with an associated name describing the unit. Text 50 Page 37 of 54 ------- Table Name: tbIEmisConcs Table Description: Emission Concentrations selected for this test Field Name Field Description Field Type Size Key Required Method PK- This is the test method at this test location that the emission concentratio indicated in this record is to be applied. Text 50 Primary ProcessUnits This is the units associated with the process parameter. It is typically a mass value per unit of time. The user has been advised that the time unit must be the same as the time unit for the calculated emission rate. Text 50 ProcessParam This is the Process Parameter selected by the user when a process based emission is to be calculated. A process parameter is selected only in conjunction with an emission rate (i.e. Ib/hr or grams/minute). Text 75 ProcessParamID FK-This is the process parameter Foreign Key which is to be used to generate a process based emission value. This process parameter is associated with an emission rate with the same time denominator as the one used for the process parameter. Long Integer 4 Foreign CorrPerc PK- This is the oxygen or carbon dioxide concentration value to which the concentration is to be corrected for air dilution. Double 8 Primary Location PK- This is the test location that the emission concentration indicated in this record.is to be applied. Text 50 Primary EmisConc PK- This is the basic units of measurement (emission or Concentration) to be applied to the test method at the test location specified in this record. Text 50 Primary CorrAnal PK- This is the compound (02 or C02) which should be used to correct for dilution with air the basic emission concentration indicated in this record. Text 5 Primary Table Name: tbILocation Table Description: Sample Locations selected for this test Field Name Field Description Field Type Size Key Required ACFM This is an estimated volume rate (cubic feet per minute) of the stack gas. This value is used in the Test Plan Review to assess the proposed sampling volume, time and analytical finish. Long Integer 4 Page 38 of 54 ------- Table Name: tbILocation Table Description: Sample Locations selected for this test Field Name Field Description Field Type Size Key Required VdwnStreamDist For ducts less than 12 inches in diameter, this is the distance in inches to the nearest downstream (toward the exit point or with the gas flow) disturbance in the gas flow. Long Integer 4 Controlled This check box field indicates whether this location is after a control device which would affect the emissions. Yes/No 1 AssumedMoisturePct This is an estimated moisture of the stack gas. This value is used in the Test Plan Review to assess the proposed sampling volume, time and analytical finish. Single 4 AssumedStack02Pct This is an estimated oxygen concentration of the stack gas. This value is used in the Test Plan Review to assess the proposed sampling volume, time and analytical finish. Single 4 InletOutlet This check box field indicates whether this location is before or after a control device which would affect the emissions. Text 50 NPTraverse This check box field indicates whether the sampling methodologies used for this test location are for a pollutant that is particulate form or is a gas or vapor form. Yes/No 1 VUpStreamDist For ducts less than 12 inches in diameter, this is the distance in inches to the nearest upstream (toward the emission source or counter to the gas flow) disturbance in the gas flow. Long Integer 4 NumPoints This is the number of sample collection points. This value can be calculated by the ERT based upon the diameter (equivalent diameter), the upstream distance, the downstream distance and the type of traverse (particulate or non particulate). Long Integer 4 DuctDiam If the test location is a circular duct or stack, the tester or facility will provde the diameter of the duct in inches in this field. This field will be blank if the duct or stack is rectangular. Double 8 Temp This is an estimated temperature (F) of the stack gas. This value is used in the Test Plan Review to assess the proposed sampling volume, time and analytical finish. Long Integer 4 Location PK- RF- This is the name of the test location as entered by the source tester or facility Text 50 Primary Req. Page 39 of 54 ------- Table Name: tbILocation Table Description: Sample Locations selected for this test Field Name Field Description Field Type Size Key Required DuctLength If the test location is a rectangular duct or stack, the tester or facility will provde the length of the duct in inches in this field. This field will be blank if the duct or stack is circular. Double 8 DuctWidth If the test location is a rectangular duct or stack, the tester or facility will provde the width of the duct in inches in this field. This field will be blank if the duct or stack is circular. Double 8 EquivDiam If the test location is a rectangular duct or stack and both the duct length and width is available, the equivalent diameter of the duct will be calculated using equation Equation 1-1 in Section 12.2 of Method 1 and entered in this field. Double 8 UpStreamDist This is the distance in inches to the nearest upstream (toward the emission source or counter to the gas flow) disturbance in the gas flow. Double 8 NumTravPorts This is the number of access holes (Ports) in the duct or stack which are available to insert the sampling equipment. Long Integer 4 DwnStreamDist This is the distance in inches to the nearest downstream (toward the exit point or with the gas flow) disturbance in the gas flow. Double 8 TestPlanID FK- This number provides a link to tbltestplan. Long Integer 4 Foreign Table Name: tbIMethodParams Table Description: Methods and Target Parameters selected for this test Field Name Field Description Field Type Size Key Required Group 8/11/11 keeps islSO for custom methods Text 10 Comments This is a comment by the user on the proposed performance of the test method at the test location. Memo 0 Molwt This is the molecular weight of the custom pollutant identified by the user. This field was added 10/10/11. Double 8 CAS This is the CAS Registry Number provided by the user for custom pollutants.The number is a unique identifier assigned by Chemical Abstracts Service (CAS) to every chemical substance. It was added 8/5/11 Text 40 Page 40 of 54 ------- Table Name: tbIMethodParams Table Description: Methods and Target Parameters selected for this test Field Name Field Description Field Type Size Key Required LbHrLimit added 5/13/11 for outlet QA calculations -10/29/12 not used, now with emisconc Double 8 Compliance added 9/29/05 - Yes/No/Indeterminate - says if it demonstrates compliance or not Text 20 TestRunDuration This is the proposed sampling duration for the test method at the test location. Long Integer 4 NumTestRuns This is the number of test runs of the test method which are proposed for the test series at the test location. Long Integer 4 TestMethod PK- RF- This is the test method which will be used to quantify the target pollutant at the sample location. Text 50 Primary Req. TargetPoll PK- RF- This is the pollutants which is intended to be measured during the test program. Text 50 Primary Req. TestPlanID FK- This number provides a link to tbltestplan. Long Integer 4 Foreign Location PK- RF- This is the sample location as entered in the "Location" area of the test plan. Text 50 Primary Req. NumSampPoints This is the number of samplng points which were identified in the test plan sampling location page. Long Integer 4 Table Name: tbIProcessParams Table Description: Target Process Parameters selected for this test Field Name Field Description Field Type Size Key Required ACTION RF- This is the action performed on the process material (for example the term "Burned" in "Tons of Coal Burned per hour") Added 1/16/07 for EF factor Text 20 Req. UDesc This is user comments which are entered on the SCC selection tab. Added 1/23/06 How they came up with the U factor Memo 0 Poll Unit RF- This is the combination of the Pollutant Units of emission per Time Unit and is present only for Process Parameter ID number 1. Added 1/23/06 Text 25 Req. TimeUnit RF- This is the unit of time for the emissions measurement (for example the term "hour" in "Tons of Coal Burned per hour"). For consistency user is told to select the same process paramete time units as the calculated emission time units. Added 1/23/06 Text 25 Req. Page 41 of 54 ------- Table Name: tbIProcessParams Table Description: Target Process Parameters selected for this test Field Name Field Description Field Type Size Key Required POLLJJNIT RF- This is the mass units of measurement for the pollutant emissions. Added 1/16/07 for EF factor Text 10 Req. U added 1/23/06 +/- U factor This field does not appear in the current "Permit/SCC" tab of the Test Plan. Long Integer 4 MATERIAL RF- This is the name of the process material described in the parameter (for example the term "Coal" in "Tons of Coal Burned per hour"). Added 1/16/07 for EF factor Text 40 Req. TargetLow The Target Low is the lower bound value of the expected range for the Units of Measure of Process Parameter. Double 8 MEASURE RF- This is the process parameter measurement unit (eg. the term "Tons" in "Tons of Coal Burned per hour"). In an emission factor or a process based emission value, the measure rate is divided into the pollutant mass rate. Added 1/16/07 for EF factor Text 35 Req. ProcessParamID PK- This is the numerical sequence of the process parameters. The value 1 is assigned to the process parameter associated with the SCC. When the SCC has existing default parameters the parameters in the first record are set. AutoNumber 4 Primary comments This is user comments which are entered on the Process Parameter tab. Memo 0 TargetValue The Target Value is the upper bound value of the expected range for the Units of Measure of Process Parameter. Double 8 UOM This is the "Unit of Measure" for the Process Material. It is the combination of the "Measure" for the Process parameter (typically weight, energy or volume) per the a "Time Unit" (for example Tons per hour, cubic feet per hour). Text 50 Target Pa ram The Target Parameter is shown on the SCC selection tab and is the default denominator for the Emission Factor associated with the SCC. It is presented on the first line of the Process Data area as the combination of the Material and Action. Double 8 Name The Name is a concatenation of the Material and Action (for example Coal Burned) Text 75 TestPlanID FK- This number provides a link to tbltestplan. Long Integer 4 Foreign Page 42 of 54 ------- Table Name: tbIProcessParams Table Description: Target Process Parameters selected for this test Field Name Field Description Field Type Size Key Required see This is the SCC which is selected on the SCC tab from a multi stage drop down list and is only present for Process Parameter ID number 1. Added 1/23/06 Text 11 Table Name: tbIRegs Table Description: Regulatory Limit Data Field Name Field Description Field Type Size Key Required Compliance not used Text 25 ProcessUnits not used Text 50 ProcessParam not used Text 75 Part_SubPart This is text from a drop down list of 40CFR60 and 40CFR63 regulations. Text 30 ProcessParamID not used Long Integer 4 Limit This field is the numerical value for the regulatory limit for the compound and units of measure selected by the user. Double 8 RegDesc This is text provided by the user to describe either supplementary information providing more detail than the citation of the regulation or providing the regulatory citation and details of an applicable regulation for a non part 60 or 63 regulation. Text 150 Unit This is text from a drop down list of emissions units for compounds which were previously entered by the selection in the test methods and concentrations area. Text 50 Compound This is text from a drop down list of compounds which were previously entered by the selection in the test methods and concentrations area. Text 50 Table Name: tbIProcessLab Table Description: Process Parameter Lab Data Field Name Field Description Field Type Size Key Required ProcessLabID PK- This is the numerical identifier for the Process Lab Parameter. AutoNumber 4 Primary TestPlanID FK- This number provides a link to tbltestplan. Long Integer 4 Foreign Page 43 of 54 ------- Table Name: tbIProcessLab Table Description: Process Parameter Lab Data Field Name Field Description Field Type Size Key Required Name This is the name of the Process Lab Parameter Text 75 UOM This is the unit of measure for the parameter. Text 15 comments This is a comment on the process parameter or unit of measure. Memo 0 Table Name: tbIAPCDParams Table Description: Air Pollution Control Devices Field Name Field Description Field Type Size Key Required tbIAPCDParamID PK- This is the numerical identifier for this air pollution control device. AutoNumber 4 Primary ptb This is used for backward compatibility with old project data sets and is not used now. Text 50 comments This is a comment field for the user to provide more details on the design or operation of the air pollution control or the Target Parameter used to characterize the controls performance. Memo 0 TargetValue This is the pre test prospective value of the target parameter in the units of measure which is expected to be achieved during the emission test. Double 8 UOM This is the units of measure for the target parameter identified in UOM. Text 50 Target Pa ram This is the name of an operating parameter which provides an indication of the effectiveness of the operation of the identified control device. Double 8 TestPlanID FK- This number provides a link to tbltestplan. Long Integer 4 Foreign location FK- This is the test location which the named APDC is associated. Text 50 Foreign APCDName RF- This is the text identifier of one or more general installed air pollution control devices. The user may select one of the standard control devices in apptblContoEquip or another name of a control not on that list. Text 75 Req. Page 44 of 54 ------- Table Name: tbIAPCDRunData Table Description: Air Pollution Control Device run data Field Name Field Description Field Type Size Key Required Comment This is a text field for additional run specific information on the operation of the control device or the measured parameter value. Memo 0 Value This is the numerical value of the process variable identivied in tbIAPCDParams. Double 8 APCDParamID PK- This is the numerical identifier as indicated in tbIAPCDParams for this air pollution control device. It is a link to tbIAPCDParams Long Integer 4 Primary Run PK- This is the numerical identifier for the process run number for the measured value. The run numbers used would be associated with the test runs. Long Integer 4 Primary Table Name: tbIAttachments Table Description: Attached documents to support this test Field Name Field Description Field Type Size Key Required keep This is used for backward compatibility with old project data sets and is not used now. Yes/No 1 Attach ID PK- This is an ID number for the description of the attachments for the test report. Attachment ID numbers below 50 are used for established fixed documentation areas. Attachment ID numbers above 50 are supplementary types provided by the user. AutoNumber 4 Primary TestPlanID FK- This number provides a link to tbltestplan. Long Integer 4 Foreign Attach Desc This is a description of the type of documentation filed in the area covered by these attachments. Descriptions for ID numbers below 50 are set and not changeable. Text 120 Filename This is used for backward compatibility with old project data sets and is not used now. Text 100 xfile This field has an indicator of the number of attachments in this record. When selected, this field opens a menu which contains the names of the files that the user attached to the documentation area described in AttachDesc. Attachment 4 Page 45 of 54 ------- Table Name: tbICyllnv Table Description: Inventory of test gas cylinders Field Name Field Description Field Type Size Key Required CertDate This is the date which the gas provider certified the concentration of the gas contained in the cylinder. Date/Time 8 UncertainPercent This is the uncertainty associated with the certification value for the gas. It may be the required uncertainty for the specific procedure or a value assigned by the vendor. Double 8 CertValue This is the numerical value of the concentration of the gas contained in the cylinder. This value will be used by the ERT to compare with the measured values during calibration. Double 8 CertProcedure This is the certification procedure used by the gas provider to verify the concentration of the gas in the cylinder and indicated in the provided paperwork. Text 50 CylID PK- This is a unique identifier provided for the specific calibration gas cylinder and gas. EPA guidance is to use the cylinder ID on the gas certificate supplemented by the specific gas identifier for multicomponent gasses. Text 50 Primary ExpDate This is the date which the certification expires on the certificate of the concentration of the gas contained in the cylinder. Date/Time 8 Compound(Analyte) This is the specific gas compound for which this certified value will be used to calibrate an instrument. Text 50 Table Name: tbIProcessLabRun Table Description: Process Parameter Lab Run Data Field Name Field Description Field Type Size Key Required Comment This is a comment on the process parameter collection, measurement or analysis. Memo 0 Value This is the value in the units of measure described in the test plan record. Double 8 Run PK- This is the Run number for the Process Lab analysis. Long Integer 4 Primary ProcesslabID PK- This is the Process Lab ID which this record is one of the runs. It provides a link to tbIProcessParams Long Integer 4 Primary Page 46 of 54 ------- Table Name: tbIProcessRunData Table Description: Process Parameter Run Data Field Name Field Description Field Type Size Key Required ProcessParamID PK- This is the numerical Process Parameter ID assigned in the Process Parameter during the preparation of the Test Plan. Links to tbIProcessParams Long Integer 4 Primary Run PK- This is the numerical Run number for the Process Parameter. For Emission Factor development and for process parameter based emissions, the process parameter runs are associated with emission test runs. Long Integer 4 Primary Value This is the numerical value for the rate which the Action on the Process Parameter is occuring during the run. Double 8 Comment This is user comments on the some aspect of process parameter run. Memo 0 Table Name: tbIComments Table Description: Observer, Test Reviewer, and Tester Comments Field Name Field Description Field Type Size Key Required FieldID PK- This is the field name for the type of comment. Currently there are three fields which are available for users or reviewers to provide comments on the overall test report. These are Observer (State agency), Test Reviewer (test company) and Tester. Text 50 Primary Comment This is the text provided by the user identified in FieldID. Memo 0 Table Name: tbIStateQA Table Description: Regulatory Test Plan Review Data Field Name Field Description Field Type Size Key Required TesterComments This is used for backward compatibility with old project data sets and is not used now. Text 5 EPASampleAuditYN This check box is used by State agency reviewers to indicate whether the information provided in the test plan Audit Samples area (12) is acceptable, requires revision or is not applicable for the test plan. Text 5 Page 47 of 54 ------- Table Name: tbIStateQA Table Description: Regulatory Test Plan Review Data Field Name Field Description Field Type Size Key Required EqupCalibrationYN This check box is used by State agency reviewers to indicate whether the information provided in the test plan Equipment Calibration area (13) is acceptable, requires revision or is not applicable for the test plan. Text 5 CalibGasCertifiedYN This check box is used by State agency reviewers to indicate whether the information provided in the test plan Calibration Gas Certification area (14) is acceptable, requires revision or is not applicable for the test plan. Text 5 DilutionProposedYN This check box is used by State agency reviewers to indicate whether the information provided in the test plan Dilution probe area (15) is acceptable, requires revision or is not applicable for the test plan. Text 5 Gas This check box is used by State agency reviewers to indicate whether the information provided in the test plan Calibration Gas list area (16) is acceptable, requires revision or is not applicable for the test plan. Text 5 TestSchedule This check box is used by State agency reviewers to indicate whether the information provided in the test plan Test Schecule area (17) is acceptable, requires revision or is not applicable for the test plan. Text 5 Comments This check box is used by State agency reviewers to indicate whether the information provided in the test plan Additional Comments area (18) is acceptable, requires revision or is not applicable for the test plan. Text 5 FacRepName This check box is used by State agency reviewers to indicate whether the information provided in the test plan Facility Review Signature area is acceptable, requires revision or is not applicable for the test plan. Text 5 TestRepName This check box is used by State agency reviewers to indicate whether the information provided in the test plan Test Company Review Signatue area is acceptable, requires revision or is not applicable for the test plan. Text 5 OxygenConcDet3or3a This check box is used by State agency reviewers to indicate whether the information provided in the test plan Molecular Weight determination area (11) is acceptable, requires revision or is not applicable for the test plan. Text 5 Page 48 of 54 ------- Table Name: tbIStateQA Table Description: Regulatory Test Plan Review Data Field Name Field Description Field Type Size Key Required AgencyComments This is used for backward compatibility with old project data sets and is not used now. Text 5 Target Pa ram This check box is used by State agency reviewers to indicate whether the information provided in the test plan Sampling Method, Pollutants measured, test runs and durating area is acceptable, requires revision or is not applicable for the test plan. Text 5 Attachments This check box is used by State agency reviewers to indicate whether the information provided in the test plan Attachments area is acceptable, requires revision or is not applicable for the test plan. Text 5 PPE This check box is used by State agency reviewers to indicate whether the information provided in the test plan Personal Protective Equipment area (19) is acceptable, requires revision or is not applicable for the test plan. Text 5 Process This check box is used by State agency reviewers to indicate whether the information provided in the test plan Process area (4a) is acceptable, requires revision or is not applicable for the test plan. Text 5 TestPlanID PK- This number provides a link to tbltestplan. Long Integer 4 Primary FacName This check box is used by State agency reviewers to indicate whether the information provided in the test plan Facility Information area is acceptable, requires revision or is not applicable for the test plan. Text 5 TestCoName This check box is used by State agency reviewers to indicate whether the information provided in the test plan Test Company Information area is acceptable, requires revision or is not applicable for the test plan. Text 5 PermittedSourcelD This check box is used by State agency reviewers to indicate whether the information provided in the test plan Permit and Source ID area is acceptable, requires revision or is not applicable for the test plan. Text 5 TestPurpose This check box is used by State agency reviewers to indicate whether the information provided in the test plan Purpose area (1) is acceptable, requires revision or is not applicable for the test plan. Text 5 Page 49 of 54 ------- Table Name: tbIStateQA Table Description: Regulatory Test Plan Review Data Field Name Field Description Field Type Size Key Required MeetMinReqYN This check box is used by State agency reviewers to indicate whether the information provided in the test plan Method 1 Acceptability area (9) is acceptable, requires revision or is not applicable for the test plan. Text 5 OtherRegPurposeDes c This check box is used by State agency reviewers to indicate whether the information provided in the test plan Other Regulatorty Purposes area (3) is acceptable, requires revision or is not applicable for the test plan. Text 5 CyclonicFlowYN This check box is used by State agency reviewers to indicate whether the information provided in the test plan Cyclonic flow area (10) is acceptable, requires revision or is not applicable for the test plan. Text 5 ProcessLab This check box is used by State agency reviewers to indicate whether the information provided in the test plan Process Lab area (4b) is acceptable, requires revision or is not applicable for the test plan. Text 5 SourceDesc This check box is used by State agency reviewers to indicate whether the information provided in the test plan Source Description area (5a) is acceptable, requires revision or is not applicable for the test plan. Text 5 APCD This check box is used by State agency reviewers to indicate whether the information provided in the test plan Air Pollution Control Device area (5b) is acceptable, requires revision or is not applicable for the test plan. Text 5 Location This check box is used by State agency reviewers to indicate whether the information provided in the test plan Sampling Location area (6) is acceptable, requires revision or is not applicable for the test plan. Text 5 EmisCon This check box is used by State agency reviewers to indicate whether the information provided in the test plan Emissions Concentrations area (7b) is acceptable, requires revision or is not applicable for the test plan. Text 5 TestlnAccordanceDes c This check box is used by State agency reviewers to indicate whether the information provided in the test plan Alternative Methods area (8) is acceptable, requires revision or is not applicable for the test plan. Text 5 Page 50 of 54 ------- Table Name: tbIStateQA Table Description: Regulatory Test Plan Review Data Field Name Field Description Field Type Size Key Required ApplRegs This check box is used by State agency reviewers to indicate whether the information provided in the test plan Applicable Regulations area (2) is acceptable, requires revision or is not applicable for the test plan. Text 5 Table Name: tbIStateQACmts Table Description: Regulatory Test Plan Review Comments Field Name Field Description Field Type Size Key Required Accepted This field is the result of the acceptability check box for the area described by the Field ID. PAUL -1 selected Yes, No and N/A and there was no change in the values shown in the "Accepted" field. Text 1 Comment This field is the comments by the State Agency Reviewer on the area described by the Field ID. Memo 0 SortID This is the sequence number for the Field ID. Long Integer 4 testPlanID FK- This number provides a link to tbltestplan. Long Integer 4 Foreign TestPlanSection This is the alphanumeric ID for the test plan area which the record associated with thid field ID covers. Text 30 FieldID This is text describing the area of the test plan which the record associated with this field ID covers. Text 30 Table Name: apptblQAQs Table Description: Table that holds the Quality Assurance Questions used for the test report Field Name Field Description Field Type Size Key Required Nval Value for No answer Long Integer 4 AnsField field to check Text 255 ERTCheck calculation for answering ERT questions Text 255 RefrLink link to web reference Hyperlink 0 Page 51 of 54 ------- Table Name: apptblQAQs Table Description: Table that holds the Quality Assurance Questions used for the test report Field Name Field Description Field Type Size Key Required Data Link link to data in ERT Text 255 DataType Attach=attachment; Qry = query; frm = Form;.... used with Showdata to show data related to the question Text 10 SortID master question number Double 8 RevType Review type (ERT or 3rd Party) Text 10 AnsTable table to check Text 255 Y2val Value to add if ERT ans is no and 3rd ans is yes. on yes, adds to yes value Long Integer 4 Yval Value for Yes answer Long Integer 4 Question Question Memo 0 LinkID links Reg to Completeness Long Integer 4 QID Unique ID for this record Long Integer 4 QuestType Question type: All; Manual Test Method (MTM); Instrumental Test Method (ITM); Lab; Other (OTH) Text 10 Table Name: tbIQAQAns Table Description: Quality Assurance Question Answers Field Name Field Description Field Type Size Key Required Comment Ths is a text field which the reviewer may provide comments with respect to the review of the area described by the quality assessment question. Memo 0 QID PK- This is the ID number of the quality assessment question. Long Integer 4 Primary Answer This is a drop down response for the reviewers assessment on whether the available documentation demonstrates that the test meets the required specifications for the question area. Available responses include Blank (no selection), Yes, No and N/A. Text 5 Page 52 of 54 ------- Table Name: tbIEFLink Table Description: Table for the Emission Factor Export Field Name Field Description Field Type Size Key Required xtbl This is the table record which should be used to calculate the basic emission rate in pounds per hour and which should be divided by the process rate documented in the process run indicated in this record. tbIRunDatalTM; tbIRunHeader Text 20 Location This is the test location that the emission concentration indicated in this record.is to be applied. Text 50 Method This is the test method at this test location that the emission concentratio indicated in this record is to be applied. Text 20 RunNumber This is the Emission Test Method run number for the location which this record represents. Text 20 see This is the SCC for which this test record represents, added 1/23/06 Text 11 Run This is the primary or initial process run number for which this record represents Long Integer 4 Table Name: tbISubmitActions Table Description: Project Data Set Submittal History Field Name Field Description Field Type Size Key Required Comment This is a comment field where the submitting individual may provide supplementary information to the recipient about the Project Data Set or submission report. Memo 0 SubmittedFrom Email This is the email address of the individual that is preparing the Project Data Set file for transmittal.. Text 50 SubmittedFrom This is the name of the individual that is submitting the Project Data Set. Text 50 SubmittedToEmail This is the email address (if known) of the individual to whom the Project Data Set file is being sent. Text 50 SubmittedTo This is the name of the person or system to whom the user is submitting the Project Data Set. Text 50 SubmitDate This is the date that the user processed the Project Data Set for submission to the next individual. Date/Time 8 ID PK- This is the unique key for this record. AutoNumber 4 Primary Page 53 of 54 ------- Table Name: tbISubmitActions Table Description: Project Data Set Submittal History Field Name Field Description Field Type Size Key Required PkgName This is the file name which the ERT assigns to the Project Data Set package. It consists of the Facility Name followed by the date and time that the ERT created the file. Text 255 Action This is one of a limited list of possible actions which the current user may select. The actions include but are not limited to Submit (or Resubmit) Test Plan (or Report), Approve Test Plan (or Report), Notice of Deficiency (Test Plan or Test Report). Text 50 Page 54 of 54 ------- |