XBRL-CRAS
CREDIT RISK ASSESSMENT SERVICES
FLIPA Project update
Seattle conference – Nov. 05, 2003
V. Bert – GERLING NCM
Content

Introduction

Why is XBRL-CRAS different?

Taxonomy overview

Project overview

Questions
Nov, 2003 – 8th XBRL Int’l conference -CRAS wg update – V. Bert - Restricted
1
Content

Introduction

Why is XBRL-CRAS different?

Taxonomy overview

Project overview

Questions
Nov, 2003 – 8th XBRL Int’l conference -CRAS wg update – V. Bert - Restricted
2
Who are we?
XBRL-Int’l
XBRL-CRAS working group
Credit Risk Assessment Services
FLIPA Taxonomy
Credit Insurance
Business Info.
suppliers
Other projects
welcomed!
Nov, 2003 – 8th XBRL Int’l conference -CRAS wg update – V. Bert - Restricted
3
The XBRL-CRAS project receives special attention from XBRL International and other 3rd
parties because CRAS has specificities that other XBRL projects do not have...
Content
Application
• CRAS members reports
information on other
companies
• XBRL usually used to report
financial figures about the
company
• XBRL is usually used to
produce information
• CRAS intends to develop an
end-to-end application
including querying,
answering modes,…
XBRL
CRAS
• The need to use standard
semantic terms through
code lists is specific to
XBRL-CRAS
• XBRL allows the use of code
list – no technical difficulty.
• Phase 1 will recycle the
existing business
requirements which makes
CRAS quickly ready to start
technical implementation
Business semantic & Code Lists
Business Requirements
Nov, 2003 – 8th XBRL Int’l conference -CRAS wg update – V. Bert - Restricted
4
Even with the support we continuously receive from XBRL Int’l,
CRAS still has to manage key success factors to ensure smooth delivery of the target
Project Challenges
International context & large
group (different companies)
No dedicated resources
Wide business container
Short time-to-market
Evolving XBRL Specifications
Lack of XBRL expertise
among project members
Key Success Factors
 Ensure good communication through centralized support office
 Obtain steering committee support to assign local resources
 Outsource tasks when it is feasible / reasonable
 Assign a task to chase completion of targets
 Main focus on NON-Financial business information
 Leverage every independent XML initiatives towards XBRL
 Ensure quick decision-making and easy implementation
 XBRL experts to be integrated in the design strategy process
 Final technical validation to be performed on stable requirements
 Need assistance from external experts and learn for the future
Nov, 2003 – 8th XBRL Int’l conference -CRAS wg update – V. Bert - Restricted
5
XBRL-CRAS project team agreed on assumptions that paves the way towards the
implementation of an end-to-end application
Electronic credit report
Deliver a first electronic credit report trough
an end-to-end application
Transaction context
Run XBRL Instance document in Synchronous real time
transaction environment (10.000’s per day)
Business semantics
& Code Lists
Use of common existing code lists as defined under GREFIS,
UN/EDIFACT & ISO
Language
Develop a multi-language case to benefit from XBRL flexibility
for labels and code lists
Technical XBRL Specs
Develop under XBRL Specification 2.1
Security
Security items (encryption, signature,…) managed outside of
the FLIPA project
Nov, 2003 – 8th XBRL Int’l conference -CRAS wg update – V. Bert - Restricted
6
Content

Introduction

Why is XBRL-CRAS different?

Taxonomy overview

Project overview

Questions
Nov, 2003 – 8th XBRL Int’l conference -CRAS wg update – V. Bert - Restricted
7
XBRL-CRAS : The FLIPA taxonomy
Message information
non-XBRL
Message information
non-XBRL
e-Report over XBRL
Sender,
Envelope
Product,
header
...
...
Entity
Related
entities
Key
Credit
Business
Negative
financial
recomme
rating
events
figures
ndation
Envelope
trailer
…
XBRL-CRAS FLIPA taxonomy extract
Nov, 2003 – 8th XBRL Int’l conference -CRAS wg update – V. Bert - Restricted
8
XBRL-CRAS FLIPA Core Taxonomy (Business semantics requirements)
Item
Identification
Related entities
Related entities
Related entities
Related entities
Legal form - Current
Legal form - former
Activity
Activity
Description
 Organization Business Ids
 Organization Name / Trade name
 Organization Address
 Branch/head office information
 Organization Business Ids
 Organization Name
 Organization Address
 Type of relationship: Shareholders/shareholdings/affiliates
 Nb of shares
 % of shares
 Code,
 Description Long,
 Description short,
 Date start
 Code (SIC, Nace…)
Nov, 2003 – 8th XBRL Int’l conference -CRAS wg update – V. Bert - Restricted
9
XBRL-CRAS FLIPA Core Taxonomy (Business semantics requirements)
Item
Trading countries
Trading countries
Trading countries
Operation status
Description
 Trade Class (importer/Exporter),
 Country,
 % of total
 Code List:
Nov, 2003 – 8th XBRL Int’l conference -CRAS wg update – V. Bert - Restricted
10
XBRL-CRAS FLIPA Core Taxonomy (Business semantics requirements)
Item
Trend
Trade Morality
Financial situation
Payment Trend
Description
 Level,
 Up, down
 Undetermined
 Good,
 Average,
 Poor,
 Undetermined
 Strong,
 Weak…
 Payment scores
Nov, 2003 – 8th XBRL Int’l conference -CRAS wg update – V. Bert - Restricted
11
XBRL-CRAS FLIPA Core Taxonomy (Business semantics requirements)
Item
Status
Business outlook
Payment behavior
Description
 Operating,
 Chapter 11, 13
 Dormant…
 Trend up,
 Flat,
 Trend down
 General experience:
