The LIMS statistical reporting templates (worksheets organized in spreadsheets) harmonized for the SADC region describe the contents and the type of information (“contentware ”) that should be collected at country level before being transferred to the SADC secretariat, Livestock Unit of FANR.

The templates are organized into eleven (11) independent modules, representing the first "core" dimensions and essential elements of the regional LIMS. Each template describes one content; made of thematic and quantitative data, reflecting one aspect of the livestock sector. Data should be collated in Member States who will be using such information to guide their livestock policies and eventually shall be sent to the SADC secretariat.

Some field questionnaires have been derived from the templates using the same contents (the minimum data set). They will be used by enumerators and extension services, in order to facilitate the collection of relevant information in combination with various electronic devices and technologies (e.g. the digital pen technology DPT, is tested in a collaborative project between the SADC PRINT project, the African development bank funded TAD’s project (Strengthening institutions for risk management of transboundary animal diseases) and the FAO sub regional office of the Regional Animal Health Centre in Gaborone).

The set of reporting templates (i.e. Excel data sheets) is provided in this page. This set represents an illustration of the contents which should be accessible in the national and regional livestock statistics within the SADC region. National statistics can go beyond this minimum data set though.

The templates are translated into the three official languages of SADC English, French and Portuguese

Templates_Excel_Reports

The Spreadsheets represent the minimum dataset that should be gradually provided in Member States and to SADC secretariat

The customization of such data sheets can easily be done at national level using national logos or insignas, like in the example displayed in this page (Customization for Botswana) and the attached file (based on one module only, the LIMS Module 1 on livestock census)

National_Frontpages

Interoperability with External Data Capture Devices (DPT Digital Pen Technology) or External Databases

Besides, and in order to allow interoperability with external sources of data, the LIMS software has been designed with a function ready to import "external data" . A selection of data can be queried from various national databases (external sources), provided that the result of such a query is formatted in a specific way and therefore compliant with the "LIMS import format ".

The following training note provides for explaining the general features and the various steps to be followed to use the interoperability function of LIMS . This note should be carefull read, particularly in view of using LIMS in relation with the Digital Pen Technology , a data capture device tested in five SADC countries: Angola, Zambia, Mozambique, Malawi, Tanzania. The SADC TAD's project funded by the African Development Bank is responsible for the follow up and the implementation of the DPT in the five countries in collaboration with the FAO (Regional Center for Animal Health) .

Note_Interoperability_function_LIMS

To import data into LIMS one should firstly prepare data using the following Excel Files (with several tabs) which are specifically formatted. Therefore they represent the Importing Templates to be used with the import function of LIMS. The files accessible here are adapted to the current LIMS version ver 2.04.

LIMS_IMPORT_TEMPLATES_for_ver 2_0_4

The list of the 11 LIMS modules is provided hereafter, organized in four components

Component on Animal production

Module 1: Numbers & Composition of Herds / Effectivos animais do rebanho nacional / Effectifs nationaux – recensement animal

1. Nr by species / effectivos animais por espécies / Nombre par espèce

2. Nr by economics / effectivos animais por função economica / Nombre par fonction économique

3. Nr by breeds / Effectivos animais por raça / Nombre par race

4. Nr by herd structure / Effectivos animais por idade e sexo / Nombre par âge et sexe (démographie)

Module 3 Production Parameters / Produção animal / Production animale

1.Slaughter / Abate (carne) / Abattages

2.Milk / Leite / Lait

3.Dairy products / Lacticinios / Produits laitiers

4.Eggs / Ovos / Oeufs

5.Hides, skins / Curos e Peles / Cuirs et peaux

Component on Livestock Development

Module 2 Human Households & Population in Livestock farming / Agregados familiares criadores / Ménage engagés dans l’agriculture et l’élevage

1. Human Population / Agregados familiars / Ménages et population humaine

Module 6 LS Infrastructures / Infra-Estructuras / Infrastructures

