Page 216 - Contributed Paper Session (CPS) - Volume 3

CPS1997 Rawia Wagih Abd ElMagid ElSayed R. et al.
7. Activity exploitation of mines and quarries
Comprehensive inventory of establishments that work in the field of
mining and quarrying and are not included in regular statistics and the source
is the governments and the Ministry of Local Development frame as a
supplementary framework.
The regular statistics data are added to the corresponding data in the
census to reflect the outcome of the economic situation within establishments
in all of the public / business public sector and the private sector and that is
the eighth frame and any duplication for each establishment is deleted before
creating the Comprehensive Economic Frame.

Secondly: configuration of the Main Economic Aggregated Frame (MEAF) from
each of regular statistics and bulletins of CAPMAS (inner Frame) and Ministry
of Investment statistics, the Federation of Industries and Chambers of
Commerce (external frame)

The Inner frame: It is created from the regular statistics data and from the data
of CAPMAS departments and bulletins (130 bulletins) that have 68 frames with
overlapping and merging between them and frames of regular statistics and
then they are compared to delete any duplicate in the data to set the inner
frame.

The external frame: It is created from data provided by the Ministry of
Investment (any establishment is operating according to the records of the
ministry), The Federation of Industries and Chambers of Commerce then
configured to obtain any additional data. Next, MEAF is configured, merged
and compared with these frames (inner and external frames) and any duplicate
in data is deleted.

Finally, The Master Establishment Frame (MEF) is generated through a merge
between the Comprehensive Economic Frame and Main Economic
Aggregated Frame (MEAF) and thus solving the overlapping between these
frames is the best way to overcome the problem of data duplication.
Having only one frame without duplication of data and creating unique
code (ID) for each establishment and having only one source of data which is
CAPMAS, then the MEF would be the effective frame with the following
structure.

205 | I S I W S C 2 0 1 9