Transcript PowerPoint-presentatie

CEN/WS XBRL
CWA2:
Hot topics of interest in 2nd level reporting
20 February 2013
Ignacio Boixo
Page 1
CWA2
Hot topics of interest in 2nd level reporting
Workflow on 2nd level reporting
Proof of concept e-mail validation
Core Business Vocabulary
Legal Entity Identifier
Any other Business?
Page 2
Requirement: example workflow
Signature (and
encryption) via National
regulator public certificate
Signature (and
encryption) using
European regulator
public certificate
Submission container
Subcontainer
header.xml
nationalinstance1.xbrl
nationalinstance2.xbrl
Declarer
Page 3
Subcontainer
National
Supervision
Authority
European
Supervision
Authority
Encryption (public key of the first addressee)
Signature 1 (contributor 1 - private key)
Zip
Alternative A: Signature encapsulated
National
Supervision
Authority
Header
Instance 1, Instance 2, …,
Instance n
Signature 2 (contributor 2 - private key)
Zip
Header
Instance 1, Instance 2, …,
Instance n
Signature/
Encryption
(addressee
certificate)
& transfer
Encryption (public key 2nd addressee)
Signature 3 (contributor 3 key)
transfer
Zip
Header
Instance 1, Instance 2, …,
Instance n
…
Page 4
Other
Authority:
e.g. EBA
Other
Authority:
BIS / ESRB /
Banking
Union / …
Encryption (public key of the first addressee)
Signature 1 (contributor 1 - private key)
Zip
Alternative Z: Zip-encapsulated
National
Supervision
Authority
Header
Instance 1
Instance 2
...
Instance n
SignedSubContainers
XadesSignedSubcontainer.xml
•signed with contributor 2
private key
•Inside, zip file with a new
Header, Instance 1, Instance
2, …, Instance n.
Encryption
(next
addressee)
& transfer
FullSubContainers
EncryptedSubcontainer.xml
•public key 2nd addressee
•signed with contributor 3
private key
•Inside the signed, zip file with
a new Header, Instance 1,
Instance 2, …, Instance n.
Page 5
Transfer
only
Other
Authority:
e.g. EBA
Other
Authority:
BIS / ESRB /
Banking
Union / …
Characteristics
Alternatives are functionally equivalent: both provide
Xades-signed sub-containers for trusting authorities
Fully encrypted subcontainers for non-trusting authorities
Both alternatives can deliver as a result a set of files using a generic
decomposition tool
For Alternative 1, the result file set will be a flat set of files having their original
filenames
For Alternative 2, the result file set will be a hierarchical set of files (in accordance with
the folder hierarchy defined in the .zip container, both folders and files having their
original name)
Problem : How shall the NSA identify the final recipients of the subpackages
(EBA, Banking union, etc)?
For Alternative 1, the addressee of the subcontainer has to be identified using a nonstandard xml tag (requiring thus an intermediate xml schema which is not standard?)
For Alternative 2, a file naming convention would be required in the instructions of the
NSA to identify the addressee of the subpackage
Page 6
Proof of concept e-mail validation
Encryption (XML Encryption)
Signature (XADES-EPES)
Zip
Instance-1
…
Instance-n
Anonymous
Encryption (XML Encryption)
Signature (XADES-EPES)
Package & Compress (zip)
Feedback
instance1.xml
instance2.xml
…
instancen.xml
Page 7
Eurofiling
Test
Validator
(Arelle)
http://joinup.ec.europa.eu/asset/core_business/description
Page 8
Page 9
Page 10
TABLE 1. Legal Entity-Names
TABLE 2. Legal Entity-Identifier
TABLE 3. Legal Entity-Code
TABLE 4. Person-Names
TABLE 5. Person-Identifier
TABLE 6. Person-Location
TABLE 7. Legal Entity-Address
TABLE 8. Location-Address
TABLE 9. Location-Geometry
TABLE 10. Location-Geometry (alternative representation)
In yellow, the primary key of the table, usually an unique value, not to be repeated (see notes on Tables 1, 4 and 6).
Page 11
TABLE 1. Legal EntityNames
Typed
Primary
Dimension
Item
Legal name Alternative
name
Note: Legal name as primary key would be duplicated is several alternative names exist. This is NOT an issue
in XBRL. In RDBMS, both jointly are the primary key.
TABLE 2. Legal Entity-Identification
Legal Entity - Identifier
Primary
Primary
Typed
Typed
Primary
Primary
Item
Item
Dimension Dimension
Item
Item
Legal name Issuing
Issuing
Identifier Identifier Date of
authority authority
type
issue
(name)
URI
TABLE 3. Legal EntityCode
Company activity
Company Status
Company type
Typed
Primary
Primary
Primary
Primary
Primary
Primary
Primary
Primary
Primary
Primary
Primary
Primary
Dimension
Item
Item
Item
Item
Item
Item
Item
Item
Item
Item
Item
Item
Legal name Content
List
List agency List version Content
List
List agency List version Content
List
List agency List version
Page 12
TABLE 4. Person-Names
Residency
citizenship
Typed
Primary
Primary
Primary
Primary
Primary
Primary
Primary
Primary
Primary
Primary
Primary
Primary
Dimension
Item
Item
Item
Item
Item
Item
Item
Item
Item
Item
Item
Item
Full name Family
Given
Patronymic Alternative Gender
Birth Name Date of
Date of
name
id: URI
name
id: URI
name
name
name
name
(closed list)
birth
death
TABLE 5. Person-Identifier
Legal Entity - Identifier
Primary
Primary
Typed
Typed
Primary
Primary
Item
Item
Dimension Dimension
Item
Item
Full name Issuing
Issuing
Identifier Identifier Date of
authority authority
type
issue
(name)
URI
TABLE 6. Person-Location
Country of birth
Place of birth
Country of death
Place of death
Typed
Primary
Primary
Primary
Primary
Primary
Primary
Primary
Primary
Dimension
Item
Item
Item
Item
Item
Item
Item
Item
Full name Geographic Geographic Geographic Geographic Geographic Geographic Geographic Geographic
name
identifier: name
identifier: name
identifier: name
identifier:
URI
URI
URI
URI
13 (i.e. "John Smith") is prone to be duplicated. This is an inherent issue of the Core Person Vocabulary. Disambiguation to be solved
Note:Page
Full name
(hopefully) by adding something (to be investigated) to the Full name.
TABLE 7. Legal Entity-Address
Typed
Primary
Primary
Dimension
Item
Item
Legal name Full address PO Box
Primary
Primary
Primary
Item
Item
Item
Thoroughfar Locator
Locator
e
designator name
Primary
Item
Address
area
Primary
Item
Post name
Primary
Primary
Primary
Item
Item
Item
Admin Unit Admin Unit Post Code
L1
L2
Primary
Item
Address ID
Primary
Primary
Primary
Item
Item
Item
Thoroughfar Locator
Locator
e
designator name
Primary
Item
Address
area
Primary
Item
Post name
Primary
Primary
Primary
Item
Item
Item
Admin Unit Admin Unit Post code
L1
L2
Primary
Item
Address ID
TABLE 8. Location-Address
Typed
Primary
Primary
Dimension
Item
Item
Geographic Full address PO Box
identifier
TABLE 9. Location-Geometry
Typed
Dimension Primary Item Primary Item Primary Item Primary Item
Geographic WKT
Lat
Long
XML
identifier
geometry
Page 14
TABLE 10. Location-Geometry (alternative representation)
Typed
Dimension Primary Item Primary Item Primary Item
Geographic Coordinates CRS
Geometry
identifier
type
Legal Entity Identifier and mapping to Core Business Vocabulary
Page 15
Legal Entity Identifier
Page 16
Legal Entity Identifier
Page 17
http://www.dtcc.com/downloads/news/CiCi_Report.pdf
Page 18
http://www.dtcc.com/downloads/news/CiCi_Report.pdf
Page 19
http://www.dtcc.com/downloads/news/CiCi_Report.pdf
Page 20
Thanks for your attention
[email protected] (as back up of [email protected])
Comments or questions?
Page 21