Sustainability & Risk / Green Building / Carbon Footprint - Background Data

Importing Factors

If you are importing data into the Green Building background data tables, the file ConvertFactorsEntryValues.sql (located in schema\ab-products\risk\green\footprint\dataload ) is an SQL script that you have to run against the database server if you import data into the Green Building background data tables that represent the Carbon Footprint Protocols listed below.

These background data tables use two fields for every factor:

  • One field is used on forms for the user to enter a value in units that the user selects on the form. This field has a name with a suffix of "_entry".
  • The other field is a calculated field that stores the converted "_entry" field value in fixed internal units. The name of this field is the same as the "_entry" field without the suffix. For example: gb_fp_refrig_data.charge_entry and gb_fp_refrig_data.charge.

If you import data into any of the tables below, you should omit the calculated field counterparts of any "_entry" fields, but you should import data into the following fields:

  • fields with the "_entry" suffix,
  • fields with the corresponding units fields, named as or with a suffix of "units" and "units_type."

The fields named as or with the suffix "units_type" MUST have a specific value that is unique to each field. These values are shown in the table below. The values used in the "units" and "units_type" fields are validated against the bill_unit.units and bill_unit.units_type fields.

There are three tables below with two values for units_type. This means there are two fields in the table with a suffix of "_units_type." Use the first value for the ch4_n2o_units_type field, and the second value for the co2_units_type field.

Procedure

To import Green Building background data:

  1. Import the data using the guidelines above. Use the units_types field values in the following table in your data import file:
    Table Name Required units_type field value(s)
    gb_fp_airc_data AIRCRAFT FUEL CONSUMPTION
    gb_fp_carbon_data CARBON CONTENT
    gb_fp_comm_airc_data COMMERC AIR CH4-N2O EMISSIONS, COMMERC AIR CO2 EMISSIONS
    gb_fp_egrid_subregions EGRID CH4-N2O EMISSIONS, EGRID CO2 EMISSIONS
    gb_fp_emiss_data

    FUEL EMISSIONS

    gb_fp_fuel_dens_data

    FUEL DENSITY

    gb_fp_heat_data

    HEAT CONTENT

    gb_fp_mobile_data MOBILE CH4-N2O EMISSIONS, MOBILE CO2 EMISSIONS
    gb_fp_refrig_data REFRIGERATION EMISSIONS
    gb_fp_waste_liq_data WASTE WATER EMISSIONS
    gb_fp_waste_sol_data

    SOLID WASTE EMISSIONS

  2. To convert the values in the "_entry" fields (which are in the units specified in your load file) into the Green Building internal units for each field, and store them in the calculated fields, execute the ConvertFactorsEntryValues.sql script against your database server.