All beneficiary data fields

[mishaker]

in all beneficiary data export, please explain fields in bold:

project_id report_id beneficiary_id cluster_id cluster focal_point_name focal_point_phone focal_point_email organization programme_partners implementing_partners project_hrp_code project_code project_title project_start_date project_end_date project_status project_details donor project_budget project_budget_currency report_month_number report_month report_year reporting_period admin0pcode admin0name admin1pcode admin1name admin2pcode admin2name admin3pcode admin3name admin4pcode admin4name admin5pcode admin5name conflict site_id site_class site_status site_population site_hub_id site_hub_name site_implementation_name site_type_name site_name category_type_id category_type_name beneficiary_type_id beneficiary_type_name hrp_beneficiary_type_id hrp_beneficiary_type_name beneficiary_category_name strategic_objective_id strategic_objective_name strategic_objective_description sector_objective_id sector_objective_name sector_objective_description response activity_type_id activity_type_name activity_description_id activity_description_name activity_detail_id activity_detail_name remarks indicator_id indicator_name activity_status_id activity_status_name delivery_type_id delivery_type_name distribution_status distribution_start_date distribution_end_date partial_kits kit_details units unit_type_id unit_type_name transfer_type_value mpc_delivery_type_id mpc_delivery_type_name mpc_mechanism_type_id mpc_mechanism_type_name package_type_id transfer_category_id transfer_category_name grant_type_id grant_type_name total_amount households families boys girls men women elderly_men elderly_women details total total_pwd admin1lng admin1lat admin2lng admin2lat admin3lng admin3lat admin4lng admin4lat admin5lng admin5lat site_lng site_lat updatedAt createdAt

[fakhrihawari]

1. admin0pcode is for country code e.g.Afghanistan is AF
2. admin0name is for country name e.g Afghanistan is Afghanistan
3. admin1pcode is for First - level administrative divisions code e.g Nimroz is AF34
4. admin1name is for First - level administrative divisions name e.g Nimroz
5. admin2pcode is for second - level administrative divisions code e.g Kang is AF3402
6. admin2name is for second - level administrative divisions name e.g Kang
7. admin3pcode is for third - level administrative divisions code
8. admin3name is for third - level administrative divisions name
9. admin4pcode is for fourth - level administrative divisions code
10. admin4name is for fourth - level administrative divisions name
11. admin5pcode is for fifth - level administrative divisions code
12. admin5name is for fifth - level administrative divisions name
13. admin1lng is for First - level administrative divisions longitude
14. admin1lat is for First - level administrative divisions latitude
15. admin2lng is for second - level administrative divisions longitude
16. admin2lat is for second - level administrative divisions latitude
17. admin3lng is for third - level administrative divisions longitude
18. admin3lat is for third - level administrative divisions latitude
19. admin4lng is for fourth - level administrative divisions longitude
20. admin4lat is for fourth - level administrative divisions latitude
21. admin5lng is for fifth - level administrative divisions longitude
22. admin5lat is for fifth - level administrative divisions latitude
23. site_lng is for site longitude
24. site_lat is for site latitude

[rafinkanisa]

Adding notes

What you're asking is related with the geospatial data fields. ReportHub follows an administrative structure that complies with humanitarian standards. This makes the reporting data linked to geographic polygons for analysis and thematic representation using GIS software