Slow,
Slow 30,…
Prompt
Payment details
Payment details
Payment details
 Detail with trading partners,
High credit,
Owes,
Past due
Terms
Nb of employees
 Location,
 Headquarters / Branch
 Nb of employee / seasonnal
Nov, 2003 – 8th XBRL Int’l conference -CRAS wg update – V. Bert - Restricted
12
XBRL-CRAS FLIPA Core Taxonomy (Business semantics requirements)
Item
Financial statement data
Industry ratios
Principal and management
Real estate properties
Real estate properties
Real estate properties
Financial institutions
Financial institutions
Financial institutions
Description
 Use of existing taxonomies:
IFRS, US GAAP, German AP…
Full or extracts only
 Trade sector standards
 Names
 Mgt titles,
 Background
 General property,
 Total value,
 General mortgage information,
 Total value of mortgage,
 Dates,
 Address
 Name,
 Address,
 Customer since,
 Type and amount of Credit
Nov, 2003 – 8th XBRL Int’l conference -CRAS wg update – V. Bert - Restricted
13
XBRL-CRAS FLIPA Core Taxonomy (Business semantics requirements)
Item
Credit Recommendation
Business ratings - current
Business ratings - former
Score
Negative events
Negative events
Negative events
Description
 Amount
 Type of rating,
 Rating,
 Agency Name and address,
 Score Type and value,
 Type and Amount,
 Nb & Status,
 Dates occurred
Nov, 2003 – 8th XBRL Int’l conference -CRAS wg update – V. Bert - Restricted
14
Taxonomy extensibility:
CRAS, FLIPA, jurisdiction or company Taxonomy extensions
Message information
non-XBRL
Message information
non-XBRL
e-Report over XBRL
Sender,
Envelope
Product,
header
...
...
Entity
Related
entities
Entity
Related
entities
Key
Credit
Business
Negative
financial
recomme
rating
events
figures
ndation
Business
rating
XBRL-CRAS taxonomy extract
Nov, 2003 – 8th XBRL Int’l conference -CRAS wg update – V. Bert - Restricted
Balance
Sheet
Profit &
Loss
Country specific
XBRL extension
IFRS
US GAAP
GERMAN AP
SPANISH GAAP
Envelope
trailer
…
…
Other…
Company
specific
XBRL
Extension
15
Content

Introduction

Why is XBRL-CRAS different?

Taxonomy overview

Project overview

Questions
Nov, 2003 – 8th XBRL Int’l conference -CRAS wg update – V. Bert - Restricted
16
FLIPA
project
The project is organized in competence areas:
- to deliver the key results expected from the different workstreams
- to ensure right level of project governance, monitoring & coordination
- to establish communication to the external world.
Responsibilities of each project are detailed in appendix
Nov, 2003 – 8th XBRL Int’l conference -CRAS wg update – V. Bert - Restricted
17
FLIPA
In order to develop the electronic report product,
the project team has identified the following workstreams to be performed…
project
WS 0
Project Office
and Steering
preparation
WS 1
Project
Management and
Liaison team
Project Office,
Budget and resource definition,
WS 2
Business
Requirements
WS 3
XBRL Taxonomy
development
 CRAS
Chairmanship
 WG project
management
 TWG Project
Management
 Project
Management
 Finalize Business
Requirements
 Taxonomy design
strategy
 Project reporting
 Design conceptual
samples
 Data Model
 Champion CRAS
cause
 Taxonomy
certification
Planning,
 Validation Rules
 Taxonomy
Implementation
 Sign-off code lists
 Testing
Implementation Road map.
WS 4
Non-XBRL
components
 Technical Layer
 Transaction
Infrastructure
definition
WS 5
Pilot testing
&
Implementation
 Pilot testing
coordination
 Infrastructure SetUp
 Product and service
handling
 Interoperability
testing
 Testing
 Validation and signoff
 Quality Assurance
Nov, 2003 – 8th XBRL Int’l conference -CRAS wg update – V. Bert - Restricted
18
FLIPA
project
Design to cost:
THE reasonable approach to deliver the CRAS FLIPA taxonomies on time
Description
 Reasonable approach to deliver phases 1 and 2
on time
2003
2004
2005
2005
Phase 1
50%
50%
Phase 2
100%
Nov, 2003 – 8th XBRL Int’l conference -CRAS wg update – V. Bert - Restricted
19
… and proposed the following planning to have the phase 1 ended in March 2004
Man/days
Nov
Dec
Jan
Feb
Mar
WS 0
Project office and 1st
steering preparation
20
20
WS 1
Project Management
and Liaison activities
40
31
WS 2
Business Requirements
81
0
WS 3
XBRL Taxonomy
development & QA
90
36
WS 4
Non-XBRL components
40
0
WS 5
Internal External
E-report testing
/
0
271
87
Testing not included as dependant on company specific infrastructure
Nov, 2003 – 8th XBRL Int’l conference -CRAS wg update – V. Bert - Restricted
20
Content

Questions & Answers
For further Information please refer to our
Website and egroup:
http://www.grefis.org/xbrl-cras.htm
http://groups.yahoo.com/group/XBRL-CRAS/
Vincent BERT
Senior Manager
Group Business Information Dept.
*
GERLING NCM
44 Av G. Pompidou
92300 Levallois-Perret
FRANCE
Tél. : +33 (0)1 41 05 71 40
Fax : +33 (0)1 56 90 01 09
E-mail : [email protected]
To be renamed « atradius » on 01/01/04
Nov, 2003 – 8th XBRL Int’l conference -CRAS wg update – V. Bert - Restricted
21
Descargar

XBRL-CRASFlipa pres Seattle 05/11/2003