IHSN Survey Catalog
  • Home
  • Microdata Catalog
  • Citations
  • Login
    Login
    Home / Central Data Catalog / EGY_2007_ES_V01_M_WB
central

Enterprise Survey 2007

Egypt, Arab Rep., 2006
Get Microdata
Reference ID
EGY_2007_ES_v01_M_WB
Producer(s)
World Bank
Metadata
DDI/XML JSON
Study website Interactive tools
Created on
Sep 29, 2011
Last modified
Mar 29, 2019
Page views
44194
Downloads
675
  • Study Description
  • Data Dictionary
  • Downloads
  • Get Microdata
  • Related Publications
  • Data files
  • EGY_06
    Manu_allfirms_idstd
  • Egypt_Services06_idstd

Data file: Egypt_Services06_idstd

The file contains the cleaned, raw data from services sector businesses. Text of questions can be found in "Productivity and the Investment Climate Private Enterprise Survey - Services Sector" in "Questionnaires" folder.

Cases: 343
Variables: 623

Variables

q53b
number of female temporary workers in 2005
q54
number of permanent skilled, professional, or managerial workers of foreign nati
q55a
number of permanent employees who were dismissed or laid off in 2005
q55b
number of permanent employees who left due to sickness or died in 2005
q55c
number of permanent employees who left for other reasons in 2005
q56a
number of weeks it took in 2004 and 2005 to fill the vacancy for a skilled techn
q56b
number of weeks it took in 2004 and 2005 to fill the vacancy for a production/se
q56c
number of weeks it took in 2004 and 2005 to fill the vacancy for a manager
q57a1
did the firm offer any "internal training" to its permanent employees in 2005?
q57a2
did the firm offer any "external training" to its permanent employees in 2005?
q57b1
number of male permanent professionals/ skilled workers who received formal trai
q57b2
number of female permanent professionals/ skilled workers who received formal tr
q57b3
number of male permanent unskilled workers who received formal training in 2005
q57b4
number of female permanent unskilled workers who received formal training in 200
q57c1
the average number of weeks of training for male professionals/ skilled workers
q57c2
the average number of weeks of training for female professionals/ skilled worker
q57c3
the average number of weeks of training for male unskilled workers
q57c4
the average number of weeks of training for female unskilled workers
q58
percentage of workforce that is unionized (in workers' general union)
q59a
number of days of production in 2005 lost due to worker strikes or other labor d
q59b
number of days of production in 2005 lost due to employee absenteeism because of
q60a1
number of male permanent workers having "some university degree or higher"
q60b1
number of female permanent workers having "some university degree or higher"
q60a2
number of male permanent workers who "completed secondary (including vocational)
q60b2
number of female permanent workers who "completed secondary (including vocationa
q60a3
number of male permanent workers having "preparatory/ incomplete secondary educa
q60b3
number of female permanent workers having "preparatory/ incomplete secondary edu
q60a4
number of male permanent workers who "completed primary education"
q60b4
number of female permanent workers who "completed primary education"
q60a5
number of male permanent workers who "did not complete primary education/ did no
q60b5
number of female permanent workers who "did not complete primary education/ did
q60atot
total number of male permanent workers
q60btot
total number of female permanent workers
q61a
the highest level of education of the top manager
q61b
number of years of experience of the top manager
q61c
number of years of experience of the top manager in a domestic establishment
q61d
number of years of experience of the top manager in a foreign establishment
q62
balance sheet complete
q62a1
total sales (2005)
q62a2
total sales (2004)
q62b1
total purchases of raw material and intermediate goods including finished goods
q62b2
total purchases of raw material and intermediate goods including finished goods
q62c1
total cost of labor, including wages, salaries and bonuses (2005)
q62c2
total cost of labor, including wages, salaries and bonuses (2004)
q62d1
rent on land and buildings (2005)
q62d2
rent on land and buildings (2004)
q62e1
rent on land (2005)
q62e2
rent on land (2004)
q62f1
rent on machinery, equipment, and vehicles (2005)
q62f2
rent on machinery, equipment, and vehicles (2004)
q62g1
interest charges (2005)
q62g2
interest charges (2004)
q62h1
all other costs, i.e.: energy, transport, overhead expenses, etc (2005)
q62h2
all other costs, i.e.: energy, transport, overhead expenses, etc (2004)
q63a1
total energy and fuel (value in thousands of egyptian pounds)
q63a2
total energy and fuel (% of total other costs)
q63b1
fuel for generator (value in thousands of egyptian pounds)
q63b2
fuel for generator (% of total other costs)
q63c1
transport/logistics (excluding rent on vehicles) (value in thousands of egyptian
q63c2
transport/logistics (excluding rent on vehicles) (% of total other costs)
q63d1
water (value in thousands of egyptian pounds)
q63d2
water (% of total other costs)
q63e1
telephones/ telecommunications (value in thousands of egyptian pounds)
q63e2
telephones/ telecommunications (% of total other costs)
q63f1
electerisity (value in thousands of egyptian pounds)
q63f2
electerisitiy (% of total other costs)
q64a
percentage of net profits (after tax) from total annual sales during the last ac
q65a1
expenses of purchasing "machinery and equipment (new and/or used)" in 2005
q65a2
expenses of purchasing "machinery and equipment (new and/or used)" in 2004
q65b1
spending on "land, buildings, or improvements to leasehold" in 2005
q65b2
spending on "land, buildings, or improvements to leasehold" in 2004
q65c1
expenses of purchasing "land" in 2005
q65c2
expenses of purchasing "land" in 2004
q65d1
expenses of purchasing "vehicles" in 2005
q65d2
expenses of purchasing "vehicles" in 2004
q65e1
spending on "information technology" in 2005
q65e2
spending on "information technology" in 2004
q65f1
spending on "design, research and development" in 2005
q65f2
spending on "design, research and development" in 2004
q66a1
the net book value of "machinery and equipment (including transport)" at the end
q66a2
the net book value of "machinery and equipment (including transport)" at the end
q66a3
the net book value of "machinery and equipment (including transport)" at the end
q66b1
the net book value of "land, buildings and leasehold improvements" at the end of
q66b2
the net book value of "land, buildings and leasehold improvements" at the end of
q66b3
the net book value of "land, buildings and leasehold improvements" at the end of
q66c1
the net book value of "land" at the end of 2003
q66c2
the net book value of "land" at the end of 2004
q66c3
the net book value of "land" at the end of 2005
q67a
value of "machinery and equipment (including transport)
q67b
value of "land, buildings and leasehold improvements"
q67c
value of "land"
q68a1
value of total assets at the end of 2004
q68a2
value of total assets at the end of 2005
q68b1
value of accounts receivable at the end of 2004
q68b2
value of accounts receivable at the end of 2005
time2_m
the interview ended at: minute:
time2_h
the interview ended at: hour:
hday2
the interview ended at: day:
hmonth2
the interview ended at: month:
hyear2
the interview ended at: year:
filter__
q7b1=0 (filter)
firmcode
ficod
idsurvey
q18a
has the establishment agreed to a new joint venture with foreign partner in 2004
q18b
has the establishment upgrading an existing product line in the factory in 2004
q22b
does the firm compet with illegal and unregisted firms?
q23a1
number of times the establishment experienced "power outages or surges from the
q23b1
number of hours the "power outages or surges from the public grid" lasted on ave
q23c1
total losses (as a percentage of sales) resulting from "power outages or surges
q23a2
number of times the establishment experienced "insufficient water supply for pro
q23b2
number of hours the "insufficient water supply for production" lasted on average
q23c2
total losses (as a percentage of sales) resulting from "insufficient water suppl
q24a
does the establishment own or share a generator?
q24b
percentage of electricity coming from the firm's own or shared generator
q24c
the generator's original cost in egyptian pounds
q24y
year of acquisition of the generator
q25c
percentage of the establishment's water supply purchased from private vendors
q26b
does the establishment regularly use a website in its interactions with clients
q28b1
does the establishment use e-mail to contact clients
q28b2
does the establishment use e-mail to buy and advocate in large way?
q28b3
does the establishment use e-mail to serve clients and produce new lines
q28b4
does the establishment use e-mail to research and voting for new services
q28f
does this establishment have a high-speed, broadband internet connection on its
q29a
does the establishment own or lease the majority of its land?
q29b
the way by which the firm acquired the land
q29c
is there an ownership title for the land?
q29d
the way by which the land was rented
q31a_1
in 2005, what percent, as a proportion of the value of total annual purchases of
q31a_2
in 2005, what percent, as a proportion of the value of total annual purchases of
q31a_3
in 2005, what percent, as a proportion of the value of total annual purchases of
q31b_1
in 2005, what percent, as a proportion of the value of total annual sales of mat
q31b_2
in 2005, what percent, as a proportion of the value of total annual sales of mat
q31b_3
in 2005, what percent, as a proportion of the value of total annual sales of mat
q32_1a
the contribution of "internal funds or retained earnings" in the establishment's
q32_1b
the contribution of "internal funds or retained earnings" in the establishment's
q32_2a
the contribution of "domestic commercial banks (loan, overdraft)" in the establi
q32_2b
the contribution of "domestic commercial banks (loan, overdraft)" in the establi
q32_3a
the contribution of "international commercial banks" in the establishment's work
q32_3b
the contribution of "international commercial banks" in the establishment's new
q32_4b
the contribution of "leasing arrangement" in the establishment's new investments
q32_5a
the contribution of "special development financing/ or public financing (governm
q32_5b
the contribution of "special development financing/ or public financing (governm
q32_6a
the contribution of "trade credit (supplier or customer credit)" in the establis
q32_6b
the contribution of "trade credit (supplier or customer credit)" in the establis
q32_7a
the contribution of "credit cards" in the establishment's working capital in 200
q32_7b
the contribution of "credit cards" in the establishment's new investments
q32_8a
the contribution of "equity, sale of stock" in the establishment's working capit
q32_8b
the contribution of "equity, sale of stock" in the establishment's new investmen
q32_9a
the contribution of "family, friends" in the establishment's working capital in
q32_9b
the contribution of "family, friends" in the establishment's new investments
q32_10a
the contribution of "informal sources (e.g. money lender)" in the establishment'
q32_10b
the contribution of "informal sources (e.g. money lender)" in the establishment'
q32_11a
the contribution of "other sources of financing" in the establishment's working
q32_11b
the contribution of "other sources of financing" in the establishment's new inve
q32y
last year of new investment
q33
was a gift or informal payment expected in dealings with bank officials?
q34a1
does this establishment have a checking account?
q34a2
does this establishment have a saving account?
q35c
was the loan in a foreign currency?
q35d
did the loan require collateral or a deposit?
q35e1
were "land and buildings" used as collateral?
q35e2
were "immoveable plant, machinery" used as collateral?
q35e3
were "moveable machinery and equipment (including vehicles)" used as collateral?
q35e4
were "other tangible assets (e.g. accounts receivable, inventory)" used as colla
q35e5
were "personal assets of the owner/manager (e.g. house)" used as collateral?
q35e6
were "other assets" used as collateral?
q35f
the approximate value of the collateral required as a percentage of the loan val
q35g
the loan's annual rate of interest in 2004
q35h
the total duration of the loan in months
q35i1
was the main use of this loan "to buy/ update/ or replace machinery and equipmen
q35i2
was the main use of this loan "to buy other fixed assets (land, buildings, and v
q35i3
was the main use of this loan "to buy inputs, supplies, goods to resell"?
q35i4
was the main use of this loan "to pay earlier loans"?
q35i5
was the main use of this loan "other uses"?
q37a1
the principal reason for not applying for a loan
q37a2
the second reason for not applying for a loan
q37a3
the third reason for not applying for a loan
q37b
the principal reason mentioned when rejecting the application for a loan
q38
share of the firm's total borrowing denominated in foreign currency
q39
does the establishment have property and casualty insurance on the majority of i
q40
does the establishment have its annual financial statement checked and certified
q41a1
percentage of the firm's total sales to public sector in 2005 that were not paid
q41a2
percentage of the firm's total sales to private sector in 2005 that were not pai
q42b
number of months it typically takes to resolve an overdue payment with customers
q43c
were the decisions of the court on disputes over overdue payments enforced?
q43d
the total time (calendar days) taken for commercial registration
q44a
in what year did this registration take place
q44b1
the total time (calendar days) taken for commerial registration
q44b2
did the firm have to present gifts or unofficial payments to finish commerial re
q44b3
the total time (calendar days) taken for industrial registration
q44b4
did the firm have to present gifts or unofficial payments to finish industrial r
q45
did the firm hire an outside company to help complete the commercial or industri
q46a1
first main reason that affects the decision of changing number of employees in t
q46a2
second main reason that affects the decision of changing number of employees in
q46b
number of workers to be fired if there are no restrictions affecting the firm's
q46c
number of workers to be hired if there are no restrictions affecting the firm's
q47a
are establishments in the same sector required to make gifts or informal payment
q48a1
the actual delay (in months) experienced till receiving "a mainline telephone co
q48b1
the actual delay (in months) experienced for receiving "a mainline telephone con
q48c1
was a gift or informal payment asked for or expected to obtain "a mainline telep
q48a2
the actual delay (in months) experienced till receiving "an electrical connectio
q48b2
the actual delay (in months) experienced for receiving "an electrical connection
q48c2
was a gift or informal payment asked for or expected to obtain "an elecrical con
q48a3
the actual delay (in months) experienced till receiving "a water connection"
q48b3
the actual delay (in months) experienced for receiving "a water connection" (the
q48c3
was a gift or informal payment asked for or expected to obtain "a water connecti
q48a4
the actual delay (in months) experienced till receiving "a construction permit"
q48b4
the actual delay (in months) experienced for receiving "a construction permit" (
q48c4
was a gift or informal payment asked for or expected to obtain "a construction p
q48a5
the actual delay (in months) experienced till receiving "an import license"
q48b5
the actual delay (in months) experienced for receiving "an import license" (the
q48c5
was a gift or informal payment asked for or expected to obtain "an import licens
q48a6
the actual delay (in months) experienced till receiving "main operating license"
q48b6
the actual delay (in months) experienced for receiving "main operating license"
q48c6
was a gift or informal payment asked for or expected to obtain "main operating l
q48a7
the actual delay (in months) experienced till receiving "an import card"
q48b7
the actual delay (in months) experienced for receiving "an import card" (the fir
q48c7
was a gift or informal payment asked for or expected to obtain "an import card"?
q48a8
the actual delay (in months) experienced till receiving "municipal permits"
q48b8
the actual delay (in months) experienced for receiving "municipal permits" (the
q48c8
was a gift or informal payment asked for or expected to obtain "municipal permit
q48a9
the actual delay (in months) experienced till receiving "industrial security lic
q48b9
the actual delay (in months) experienced for receiving "industrial security lice
q48c9
was a gift or informal payment asked for or expected to obtain "industrial secur
q48a10
the actual delay (in months) experienced till receiving "environmental approval"
q48b10
the actual delay (in months) experienced for receiving "environmental approval"
q48c10
was a gift or informal payment asked for or expected to obtain "environmental ap
q49a
percentage of total sales reported for tax purposes
q49b
percentage of total workforce reported for purposes of labor regulation and soci
q50b1_11
number of times the establishment was inspected by "tax inspectorate" in 2005
q50b1_13
number of times the establishment was inspected by "tax inspectorate" in 2004
q50b1_21
was a gift or informal payment asked for or expected at the interactions with "t
q50b21
number of times the establishment was inspected by "labor and social security" i
q50b23
was a gift or informal payment asked for or expected at the interactions with "l
q50b31
number of times the establishment was inspected by "fire and building security"
q50b33
was a gift or informal payment asked for or expected at the interactions with "f
q50b41
number of times the establishment was inspected by "sanitation/ epidemiology" in
q50b43
was a gift or informal payment asked for or expected at the interactions with "s
q50b51
number of times the establishment was inspected by "police" in 2005
q50b53
was a gift or informal payment asked for or expected at the interactions with "p
q50b61
number of times the establishment was inspected by "environmental authorities" i
q50b63
was a gift or informal payment asked for or expected at the interactions with "e
q50b71
number of times the establishment was inspected by "state office dealing with co
q50b73
was a gift or informal payment asked for or expected at the interactions with "s
q50b81
number of times the establishment was inspected by "customs clearance" in 2005
q50b83
was a gift or informal payment asked for or expected at the interactions with "c
q50b91
number of times the establishment was inspected by "other agencies" in 2005
q50b93
was a gift or informal payment asked for or expected at the interactions with "o
q51a
is a gift or informal payment expected to secure the contract, when performing b
q51b
the typical value of the gift or informal payment (made to the government offici
q51c
in 2005 did this establishment pay for security, for example equipment, personne
q51d1
in 2005, what percent of its total annual sales is paid for security?
q51d2
what is the total annual cost of security?
q52
the total number of full-time paid employees when the firm started its operation
q52a
three fiscal years ago year, in the year 2002, how many permanent, full-time emp
q53a1
the average number of permanent workers in 2003
q53b1
the average number of permanent workers in 2004
q53c1
the average number of permanent workers in 2005
q53c2
the average number of permanent professionals in 2005
q53c3
the average number of permanent skilled production workers in 2005
q53c4
the average number of permanent unskilled production workers in 2005
q53c5
the average number of permanent non- production workers in 2005
q53d1
the total number of female permanent workers in 2005
q53d2
the number of female permanent professionals in 2005
q53d3
the number of female permanent skilled production workers in 2005
q53d4
the number of female permanent unskilled production workers in 2005
q53d5
the number of female permanent non- production workers in 2005
q53e1
the total number of part-time workers in 2005
q53f1
the total compensation and salaries of all permanent workers
q53f2
the total compensation and salaries of permanent professionals
q53f3
the total compensation and salaries of permanent skilled production workers
q53f4
the total compensation and salaries of permanent unskilled production workers
q53f5
the total compensation and salaries of permanent non- production workers
q54a
number of male temporary workers in 2005
q54b
number of female temporary workers in 2005
q55
number of permanent skilled, professional, or managerial workers of foreign nati
q57a
number of weeks it took in 2004 and 2005 to fill the vacancy for a skilled techn
q57b
number of weeks it took in 2004 and 2005 to fill the vacancy for a production/se
q57c
number of weeks it took in 2004 and 2005 to fill the vacancy for a manager
q58a1
did the firm offer any "internal training" to its permanent employees in 2005?
q58a2
did the firm offer any "external training" to its permanent employees in 2005?
q58b1
number of male permanent professionals/ skilled workers who received formal trai
q58b2
number of female permanent professionals/ skilled workers who received formal tr
q58b3
number of male permanent unskilled workers who received formal training in 2005
q58b4
number of female permanent unskilled workers who received formal training in 200
q58c1
the average number of weeks of training for male professionals/ skilled workers
q58c2
the average number of weeks of training for female professionals/ skilled worker
q58c3
the average number of weeks of training for male unskilled workers
q58c4
the average number of weeks of training for female unskilled workers
q59
percentage of workforce that is unionized (in workers' general union)
q60a
number of days of production in 2005 lost due to worker strikes or other labor d
q60b
number of days of production in 2005 lost due to employee absenteeism because of
q61a1
number of male permanent workers having "some university degree or higher"
q61b1
number of female permanent workers having "some university degree or higher"
q61a2
number of male permanent workers who "completed secondary (including vocational)
q61b2
number of female permanent workers who "completed secondary (including vocationa
q61a3
number of male permanent workers having "preparatory/ incomplete secondary educa
q61b3
number of female permanent workers having "preparatory/ incomplete secondary edu
q61a4
number of male permanent workers who "completed primary education"
Total: 623
<123>
Back to Catalog
IHSN Survey Catalog

© IHSN Survey Catalog, All Rights Reserved.