Transcript Dias nummer 1

The Danish Statistical Business Register:
Units, variables and extracts
Kiev 2nd – 5th October 2012
Mrs Vibeke Skov Møller ([email protected])
Basic data model for the Danish SBR
Types of Units comprised by Statistical Denmarks SBR
Statistical Units
Administrative units
Enterprise
Group
Enterprise
Legal Unit
Establishment
(LKAU)
Local Legal
Unit (LLKAU)
Kind of Activity
Units (KAU)
Responsibillity:
Statistics Denmark
Responsibillity:
Danish Commerce and
companies Agency
VAT Unit 1
VAT Unit 2
VAT Unit 3
Central Tax and
Customs Authorities
Kiev 2nd – 5th October 2012
Mrs Vibeke Skov Møller ([email protected])
2
Number of units in the Danish SBR
- 636,000 enterprises on 31 December 2011
- Of wich only 297,000 are real active
- 696,000 local units on 31 December 2011
- Many very small (insignificant) units (approx 25 %)
- Few very important units (approx 5 % of the units
have 80 % of turnover)
- The majority (approx. 80 %) are sole proprietors and
have only a small part of turnover
- Vice versa for the public limited companies
- Only few enterprises (less than 5%) have more than
one LKAU
- Growing number of units in services, decline in
manufacturing
Kiev 2nd – 5th October 2012
Mrs Vibeke Skov Møller ([email protected])
3
Number of updating in the Danish SBR
- High level of updating:
- Creations (entries) in 2011: 64,000 enterprises
- Cessations (“deaths”) in 2011: 53,000 enterprises (of which
5,000 were also created in 2011)
- Updating of addresses (in 2005):
- Approx. 45,000 enterprises
- Approx. 44,000 local units
- Updating of principal activity (in 2005):
- Approx. 29,000 enterprises (of which 3.400 from Nace
98.00)
- Approx. 29,000 local units (of which 3.400 from Nace
98.00)
- 165 extracts for in-house statistical surveys annually
Kiev 2nd – 5th October 2012
Mrs Vibeke Skov Møller ([email protected])
4
Variables 1: Identifikation
ENT
LKAU
LeU
LLKAU
EG
VAT
Identification no.
x
x
X
x
x
x
Name
x
x
X
x
x
x
x
x
x
x
x
Other def.
Address
-
Physical location
-
Postal
(x)
(x)
(x)
(x)
Other def.
-
Postbox
(x)
(x)
(x)
(x)
Other def.
(x)
(x)
(x)
(x)
(x)
x
x
Phone, fax, e-mail
Sub-type
Kiev 2nd – 5th October 2012
Mrs Vibeke Skov Møller ([email protected])
5
Variables 2: Demography
ENT
LKAU
LeU
LLKAU
EG
VAT
Creation/birth
x
x
x
x
x
x
Cessation/death
x
x
x
x
x
x
(x)
(x)
Not active
Kiev 2nd – 5th October 2012
Mrs Vibeke Skov Møller ([email protected])
6
Variables 3: Stratification
ENT
LKAU
LeU
LLKAU
Location address (code)
x
x
x
x
Other def.
Main activity
X
x
x
x
X
Secondary activity (1-3)
(x)
(x)
(x)
(x)
Legal form
x
Sector code
EG
VAT
x
Other def.
x
x
x
Employment:
- FTE
x
- Employed pers. (total)
x
x
x
x
- Employed pers. (hired)
x
x
x
X
Turnover
x
Statistically significant*
x
x
x
Kiev 2nd – 5th October 2012
Mrs Vibeke Skov Møller ([email protected])
7
Variables 4: Relations
Enterprise – stat. LKAU
ENT
LKAU
X
X
LU – adm. LKAU
Enterprise - LU
X
Adm. LKAU – stat. LKAU
EG – enterprise
LU - VAT
LeU
LLKAU
X
X
EG
X
X
X
X
X
X
X
Kiev 2nd – 5th October 2012
Mrs Vibeke Skov Møller ([email protected])
VAT
8
Examples of tables in the Danish SBR
Enterprise
Activity Nace 2
Id_nr
Unit_nr
Unit_type
Updating date
Updating source
Updating Id
Correcting date
Correcting source
Correcting Id
Activity code No
Activity code
Updating date
Updating source
Updating Id
LKAU
Id_nr
Updating date
Updating source
Updating Id
Unit_nr = Id_nr
Unit_type =
Enterprise or
LKAU
Activity code No =
0, 1, 2, 3
Activity code =
Danish Nace 2
Kiev 2nd – 5th October 2012
Mrs Vibeke Skov Møller ([email protected])
9
The units types
One physical
location
One
Activity
One or
more
activities
Locations in
different
countries
One or more
physical locations
- LKAU
- LUHP
- KAU
- UHP
- Local unit
- Enterprise
- Enterprise Group
- Institutional unit
- Multinational
Enterprise
Group (MEG)
Plus: Legal unit – administrative; not statistical
LUHP: the local unit of homogeneous production (of interest for National Account)
UHP: the unit of homogeneous production (of interest for National Account)
Kiev 2nd – 5th October 2012
Mrs Vibeke Skov Møller ([email protected])
10
An enterprise with several KAUs and LUs
Ent. 1
KAU 1
Act. 52.11.10
Faglig
KAU
enhed
2 1
Act.
Br. 52.11.10
52.11.30
KAU 3
Act. 60.24.10
LKAU 1
LKAU 2
LKAU 3
LKAU 4
LKAU 5
Act. 52.11.10
Act. 52.11.10
Act. 52.11.30
Act. 52.11.30
Act. 60.24.10
LU 1
Act. 52.11.10
LU 23
Act. 52.11.??
LU 4
Act. 52.11.30
LU 5
Act. 60.24.10
Kiev 2nd – 5th October 2012
Mrs Vibeke Skov Møller ([email protected])
11
Data extracts from the business register
The business register supplies extracts for the statistical
divisions at Statistics Denmark. They may, e.g. cover:
- Total extracts from the entire business register
- Partial extracts with selected activities, selected
geographical areas, selected legal forms or size groups
measured in terms of turnover or number of employees
Extracts are used for statistics, questionnaire-based
surveys and service tasks (i.e. tasks which the users pay
for)
Kiev 2nd – 5th October 2012
Mrs Vibeke Skov Møller ([email protected])
12
How to order data extracts
Extracts are made by
the business register –
refinement in own division
• Via email to a functional mailbox: [email protected]
• The users should specify the purpose / intended usage of
the data extract:
– Selection of sample survey?
– Mailing of questionnaires?
– Extrapolation of figures from sample to population?
• important to know if it relates to units at legal, enterprise or local unit level
– The date/period for the extract should be specified
• The extracts should be requested well in advance
– Data are usually supplied within 3 days (90%)
– Special extracts may take longer time
The business register
helps the statistical divisions
to ensure correct use
• New on line tool for extracting data from the frozen
SBR-versions has resently been released
Kiev 2nd – 5th October 2012
Mrs Vibeke Skov Møller ([email protected])
13
User feedback regarding extracts
We receive feedback from customers of data extracts
regarding:
•
•
•
•
Returned mail, changes of address
Changes of activity (or errors)
Discontinuation of LKAUs
New LKAUs
It is important that the statistical divisions forward errors
and corrections to the SBR and do not themselves
maintain any ”shadow registers”.
The higher the number of corrections received, the better
the quality of data in the Business Register
Kiev 2nd – 5th October 2012
Mrs Vibeke Skov Møller ([email protected])
14
Business Register and Data Collection – one
service line
Core process
Receive
data to
SBR from:
Quality
assure
SBR data:
Extract
data from
SBR:
-ABR
-Tax
-E-Income
-Turnover
-TEGs
-LKAU
empl.
-Manual
-Automatic
-Stats. Div.
-Profiling
-Frozen
-Ad-hoc
-Internal
Basic data
Frozen
versions
of SBR:
-Monthly
-Quarterly
-Annual
Send out
questionnaires:
-Prepare
survey
population
-Print and
send
Register
received
data:
Send
reminders:
-Registration
-Scanning
-Verification
-Reminder(s)
-Manage
police prosecution
Statistical data
Return path to XIS
Stats. Dept.
Internal statistics
Burden reduction
Support enterpr.
Maintain and
develop IBS
Data Collection
Develop electronic
questionnaires
Coordinate re
generic IT
systems
Coordinate with
stats. divisions
Extract and
optimize samples
Method
Measure quality
Optimization of
SBR performance
Coordination re
statistical units
Activity
classification
Maintain and dev.
the SBR applic.
Cooperate with
data providers
Support processes
Business Register
Statistical
data in XIS:
-Retail
trade
-Industry
-Intrastat
-R & D & I
Process
statistical
data
-Ext. trade
-STS
-SBS.
-Services
15Statist