Infrastructures Agreg. / Infra-Estructuras Agregados / Infrastructures description agrégées

3.Dipping / Tanque banheiros / Bain détiqueur

4.Pens / currais / Enclos de vaccination

5. Vet clinics / Clinicas vet. / Cliniques vétérinaires

6.Govt Offices / Officios do governo / Bureaux de l’état

7. Mun Abattoirs & slabs / Matadouros municipais e locais e casas de matança / Abattoirs locaux et tueries

8. Milk Collection / Recolha de leite / Récolte de lait liquide

9. Livestock Markets / Mercados / Marchés

10.Storage Products / Armazens / Entrepôts et Stocks

Infrastructures Detailed / Infra-Estructuras detalhados / Infrastructures détaillées

1.Vet Diagnostic Labs / Laboratorios / Laboratoires de diagnostic

2.Vet Vaccine Labs / Productores de Vacinas / Producteurs de vaccins

3. Industrial Abattoirs / Matadouros industrias / Abattoirs industriels

4.Dairy Processing Plants / Usina de transformação de leite / Unité de transformation laitière

5.Secondary Markets, / Mercados segundarios / Marchés secondaires

6. Port of Entry & Exit / Portos de entrada e saida / Postes d’inspection en frontière PIF

Module 8 Livestock Associations and Service Providers / Associações de criadores e fornecedores de servicios / Association d’éleveurs et fournisseurs de services

1.Umbrella org & assoc / Associações / Associations et Confédérations

2.Private companies / Privado / Secteur privé

3.Government / Publico / Secteur public

Module 9 LS related Laws, Regulation and Acts, policy docs / Legislação e politicas agro pecuaria / Législation et documentsd e politique sur le secteur élevage

1.National Docs / Nivel nacional / niveau national

2.International Docs / Niveis internacional e regional (SADC) / Niveau international ou sous régional (SADC)

Component on Animal Health

Module 7 Meat Inspection / Food safety / Segurança Sanitaria dos alimentos / Sécurité sanitaire des aliments

1. Ante-mortem / Inspecção ante mortem / Inspection ante mortem en abattoir

2. Post-mortem / Inspecção post mortem / Inspection post mortem en abattoir

Module 10 Disease Outbreak notification / Notificação dos surtos de doenças / Information sanitaire notification d’épidémies animales

Outbreaks / Epidemias focos / Foyers d’Epizooties animales

Module 11 Vaccinations (e.g. TAD’s) / Vacinação / Vaccinations

1.Vaccination / vacinações efectuadas / Vaccinations effectuées (prophylactique et de contrôle)

Component on Livestock Marketing and Trade

Module 4 Livestock & Products Price / Preços dos productos animais / Prix des produits d’élevage et animaux vivants

1. Live animals / Animal vivo / Animaux vivants

2. Meat products / Producto de carne / Produits carnés

3. Milk products / Leite e Lacticinios / Produits laitiers

4. Eggs / Ovos / Oeufs

5. Hides & skins / Curos e Peles / Cuirs et peaux

6. Fiber & feathers / Fibras e plumas / Fibres animales et plumes

Module 5 Livestock & Products trade: import/export / Importação e Exportação / Import et Export

Also we suggest the user shall link to the SADC trade database from TIFI and SPS pages of the AIMS portal

SPS pages of SADC AIMS

SADC trade database: http://www.sadctrade.org/

The LIMS system uses the HS harmonized system used internationally as the major standard to categorize products traded between countries, including LLP Livestock (alive) and Livestock Products . The categories can be described with various levels of details (HS2, HS4, HS6 etc..).

A full description of the HS system is here:

01 - IntroEnglish

HS_02_EngText

The LIMS software offers to select only some categories of the HS listing.

1. Live Animals / Animal vivo / Animaux vivants

2. L. stock Products / Producto animais / Produits d’élevage

3. L. stock Inputs / Inputs / Intrants de l’élevage