{"doc_desc":{"title":"Template_project","idno":"EGY_HEWW_2023_HD_V1","producers":[{"name":"Economic Research Forum","abbr":"ERF","affiliation":"","role":"Cleaning and harmonizing raw data received from the Statistical Agency"}],"prod_date":"2025-12","version_statement":{"version":"Version 1"}},"study_desc":{"title_statement":{"idno":"EGY_HEWW_2023_HD_V1","title":"The Harmonized Employment, Wage and Working Hours, HEWW 2023","alternate_title":"HEWW 2023"},"authoring_entity":[{"name":"Central Agency For Public Mobilization & Statistics","affiliation":"CAPMAS"}],"production_statement":{"copyright":"(c) 2025, Economic Research Forum , CAPMAS, Egypt"},"distribution_statement":{"contact":[{"name":"Economic Research Forum (ERF) - 21 Al-Sad Al-Aaly St., Dokki, Giza, Egypt","affiliation":"ERF","email":"erfdataportal@erf.org.eg","uri":"www.erf.org.eg"}]},"series_statement":{"series_name":"Enterprise Survey [en\/oth]","series_info":"A yearly survey collected by the Central Agency for Public Mobilization and Statistics (CAPMAS)"},"version_statement":{"version":"V1: A cleaned and a harmonized version of the survey dataset, produced by the Economic Research Forum for dissemination.","version_date":"2025-12","version_notes":"All documentation available for the original survey provided by the Statistical Agency, and for the harmonized datasets produced by the Economic Research Forum, are published, along with a copy of all occupations and economic activities used during the harmonization process. \nHowever, as far as the datasets are concerned, the Economic Research Forum produces and releases only the harmonized versions in both SPSS and STATA formats."},"study_info":{"topics":[{"topic":"Enterprise main characteristics","vocab":"ERF","uri":""},{"topic":"Wages and working hours","vocab":"ERF","uri":""},{"topic":"Employees' characteristics","vocab":"ERF","uri":""},{"topic":"Job vacancies","vocab":"ERF","uri":""},{"topic":"Working skills","vocab":"ERF","uri":""}],"abstract":"*********************************************************************************************************************************************************************\n*********************************************************************************************************************************************************************\nTHE CLEANED AND HARMONIZED VERSION OF THE SURVEY DATA PRODUCED AND PUBLISHED BY THE ECONOMIC RESEARCH FORUM REPRESENTS 100% OF THE ORIGINAL SURVEY DATA COLLECTED BY THE CENTRAL AGENCY FOR PUBLIC MOBILIZATION AND STATISTICS (CAPMAS)\n*********************************************************************************************************************************************************************\n*********************************************************************************************************************************************************************\nThe Central Agency for Public Mobilization and Statistics collects annual establishment data on employment size, average wages, and average monthly working hours in public business sector and private sector establishments. These data provide indicators by economic activity (excluding agricultural activities not conducted within establishments), geographical distribution, and occupational classification.\nEgypt has extensive experience in conducting establishment surveys. The first establishment survey on employment, wages, and hours of work was carried out in 1942, twice a year-in January and July. The current survey programme is implemented annually, using June as the reference period. In 2020, the survey design was revised to enable the collection of occupational wage data for individual sampled employees at the 6-digit level of the occupational classification. A further major revision was introduced in 2022, adding new sections to gather information on the skills required for occupations represented in the sample of establishment workers, as well as the skills required for current vacancies, and those anticipated for future recruitment.","nation":[{"name":"Egypt","abbreviation":"EGY"}],"geog_coverage":"Covering a sample of urban and rural areas in all the governorates.","analysis_unit":"Establishment","universe":"The survey covered all active establishments within the scope of the economic census of 2017-2018 with a few exceptions. (see attched documents)","data_kind":"Sample survey data [ssd]","notes":"The survey covers all active establishments falling within the scope of the 2017-2018 Economic Census, across the public and private sectors (including private, cooperative, and non-governmental organizations), excluding diplomatic and international entities. An establishment may take the form of a factory, workshop, store, office, mine, farm, or any similar economic unit. It is defined as an economic unit that primarily or exclusively conducts a single type of economic activity at one physical location. An establishment may operate independently or as part of a larger enterprise. An enterprise, in turn, is a legal entity-or a group of legal entities-that may encompass multiple.\nIt is important to note that the Economic Census itself is a stratified sample based on economic activity, governorate, and establishment size (measured by number of employees). Establishments with 10 or more employees are fully enumerated (100 percent). Those with 5-9 employees are included on a half-sample basis (50 percent), while establishments with 1-4 employees are sampled at a small fraction (5 percent). The census also included a 10 percent sample of temporarily closed establishments. Additionally, all establishments engaged in rare activities-defined as activities with up to 30 establishments-were fully included at the economic activity level within each governorate."},"method":{"data_collection":{"data_collectors":[{"name":"Central Agency For Public Mobilization & Statistics","abbr":"CAPMAS","role":"","affiliation":""}],"sampling_procedure":"*********************************************************************************************************************************************************************\n*********************************************************************************************************************************************************************\nTHE CLEANED AND HARMONIZED VERSION OF THE SURVEY DATA PRODUCED AND PUBLISHED BY THE ECONOMIC RESEARCH FORUM REPRESENTS 100% OF THE ORIGINAL SURVEY DATA COLLECTED BY THE CENTRAL AGENCY FOR PUBLIC MOBILIZATION AND STATISTICS (CAPMAS)\n*********************************************************************************************************************************************************************\n*********************************************************************************************************************************************************************\nThe sampling frame is constructed using explicit stratification by governorate and establishment size class. Stratification by economic activity is applied implicitly by sorting the list of establishments within each explicit stratum according to their 4-digit activity code, in order to avoid excessively large number of strata. \nAll public sector enterprises are included in the sample (100 percent). For enterprises operating multiple establishments (\"branches\"), up to five branches in addition to the headquarters (HQ) are selected. This approach ensures that the sampling unit reflects public sector establishments rather than enterprises, which may consist of several establishments carrying out different economic activities.\nFor the private sector, the sampling design is based on stratification by governorate and five establishment size classes defined by number of employees. Sampling rates vary by size class, with smaller establishments selected at lower rates and larger establishments at higher rates.\nEmployee characteristics are collected at the individual employee level on a sample basis, using the same approach for both public (HQ and branches) and private sector establishments. The design specifies the use of systematic sampling from an establishment's employee list sorted by occupation. In practice, however, the selection of sample employees was performed directly by the establishments.","coll_mode":["Face-to-face [f2f]"],"research_instrument":"The full survey questionnaire is structured into three parts. The first part gathers general data on the establishment, including its branch of economic activity and lots of information like whether it has a commercial or industrial register, and accounting books or not. The second part covers characteristics of employees-first at the establishment level, and then at the level of sampled employees-capturing information on occupation, wages, hours of work, skills, social security coverage provided by the employer, and access to paid annual or sick leave. The third part collects data on job vacancies, hirings, and separations.","sources":[{"name":"","origin":"","characteristics":""}],"coll_situation":"Field work\n\nSince the first quarter of research (January \u2013 March2020), a complete transformation of data collection using the tablet has been made through designing a program that contains rules for filtering mistakes and sending inquiries as soon as possible and preparing a laboratory to receive and follow up data and return the inquiries that have errors to the field again to correct them again.\n\n1- The field staff was selected from the most experienced persons from CAPMAS and from some young people out side CAPMAS\n2- Central training program for supervisors was conducted at CAPMAS in Cairo and locally in governorates for interviewers and field editors.\n3- Supervision program was implemented on collections data persons in all governorates to check the field work.\n4- Data were collected by using personal interview method for household in dwelling and it had been obtained from the head of household or his wife or any eligible person in case of their absence.\n5- Duties and responsibilities of all levels of field staff (interviewer, editor and supervisor) were defined to enable them perform their tasks accurately and timely.","weight":"Sample weights are used to expand the survey results to represent population totals. The weight assigned to an establishment reflects the number of establishments in the population that it represents; likewise, the weight assigned to an employee reflects the number of employees in the population represented by that sampled employee.\nEach sample weight generally consists of three components:\n1. The design weight, which reflects the probability of selecting the unit under the sampling design;\n2. A non-response adjustment, to account for units that were selected but did not respond; and\n3. A calibration adjustment, to align the weighted results with internal consistency requirements or with external aggregate controls.\nThe procedures used to calculate establishment and employee weights in the survey are described separately for the public and private sectors.\n\n\nNote: there are more details on the weights and sampling at the \"The Employment, Wage and Working Hours - Annual Bulletin\u201d document in the downloading  tab.","cleaning_operations":"Data Processing\n\n1- Coding\nSpecialized staff is responsible for coding data of activity, occupation and geographical identification according to activity, occupation and geographical manual, thus the questionnaires will be valid for data entry.\n2- Data entry and tabulations It included machine data entry, data validation and tabulation as well as preparing a final survey bulletin and output tables.\n\n---> Raw Data\n\nOffice editing is one of the main stages of the survey. It started once the questionnaires were received from the field and accomplished by the selected work groups. It includes:\na-Editing of coverage and completeness\nb-Editing of consistency\n\n---> Harmonized Data\n\n- The STATA  package is used to clean and harmonize the datasets.\n- The harmonization process starts with a cleaning process for all raw data files received from the Statistical Agency.\n- All cleaned data files are then merged to produce one data file on the individual level containing all variables subject to harmonization.\n- A country-specific program is generated for each dataset to generate\/ compute\/ recode\/ rename\/ format\/ label harmonized variables.\n- A post-harmonization cleaning process is then conducted on the data.\n- Harmonized data is saved in SPSS and then converted to STATA, to be disseminated."},"method_notes":"Quality Control Procedures\n\nThe precision of survey results depends to a large extent on how the survey has been conducted. As such, it was crucial to exert much effort and to take necessary actions towards rigorous preparation for the present survey. The preparatory activities, set up the general framework of survey implementation such as:\n1- Applying the recent international recommendations of different concepts and definitions.\n2- Evaluating the quality of data in all different implementation stages to avoid or minimize errors to the lowest level possible through:\n   A. Implementing field editing after finishing data collection for establishment  in governorates to avoid any errors in suitable time.\n   B. Re-interviewing a sample of establishments  by Quality Control Department in some governorates and examining the differences with the original responses then take the necessary procedures."},"data_access":{"dataset_use":{"conf_dec":[{"txt":"To access the micro data, researchers are required to register on the ERF website and comply with the data access agreement.\n\nThe data will be used only for scholarly research, or educational purposes. Users are prohibited from using data acquired from the Economic Research Forum in the pursuit of any commercial or private ventures.","required":"yes","form_no":"","form_uri":""}],"contact":[{"name":"Economic Research Forum","affiliation":"ERF","email":"erfdataportal@erf.org.eg","uri":"www.erf.org.eg"}],"cit_req":"The users should cite the Economic Research Forum and the Central Agency For Public Mobilization & Statistics as follows:\n\nOAMDI, 2025. The Harmonized Employment, Wage and Working Hours (HEWW), http:\/\/www.erfdataportal.com\/index.php\/catalog. Version 1.0 of Licensed Data Files; HEWW 2023- Central Agency for Public Mobilization and Statistics (CAPMAS). Egypt: Economic Research Forum (ERF).","conditions":"Licensed datasets, accessible under conditions.","disclaimer":"The Economic Research Forum and the Central Agency For Public Mobilization & Statistics have granted the researcher access to relevant data following exhaustive efforts to protect the confidentiality of establishment data. The researcher is solely responsible for any analysis or conclusions drawn from available data."}}},"schematype":"survey"}