BUSINESS REGISTER CBS-ISRAEL

1
BUSINESS REGISTERCBS-ISRAEL
2
LEGAL FRAME WORK

• in 1997 two inter-governmental committees
  issued
• 1. LEGAL ASPECTS
• 2. PRACTICAL TECHNICAL ASPECTS

3
LEGAL FRAMEWORK

• In the end of 1998 Decisions made
• BR for statistical purposes in the Central Bureau
  of Statistic
• Based on Administrative tax sources and other
  business sources
• Internal BR- not accessible to public
• International recommendations -Eurostat

4
PLANING ESTABLISHMENT

• In 2000 planning preparations
• Analyzing and planning a database structure
• Coordinating the economic activity codes to ISIC
  rev 3
• Activity classification base for all businesses
  from different sources
• census of all employers
• surveys
• other frames

5
Main purposes and aims

• Main available source for integrated business
  information
• Coordination of statistical business surveys
• Producing business demography

6
BUSINESS REGISTERCBS-ISRAEL

• In 2003 the business register has been launched
• 500,000 business records - then
• 800,000 business records -now
• 430,000 active businesses in 2007

7
Main sources

• VAT source
• 470,000 businesses
• business id (vat identity id in most cases)
• monthly revenue and expenditure
• activity type and dates of activity
• economic activity description
• names of the business
• addresses of the business
• Relations file- vat reporting units(vat-partnersh
  ips)

8
Main sources

• National Security source(NS)
• 200,000 employers
• employer id
• entity id
• activity type dates
• names, addresses,tel no
• no of total employees and total salaries-monthly

9
Main sources

• Updating data
• VAT- all active businesses data-Monthly updated
  -latest 12 months ( 1.5 month lag)
• VAT -Relations file- (vat-partnerships)-yearly
• National Security- all active employers data
  twice a year-latest 25 months ( 1.5 month lag)
• NS-all additions of new employers bi-monthly

10
MATCHINGbuilding basic coordinated record

• VAT
• Vat registration id
• (primary key)
• Entity id

• National security
• National security id
• (primary key)
• Entity id

MOSTLY ENTITY IDVAT ID
11
Data capture from administrative files

• Validation checks
• logical corrections-
• preventing the creation of duplications-as much
  as possible
• Every record has an internal unique BR id
  LMS id

12
BR- DB structure
Statistics unit
Surveys
Storage
Historical Data
VAT
Surveys Frames
LMS UNITS B. Register
Connection To Different External Surveys
NATIONAL SECURITY
Partnership Information
Local Units
13
Some technical facts
BR- DB structure

• Oracle Database
• Interface on Windows Platform
• Developed in Visual Basic 6 and .Net
• Receiving Data by Government Secure File Transfer
  System

14
BR- logical structure
Storage
Statistics unit
Surveys

• Definitions of frames samples
• Building special fictitious sample units
• Process of frames adjustment (additions)

• Building matching units
• Maintenance of units
• Updating quantities data
• Relations
• Classifying activity

• Receiving input files
• History of changes (keys,status,activity etc)
• Logical corrections

15
National Security
VAT
Surveys inputs
BUSINESS REGISTER
Other business files
Income tax file
16
Main activity in BR unit

• Maintenance , management and control improvement
  processes
• Classifying all units
• Statistical business frames
• Business demography
• Updating SNA classification of sector for all
  active enterprises(since 2004)
• BR other outputs

1.
2.
3.
4.
5.
6.
17
Classifying activity units
2.

• ISIC REV 3 classification 4 digits
• Automatic classifying system according to
  activity description from VAT (online updated)
• Else classifying by
• Surveys
• Contact businesses
• DB
• Employers mostly clerical work
• Quality checks-Special branches

Main activity in BR section
18
Statistical business frames
3.

• Define statistical business frames
• since 2004- 5 new important samples been
  taken-for example
• Survey of revenue indicators
• Survey of employment and salaries indicators
• Survey of manufacturing indicators

Main activity in BR section
19
Statistical business frames
3.

• Each frame needs different definitions
  fictitious sample unites
• Maintenance and additions of samples
  bimonthly/monthly
• Refreshing long-run frames yearly
• Some of the frames are sampled automatically in
  the BR

Main activity in BR section
20
Business demography
4.

• Once a year a process of freezing Since 2003
• A. all active businesses
• Economic activity
• Location
• number of employees
• Salaries
• Birth or death (new process)

Main activity in BR section
21
Business demography
4.

• Once a year a process of freezing Since 2003
• B. all opening closures by VAT
• Economic activity
• Location
• employment

Main activity in BR section
22
Business demography
4.

• publishing Years 2003-2007
• yearly -all active businesses by number of
  employees and economic activity-
• yearly- all opening closures in business sector
  by VAT registration -by economic activity and
  employments /by area

Main activity in BR section
23
Business demography
4.

• Producing births for each year since 2005 (On
  final stage)
• Birth rates by size, location, economic activity
  act.
• Survival rates by size, location, economic
  activity act.

Main activity in BR section
24
Business demography
4.

• On-going process of producing OECD-Eurostat new
  definitions for each year since 2005-
• Enterprise birth/death(2003)
• Employers enterprise birth/death(2003)

Main activity in BR section
25
BR other output
6.

• World bank questionnaires
• OECD questionnaires
• Main information center for all businesses-in CBS
• Classifying files of import and export
  businesses
• Supporting other business surveys in CBS

Main activity in BR section
26
BR other output
6.

• Producing data for other economic institutions
• Producing data for government authorities and
  local authorities or other policy makers

Main activity in BR section
27
In process

• Collecting data on local units-large businesses
• Preparing the match of activity code ISIC rev 4
  to the BR activity codes
• Response burden- connecting other existing
  surveyes to BR

Main activity in BR section
28
USERS OF BR-ON-LINE

• DEPARTMENT OF BUSINESS- 30 AUTHORIZED POSITIONS
• OTHER CBS DEPARTMENTS-30 AUTHORIZED POSITIONS

29
EXAMPLES OF BR SCREENS
30
Id numbers
515151510
91212121200
515151510
912121212
Names, types
???? ????? ???'
????? ???' 2005
MAIN SCREEN
classifying
Activity dates
31
MONTHLY DATA
Id names
515151510
515151510
91212121200
912121212
???? ????? ???'
????? ???' 2005
Monthly employeessalaries
Monthly revenueexpense
32
RELATION WITH OTHER BUSINESSES
525252520
525252520
91111111100
911111111
525252520
??? ???? ????
557123456
??? ????? ????'
557123456
511111111
???? ????? ??'?
93333333333
933333333
522222222
????? ??????
92222222222
922222222
525252520
??? ???? ????
91111111100
911111111
33
THANK YOU FOR YOUR ATTENTION