Labels

Labels are used to match information from the Baseline Storage Sheets to metadata in the database.

Wealth Characteristic Labels

Wealth Characteristic labels are pulled from Column A of the 'WB' worksheet in a BSS. They are used by the WealthCharacteristicValue ingestion pipeline to determine the attributes for a given row in a BSS.

Wealth Characteristic Labels contain the following fields:

• Wealth Characteristic Label: This field contains an item from Column A of the WB worksheet in a BSS.

• Status: There are three status options:

  • Complete: The label has been associated with a Wealth Characteristic and can be ingested.

  • Under discussion: Discussion or investigation is needed to determine if this can be ingested or if it needs a correction. It may need a new Wealth Characteristic or it may be unclear what the associated Wealth Characteristic should be.

  • Correct the BSS: Discussion or investigation has led to the conclusion that a correction is needed.

• Wealth Characteristic: The Wealth Characteristic that corresponds with this label, if applicable.

• Product: The product associated with this Wealth Characteristic Label, if applicable.

• Unit of Measure: The unit measure associated with this Wealth Characteristic Label, if applicable.

• Notes: Any notes explaining the status or choice of associated Wealth Characteristic should be entered here.

Activity Labels

Activity labels are pulled from Column A of the 'Data', 'Data2' or 'Data3' worksheets in a BSS. They are used for the LivelihoodStrategy and LivelihoodActivity the data ingestion pipelines to determine the attributes for the LivelihoodStrategy and/or LivelihoodActivity for a given row in a BSS.

Activity Label fields include:

• Activity Label: This field contains an item from Column A of the 'Data', 'Data2' or 'Data3' worksheets in a BSS.

• Activity Type: The location in the BSS of the Livelihood Activity that corresponds to this label. This could be a general Livelihood Activity in the ‘Data’ worksheet, an Other Cash Income activity from the 'Data2' worksheet, or a Wild Foods, Fishing, or Hunting activity from the 'Data3' worksheet.

• Status: There are three status options:

  • Complete: The label has been associated with a Wealth Characteristic and can be ingested.

  • Under discussion: Discussion or investigation is needed to determine if this can be ingested or if it needs a correction. It may need a new Wealth Characteristic or it may be unclear what the associated Wealth Characteristic should be.

  • Correct the BSS: Discussion or investigation has led to the conclusion that a correction is needed.

• Is Start?: Select the checkbox to indicate if this Activity Label marks the start of a new Livelihood Strategy section in the BSS. In the BSS these cells often have a light green background. For example Sorghum Deyr: kg produced or any other crop name followed by kg produced indicates the start of a new Activity.

• Strategy Type: The type of livelihood strategy, such as crop production, or wild food gathering.

• Product: The product associated with this Activity Label, if applicable.

• Unit of Measure: The unit of measure associated with this Activity Label, if applicable.

• Currency: The currency associated with this Activity Label, if applicable.

• Season: The season associated with this Activity Label, if applicable.

• Additional ID: Additional text identifying the Activity Label, if applicable.

• Attribute: Additional attributes from the BSS for the associated Livelihood Activity, if applicable. This describes the type of information being stored and will correspond to the attribute column in the ActivityLabel tab in the Reference Data workbook. For example, Sorghum Deyr: kg produced maps to the quantity_produced attribute. Possible attributes include:

  • milking_animals

  • lactation_days

  • daily_production

  • quantity_produced

  • quantity_sold

  • price

  • income

  • type_of_milk_sold_or_other_uses

  • quantity_other_uses

  • percentage_kcals

  • animals_slaughtered

  • carcass_weight

  • purchase_price

  • sales_price

  • product__kcals_per_unit

  • times_per_month

  • months_per_year

  • expenditure

  • times_per_year

  • unit_multiple

  • people_per_household

  • payment_per_time

  • percentage_sold_slaughtered

  • reference_year_percentage_sold

  • percentage_milk_sold

  • quantity_produced_or_purchased

  • quantity_purchased

  • number_of_local_measures

  • name_of_local_measure

  • product__name

  • percentage_monthly_kcals

  • number_of_children

  • activty_notes

• Notes: Any notes explaining the status or choice of associated Activity or Strategy type should be entered here.