Home

ARACHNE

image

Contents

1. E o 52 sane a0 o gs _ 2 gt gt See Sse ase 2 BB sEB 2S eS 8 5 FEIRER Osea desg MW x lgyo2zi9 6ci26cso26co0 97 ES EE 24 EL gt 09 9958 os 280 u ou5owsc5o2stcos9 S Zct EcczEZcrc0 57 e ad E ab e E m OS se 2 592 5z92o5098g822o028 0986 0595so09srco059 sg j oclo a2 595 9s gs So SS SSS SVS SES ST ESE SEED DEE SER wiszwi2gw aeag ass SS OSs b se 55 SEs sos s 5S2 ggo a 825 fLPIPPIPPTIE co o 26 oO O CE Cso L 8E Jz 3S 2 32 J32 538 isQ 18 16 0 sQ 4o Links between beneficiaries project partners and sub contractors I ov lo 30 o o OC 30 Links between beneficiaries project partners and sub contractors 0 lo is 1c o o 30 0 lo 13 16 o o 30 ru w 0 i19 800 259 oQ o 30 0 Alert Value 2 219 sio 2 SQ 20 e o zT zs Number of paths between beneficiaries project p 1 i29 10 i160 259 o 30 0 i10 260 1c oQ o 30 0 i20 Q 13 25 31 w 0 le 150 210 25Q 33 s C w 0 lap 100 1c of 250 Wo a w 0 i30 3010 219 o Q o 30 w rn is 13 330 259 o 20 a 0 eQ eQ e op oo soQ 0p 150 so 5 20 5Q 70 w o9 00 w 0 FAKE Project link subContractor e Mr Norbert Marcel Madeleine Yerkimpe Legend Role Role Related company VADIS B S CONSULTING Bl Beneficiary BISNODE BELGIUM El Sub contractor HOLDING NV e 1 FAKE Project link subContractor
2. In this screenshot based on the Links between contractors suppliers we can see there are relationships between different contractors companies related to the selected project 7 6 1 Customization The customization works the same way as the surrounding graphs giving you the ability to add one more relation level to the graph using multiple relation types 7 6 2 Specific options The specific options are identical to the local view graph chapter 7 4 2 Note that the history will only contain different version of the graph each time you modify its customization parameters as there is no navigation in this type of graph 65 ARACHNE User manual 7 Common graph options For all or some of graph windows there are common available options Save Save as Zoom KPI Quick Highlighting as image vector coloring search image Hierarchical graph Group map Affinity graph Local view Surroundings graph Paths graph T 1 Save as image The 44 button saves the graph with its legend if displayed as a bitmap image The graph can be saved in JPEG PNG or BMP format by selecting the file format when saving it This is a convenient tool to include graphs in other documents or to print them 7 1 2 Save as vector image The lj button saves the graph in vector format SVG Vector formats have the advantage that they can be scaled from very tiny to very large prints without quality loss 7 7 3 Zoom The zoom options
3. 71 ARACHNE User manual i 8 1 2 Contract interactive report Case management and general information This section is similar to the project report but with contract information 8i Interactive report Contract32 Case management Case status Case sub status amp New case General information A Contract ident Contract 32 Name Contract 32 Description blabla Amount 126 497 14 Signature date 2003 03 01 Source Fake End date initial 2010 08 31 Nb contract addenda 4 End date effective 2010 12 29 Subcontract No Key expert e Addenda cost 39 437 14 Contract type Beneficiary type Public Project type Hail Project status Closed Contract modifications Procurement proc NegotiatedProcedure Member state Fake country Neighborhood section This section contains the following elements requestors contractors sub contractors consortium members and sub contracts Neighborhood Requestors Contractors Sub contractors Consortium members Sub contracts Requestor Name generic Requestor Project ident Requestor Name Requestor Cost Eligibility Contract Overall Score 1 i a e o FAKE Praject 020 08 FDVC 01 02 00 00 020 08 FAKE Project 020 08 64 959 590 00 2 CM Revised score Requestor Overall Score Procurement Overall Score Requestor ne Management wn Overall Score Requestor Hequestor i C I e oO Alerts summary This section i
4. Applicable project types Pop up information Activity changes 3 Activity changes Company involved Role in project Previous sector New sector 0 GET Kereskedelmi s Szolg ltat Korl tolt Felel ss g T rsas g Beneficiary Manufacture of electricity distribution and control apparatus Wholesale of electrical household appliances 1 GET Kereskedelmi s Szolg ltat Korl tolt Felel ss g T rsas g Beneficiary Shaping and processing of flat glass Manufacture of electricity distribution and control apparatus 2 GET Kereskedelmi s Szolg ltat Korl tolt Felel ss g T rsas g Beneficiary Wholesale of electrical household appliances Shaping and processing of flat glass 239 ARACHNE User manual B Activity changes 3 Activity changes Number of different sectors last year Number of different sectors in the last 3 years Change date of sectors Related company 3 20130918 HU13375542 3 20130320 HU13375542 3 20130220 HU13375542 a P The following detailed information is available in the tables tab Company name Role in the project Previous sector activity code limited to 30 as a preview New sector activity code limited to 30 as a preview Number of different sectors activity code in the last year Number of different sectors activity code in the last 3 years Date ofthe change in sector activity code VAT number of the company No detailed informatio
5. Here s a matrix representing the different categorical alerts and their availabilities for the different entities Projects Contracts Beneficiaries Contractors Procurement Contract management Eligibility Performance Concentration Reputational amp Fraud Other 27 ARACHNE User manual Es Each alert is represented by a numerical value and a LED style indicator which goes from green no risk to red highest risk x S et est get sae z 265 28 EE 25 225 Sio 25 30 Es Se 223 s 55 ES gS 08 sz 52g Zi 28 88 5a RIP o 2 ig so 1c o0 ssQ 16 e so D 278 27 sog Q 35 so 28 so sog 100 25 so 5 100 2 so 3500 w og 22 so 50 100 17 so soQ o 23 so og 0 30 o 18 Missing alerts are represented by a minus sign and a grey LED representation It means that e the alert is out of scope for the project contract e Or the data required to calculate the alert are not provided to Arachne e Ornotall data internal and or external are available to calculate the alert 5 2 Projects dashboard The projects dashboard focuses on the E C projects and their beneficiaries contractors Projects global No condition F o gt o o zo a S 8 BB a 28 28 28 B 552 X bS o Eo sbo to 8o 50 22 Sen Name generic Case status c8 S Ebs 25 ss s 8 2553 Project type M
6. VPI EDV min minimum Estimated Deal Value indicates the lowest range prediction of the financial value a company has if it would be sold at that moment VPI EDV max maximum Estimated Deal Value indicates the highest range prediction of the financial value a company has if it would be sold at that moment The strength of the relationship between two groups defined as the average of the two PR ratios between them e 111 ARACHNE User manual Welcome window The welcome screen acts like a kind of cockpit in which different types of information are directly visible for the connected user This information covers the case management the alert statistics and the different dashboards used in the application 112 ARAUHNE U Ser Mdahudl 14 2 Vadis Predictive Indicators VPI P2B Bankruptcy is a predictive indicator that indicates the propensity to bankruptcy i e the probability that a company will go bankrupt within the next 12 to 18 months VPI P2B Bankruptcy bases its predictions on models with global reach and that are then localized The best model for each country size block is chosen amongst a large number of models built in that block and cross validated within the population All models are built based on the actual bankruptcy events which occurred during the preceding years The best models are further tested and validated using identified bankruptcy events from an earlier period than the one that was used
7. c a 2 Es Os 235 Project type Member state Manat z P BP Si SE iP 28 i ER S 6 c z a6 O o cus FAKE Project supervision1 34 i849 s0G 30 50o 22 Solid waste Fake country Minist FAKE Project ExtProv 34 18 sog C 35 50o 0 Solid waste Fake country Minist Standard columns can be re ordered using drag and drop However alert columns cannot be moved Standard columns have their header text displayed horizontally and no other symbol User can click with the left mouse button on the header cell to sort the current elements present in the dashboard Sorting is limited to one column only it is not possible to sort on multiple columns at the same time see chapter 5 6 4 for more details Alert categories Alerts are grouped aggregated into alert categories The dashboard screen offers the ability to expand and collapse these categorical alerts to display the individual alerts see chapter 5 6 3 The alert selection indicator red triangle on the cell upper left corner indicates which current alert category is used by the dashboard selection Dashboard toolbar A dedicated dashboard toolbar is present on the bottom of the dashboard screen BSB FE 20 element s Select all Selects all items present in the dashboard Note this is only selecting the root items Items present in sub dashboards are not selected Selection is used when using the export feature from the file menu Le cha
8. closes all windows actually m Task pane opened in the application space DEL TEn Lis In addition the list of currently opened windows is present in the F3 GET Client introduction menu for quick switch between them E Welcome window D Projects global The Help menu contains the About option the link to the user About Alt A manuals present in the application folder as well as other help links The last option opens a data information panel in the task User manuals pane which lists different release information about the current Content database Index Orbis 20130918 2013 09 18 ee Cluster Groups 4 5 1 2013 09 18 Lene UPI 20130918 2013 09 18 Data information Alt4D VPI 20130918 2013 09 18 MDD Arachne GetMetaDB CE 20130918 D29 Search 3 2 5 2 Task pane The task pane is the left side part of the application screen and contains multiple functional blocks User information module Ei Administrator Your login name JP Connect Connect link 2 Your current profile A Change your password 498 Disconnect The password change option Your profile information Disconnect link Note that the password change option won t be available when connected using the ECAS authentication Case management module Case management Case management welcome screen List of opened cases based on user s context List of white listed cases based on user s context List of black listed cases base
9. 3 Filter groups sub alerts are located into their own groups the general group contains only top level alerts Combinations of criteria from multiple groups can be done Clicking on group title will open each group so individual values can be changed 4 Buttons these buttons allow applying the filter and resetting the filter By resetting a filter all selectors will be re initialized to the full range of values To perform a selection change the selection criteria or values and click the Apply Filter button To reinitialize the dashboard to its default selection click the Reset then the Apply Filter button Contract Management Overall Score Links between beneficiaries project partn o6 5 42 Q 50 o ERENT i Range selectors cover the complete range of values for each alert This allows the user to refine its selection and to target potential issues more accurately Moving the left right cursors will select the minimum maximum value of the selected range When cursors are completely on the left and on the right covering the complete range the criterion is ignored Performing complex filtering Single or multiple criteria can be used in multiple groups if needed The selection is always the combination of all modified criteria 39 ARACHNE User manual 6 Search and navigate In order to perform dedicated and accurate investigations the application contains dedicated search forms These search options are separated in two cate
10. 558 62 on 3go0 a go En 29 zZuzo Name generic Case status 8 Ss 23 ia zz og Sos Projecttype Member state Mana ps Oss us dir 58 i icr m z O 4 6 Overall Score 32 FAKE Project 024 09 Q lt 20 D 1 so so so 10 ESF Fake country Minis Overall Score 30 FAKE Project link subContractor Q soQ 0 0 O 25 so0 1s Road Fake country Minis FAKE Project sanction03 Q 3soQ Q 0 0 25 so s Fake country Minis Overall Score 17 Overall Score 16 FAKE Project 234 10 Q ieQ 0 e o so 16 10 ESF Fake country Minis FAKE Project 017 09 D 16 D w o 350 30 o 16 ESF Fake country Minis Overall Score 13 FAKE Project 242 10 Q 130 0 cw o so o 10 ESF Fake country Minis Overall Score 12 FAKE Project 023 08 D 120 Q oQ s0 soQ s 17 ESF Fake country Minis FAKE Project 240 10 Q 12 Q o o so o 10 ESF Fake country Minis FAKE Project 241 10 D C Q o o so o 10 ESF Fake country Minis FAKE Project 246 10 9 Q 9 o9 o soQ 1 10 ESF Fake country Minis PAT T312 2 4 171044 A An A m e a li an en lii a ae aal ald 2 42 FT ao wie AE ai J User can change the sort order by clicking on elements in the group panel arranged by moving them The X button in a group item removed the item Group by Group by Concentration Overall Score
11. Copyright Vadis s a 2013 ARACHNE User Manual Client application v1 1 European Commission 1 Table of contents PADI OF CONTENTS REEL DIL 1 ADOUAT HNE e 5 2 1 Groups Exploration OOM RR R 5 Arachne OV OT VC A 6 3 1 OO ES TE A P 6 3 1 1 Installing the client application eee 6 3 1 2 RUNNING the client APPLICATION essei eese nnne nnns nnne 6 3 2 Arachbe gta s d Bs eee ae rn ear eee ree UMS 9 3 2 1 CONNECTING to the applicatiOl iuc isdem et turas nao Evi et Seo E aun ratius do noxa vao dal exo dasE d 9 3 2 2 Disconnection fromthe Syste s siesvssss vua vs stas co EAD esri la Eee aE PA VERA Dre ku le az E PE pu VE ROS 10 3 2 3 Wacome SCLCCI 10 3 2 4 Aracmne interj ACE cirerer oniri n E N E AS 15 3 2 5 Menus and LOO DOIG 16 Understanding the CONCE pts ccscscsccccscsccccccscsccccccscsceccccscscsccccecscsccccecscsceccccscsceseececscssess 20 4 1 PY ACIS Coal ed AAE A A E E EE A A E E A E E E T 20 4 2 Daere D a E A E E 20 4 2 1 Weekly schedule and data refresh cycle lesen 20 4 2 2 New data deliveries impact isses esee eene enne nnn nnns nnne snas aane sanas 21 4 3 Wo e A mtm 21 4 4 Authentication and data iSOlation cccccccccccssss
12. M M and consortium member Notapplicable o Input data The following data is used to calculate the alert Propensity to bankruptcy year X latest available indicator from Orbis Propensity to bankruptcy year X 1 Calculated data The following data is calculated for the alert Evolution of the propensity to bankruptcy from year X 1 to year X Alert value The alert gets a value from O to 10 depending on the value of the propensity to bankruptcy indicator value in Orbis and the evolution of the propensity to bankruptcy over 2 years An increase over time results in a larger alert value Project score Highest alert value of any company linked to the project beneficiary project partner contractor or consortium member Applicable project types Pop up information High or deteriorating propensity to bankruptcy Ea High or deteriorating propensity to bankruptcy Company involved Role in project P2B Bankruptcy score year X P2B Bankruptcy score year X 1 PORT REAL ESTATE Contractor 15 T MOLENBERGNATIE Beneficiary 8 8 The following detailed information is available in the tables tab for all involved companies for which predictive indicators are available Company name 206 ARACHNE User manual Role in the project Propensity to bankruptcy score year X Propensity to bankruptcy score year X 1 No detailed information is available in the values tab Links to further details PORT REAL ESTA
13. Number of affinities Contacts Name Contains Affinity links Name Age c Overview Number of affinities z Contacts Number af Companies Contacts Number of linked groups Affinity links Name Age 120 54 E Number of affinities Number of Companies Number of linked groups Linked countries Contains 6 1 2 2 Search results As the search results represent relations instead of entities it is composed of two parts 1 theresults tree which shows the relation structure and 2 theresults table which displays relation data a f All results Manager a El R Mr Sukhwinder Singh a Mc P Manager ae Number i Hl GOGA ENTREPRISE c date NEN Em Mr Sebastian Muissus M WIRSOL BENELUX m S Mr Firas Alaouie a Mr Sebastian Muissus 30 19830901 8 M SEC SALLAUM EXPORT CENTER ram B amp Mr Christopher Erbsloeh tu Mr Firas Alaouie 30 19830000 5 Hl C H ERBSLOH BENELUX Eg Mr Christopher Erbsloeh 31 19820000 27 Ea Mr E Hadi Diouf 7 a Mr El Hadii Diouf 35 19771103 16 gg CERCLE DES ETUDIANTS SENEGALAI B R Mr Joel Jacobus E Mr Joel Jacobovitz 33 19800126 6 E EASY TRADING Ga Mr Mohammad Hammad Zafar 35 19780805 17 TA aaa dui s Mr Mohammad Mohammadi Vakil Seyed 29 19840502 21 i f amp Mr Mohammad Mohammadi Vakil Seyed Ga Mr Menasche Glecer 29 19831205 11 HI ACROPAQ lil ACROPAQ fa Mr Emmanuel Cuisinier 31 19820610 8 L 1006 elementis e 49 ARACHNE
14. Signature date Key expert change Name generic 39 B 5 EC Type VAT Number E C Country E C oO a Fake Extprov 30 Contracti21 2009 03 01 en Kasa Oszczednosci Bank Polski 30 Unknown 5250007738 POLAND Contract 25 Contacti 2009 01 01 Contract14 Q 25 Contractl4 2009 03 01 Contractor 18 22 FRANCE Contract202 E 24 Contract202 2009 0301 7 Contractor 19 21 FRANCE Fake PO b Q 24 Contracti20 2009 0301 KENDERESI VIZIKOZMU TARSULAT 19 Public 12834444 HUNGARY Contract s G Q 23 Cor 2009 0201 KOMOZO CTMh EOOR i8 111580598 BULGARIA Contract3 F 23 Contr 20090301 LES EPESA PROFESIONALNA 17 BULGARIA Es Fake o 22 Contracti07 2009 03 01 Bi Wrong VAT Q 17 116563994 BULGARIA Bota me HELL nies oie ae ee BE PUMP Kereskedelmi s Szolg ltat Kt 17 HUNGARY Display complete dashboard Display complete dashboard This window displays each dashboard in its minimal version with a reduced set of alerts functions and records o Right click navigation remains effective and the link below each dashboard allows you to open the full functional version This screen is divided into three main sections the case management if applicable for the user part on the top the alert statistics on the middle and the dashboard summaries on the bottom Case management and alert statistics sections can be expanded collapsed using the button on the right of each section title
15. oc FAKE Project SME2 o 33 3100 i10 oQ 0 6 o o0 Q Q Q Q Q ELT o 13 SME Fake country Ministerie 8 FAKE Project 011 08 1300 250 3 8 10 o 10 i10 10 10 oQ oQ Q Q Q Q 10 10 ESF rA maium 7c a Annn Fake country Ministerie 1 cor m a as piim The results of expansion are quite similar in terms of navigation to the context menu accessible via a right click on a project and the selection of Beneficiaries 37 ARACHNE User manual m o 529 u Q0 0 0 o 5 o w xat S3 28 Seen S55 lesan 55 Ges tees eS esSE ce gee 2395 52522 BES P iP ind Name generic bz Ss 225 53 2225 ese 2835205252 Seg 98 255 Member state Managing Authority Op program ic Be BE Ere BIpOI 82id BRISBIIBSIIN EEEE 523 B Bas ccu 60 eR USED cx i a EELO cu EERE E R0 e o0 D c T TN E CHAMEN ERORO ic GR Createnewcase S522 52_2 L Copy name to clipboard VRATSA INVEST GRUF MOHWKA BA cep wk D Interactive report Printable report FAKE Project SME2 URS AE e oO o9 o9 oO O O o 13 SME Fake country Ministerie 8 9999XA999XX FAKE Project 01108 aaa cf 10 10 10 10 08 oO O O 10 10 ESF Fake country Ministerie 1 3999XA999XX FEN 50 voen oO O 10 9 oO O oQ cts Fake country Ministerie 2 3999XA999XXQ FAKE Project 002 08 4 E O O O O o 18 ESF Fake country Ministerie 2 9999
16. 1 130 so of o so oQ o so ieQ 35 ARACHNE User manual E 5 6 5 Viewing alert details This function is only available on individual risk indicator alerts using the right mouse click It displays a dedicated dialog giving extra info on the elements implied in the alert computation as well as clickable links giving an extra context to the alert Alert details are only available on projects and contracts as alerts at company level Beneficiary or contractor are aggregated alerts Beneficiaries involved in multiple projects Li Beneficiaries in multiple projects i a 0 Beneficiary s number of projects o Beneficiary s max number of projects in a same m i i 2 o e Related companies The alert details window can be dragged by maintaining mouse click on the title bar The window can be resized by clicking and dragging the bottom right corner Each individual alert has its own extra information which can contain three types of information Values Beneficiarys number of projects Benefician s max number of projects in a same m The values are present in a simple name value table and are global values used to compute the alert Table information Beneficiary s projects list FAKE Project sanctionO3 FAKE Project SME1 FAKE Project SME FAKE Project SME4 The table information is a multi occurrences multi value
17. 10 ARACHNE User manual Es 3 2 3 1 Current cases section This section of the screen displays all cases related to the user s context in the case management system Cases can be double clicked to get their details Cases are sorted on their creation dates the oldest ones appearing first The case management section is only shown if the user has the necessary access rights Current cases A Id numeric Case title Casetype Casetarget name Amount Case status Case sub status Creation date Follower gt 246 Case to investi gate Project FAKE Project 407 08 4000141 000 00 Unas signe d None 30 12 2013 112500 247 Case 2 FAKE project 3 8 Project FAKE Praject 003 08 35 900080 00 Unassigned Mone 30 12 2013 11 32 14 Case management This table displays the following information about the case the user is allowed to see idis the identification number of the case which is automatic generated Casetitle is the user defined title for the case Case type the entity type to which the case applies The value can be either Project or Contract Case target name is the name of the project or contract concerned by the case Amount is the total cost of the project or the contract amount Case status and sub status give the case current status in time please see chapter 9 for more details about the different statuses Creation date is the date and time when the case was created A Follower is the user assigned to t
18. Boris Gregor Ing Radoskse Jakab Ing Lubomir Ing Milan Hakai j i Res m Trstenciy Sobota Gajalsky pt o Kmek regi n i HL amp VNEMESTO Hok rekonstmkca Centrum vskuru SRBRATSLAVA aintenzifik amp m OV rizikz sobovania i vodou velk ho E mesta i HLAWNE MESTO SR BRATISLAVA re El o RT 178596 Ev y Search lt 15 nodes 15 links 7 5 3 Specific options The specific options are identical to the local view graph chapter 7 4 2 Note that the history will only contain different version of the graph each time you modify its customization parameters as there is no navigation in this type of graph 7 6 Paths graph Paths graph is only available from specific alert details in the reputation and fraud alert category Links between beneficiaries project partners Links between beneficiaries project partners and contractors suppliers Links between beneficiaries project partners and sub contractors Links between contractors suppliers Links between contractors suppliers and sub contractors 64 ARACHNE User manual E The graph displays an identified shortest path between two given entities and some extra information covering the links between found elements In addition the graph can be manually enriched with extra entities and relations if needed Path graphs are only available through specific alert details using the Path links when available
19. Closed view Deep view Depth 2 3 Max nodes 100 300 1 4 1 Customization Options are available by clicking on the tool XX button in the bottom toolbar 59 ARACHNE User manual Parameters Graph depth Max number of nodes 100 ul X v The local view parameters are the graph depth i e the number of neighborhood levels taken from the entry point and the number of neighbor nodes to display on screen 1 4 2 Specific options 1 4 2 1 Overview Clicking on the how hide overview button Ed shows or hides a graph overview panel that can be used to quickly navigate into different areas of a big graph Local view THERAGEN ETEX CO LTD NATIONAL PENSION SERVICE KB FINANCIAL GROUP INC 100 0 36 amp p B E 100 nodes 100 links The blue rectangle represents the main view in the whole graph It can be moved redrawn using the mouse The overview rectangle can also be resized by dragging its borders 7 4 2 2 Navigation and navigation history When double clicking on a company a new local view will be displayed with the current parameters using the selected company as center This gives the ability to slide the view from one point to another without leaving the window In parallel to this navigation the graph keeps a history of the different entry points 60 ARACHNE User manual Es Using the back forward arrows or the history list allows you to go quickly
20. Project type Input data The following data is used to calculate the alert Number of valid tender offers Calculated data The following data is calculated for the alert Average number of valid tender offers in the peer group Deviation of the number of valid tender offers for a specific contract from the average value in the peer group Alert value The alert gets a value from O to 10 depending on the deviation Project score Applicable project types Pop up information Number of valid tenderers ga Number of walid tenderers Alert Total number of valid tenderers for all contracts of the project Lowest number of valid tenderers on project related contracts Average number of valid tenderers in the peer group The following detailed information is available in the values tab Total number of valid tender offers for all contract of the project Lowest number of valid tender offers on project related contracts Average number of valid tender offers per contract in the peer group No detailed information is available in the tables tab Links to further details No links to further details are available 118 ARACHNE User manual E 14 3 3 4 Total Amount of contracts procured via negotiated restricted procedure Total Project Cost Description This check will look at the percentage of contracted amounts within a project that have been awarded using a negotiated or restricted procedure The objective
21. User manual The tree part is used as a sub selection mechanism When relations have the same source entity they are grouped together in the tree Manager Manager 5 M Manager 5 Ni Manager Person Pim Birth of Number of of li j date Finities Companies ka a Mr Jean Christophe Emile Mau Clare 34 19790304 T 5 a Mr Jean Christophe Emile Mau Clare 34 19790304 Fi 5 g CORTIL IMMO C5 DIAMOND PRODUCTS CO GE IN DUO GRILL Mil RDB IMMO 5 Fe 4 4 T 1006 element s When a source element is selected the table displays only the relations having this entity as a source The same mechanism applies when a target entity is selected the table shows only the relations related to this target entity The table columns correspond to the default columns for the source entity the relation and the target entity Header names for source and target entities are prefixed with their names entity role property name as the relation has no prefix only the property name is used 6 1 3 Searching on text fields The way the application processes text search queries differs based on the selected operator In standard search forms most of them use the Contains operator which has particular behavior as it is based on full text indexing techniques This operator is also used by default in dashboard filters for project name The full text indexing strategy behind the Contains operator indexes all separat
22. tree like representation of companies and their common legal links inside the group e The Group map is the top view over groups displaying information about how groups are linked together through their respective company legal links e The Affinity graph represents links between people through companies e The Local view the opposite of the hierarchical view is not limited to a defined set of companies but corresponds to a variable set of companies surrounding the selected one called entry point These surroundings can be modified through parameters to include or exclude elements based on different values e The Surroundings graph is similar to the local view but uses a particular path definition to include the entry point surroundings e Finally the Paths graph displays shortest path information between two given entities and can be enriched with extra entities and relations manually 1 1 Hierarchical view The goal of a hierarchical graph is to display the set of companies belonging to a given group This set is displayed as a directed tree like graph based on the legal links This gives a near reality organizational tree of shareholders and subsidiaries ETEX Std Aggregated companies ETEX Company lY T b MANASCO REDCO MANASCO CAFCO INTERNATIONAL LLC POLYFIBRE S A CERAMICAS CORDILLERA S A Nou RA INVERSIONES ETEXCHILE LTDA sr 0979 NM ETEX LATINOAMERICA S A JANS PULVERIZAR S A SOCIEDAD INDUSTR
23. 005 09 Project Start date 2010 11 01 2011 01 01 2008 10 01 2008 11 03 2009 02 01 2009 01 01 2009 07 01 Project End date 2013 08 31 2012 04 30 2011 12 31 2003 09 30 2014 01 31 2014 04 30 2013 12 31 e For contractors related projects related contracts related executors Neighborhood Related projects Contracts Executors Project Name generic Benef turnover Past fin corr Project Project ident FAKE Project link subContractor FDVC 001 Alerts summary Project Name FAKE Project link subContractor Project Start date Project End ARACHNE User manual Contract Management Overall Score contractor Concentration Overall Soore contractor Eligibility Overall 5core Mame i Overall Alert contractor C3 i Procurement Overall 5core contractor C i Contract Management Overall Score c C I Eligibility Overall Score contractor SubContractors with invalid VAT n 2 Concentration Overall Score contractor Reputational Fraud Alerts Overall Scar CU on 2 No alert information available Procurement Overall Score contractor Overall Alert contractor E Reputational Fraud Alerts dU IINE i Description 31 Overall Alert contractor Procurement Overall Score contractor 25 Contract Management Overall Score contractor 50 Eligibility Overall Score contractor ki si 10 n Tactors
24. 01 01 2010 12 31 525 230 00 000016402008 Prevenir para Inovar Sector da Cer mica e Vidro SE POAT 2008 09 01 2009 12 30 719 325 00 000401402011 Surdocegueira um modelo de interven o SE POAT 2012 01 02 2013 12 30 97 712 29 m 000342402011 FORUM CREATIVE LEARNING BUSINESS INNOVATION SE POAT 2011 06 09 2012 02 28 114 649 52 a 000351402011 Iniciativa de divulga o de informa o t cnica sobre emprego SE POAT 2011 11 16 2011 12 31 40 000 00 J 000363402011 Avalia o do Programa Mais Sucesso Escolar SE POAT 2011 06 21 2012 06 20 79 217 60 E 000388402011 Mostra de Foma o Profissional Espa o de Informa o Profiss SE POAT 2011 11 01 2012 05 31 96 000 00 y nnnag94n2n11 NetFORCE Partal de Farmacdn e Certificac in n SE POAT 2011 06 20 2013 12 31 100 nnn m i 5000 element s post filtering Clicking on the post filtering button displays a new window allowing the user to select on which properties values to filter the current results This window works exactly as the expert search but with a property set strictly limited to the actually visible columns as it won t generate any server query It will just proceed to local results filtering L fe e x 4 TT For more information about how to define your criteria please read the previous chapter about expert search Once you have defined your criteria click on the Apply button to apply the filter to the local result
25. 032 g2 a 5 faes 1 o O w S 55 i ian 4 mm Ii ri 5 sg Procurement Overall Score g a 5 i G Contract Management Overall Score e Q up g Higibility Overall Score i e SRE OME S retemence Overal Sow o 0 C i Concentration Overall Score u u D 9 Other Overall Score i l m 0 Reputational Fraud Alerts Overall Score _ g 4 00 c o so G oO The context menu lists all alert categories with the selected column in bold Clicking on a menu option will expand or collapse the selected category 33 ARACHNE User manual Es Alerts details are shown in grey text instead of black text and don t have an expand collapse symbol When the context menus are re opened checked items correspond to the expanded columns Note that alerts behave exactly like alerts categories when you click on them the selected alert is used for the dashboard selection rows are re queried o go F g Loy py 27 o5 52 we arlsa is oa tE i EZ latodg fee al BOR aASocahBE7ZgTE Eo Gc EU LL aama S SB En N Eas gles o ums E5 23885579 Eg sue sue dese n T gt Zo 68 dmj uzL mgcH ros ag amp 54 o gt ES oF S55 16 so io o 00 O we 130 25 ots SH 100 ij i o x19 108 off 00 O 0 e se ce c ce GO O O ine 0 s o 09 003 ae 4 5 6 4 Sorting and grouping Sorting will change by single left clicking on the column headers present
26. ARACHNE User manual Name of the director that changed limited to 30 as a preview Number of changes in directors in the last year Number of changes in directors in the last 3 years Date of the change Change status new or previous VAT number of the company No detailed information is available in the values tab Links to further details E OPUS Ingatlanszolg ltat s Kivitelezd Kit The following links to further details are available Link to the interactive reports of the companies mentioned in the tables tab 44 3 9 5 4 Activity changes Description The objective of this check is to identify projects for which there is related company beneficiary project partner contractor or consortium member for which the sector activity code has changed in the past three years Level of calculation The check is performed for each beneficiary project partner contractor and consortium member Peer group Input data The following data is used to calculate the alert Orbis ID of Beneficiary Orbis ID of Project partners Orbis ID of Contractors Orbis ID of Consortium members Sector activity code Orbis Calculated data Alert value The alert gets a value between 3 and 10 depending on the number and timing of the changes in activity code during the last 3 years Project score Highest alert value of any company linked to the project beneficiary project partner contractor or consortium member
27. Allows to add an extra text as page header Document title Defines the global title used in the text file XML formatted file parameters Encoding type Allows the following encodings when saving into XML file Standard ANSI ASCII 7 bit strict ASCII encoding UTF 8 most commonly used encoding Unicode true Unicode encoding 92 ARACHNE User manual Once the correct parameters have been selected click Next 10 2 2 5 File format confirmation This screen displays a summary of your file format parameters Just click Next to confirm 10 2 2 6 Export screen Once everything is confirmed the final step is displayed and the export can begin Just click on the Export button to start exporting data A progress bar will indicate the export progress E Export status Data were successfully exported Once the export is finished click on the Close button 10 2 3 File associations By default once the export wizard has closed the application will try to open the exported file with its windows default application This behavior can be enabled or disabled via user options see chapter 11 1 in the export options section 93 ARACHNE User manual 11 Customizing your application The Parameters menu allows you to modify the application options and appearance This menu contains six functions Windows configures windows elements and modules Colors configures colors used in palette and g
28. Dashboards X Ce The Relations menu contains the different relation search forms Search for Legal links available Search for Private links Search for Memberships Search for Affinity links EE x Case manage The Dashboards menu contains the different dashboards defined Projects global for the European Commission projects beneficiaries contracts HB Beneficiries global k and contractors These menu options link to the full dashboard Contracts global for each entity Please refer to the chapter 5 for more details on Contractors global dashboards management welcome screen not the same as the application Welcome screen B PP welcome window and the user s case list Cases list Zee Windows The Parameters menu contains the different parameters that can Windows be adapted by the user This covers the colors used in the application the language French and English are available the columns used in search results and navigation tables etc Please refer to chapter 11 for more details Templates Columns Languages amp General aAlt G 16 gi i ARACHNE User manual Windows The Windows menu contains options to enable disable some Notifications interface components such as the welcome window the basket D Welcome window window the legends and the task pane These options can be G Baket used to gain more application space if needed E j j j E Legends The Close all opened window
29. EC Overall Alert contractor aj i E iol Company age fo Company conscod S Company incor sS Company name s Company name E C Project count as beneficiary Project count as contractor Invest Active compan Bankrupt Ka F4 Company quoted Entity bvd indicator E Contractor overall score 3 1 Entity type E Contractor overall score 3 2 es Contractor overall score Q 3 In a group E Country Linked to another group E3 Country E C m PO 8 EC Source VPI P2B Bankruptcy m EC Type VPI Bankrupt rating i Entity type VPI P2B Sold Top 20 S Group ID 11 3 1 For table columns The selection will impact search results navigation tables and the basket This selection has no impact on the dashboards Once the new selection has been made it is effective for all newly opened windows 11 3 2 For details panel The selection impacts only the details panel present on the task pane Once the selection has been made it will be directly updated the next time a new entity is displayed in the panel 11 3 3 For graph indicators The selection impacts only the coloring indicators present in graph windows Once the selection has been applied it will be directly available in next opened graph windows Note that in this mode an additional button nal allows insertion of separators which make the menus easier to read and use 11 3 4 Editing columns 1 Sel
30. EN Year F Ebitda ke Effective Year Number of employees Tm The property picker will list all available properties for the form s target entity Once you have entered your criteria just click on the Search button to start the query 6 1 1 4 Search messages Different message dialogs may occur while proceeding to searches Size limitation Information Your search retumed 11171 rows Only the first 5000 results will be displayed This message will occur when the number of records matching the criteria is above the server limit This is happening when the search criteria are too permissive In that case only the first records will be returned and there is no guarantee the returned records will match a defined order In this case refine your selection criteria or use the top selection mechanism No result Information 42 ARACHNE User manual This message will appear when no record matches the criteria Operator was not set i Filter element on property Company name skipped Reason Mo operator defined This message can appear when clicking on the search button and you forgot to pick an operator in the custom operators list No sort property defined This message can appear when clicking on the search button with the top selection enabled but no top property selected No values defined for the selected criteria in expert mode Information This message ca
31. For example when exporting projects you can only select properties 88 ARACHNE User manual Es belonging to projects name but you cannot select properties belonging to other entities like contract or beneficiary i e you cannot export beneficiary contractor name or other beneficiary contractor related fields when exporting a project Data export wizard Template DESM D 39 Previous Net Once the selection has been done clicking on the Next button will request the properties to the server 10 2 2 1 Property selection mechanism When exporting entities the entity type is pre selected so you only have to select the properties you want to export in the property tree Selection is done by checking items in the list In addition the bottom buttons allow to select all properties no property or to invert selection When organized in categories selecting the category will automatically select all properties below it L Status m 3 Alerts all m CM Revised score m Concentration Overall Score m Contract Management Overall Score l Eligibility Overall Score j a Other Overall Score Overall Score j a Performance Overall Score ml Procurement Overall Score 1 There is also a way to focus on properties containing specific characters by typing them in the text box on top of the tree The list will high
32. IntraComm gt Authentication Service gt Where Are You From Where are you from Welcome to the European Commission Authentication Service ECAS Choose the institution or body for which you want to log in Choose External if you don t work for a European institution or body Choose W 7 if you have a special external account composed of w and 7 digits If you aren t sure select the I don t know option for help tur Comision European Commission External European Commission Executive Agencies Partners Researchers Citizens I have an account w 7 digits I don t know Special external accounts More information about this screen This action needs to be done only at the first logon After a correct ECAS authentication the system will display the message that a correct ticket was received This page may be closed CET Ble Edi View Favorites Jools Help 3 E Arachne Home n v i de v Pager Safetyv Took v Ticket was correctly received You can close this page Oo ARACHNE User manual 3 2 Arachne at a glance This chapter will quickly guide you through the main screens and interfaces that are visible when the application starts 3 2 1 Connecting to the application When the application starts it will automatically redirect you to the ECAS login page If you are already authenticated with ECAS the application will automatically proceed to your connection Once you are connected you can
33. MOLENBERGNATIE PORT REAL ESTATE The following links to further details are available Link for each company with an involvement in the project that is mentioned in the tables tab Clicking on the link opens a new window in which the related companies within the group of the company that are mentioned in the tables tab can be selected For each selected company the interactive report will be opened Multiple elements are available Please chose the elements you want to display MOLENBERGNATIE GMD VIETNAM 2 MOLENBERGNATIE GMD VIETNAM 226 ARACHNE User manual 14 3 9 3 5 Inconsistent activities Description The objective of this check is to identify projects for which there is related company beneficiary project partner contractor or consortium member that is involved in many activity sectors Level of calculation The check is performed for each beneficiary project partner contractor and consortium member Peer group Input data The following data is used to calculate the alert Orbis ID of Beneficiary Orbis ID of Project partners Orbis ID of Contractors Orbis ID of Consortium members Activity sector code Orbis Number of activities per company greater than 1 Project score Highest alert value of any company linked to the project beneficiary project partner contractor or consortium member Applicable project types Pop up information Inconsistent activities E3 Inconsiste
34. Orbis 73 ARACHNE User manual 8i Interactive report THYMOS spol s r o THYMOS spo sro General information Company name THYMOS 5 R 0 Company name E C THYMOS spol sr o Unique identification number 5K31672914 VAT Number E C 5K2020515772 Type C Industrial companies EC Type Private Total grants amount 0 00 Address E C Popradska 518 Post code E C 05952 City EC Velka Lomnica Country E C SLOVAKIA Orbis address P Address Popradska 518 Zip code 05952 Company city VELKA LOMNICA Country SLOVAKIA Financial information Effective Year 2012 Total assets k 9 316 00 Operating revenue k 15 574 00 Cash flow kE 402 00 Ebitda kE 547 00 Number of employees Profit loss for the period kE 132 00 VPI P2B Bankruptcy 16 Neighborhood The neighborhood section contains the following information e For beneficiaries related projects Neighborhood Related projects Project Name generic Benef turnover Pastfin corr Project Project ident FDVC 01 01 00 00 031 10 FDVC 01 01 00 00 032 10 FDVC 01 02 00 00 001 08 FDVC 01 02 00 00 002 08 FDVC 01 02 00 00 003 09 FAKE Project 031 10 FAKE Project 032 10 FAKE Project 001 08 992 81 992 81 992 81 992 81 992 81 992 81 FDVC 01 02 00 00 004 09 8 C 01 02 00 00 005 09 Project Name FAKE Project 031 10 FAKE Project 032 10 FAKE Project 001 08 FAKE Project 002 08 FAKE Project 003 09 FAKE Project 004 09 FAKE Proiect
35. Sidus etsi Eutiaie uetus E UNI E MM REP DI DIEM LAINE 63 7 5 1 POE CTI 19 S CETTE Em 63 7 5 2 ei roce t PE S 63 7 5 3 AY 01 lt 4 1 OPOE NR ORO 64 7 6 MCI ea T E 64 7 6 1 CUS OI ZG M A 65 7 6 2 bere COD ON CORRER uu 65 7 7 Common PESDBHODEUOP S serere ee enn ene oan er een 66 7 7 1 OVS OS NIC 66 7 7 2 DOVE GS VECON OU orriren n E A RE ETE EO 66 7 7 3 7 Q 66 7 7 4 Gov qicm c E P M es 66 al vu EEUU UTITLone nm 69 8 1 IteracHVe TODO E ossonveiesonverimbRvorboniivere p votiva hein cekielaheanietincsadnetsen btinentietamanbelinesnbecmen 69 8 1 1 Project interactive report eeiseesseeissesseees eese enne rn nasa ansa assa sas sas sanas 69 8 1 2 Contract interactive report sssexesebuetsientuok te ubkinoti etn SI nM aU PIDE AIO MER UE RUIT n IRR UR PvE PESU 72 8 1 3 Beneficiary and contractor interactive reports eee 73 8 2 PUI lO TEDO aes tese sea neces E tac ocuasnanesuacecosusetonsvaestec tamed el S ees tee 75 9 Case Mana H MILIDEE TIU Sm 78 9 1 1 Case management user roles cccccseeeccccesececsseescceesececcusecssceuseseceusecsssuseessseesesesseseeenas 78 9 1 2
36. appears and the user can select entities which some information will be exported 87 ARACHNE User manual Projects global No condition B o 0 o o o co E 5 58 58 ag 85 258 5 Ze e En stn a 2o Eo gt zi S ge 59i fe Se FE s S 85 O85 ws t9 S ra gt B gt 5 gt g a6 6 6 46 66 6 amp Aplikovan v skum v oblasti produkcie bioetanolu formou hydrol zy lignocelul Q 9 uue so 509 E BOST SK a s Inovativna poloautomatick linka na v robu elektromagnetickye Q 0O O sO sO Centrum pre v skum a v voj v oblasti elektr n iB FAKE Project 003 08 LE Inov cia bodov ho zv rania v SEZ Kromp Komplexn moderniz cia vzdel vacej hmotne E Moderniz cia a dobudovanie v skumnej a v BOST SK a s Inovativna poloautomatick linka na v robu elektromagnetick ch zar Centrum pre v skum a v voj v oblasti elektr novol ov ch a progres vnych obl kov 7 FAKE Project 003 08 Odkanalizovanie podunajskej asti bratislavs 7 Inov cia bodov ho zv rania v SEZ Krompachy a s Passaporte para o Empreendedorismo Lon p Komplexn modemiz cia vzdel vacej hmotnej a informa no komunika nej infra trukt Eep ae Modemiz cia a dobudovanie v skumnej a v vojovej infra trukt ry a pr strojov ho vyb Pokro il technol gie pre environment lne e Modemiz cia LD Smaragd zameran n
37. application which implicitly disconnects you from the server or via the menu File Disconnection Ci Entities Relations Dashboa Disconnection Administrator Change your password Your current profile Export Frint Exit Using the disconnection menu will keep the application running allowing you to reconnect if needed through the same menu 3 2 3 Welcome screen The welcome screen acts like a kind of cockpit in which different types of information are directly visible for the connected user This information covers the case management the alert statistics and the different dashboards used in the application _ 4 Welcome window X Current cases Id numeric Case title Case type Case target name Amount Case status Case sub status Creation date Follower Case 2 FAKE project 3 8 Project FAKE Project 003 08 35 900 080 00 Unassigned None 30 12 2013 11 32 14 Case management amp Alert statistics Op program ident a Average of CM Revised Occurences of Overall Occurences of CM ri Score 38 Revised score 38 9999XA999XX001 p 13 00 0 0 Op program ident Average of Overall Score Global average Overall Score 14 00 CM Revised score Dashboard summaries Projects global Beneficiaries global CEN ee v o d c Name
38. are available Link to the interactive report for the related people mentioned in the tables tab Link to the interactive report for each company mentioned in the tables tab Link to WorldCompliance details and articles 14 3 9 4 4 Involvement of individuals entities included in adverse media lists Description The objective of this check is to identify projects for which there is related company beneficiary project partner contractor or consortium member for which either the company or its management is listed in adverse media lists in the WorldCompliance database This will include people that are ina political function or that have close contacts family member close colleague to a politician Level of calculation The check is performed for each beneficiary project partner contractor and consortium member Peer group Input data The following data is used to calculate the alert Orbis ID of Beneficiaries Orbis ID of Project partners Orbis ID of Contractors Orbis ID of Consortium members Private links of the companies management Orbis Calculated data The following data is calculated for the alert Links between Orbis data and World Compliance Quality of the link Alert value The alert gets a value from O to 10 depending on the quality of the match between the Orbis entity and the entity in World Compliance The quality of the match depends on the number of elements Quality of the name ma
39. calculation The check is performed for each project Peer group Not applicable Input data The following data is used to calculate the alert Projects Related consortium members Calculated data Alert value The alert gets a value of 10 when there is a consortium member that appears aS a consortium member in multiple projects within the same Member State Project score Alert value Applicable project types DG Regio Infrastructure Pop up information Consortium partners linked to multiple projects Ea Consortium partners linked to multiple projects Alert Consortium partners max number of projects in a same member state Consortium partner s number of projects Total amount of project costs of related consortium partners 2 762 183 12 The following detailed information is available in the values tab Maximum number of projects in which the consortium member is involved as a consortium member within the same Member State Number of projects in which the consortium member is involved as a consortium member Total accumulated cost of the projects in which the consortium member is involved 182 ARACHNE User manual i Consortium partners linked to multiple projects E3 Consortium partners linked to multiple projects Consortium member name Project name Contract name THE BELGIAN CHOCOLATE GROUP FAKE Project 031 10 Contract31 THE BELGIAN CHOCOLATE GROUP FAKE Project 045 08 Contract18 THE BELG
40. contract executor contract requestor and sub contract requestor links membership or affinity Search which provides for any group all the companies belonging to the group Search which provides for any company information about the group to which it belongs A person or a company who holds a participation rate in a subsidiary A skeleton group only includes companies that are linked with a participation rate higher than 50 A strong group contains companies that are linked with a participation rate or sum of participations from companies of a skeleton group of higher than 25 A company which is held to some extent by a person or another company Window allowing the user to compute statistics about a set of entities The task pane is the left side part of the application screen and contains multiple functional blocks Identifies the company having the largest influence inside a group with the following order of priority Being on top of a strong cluster Having the highest number of children direct or indirect Having the highest sum of participation rates to direct subsidiaries Having the biggest size Based on Bureau van Dijk data Having the highest shareholders funds VPI P2B Bankruptcy predicts the risk for a company to go bankrupt VPI P2B Sold predicts the risk for a company to be sold bought by another VPI No score no sufficient historical financial data to predict VPI predictive indicators
41. go back to a previous view 1 4 2 3 Highlighting The node and edge highlighting mechanism gives the ability to locate nodes or edges having particular behaviors in the graph by spotting them This option is available through the bulb Node highlighting E Edge highlighting T k gd Search T l icon from the toolbar First select the entity or relation you want to use for highlighting You ll get a dedicated form to enter your highlighting criteria Multiple criteria can be built manually by selecting properties operators and values The multiple criteria are always combined using a AND operator s Within ME Medium SM v m ele x x vl Within BELGIUM This form works exactly as the expert search or post filtering system For more details about making a selection please refer to the chapter 12 1 1 of this manual Once the Apply button has been clicked all elements corresponding to the filter are highlighted in the graph A For entities red circles appear around the matches A Forrelations edges are colored in red If you go back to the highlight menu you will see that the current selection for the item you picked is displayed in clear text Nodes and edges highlights 61 ARACHNE User manual E i Local view ETEX 2 2 200 nodes 216 links f Total participation gt 25 To change a highlight filter click on th
42. have been refreshed some old alert values may become inaccurate making the case to be resolved itself 9 1 7 3 Casechangestab Timeline Case Changes Case Assignment Changes Add comment Case Changes Case sub status This tab lists the different status changes which occurred on the case with the user and change date 82 ARACHNE User manual ki si 9 1 7 4 Case assignment changes tab Timeline Case Changes Case Assignment Changes Add comment Case Assignment Changes Assigned to RO OP Supervisor 20 09 2013 10 52 23 RO OP Fallawer RO OP Supervisor 20 09 2013 10 53 06 RO OP Follower This tab lists the different case assignment changes 9 1 7 5 Add comment tab Timeline Case Changes Case Assignment Changes Add comment Comments User Comment SA Date I want to make a comment on two lines This should be on line 2 RO OP Line 3 here Add comment Add URL here gt Fs Add comments here gt a Add comment This last tab lists the different comments made on the case and offers the ability to add new comments A comment is made of a text and an optional URL The URL can contain any reference to a document on the internet or shared network 9 1 8 Creating a case The user can create a new case in several ways From the project or contract dashboards or mini dashboards from the welcome window using the right click menu option Create new case Copy name to cli
43. i Bok GR Create new case FAKE Project sanction02 J Copy name to clipboard Pl J Copy name to clipboard m INTERVEN O NOS TROCOS Interactive report F a interactive report j Lenta Ha npoextae na ce nod f Printable report X e f Printable report 3 Len n npeameT Ha misecmuni Oy Beneficiaries Partners d n 4 Beneficiaries Partners m Prote o e defesa da zona cos E poi p E Conlacis Circuito Hidr ulico de Pedr g o 4 Involvements Funda o para a 4 Involvements 4 1 Ci ncia e a D a8 E T 4 Expenses Tecnologia 4 Expenses Surroundings graph Surroundings graph These context menus contain system functions in bold always appearing first on the popup and navigation menus System functions are standard as navigation menu may differ from one entity or relation to another 6 2 1 System functions The following system functions are available in context menus Add to basket adds the selected element s to the application basket See chapter 12 3 for more information about the basket system Create new case only if the element is part of the case management starts a new case creation process This option is only available on projects and contracts Display case only if a case exists for this element this menu leads to the case detail screen This option is only available on projects and contracts Copy name to clipboard copy the entity name on the clipboard so it can be pasted in
44. in the peer group Deviation of the cost per km for the project from the average cost in the peer group Alert value The alert gets a value from 0 to 10 depending on the deviation of costs per km for the project from the average cost per km in the peer group Project score Alert value Applicable project types Pop up information 156 i ARACHNE User manual Project cost vs km mad constructed E3 Project cost vs km road constructed Alert Lenath of road constructed in km Project cost Ratio project cost and length of the road in km Average of the ratio in the peer group The following detailed information is available in the values tab Length of road in km Project cost Cost per km project cost length of road in km Average cost per km in the peer group No detailed information is available in the tables tab Links to further details No links to further details are available 14 3 6 9 Project total cost declared to the EC Length in km per Project Description This check will return the total project costs per km for rail projects The objective is to identify projects for which the cost per km is larger than the average cost in the peer group Level of calculation The check is performed for each project Peer group Same rail type in the same Member State Input data The following data is used to calculate the alert Project cost Length of rail in km Calculated data The following
45. information displayed as a table 36 ARACHNE User manual ki i References Beneficiaries involved in multiple projects Beneficianes in multiple projects Tables Beneficiary s projects list FAKE Praject sanctionQ3 FAKE Project SME1 FAKE Project SME FAKE Project SME4 CIT References are links to other application functions giving some context information about the alert i e neighborhood graph or world compliance information related to the alert References can be of multiple types F Neighborhood displays a list of related entities s World compliance references refers to the external World Compliance data Path graphs on some kind of alerts some references to a shortest path graph may appear 5 6 6 Expanding and collapsing related entities The dashboard screen also has the capability to display embedded relationship navigation from one entity to another based on a given relation type e g a dashboard displaying a project allows the user to drill down to the related beneficiary The overview of related entities can be displayed by expanding the project using the sign on the dashboard level Project type Member state Managing Authority Performance Overall Score Concentration Overall Score Beneficiaries involved in Reputational Fraud Alerts Overall Score S 683 u 8 6eS 63 VRATSAINVEST GRUP OOD Q 100 MOHMKA BAMICEP MIOMIOH 0 Q a
46. is available in the tables tab Name of the supervision contractor Name of the works contractor 188 ARACHNE User manual E Name of the projects in which the supervision contractor appears with the same works contractor limited to 30 as a preview Name of the contracts in which the supervision contractor appears with the same works contractor Alert value for the supervision contractor Links to further details s Contract requests The following links to further details are available Link to the supervision contract s related to the current project that caused the alert value 189 ARACHNE User manual i 14 3 8 Other checks related to ESF projects 14 3 8 1 EC financial assistance total Project cost Description The objective of this check is to identify projects for with the ratio of EC financial assistance relative to the total project cost is larger than the average ratio in the peer group Level of calculation The check is performed for each project Peer group Operational Program Input data The following data is used to calculate the alert EC financial assistance Project cost Calculated data The following data is calculated for the alert Ratio EC financial assistance project cost Average ratio in the peer group Deviation of the ratio EC financial assistance project cost for the project from the average ratio in the peer group Alert value The alert gets a value
47. linked to the same contract A path is a link between several entities in the Orbis database It can be comprised of legal links between companies and private links between companies and related people A distance of 4 or less steps between two entities will be considered as a link Level of calculation The check is performed for each contractor supplier including consortium members Peer group Not applicable Input data The following data is used to calculate the alert Orbis ID of Contractors consortium members Orbis ID of Sub contractors Legal links ownership in Orbis Private links directors in Orbis Calculated data The following data is calculated for the alert Path finding between entities Alert value The alert gets a value between 3 and 10 when a path is identified depending on the number of paths that have been identified Project score Highest alert value of the values for the contractors suppliers linked to the project Applicable project types Pop up information ARACHNE User manual Links between contractors suppliers and sub contractors Ea Alert Number of paths between contractors suppliers and sub contractors The following detailed information is available in the values tab Number of paths that have been found between the contractors suppliers and sub contractors No detailed information is available in the tables tab Links to further details E Path The followi
48. management data isolation Case management data isolation works in a similar way as internal data isolation users belonging to a given user group DG MA or OP will have only access and make changes to the cases of their group In terms of inheritance top groups can access cases of bottom groups but cannot make changed on them This means a user from a managing authority can access cases opened at the operational levels but cannot do any modification on them ARACHNE User manual B i 9 1 3 Case lifecycle diagram Ongoing Assignment Decline Closing Approve Supervisor Follower 9 1 4 Howto access the case management module The case management module can be accessed either from the application menu or the task pane Case management 9 1 5 Case Management welcome screen Case management dashboard Welcome screen Unassigned Cases Case status Count Case type Count Average Average r Un O O Cl Ch Cases list Filter cases Top 10 oldest outstanding cases Users having most outstanding cases P Id numeric Case title Case status Creation date User Outstanding cases count 245 case ro 3 Opened 24 09 2013 15 Internal case management options are shown on the left bar Welcome screen button leads to this screen Unassigned cases displays the cases list with a predefined focus on unassigned cases Cases list gives the fully customizab
49. may appear differently in the graphs but have the same behavior it allows zooming in zooming out going back to 1 1 scale or fitting the graph to the window Zoom option in hierarchical graph group map and Zoom option in local view surroundings view and affinity graph path graph Fit in window Standard scale 1 1 25 Rescale to fit 50 55 75 100 Manual scale T Cy 100 0 E j Search 125 150 175 200 To O2 69 2 4 gt His The graph can also be zoomed in and out by pressing the CTRL key and rolling the mouse wheel 7 7 4 Coloring The coloring options allow you to select some typical properties and use them as a coloring option inside the graph Depending on the underlying data type the graph will use either a scale gradient coloring or a palette coloring 66 ARACHNE User manual Es Note coloring options may differ from the different graph representations 7 7 4 1 Palette colors When you select a field containing multiple distinct values strings enumerations the application will use an automatic palette generation according to the distinct values The base colors can be customized through the application settings See chapter 11 2 E Beneficiaries global JE Local view MOLENBERGNAT x Legend ax Ci tr Local view MOLENBERGNATIE id Country Company Country A ZI NS i Ecm pee i k SPAIN BM NETHERLANDS gt S unre states 4
50. member Applicable project types Pop up information 221 ARACHNE User manual B Involvement of directors shareholders with bankruptcies Involvement of directors shareholders with bankruptcies Company involved Role in project Name of the bankrupt company 0 TeleConnect Kit Beneficiay H L ZATOS TELEV ZI K ZARTKORUEN MUK DO R SZV NYT RSAS G The following detailed information is available in the tables tab Name ofthe company Role in the project Name ofthe company that went bankrupt Name of the director shareholder linked to the company and the company that went bankrupt limited to 30 as a preview Year of the bankruptcy No detailed information is available in the values tab Links to further details TeleConnect Kft X Mrs Gyula Barta Eke The following links to further details are available Link to the interactive report of the company that has a role in the project Link to the interactive report of the related director shareholder where his involvements are mentioned including links with bankrupted companies 222 ARACHNE User manual 14 3 9 3 2 Involvement of directors shareholders from sensitive regions Description The objective of this check is to identify projects for which there is related company beneficiary project partner contractor or consortium member with a director shareholder that has involvements in a sensitive region The list of sensitive regions is based on of
51. negative amounts 16 56 ESF and SME Value 127 The following detailed information is available in the values tab Total number of expenses Total amount of expenses Number of expenses with negative mounts 139 ARACHNE User manual Es Total amount of expenses with negative amounts Percentage of expenses with negative amounts compared to the total project amounts No detailed information is available in the tables tab Links to further details Expenses The following links to further details are available Link to the expenses with negative amounts 14 3 5 8 Beneficiaries with invalid VAT number Description This check will validate the beneficiary VAT number through a structure check The objective is to identify projects for which the VAT number of the beneficiary does not comply with the VAT structure requirements as mentioned on the VIES website of the European Commission Level of calculation The check is performed for each project Peer group Not applicable Input data The following data is used to calculate the alert VAT number of the beneficiary Calculated data Alert value The alert gets a value of 10 when the VAT number of the beneficiary does not meet the structural requirements as mentioned on the VIES website of the European Commission Project score Alert value Applicable project types ESF and SME Pop up information Beneficiaries with invalid VAT number E3
52. of Too publicly available data plus additional data mining options developed by Vadis for the Arachne project Vadis Predictive Indicators Cluster Groups Unique Person Identifier 108 Group Group name or Group representative Group legal link Hierarchy view Interactive report Investment companies Investment group Legal link Leveling Link The Group entity represents a set of companies strongly linked together via the Legal link relation Groups are linked to companies via the Membership relation and between each other via the Group legal link relation The group representative can be either the ultimate owner of the group if the group contains or the most influencing top level company that is chosen to represent the group When the ultimate owner is outside of a normal group in this case the ultimate owner is usually in an investment group or the group does not have an ultimate owner this most influencing top level company is the one that has the highest number of direct and indirect children with the strong links participation rates higher than 25 within the group The Group legal link relation links groups together by aggregating legal links between companies of those groups Visualization of the internal structure of a group of companies Report with detailed information about any entity A company is called an investment company when it has one of the following characteristic
53. of the alert is to identify projects for which this percentage is larger than the average percentage in the peer group Level of calculation The check is performed for each project Sector Operational Program Project type Input data The following data is used to calculate the alert Total amount of contracts procured via negotiated or restricted procedure Total project cost Calculated data The following data is calculated for the alert Percentage of the total amount of contract procured via negotiated or restricted procedure compared to the total project cost Average percentage in the peer group Deviation of the percentage for the project from the percentage in the peer group Alert value The alert gets a value from O to 10 depending on the deviation of ma A EE E DG Regio Infrastructural projects Pop up information Contracted amounts via restricted f total project cost E3 Contracted amounts via restricted procedures total project cost Alert Value Total amount of contracts procured via negotiated or restricted procedure 15 705 18 Project cost 146 939 50 Ratio contracted amounts and project cost 0 11 Average of the ratio in the peer group 0 03 The following detailed information is available in the values tab Total amount of contracts procured via negotiated or restricted procedure Total project cost Percentage of the total amount of contracts procured via negotiated restricted procedure or direc
54. or to send them to the basket From the toolbar the summary function can be called on a selection see advanced functions chapter The local results can be filtered again to create sub selection using the post filter y option see advanced functions chapter 12 Search on relations Searching on relations is a bit more complex than searching on entities as the application gives you the ability to define criteria on the relation itself but also on the source and target entities Ceci E Dashboards gt lt Ci Search for Legal links ie Search for Private links Search for Memberships Search for Affinity links Relation search is available for external data on legal links private links memberships and affinity links Relation search screens have more elements than entity search screens Overview Companies i Private links Number of affinities E e m e n t Number of Companies gt wes Porm criteria p IC ke r Linked countries Contains BELGIUM R Mrs Jeanna Valen E a Mr Marius Laurent gt 45 Manager 4 NUME TECH Manager H iru A Mr Mohamed Yusi Age Companies 4 ARRAHIM c TELECENTR faa Mr Sebastian Muissus 30 19830901 4 j R ta Mr Firas Alaouie 19830000 os a i 2 Gely o a Mr Christopher Erbsloeh R esu It S t a ble 5 ntin Boc a Mr El Hadji Diouf ABILIW a Mr Joel Jacobovitz 33 19200126 Ei amp Mr Jonathan Geor te Mr Moham
55. project Incorporation year for the company No detailed information is available in the values tab Links to further details X ARHI PLAN SRL E EREDAS SRL d BOROS IOSIF INTREPRINDERE INDIVIDUALA i 236 ARACHNE User manual The following links to further details are available Link to the interactive report for each company in the tables tab that generated an alert value 14 3 9 5 2 New shareholders directors Description The objective of this check is to identify projects for which there is related company beneficiary project partner contractor or consortium member in which new shareholders or directors have been appointed in the past three years Level of calculation The check is performed for each beneficiary project partner contractor and consortium member Peer group Input data The following data is used to calculate the alert Orbis ID of Beneficiary Orbis ID of Project partners Orbis ID of Contractors Orbis ID of Consortium members Private links Orbis Change date of private links Orbis Calculated data Alert value The alert gets a value between 3 and 10 depending on the number and timing of new directors shareholders during the last 3 years Project score Highest alert value of any company linked to the project beneficiary project partner contractor or consortium member Applicable project types Pop up information New shareholders directors 3 New shareholders direc
56. refine the dashboard focus according to a wide set of standard properties or alerts Showing the filters is done by clicking on the f button in the toolbar Ferver sete Fake sourn o Overall Score Procurement Overall Score Contract Management Overall Score Eligibility Overal Score Perfor mance Overall Score Concentration Overall Score Other Overall Reputational Fraud Alerts Overall Score CM Revised score FAKE Project SME2 FAKE Project 011 08 FAKE Project 003 09 FAKE Project 002 08 FAKE Project 023 08 FAKE Project 044 08 FAKE Project 231 10 FAKE Project 017 09 FAKE Project link subContractor FAKE Project link subContractor FAKE Project sanction01 FAKE Project sanction02 FAKE Project sanction03 FAKE Project SME3 FAKE Project SME4 FAKE Project SME5 FAKE Project 001 08 FAKE Project 002 08 FAKE Project 003 08 Member state Fake country Managing Authority lem Op program ident o600000000000000000JLD a 8 1 Filter selection criteria displays the current selection criteria as a text 2 Filter elements Different kinds of options appear to determine filter values text boxes allow text encoding combo boxes allow to pick a choice into a given list value pickers allow to 38 A ALIATI la nauwrRraAmmMmitnl Es AUT Ne ISAI 3111 a ji m a B wR B ui Af 8 V8 v enter min max values and range selectors allow the selection of a range of values for a given alert
57. shareholder into one node in any space representation Tool allowing saving researches about companies persons or groups The Beneficiary relation links projects and companies together At least one relationship must exist between a project and its beneficiary company In fact this link is not only about beneficiary but about any kind of link occurring between projects and companies e Beneficiary 1 per project e Contractors and subcontractors e Partners e Consortium members Window containing basic information about any selected entity Unique identifier or company code for any company BvD stands for Bureau van Dijk Size of the company based on Bureau van Dijk definition related to turnover number of employee and total assets of the company A case management is a tool to assist the user of the Arachne tool in managing the proper follow up of projects or contracts that require additional review Flag that indicates the company is linked to projects of the European Commission Set of companies linked to each other identified around a skeleton group of strongly linked companies It is constructed progressively from a skeleton group of all linked companies with higher than 50 participations secondly with all strongly linked ones of higher than 25 participation rates and then with other companies that this group can have the most influence A cluster group of a singleton company appears when it is jointly owned b
58. single person can have multiple roles in a company Companies for Mr Manuel Jose Lamouroux Barroso Company Company Function code Currer Previo I dm a SOCOIMA SOCIEDADE DE CONSTRUCOES E IMOBILIARIA DA MAIA S A Board of Directors Member Current a SOCOIMA SOCIEDADE DE CONSTRUCOES E IMOBILIARIA DA MAIA S A Board of Directors President Chairman Current a MOTOR F1 COM RCIO DE AUTOMOVEIS S A Owners Partners Shareholders Founders Owner Partner Shareholder Founder Current a MOTOR F1 COM RCIO DE AUTOMOVEIS S A Board of Directors Member Current a MOTOR F1 COM RCIO DE AUTOMOVEIS S A Board of Directors President Chairman Current a 2NOSH SOCIEDADE DE CONSTRUCOES CIVIS LDA Senior management Unspecified executive Current a 2NOSH SOCIEDADE DE CONSTRUCOES CIVIS LDA Owners Partners Shareholders Founders Owner Partner Shareholder Founder Current In the example above you can see multiple lines with the same company name as the selected person has multiple functions in them 53 ARACHNE User manual 1 Graphs Graph representations are known to be more intuitive and attractive than just tables and listings They also give a global and easy to read representation of relationships between different entities That s why the application uses various graphs to represent the information e The Hierarchical view is a group dedicated view which exposes the content of a group in a
59. supplier contractor is involved as a supplier contractor Name of the contracts through the supplier contractor is linked with the projects Member States of the operational program in which the supplier contractor is involved as a supplier contractor Operational programs in which the supplier contractor is involved as a supplier contractor limited to 30 as a preview Alert value for the contractor Links to further details dl Contract requests The following links to further details are available Link to contract related to the current project that generated the alert value Starting from that point the user can navigate to the supplier contractor and subsequently the related contracts 14 3 7 8 Personnel linked to multiple Projects Description The objective of this check is to identify projects for which there is personnel that is involved in multiple projects within the same Member State Level of calculation The check is performed for each project Not applicable Input data The following data is used to calculate the alert 180 ARACHNE User manual Projects Personnel involvements Calculated data Not applicable Alert value The alert gets a value of 10 when there is personnel involvement that is linked to another project within the same Member State Project score Alert value Applicable project types Pop up information linked to multiple projects E3 Personnel linked to multiple p
60. than the average cost in the peer group Level of calculation The check is performed for each project Peer group Input data The following data is used to calculate the alert Project cost Urban development m Calculated data The following data is calculated for the alert Cost per m project cost urban development Average cost per m in the peer group Deviation of the cost per m for project from the average cost in the peer group Alert value The alert gets a value from O to 10 depending on the deviation of the cost per m project cost urban development for the project from the average cost in the peer group Project score Alert value Applicable project types Energy Efficiency Urban Pop up information 168 ARACHNE User manual i Project cost Urban development E3 Project cost 7 Urban development Alert Value Project cost 2 259 724 0 Urban development m2 20 Ratio project cost and urban development 112 986 20 Average of the ratio in the peer group 36 648 46 The following detailed information is available in the values tab Project cost Urban development in m Cost per m project cost urban development Average cost per m in the peer group No detailed information is available in the tables tab Links to further details No links to further details are available 14 3 6 18 Project total cost Energy decrease Description This check will return the pro
61. the alert Links between Orbis data and World Compliance Quality of the link Alert value The alert gets a value from O to 10 depending on the quality of the match between the Orbis entity and the entity in World Compliance The quality of the match depends on the number of elements Quality of the name match exactly the same or similar Additional match on address or not Additional match on birthdate or not Frequency of appearance of the name in the database Highest alert value of any company linked to the project beneficiary project partner contractor or consortium member Applicable project types PAN Pop up information Involvement in enforcement lists Ea Involvement in enforcement lists Company involved Role in project Ferson ID ls included in enforcement lists TRUVO BELGIUM a Mr Andrew John Day Entity matched as enforcement listed with a quality score of 0 5 ETABLISSEMENTS JOSEPH ROYEN Benefici Entity not matched as enforcement listed The following detailed information is available in the tables tab Name of the company Role in the project Name ofthe related individual when applicable Type of match between Orbis and World Compliance and quality of the match 233 ARACHNE User manual No detailed information is available in the values tab Links to further details EI Mr Andrew John Day X TRUVO BELGIUM Word Compliance article 879344 The following links to further details
62. the beneficiary is involved within the same Member State as beneficiary 172 ARACHNE User manual i Beneficiaries involved in multiple OPs E3 Beneficiaries in multiple OPs The following detailed information is available in the tables tab ist of projects for the operational programs in which the beneficiary is involved List of operational programs in which the beneficiary is involved limited to 30 as a preview Links to further details X Related companies The following links to further details are available Link to the beneficiary Starting from this link the user can further navigate to the projects in which the beneficiary is involved 14 3 7 3 Project partners involved in multiple Projects Description The objective of this check is to identify projects for which the project partner appears in multiple projects within the same Member State as project partner Level of calculation The check is performed for each project Not applicable Input data The following data is used to calculate the alert Projects Project partner Calculated data Not applicable Alert value The alert gets a value of 10 when the project partner of the project is involved in another project within the same Member State as project partner Alert value Applicable project types All project types Pop up information 173 ARACHNE User manual E Partners involved in multiple projects E3 Partners involv
63. the contract Alert value The alert gets a value 10 is 1 or more external service providers is mentioned in the contract to back up financial or technical risks Project score Highest score of the contracts that belong to the project Applicable project types DG Regio Infrastructural projects Pop up information External service provider E3 Extemal service provider Alert Number of extemal providers The following detailed information is available in the values tab Number of external service providers linked to the contract External service provider E3 Extemal service provider The following detailed information is available in the tables tab Name s of the external service provider s linked to the contract Links to further details No links to further details are available 132 i ARACHNE User manual 14 3 5 Eligibility 14 3 5 1 Project costs outside eligibility period before start date This check will look for costs dated before the project has started Level of calculation The check is performed for each project Not applicable Input data The following data is used to calculate the alert Project start date Expense invoice date Alert value The alert gets a value 10 if there are any expenses for which the ete a a aeaa 8 Applicable project types Pop up information Project costs outside eligibility period before start date E3 Project costs outside eligibility period
64. the peer group Alert value The alert gets a value from O0 to 10 depending on the deviation of the cost per km cost relating to the water supply network component length of water supply network to be renovated constructed in km for the project from the average cost per km in the peer group Alert value Applicable project types Waste water or supply Pop up information ARACHNE User manual Water supply cost vs km to be renovated E3 Water supply cost vs km to be renovated Alert Value Cost relating ta the water supply network component 125 978 30 Length of the water supply network to be renovated 1 07 Ratio Water supply cost and length of supply constructed in km 117 736 73 Average ratio in the peer group 35 328 11 The following detailed information is available in the values tab Costrelating to the water supply network component Length of water supply network to be renovated constructed in km Cost per km cost relating to the water supply network component length of water supply network to be renovated constructed in km Average cost per km in the peer group No detailed information is available in the tables tab Links to further details No links to further details are available 14 3 6 17 Project total cost urban development Description This check will return the project cost versus urban development in m The objective of this alert is to identify projects for which the cost per m is higher
65. to beneficiary turnover for the project Average percentage project cost beneficiary turnover in the peer group No detailed information is available in the tables tab Links to further details No links to further details are available 14 3 5 11 Expenses higher than assistance Description This check will look for projects where the total expenses exceed the EC assistance Level of calculation The check is performed for each project Not applicable Input data The following data is used to calculate the alert Expenses line items as sourced by the Member State ECassistance amount Calculated data The following data is calculated for the alert M os MEMINI o Alert value The alert gets a value of 10 when the total amount of expenses based on the line items sourced is larger than the EC assistance Applicable project types Pop up information 143 ARACHNE User manual i higher than assistance E3 Expenses higher than assistance Alert Total amount of expenses EC financial assistance The following detailed information is available in the values tab Total amount of expenses ECassistance amount No detailed information is available in the tables tab Links to further details E Expenses The following links to further details are available Link to the expenses related to the project 14 3 5 12 Contractors with invalid VAT number Description This check will validate the c
66. type Input data The following data is used to calculate the alert Project cost Project start date Turnover of the beneficiary as mentioned in the financial statements of the project start year this information is retrieved from Orbis Calculated data The following data is calculated for the alert Percentage of project cost compared to the turnover of the beneficiary Average percentage in the peer group Deviation of the percentage for the project from the average percentage in the peer group Alert value The alert gets a value from O to 10 depending on the deviation of the percentage project cost compared to turnover of the beneficiary from the average percentage in the group An alert value is generated if the average percentage for the project is larger than the average value in the peer group Alert value Applicable project types ESF and SME Pop up information 142 ARACHNE User manual i Project cost vs annual beneficiary tumover E3 Project cost vs annual beneficiary turnover Alert Value Project costs 891 348 51 Tumover of the beneficiary 21 000 00 Ratio project cost and annual tumover of the beneficiary 4 244 52 Average ratio in the peer group 97 47 The following detailed information is available in the values tab Project cost Turnover of the beneficiary retrieved from the Orbis financial statements of the year in which the project started Percentage of project cost compared
67. u Hu BATA Danaritan 3n n7 7 01 1n 3 Cila faldar File name my export txt Save as type Text file txt Hide Folders Exported file location H XDocuments my export txt Once the export format and report type and destination file have been chosen you can fine tune export parameters Separated fields text parameters Separator character When Separator is on FreeChar mode type the character you want to use as column separator here Separator Defines which column separator is used in the file Possible values are Coma Semicolon Pipe Tab or FreeChar By default CSV files use a coma as delimiter but for some applications semicolon or tab characters are commonly used Pipe character or FreeChar can be used for specific cases Field names as headers This option is enabled by default When enabled the first row will contain the property names Line feed mode CrLf or Lf values define how the line feed is written in the file If you export files for Linux Unix operating systems please select Lf Use system localization When enabled floating point values will be formatted using the system settings settings Decimals Number of decimals to keep for floating point values Simple text parameters Include date When set the export date will be added inside the text file Text width Fixes the maximum number of characters per line Document footer Allows to add an extra text as a page footer Document header
68. value Blacklisted Revised score is set to its maximal value No action Revised score is kept untouched Note that even when a case is closed the supervisor still has the ability to change its sub status Declining a case makes it going back to ongoing status meaning the follower must continue its investigation on the case 86 ARACHNE User manual 10 Exporting data The export function is only available for users having the export function enabled on their account The export option is available from any window containing elements as a table This feature is global to the application and will export elements based on the visible table contents or selection Export function doesn t work from graphs Note depending on your user rights the export function may be disabled 10 1 Selecting records Export function will work based on the following screens Dashboard selected items the selection can be made using windows standard click SHIFT click CTRL click combinations on items in addition the Select all Select none and Invert selection buttons in the bottom toolbar can be used Searchresults or navigation tables all items or selected items Once data have been selected in a screen simply go to File gt Export option to start the export wizard Ci Entities Relations Dashboe Disconnection Administrator Change your password Your current profile Print Exit Alt F4 The following window
69. wi i iral WAT hnumib AT levtraetroctiral coetraccar whcentration Overall Score contractor 16 Reputational Fraud Alerts Overall Score contractor D Contractors with invalid VAT number Infrastructural contract The alerts summary will contain respectively categorized alert radar chart and tree specific to beneficiaries or contractors depending on the report Note that as there is no details for beneficiary and contractor alerts right clicking on them will display a No alert information available popup This is due to the fact that alerts computed at the beneficiary or contractor level are aggregated values based on related projects 8 2 Printable report The printable report summarizes all information concerning a given entity in a printable format 75 ARACHNE User manual B FAKE Project ExtProv VADIS CONSULTING Beneficiary Projectident FDVC 017 Memberstate Faux pays Operstng FAKE TEST program Overall Score 38 Start date 2011 1201 Status Closed Othercontnb 0 00 Personnel 15 Actusiadd 37 personne Additional 63 773 39 turnover Beneficiary Private Project Information Name Msnsgng Authorty CM Revised scoe End date Cost E C Fin assistance Future add personnel Benef turnover Actualadd tumover Add personnelss agreed FAKE Project ExtProv Ministene 11 2013 04 30 50 00 100 00 39 100 00 101 807 00 37 This report window acts lik
70. with round amounts Description This check will identify expenses with round amounts The objective of the alert is to identify projects for which a high amount of the total expenses is claimed via round amount expenses Level of calculation The check is performed for each project Peer group Not applicable Input data The following data is used to calculate the alert Expense amount Calculated data The following data is calculated for the alert Total amount for expenses with a round amount Total amount of expenses Percentage of round amount expenses compared to the total amount of expenses Alert value The alert gets a value from O to 10 depending on percentage of expense amounts that are round amounts compared to the total expense amounts Project score Alert value Applicable project types ESF and SME Pop up information Expenses with round amounts E3 Alert Number of expenses with round amounts Number of expenses Amount of expenses with round amount Amount of total expenses Percentage of expenses with round amounts The following detailed information is available in the values tab Number of expenses with round mounts Total number of expenses Total amount of expenses with round amounts Total amount of expenses Percentage of expenses with round amounts compared to the total project amounts No detailed information is available in the tables tab ARACHNE User manual Links to further deta
71. 0 depending on the deviation of the percentage of the contract from the average percentage in the peer group Project score Highest score of the contracts that belong to the project Applicable project types DG Regio Infrastructural projects Pop up information Contract addenda cost vs contracted amount Ea Contract addenda cost vs contracted amount Alert Addenda costs Contract cost Ratio addenda cost and contracted amounts Average of the ratio in the peer group The following detailed information is available in the values tab Contract amount Contract addenda cost Percentage of contract addenda cost compared to contract amount Average percentage in the peer group No detailed information is available in the tables tab Links to further details No links to further details are available 123 ARACHNE User manual i 14 3 4 3 Difference between Final Contract End Date and Initial Contract End Date in days Description This check will verify the difference between the initial contract end date and the actual contract end date The objective is to identify contracts for which this difference is either larger than the average value in the peer group or larger than 270 days Level of calculation The check is performed for each contract Peer group Sector Operational Program Project type Input data The following data is used to calculate the alert Initial contract end date Final contra
72. 01 10 2013 18 05 Case Changes Case Assignment Changes Add comment Comments Add comment Add URL here gt Add comments here Add comment The screen is split in two parts The case information part displaying o Casetitle and description 81 ARACHNE User manual ki si The case s related entity type and name The amount involved in the entity The current case status and sub status The assignee The supervisor O O O O O The case creation date and creator name o The date ofthe last update last comment or change on the case The case details tab panel containing The timeline values for the entity o The case changes tracking o The case assignment changes o The case comments 9 1 7 1 Case information Description Please investigate this project in detail FAKE Project 013 08 21 392 050 00 a zMot assigned yet gt Roottest Roottest2 01 10 2013 18 05 Test User Arachne 01 10 2013 18 05 9 1 7 2 Timeline tab Timeline Case Changes Case Assignment Changes Add camment Status time li CM Revised Overall Score Procurement Contract Ma Eligibility Ov Performance Concentratic Other Overal Reputational Initial state 15 eo 0 so The timeline tab displays the differences between the entity alert when the case was created and the current entity alerts Differences may appear for old cases when data
73. 09 50 Public 0404785354 BELGIUM EAT Pk DAI a naa Neil PN ee m DODA M _LIDEL INTERNATIONAL A 146 41 9428 270 93 Private 0412640473 RFI GILIN T gt I gt Display complete dashboard Display complete dashboard Contracts global Contractors global Oa OO O O of tes E Name generic Case status 5 8 es Contract ident Signature date Key expert change E Name generic ss 5 EC Type VAT Number E C Country E C Ri Tee o D Fake Extprov d 30 Contracti21 2009 0301 Kasa Oszezednosci Bank Polski 56 Unknown 5250007738 POLAND Contract 25 Conr 2009 01 01 Contract14 Q Q 25 Contractl4 200 0201 Contractor 18 e 22 FRANCE T Contract202 Q 24 Contract202 2009 03 01 7 Contractor19 Q 21 FRANCE Fake PO m e 24 Contracti20 2009 03 01 E KENDERESI VIZIKOZMU TARSULAT 19 Public 12834444 HUNGARY Contract 3 23 Contract 20090301 KOMOMO CTMN EOOA 18 111580598 BULGARIA Contract3 Q 23 Contract3 2009 03 01 ae eee 17 BULGARIA E Fake supervision o o 22 Contracti07 2009 03 01 LE Wrong VAT i7 116563994 BULGARIA beeni A aaa BE PUMP Kereskedelmi s Szolg ltat Kt 17 HUNGARY Display complete dashboard Display complete dashboard Mini dashboards display for projects contracts beneficiaries and contractors the entities having the highest global risk Only entities you are authorized to access will be ranked Each mini dashboard has a link to the comple
74. 1 EN ee A TB MARNOR lew r e zx F200 OTE SURFACE PROTECTION LAFARGE SA Sd GMBH Sx NLET N f 37 X Wa j x VERRON BELGIUM lew OBERLAUSITZER e TONBERGBAL GMBH Sd COLL EARN Sx k FIBRECEM 1 M AG Sid PROMAT E es NV Sx wx Ch 60 9 96 amp History 1 elements v Search 1 2 1 Customization a OPTICOLOR HOLDING A S Sx 23 groups The group map can be parameterized to include more or less elements in the view i 1 h 0 100 Xt Available parameters are Max number Number of jumps Symmetric weight gt 96 of node Q n careful when using higher values processing time can forcibly increase ignored when the graph is generated Number of jumps graph depth to explore This defines the number of group legal links to explore around the target group The default value is 1 The value can vary from 1 to 10 Be Symmetric weight threshold group legal links having a value below this threshold are Maximum number of nodes to fetch when the data are fetched they are sorted on the descending symmetric weight Modifying this value alters how much records are kept in this selection The value can vary from 20 to 200 7 2 2 Specific options 1 2 2 1 Navigation and navigation history When double clicking on a group the view will re center itself on the selected group This gives the ability to slide the view from one
75. 10075 ME Medium BELGIUM H F E HEIMA BE0431285853 SM Small BELGIUM KE F E FREDFUR BELGIUM BE0433725008 SM Small BELGIUM W is 305 element o Gi E E 0 element s It is possible to load append save or empty a basket as bsk format The number of elements stored in the basket is indicated in the bottom right of the window In order to have a more efficient view the basket is directly sorted by type of entity Note that the basket can hold multiple types of entities but cannot hold relations Adding a relation will add the source and target entities 12 3 3 Basket options Filtering As the basket may contain a lot of entities of different types the Filter on options will show only desired entity type Groups Projects Contracts 102 ARACHNE User manual ki i Loading saving merging baskets Filter on Load Append Save Empty The application gives also the following options Save a basket using the Save link Load a basket using the Load link current content will be removed Append a basket using the Append link current content is kept and new content is added to it Empty current basket 12 4 Navigator The navigator allows the user to visualize the different relations between different types of entities company person and group in one single screen separated into three parts because of the three diff
76. 3 00 24 Gj Opened None 8 10 Creation date Case 545252 Project 1 PEKOHCTpyKLIMA M pasui 48 069310 00 25 3 Unassig None 8 10 From b 456123835 Project OnasBaHe M4 Bb3CTaHOBREa 736 158 00 8 Gj Opened None 31 1 No date selected Case 383838 Contract lt NULL gt 0 00 11 amp Opened 9 11 To 2 1 new case for Cont Contract lt NULL gt 0 00 8 E Opened 13 1 No date selected Assignment date From Case 000000000 Project D l Nyirs gi Szennyvizelv 0 00 17 33 Unassig 13 1 case test Contract Contract45 15 871 71 17 33 Unassig 20 1 No date selected Test case 02 Project rd s t rs ge szennyviztis 0 00 10 33 Unassig 13 To Test case 04 Project Telep l si szennyviztisztito 0 00 11 33 Unassig 13 1 No date selected Testcase LM 001 Project K pz si program lebonyol 0 00 44 E Opened 16 0 Groups Test Case LM 002 Projet Az SAP Business One rend 0 00 43 S Opened 16 0 Adminis any f New Test Case LM Project Oktat si es lyegyenlos g 1 647 000 00 19 33 Unassig 18 0 Follower any Test de cas Project Uj modern eszk z k besze 0 00 45 33 Unassig 23 0 yj 9 1 6 1 Caseslist pane All open cases are displayed with their type contract or project name status assigned user Follower project contract amount creation date using a paging of 20 cases page By default projects are sorted on creation date with the oldest ca
77. 4 3 8 5 Fixed assets costs project cost Description The objective of this check is to identify projects for with the ratio of fixed assets cost relative to the total project cost is larger than the average ratio in the peer group Level of calculation The check is performed for each project Peer group Operational Program Input data The following data is used to calculate the alert Fixed assets cost Project cost Calculated data The following data is calculated for the alert Ratio fixed assets cost project cost Average ratio in the peer group Deviation of the ratio fixed assets cost project cost for the project from the average ratio in the peer group Alert value The alert gets a value from O0 to 10 depending on the deviation of the ratio fixed assets cost project cost for the project from the average ratio in the peer group Project score Alert value Applicable project types Pop up information Fixed assets vs project cost E3 Fixed assets cost over project cost ratio Values Alert Value Fixed assets cost 82 286 55 Project cost 1 110 004 00 Ratio fixed assets and project costs 0 07 Average of the ratio in the peer group 0 07 The following detailed information is available in the values tab Fixed assets cost Project cost Ratio of fixed assets cost compared to project cost Average ratio in the peer group No detailed information is available in the tables tab Links to furthe
78. 444 3 no ON Q a 4 E X E Ch 63 2 v d 3 Search E 26 nodes 31 links 7 7 4 2 Gradient colors Gradient colors are used when the selected property contains a normalizable value i e a data type having a well defined range of values Typical fields corresponding to these normalized values are alerts In that case the application uses the same gradient system as the LEDs in the dashboards e Local view Industry Servis Z IEEE Legend qx 7 f VPI P2B Bankruptcy Local view Industry Servis ZK a s VPI P2B Bankruptcy Company Probability for the company to become bankrupt score between 1and 20 A SSS I IMEEM BH E m2 wt Y N H7 4d 4 ds 11 1 4 Hj is EEE am m b 4 Bj X E 8a Q 63 0 dj Search lt E 15 nodes 14 links 67 ARACHNE User manual 7 7 4 3 Selecting an indicator Selecting an indicator is done through the icon The available indicators may differ from one graph to another as they are directly related to the underlying entities This means that the available properties depend on the kind of entity company project contract rather than the graph shown Available indicators For projects Overall Score Country E Concentration Overall Score E Type Legal form There are actually no Company age available indicators for the contracts Contract
79. Beneficiaries with invalid VAT number Alert Value Beneficiary name Foglalkoztat si Hivatal VAT Number of the beneficiary 15312778 2 42 Country code of the beneficiary HU The following detailed information is available in the values tab Name of the beneficiary Country code of the beneficiary VAT number of the beneficiary 140 ARACHNE User manual No detailed information is available in the tables tab Links to further details a Related companies The following links to further details are available Link to the beneficiary of the project list 14 3 5 9 Suppliers with invalid VAT number Description This check will validate the supplier VAT number through a structure check The objective is to identify projects for which the VAT number of any of the suppliers does not comply with the VAT structure requirements as mentioned on the VIES website of the European Commission Level of calculation The check is performed for each project Peer group Not applicable Input data The following data is used to calculate the alert Supplier VAT number Calculated data Alert value The alert gets a value of 10 when the VAT number of one of the suppliers related to the project does not meet the structural requirements as mentioned on the VIES website of the European Commission Project score Alert value Applicable project types ESF and SME Pop up information Suppliers with invalid VAT number E3 Suppli
80. Case management data isolation seien eene nnne nnns 78 9 1 3 Case lifecycle OIC GOIN coena sam Dentediideeesat ocean cae E NEE AEAEE A Ree tu hides eU 79 9 1 4 How to access the case management module esses eee 79 9 1 5 Case Management welcome SCLECECN scccsseseceeseseeecceesececsesecscseneeseceusecsssuseesseueeesesausecenas 79 9 1 6 COS CS NSE SCl CCI a tacero runt swabs E E EE E ne belli epnntece s CoU o us iE E ieee 80 9 1 7 CASES DE Fas SFE ON Gemesen EM um sU EE E OEE EEE E EEO E EEO 81 9 1 8 CeO a COSC e LU TI TIT TT 83 9 1 9 Upaaling WE OP cT EO E T TTE 84 10 EXPONE Gata EE 87 1O endis doc NU c 87 102 qXDOLEUWIZAFKO SIBDS acies E Te Cee ere 88 1021 mRelne cobi selection ssesosaeeci conve ti ietuk EAE ANAE S Vu bM E ORRO EDU Tali d cos AR ERE COME 88 1022 PrOD V eeo erein tbe Oo onerum Rb Us mos eee oe dum oe ere one ee 88 20 2 3 FIC OSSOCIG HOG aeu HO nV UDIN EIDEM E EE 93 11 Customizing your APPLICATION cececcecsceccccccscsccccccscsceccecscsceccccecececescecscsceccececscesescecnces 94 ecc UN MERI IO m M PR 94 DAZ SC OVOES P o 95 e GROCICIE CO OMS 2 aspemimbst Dr VM A A IIR EINER IN UAM DUE 96 1122 EE Solo ae t NINE 96 o De ACE CO LU osu T OA NE EA TA E 96 ILL FOrtaole COUS socie eee aE TET 97 ENS P AMENS o olco Reti T N Umm 97 TIS3 JFOPORDDHBDOI COLORS sorrires renani EEE MIU oux ee Ree Cede
81. Cluster Groups Unique Person Identifier These will be described in chapter 4 of this manual Ne 3 Arachne overview 3 1 Getting started 3 1 1 Installing the client application This section is dedicated to users who don t have the application pre installed on their computer The application is delivered as a standard Windows installer composed of one executable file setup exe and one Microsoft installer package ArachneClientSetup msi To install the application run setup exe or install the msi file directly and follow the instructions Both files must be in the same directory for the installation to execute successfully The installer will create appropriate shortcuts in your start menu and on your desktop Note that installing the application may require administrator privileges Note depending on your user rights and access policies you may not be able to perform the installation by yourself In that case please contact your network administrator For more information about installing the application please refer to the installation guide 3 1 1 1 Requirements The following hardware and software are required to use the application in a proper way Windows XP with SP1 or higher Windows Vista Windows 7 The Microsoft NET framework 2 0 must be installed prior to application install The installer will take care of this installation if it s missing on your computer AA working network connection and an inter
82. E Project 007 08 FAKE Project 008 08 FAKE Project 008 10 FAKE Project 407 08 N m o Oo O O T MOBILE MAGYARORSZ G T VK ZL SI R SZV NYT RSAS G n 4 567 00 Private HEALTH STUDIO ET SERVICE CENTRE MOLENBERGNATIE 749 06 Public 509 50 Public LIDEL INTERNATIONAL 146 13 18 o 186 968 270 93 Private Y 4 l r 16 element s 29 ARACHNE User manual ki i 5 5 Contractors dashboard The contractors dashboard focuses on contractor companies and the related contracts Contractors global Project count as contractor gt 0 e e Procurement Concentration Contract Management EC Type VAT Number E C Country E C 13 Unknown 5250007738 POLAND 0 FRANCE FRANCE HUNGARY BULGARIA BULGARIA Eligibility Overall Score Overall Alert contractor Overall Score contractor Overall Score _ contractor contractor Reputational Fraud Alerts Overall Score contractor Overall Score contractor Mame generic IB Powszechna Kasa szezednosci Bank Polski SA e Contractor18 G Contractor19 KENDERESI VIZIKOZMU TARSULAT KOMOJIO CTMIH EOOJ1 C LESOTEHNICHESKA PROFESIONALNA GIMNAZIA be Mame generic Casestatus Fake Wrong VAT Fake Extprov k E BE PUMP Kereskedelmi s Szolg ltat Kit HUNGARY Contractor20 HUNGARY Dent East KFt HUN
83. EE Overview Dianai STO 1500 z Shareholders ted o VPI P2B Bankruptcy i Legal links VPI P2B Sold Top 20 VPI Estimated Deal Value Min VP Estimated Deal Value Max Company name Company name E C Status code Country NACE Code primary Begins with Company age Between inc OE mw 15008 E VPI P2B Bankruptcy VPI P2B Sold Top 20 WPI Estimated Deal Value Min VPI Estimated Deal Value Max Direct participation gt Total participation gt 46 ARACHNE User manual E 6 1 2 1 2 Search on private links Criteria on the managers as the same as in the person search form criteria on companies are the same as in the company search form Private links can be searched base on the function code standardized function the work country and the current previous flag Previous functions mean they are not currently effective but kept in the database Field name Op Managers Linked countries Contains BE gt 25 lt 35 Companies Country Within BELGIUM Private links Function code Begins Curent Previous Name Between 1270 4 FT Number of affinities Number of Companies Overview Number of linked groups Linked countries Contains Company name Company name E C Status code Country NACE Code primary Company age Between inc D 1500 E VPI P2B Bankruptcy VPI P2B Sold Top 20 VP Estimated Deal Value Min VP Estimated Deal Value Max Function code Begins with C
84. GARY Agenda 2013 Projekthaz Kit HUNGARY FIRMA SwINKELS BELGIUM PORT REAL ESTATE 3 1 BELGIUM Eal RETE Ea MEG E Slp amp A 7T 20 element s 5 6 Dashboards options and features The options we ll explore in this chapter allow the user to focus on the most relevant information by advanced filtering and navigation options Varying the number of visible records in the dashboard Expanding and collapsing categorical alerts Sorting and grouping Viewing alert details Expanding and collapsing related entities Filtering the dashboard content to refine the selection Note For this chapter we ll take the projects dashboard as an example All the listed options and features are also available in the same way in other dashboards 30 ARACHNE User manual lE i 5 6 1 Dashboard description Dashboard contents Projects global No condition x Overall Score Eligibility Overall Score Name generic CM Revised score Procurement Overall Score Contract Management Overall Score Performance Overall Score Concentration Overall Score Other Overall Reputational Fraud Alerts gt Overall Score un e C N A 1 FAKE Project supervision1 310 150 Fake country Minist FAKE Project ExtProv Q Q0 B Q0 20 Solid waste Fake country Ministe FAKE Project 003 08 15 Energyeff Urban Fake country Ministe FAKE Project link
85. IAL PIZARRENC ETERNIT MANAGEMENT HOLDING r E INDUSTRIAS PRINCESA LIMITADA n 4 n p P P RENO ETERNIT ETERNIT UK LIMITED ETERNIT FLACHDACH Er A ETEX GRO UP GMBH ETERNIT AKTIENGESELLSCHAFT ier ania L WANIT FULGURIT GMBH iii iac MARETEX SA 1 aggregated SOCIEDAD INDUSTRIAL ROMERAL SOCIEDAD INDUSTRIAL TEJAS DEC INVERSIONES EL BOSQUE S A PROMAT INTERNATIONAL ASIA PAC EE E E E ETERNIT GUANGZHOU BUILDING S Barroc ATLAS eoma NY PROMarGuGH INVERSIONES S N LICHTENSTEINER BRANDSCHUTZG ein A 4 m m fert Ir LE l 81 element s im m LZ 4 n p BIALE Sw 46 Rh 70 Search 76 node s Y 54 ARACHNE User manual ka 7 1 1 Nodes aggregation In order to avoid having too much information in the graphs some companies are not directly represented in the graph but rather aggregated hidden in their shareholder company Concerned companies are tree leaves i e companies having a single common shareholder and no subsidiary To get information on these aggregated companies locate a company which has a blue indication below its icon This indicates the number of aggregated subsidiaries for this shareholder By selecting the company with left mouse click the table on the left will be populated with the aggregated subsidiaries This function is specific to the hierarchical graph 7 1 2 Specific options These options are available in the bottom toolbar in the graph wi
86. IAN CHOCOLATE GROUP FAKE Project 46 08 Fake Wrong VAT THE BELGIAN CHOCOLATE GROUP FAKE Project EdProv Fake Extprov The following detailed information is available in the tables tab Name of the consortium member Projects in which the consortium member is involved as a consortium member limited to 30 as a preview Name of the contracts through the consortium member is linked with the projects Alert value for the consortium member Links to further details a Related companies The following links to further details are available Alink to the consortium member Starting from that point all related information for the consortium member can be accessed including the interactive report contractor in which the list of related contracts and projects can be consulted 14 3 7 10 Consortium members linked to multiple Projects of the same beneficiary Description The objective of this check is to identify project for which there is a consortium members that appears in multiple projects as a consortium member but always for the same beneficiary within the same Member State Level of calculation The check is performed for each project Not applicable Input data The following data is used to calculate the alert Projects Related beneficiaries Related consortium members Calculated data Not applicable Alert value The alert gets a value from of 10 when there is a consortium member that appears in multiple projects as a cons
87. ICE CENTRE THE BELGIAN CHOCOLATE GROUP FAKE Project ExtProv Fake Extprov VADIS CONSULTING The following detailed information is available in the tables tab Name of the consortium member Projects in which the consortium member is involved as a consortium member limited to 30 as a preview Name of the contracts through which the consortium member is linked with the projects Name of the beneficiary of the project Alert value for the consortium member Links to further details a Related companies The following links to further details are available A link to the consortium member Starting from that point all related information for the consortium member can be accessed including the interactive report contractor in which the list of related contracts and projects can be consulted 184 ARACHNE User manual 14 3 7 11 Sub contractors linked to multiple Projects Description The objective of this check is to identify projects for which there is a sub contractor that appears as a sub contractor in multiple projects within the same Member State Level of calculation The check is performed for each project Peer group Not applicable Input data The following data is used to calculate the alert Projects Related sub contractors Calculated data Alert value The alert gets a value of 10 when there is a sub contractor that appears as a sub contractor in multiple projects within the same Member State Project sc
88. ID FAKE Project 011 08 WARENHUIS DE VRIJHEID FAKE Praject 023 08 WARENHUIS DE VRIJHEID FAKE Praject D46 08 The following detailed information is available in the tables tab Name of the supplier contractor Projects in which the supplier contractor is involved as a supplier contractor limited to 30 as a preview Name of the contracts through the supplier contractor is linked with the projects Alert value for the contractor Links to further details H Contract requests The following links to further details are available Link to contract related to the current project that generated the alert value Starting from that point the user can navigate to the supplier contractor and subsequently the related contracts ARACHNE User manual i 14 3 7 6 Suppliers contractors involved in multiple Projects of the same beneficiary Description The objective of this check is to identify projects for which there is a supplier contractor that is linked to multiple projects as a supplier contractor but with the same beneficiary within the same Member State Level of calculation The check is performed for each project Peer group Not applicable Input data The following data is used to calculate the alert Projects Related contractors Related beneficiaries Calculated data Not applicable Alert value The alert gets a value of 10 when there is a supplier contractor that is linked to multiple projec
89. ID of Consortium members Address of companies from Orbis Number of registered companies per address of companies registered on the same address Project score Highest alert value of any company linked to the project beneficiary project partner contractor or consortium member Applicable project types Pop up information Registration of multiple companies on same E3 Registration of multiple companies on same address Tables Company involved Role in project Company name Address of the company PORT REAL ESTATE Contractor 45TOX NOORDERLAAN 614 1 PORT REAL ESTATE Contractor GUSE BELGIUM NOORDERLAAN 614 PORT REAL ESTATE Contractor WILMARSDONK MAGAZIJN NOORDERLAAN 614 MOLENBERGNATIE Beneficiary MOLENBERGNATIE NIEUWELANDENWEG 32 MOLENBERGNATIE Beneficiay HELLAS INTERNATIONAL NIEUWELANDENWEG 32 9 MOLENBERGNATIE i AFRIMAR NIEUWELANDENWEdG 32 Mol EMBEBGNATIE i IL COM AB HAL DING MIEL AIEI AMTYEMMTEG 22 The following detailed information is available in the tables tab Name of company registered on the same address limited to 30 as a preview Role in the project Common address of these companies Number of companies registered on the same address No detailed information is available in the values tab Links to further details PORT REAL ESTATE MOLENBERGNATIE The following links to further details are available 220 ARACHNE User manual Link for each company with a role in the proje
90. KE Prajectink subContractor Case management Case status General information Project ident FDVC 001 DG E Managing Authority Ministerie 3 Overall Score 9 Project type Road Start date Status Closed Other contrib 0 00 Personnel 11 Actual add personne 5 Additional tumover 63 769 39 Beneficiary type Private Case sub status 5 Name Member state Op program ident CM Revised score Project income End date Cost ECC Fin assistance Add personnel as agreed Benef tumover Actual add tumover P Mew case il FAKE ProjectJink subContractor Fake country 399 x X001 IAA 991 615 18 3 The case management section is visible only for users having rights to access it Neighborhood Neighborhood Beneficiaries Contractors Sub contractors Project partners Contracts Invalvements Benef Contr Name generic Benef turnover Pastfin corr Benef Contr Company name E C Benef Contr E C Type Benef Contr VAT Mur VADIS CONSULTING VADIS CONSULTING Private 0475080462 The neighborhood contains multiple tables listing elements related to the project beneficiaries contractors sub contractors project partners contracts and involvements Alerts summary This section gives the categorical alert values as a radar chart and the complete alert tree 70 ARACHNE User manual B i Alerts summary Eligibility Overall Score Contract Management
91. Ls 6 1 1 1 Search basics In standard mode the search form part contains predefined search criteria that can be filled by the user The situation is different when using expert mode please refer to chapter 12 1 Typical form entry is composed of three parts the property name the operator and the value field Status code Within Iv Depending on the property type the value field may vary It can be a simple text box a multiple choice picker a combo box a numerical value box a range selector or a date time picker By default all fields left blank are just ignored for the search so you can fill only the desired values For some specific fields you may also have the choice of the operator Company name E C Contains In most search forms only a basic set of criteria is displayed by default The form can be switched from basic mode to advanced mode by clicking on the top left link Advanced when in basic mode Basic when in advanced mode 6 1 1 2 Advanced mode Search for Companies Advanced Search for Companies Basic Company name Contains v Company name Contains Y Company name E C Contains zZ Company name E C Contains Y Status code Within iv Status code Within m Country Within Iv Country Within Iv NACE Code primary Begins with iv NACE Code primary Begins with iv VPI P2B Bankruptcy gt 1 Company age Between inc 1 m 1500 VPI P2B Sold Top 20 gt 1l VPI P2B Ba
92. Management Overall Score Eligibility Overall Score Other Overall Score EJ EJ EJ EJ EJ EJ eel e eg Ei dl BvD Size Performance Overall Score Procurement Overall Score C E Flag Ouse es Overall Alert contractor Reputational Fraud Alerts Overall Score For persons Number of affinities Investment Gp E Number of Companies Project count as beneficiary E Most represented country Number of linked groups E EJ EJ EJ EJ Eg Project count as contractor Ultimate owner country Number of countries Comopanies count Invest SERES EJ Ej P Countries count Active company ETRE taraup dept E EJ Bankrupt company Entity bvd indicator Entity type Legal links count Eg 8 8 be EJ In a group Es EJ Linked to another group VPI Bankruptcy score 1 20 VPI Bankruptcy rating A F VPI P2B Sold Top 20 b fe E 68 ARACHNE User manual 8 Reports The Arachne reports come in two flavors the interactive version inside the application summarizes the information but still allows navigation and other features and the printable version which can be exported or printed directly Interactive version Printable version ojects glow J Det ort VEROCE TOU x VEROCE TOURS KERESKEDELMI S SZOLG LTAT KORL TOLT FELELOSS GU 1 NE Sgeti nas FAKE Project ExtProv HU1t2274699 AR VAT Number 12274696 2 13 VEROCI AR Nase m EntlyType 3 AR Type Beneficiary VADIS CONS
93. N7 77_ 51195 na M 2879 element s The F character appears in row headers to indicate they are filtered results and the button icon displays a green LED filter iS To reset the filter click on the post filter button again then click on the Reset button in the post indicator showing a currently active filter window then apply the results 12 3 Entity basket The Basket is an extra component built for keeping interesting entities from searches navigation or graphs It is particularly useful for cross fertilization searches When you click on an element of the basket some basic details about this entity are shown beneath the basket in the business card 12 3 1 Enabling the basket The basket can be enabled by checking the Basket option in the Windows menu J Notifications P Welcome window Basket i F Task pane Close all opened windows Legends BrowserWindow F Welcome window By default the basket appears collapsed on the right border of the application space Clicking on the tab will open it To keep it opened just click on the pin button in its title bar Sens 533 00 Unassigned Mone 149 00 Unassigned Mone Tam Ls E Case management Note Depending on the client version or user profile the basket feature may be disabled 101 ARACHNE User manual 12 3 2 Sending items to the basket Items can be put in the basket in two different ways Using the conte
94. OT eo 97 NS MEME Zo oec UU aa E em 97 12 Advanced functions ME 98 PE 0 1 Hcl gt RT ee ae ee ee 98 12 1 4 jBuudlngvourseorcn JOLIN ia cscesscecascosccqentesiccssunceadatacecdesavocsedeatesledssondsaiaeusdcdeeeusnscceutedtecnse 98 12 2 POSE PICMG ODLIONSSsesetesemie soatentotatersiadatuconadecaseceetaineatietaicwnaiadivososecemenumdsoanstiedeeentateneneseccen 99 ib MD ee Rec mem 101 1221 EBODURnO he DASKE KERR On Oe ae Fan oV vere E UE oU I o Hus NU DA 101 12 3 2 Senadingjtems TO the DOSKEL mierci ecin te e nbrE ead M PesPUR DC RPM NN RUP MUN eEPI 102 12 04 BOS CL ODONIS oe T IUIS SONIS E A E E DRESS 102 ip MM iro a E E T S 103 12 5 Licensing Ssystem ssessessessessessessessessersresersersresresrrsrrsresresresrrorresrorresrosesseeseeseeseeseeseeseese 103 13 Troubleshooting the application ccscscsccscscscscsccscsccccccscsccccccecscsccccecscececsecscscesescecsces 105 14 PCT OS EET TE TT TTE TETTE TT TT TT TTD 106 MEME Ci cin 106 14 2 Vadis Predictive Indicators cccccssssccccccsssseccccseessecccsseuseecccsseueececseuuseeseeseuuseeeeeseuseeseeenas 113 14 3 X ARACHNE Alerts reference ccccccccsssssssssecccccescnnsssseccccessenassesessceessenansseecsecesseaanseseseees 114 24 4 1 JAEN TUBES e a IRIURE SENI eee ne INE Ee d I EMEN S 114 DAZ Aler COG COCOONS eese ne mI od E OP cad rer read tete Eme e RR N tau DN UE cu RU RUE 115 ym MN Qc uc
95. Overall Score Performance 50 Overall Score y Concentration Overall Score Reputa tional Fraud Alerts Other Overall tera Scu The graph part is not interactive it is only used to display the categorical alerts in a graphical way However all alert values details and other information are available on the alert tree part in the same way as on the dashboard functions Name Value Description B Overall Score D o 19 Overall Score mM CM Revised score C Revised overall score as set in the case management system Procurement Overall Score C3 26 Procurement Overall Score Contract addenda costvs project 0 Contract addenda cost vs project cost Contract addenda cost vs contract 10 Contract addenda cost vs contracted amount Difference final contract end date 5 Difference final contract end date and initial contract end date Number of consortium partners Number of consortium partners CECCO 6 Contract modifications Contract modifications Right clicking on individual alerts will give you the alert details popup as described in the dashboard chapter 5 Ratio of EC financial assistance vs total project cost Ratio of EC financial assistance vs total project cost Values Alert Value Ratio EC assistance and project cost 246 84 Average ratio value in the peer group 121 18 EC financial assistance 313 959 25 Total project cost 1 271 92
96. RELGILIN I i gt Display complete dashboard Display complete dashboard Contracts global Contractors global zie i Ee aa E 2 d Name generic Case status amp 8 s Contract ident Signature date Key expert change Name generic 55 5 EC Type VAT Number E C Country E C 2 93 Fake Extprov Q 30 Contracti21 2009 03 01 Powszechna Kasa Oszczednosci Bank Polski 30 Unknown 5250007738 POLAND Contract 25 Contract 2009 01 01 SA 9 Contracti4 Q 25 Contractl4 2009 03 01 Contractor 18 22 FRANCE Contract202 Q 24 Contract202 20001001 J Contractor19 O 21 FRANCE Fake PO Q 24 Contractl20 2009 03 01 KENDERESI VIZIKOZMU TARSULAT 19 Public 12834444 HUNGARY Contract 23 Contract2 20090301 KOMOZO CTMn EOOA Q 18 111580598 BULGARIA Contract3 Q 23 Contract3 20090201 UL Hunc bis E EE eu BULGARIA BN Fake supervision 22 Contract107 2009 03 01 LE Wrona VAT 17 116562994 BULGARIA IRR PEEL OECD LL MILLION BE PUMP Kereskedelmi s Szolg ltat Kt 17 HUNGARY Display complete dashboard Display complete dashboard This window displays each dashboard in its minimal version with a reduced set of alerts functions and records o Right click navigation remains effective and the link below each dashboard allows you to open the full functional version ts Version 1 16 2416 Orbis version 20130918 VADIS BiTong tiecom Wl sureau van one As this applicati
97. TE E MOLENBERGNATIE The following links to further details are available Links to the interactive reports of the companies mentioned in the tables tab 44 3 9 1 2 High or deteriorating rating compared to sector benchmark Description The objective of this check is to compare the propensity to bankruptcy of a company with the average propensity to bankruptcy in the sector The comparison is made based on i the most recent bankruptcy score and ii the evolution of the bankruptcy score The propensity to bankruptcy is a score from 1 to 20 which indicates the probability that a company will go bankrupt in the coming 18 months Further information on the propensity to bankruptcy indicator is included in 15 2 The objective of the alert is to identify projects to which a company with high financial risk score is linked Level of calculation The check is performed for each beneficiary project partner contractor and consortium member Not applicable Input data The following data is used to calculate the alert Propensity to bankruptcy year X latest available indicator from Orbis Propensity to bankruptcy year X 1 Calculated data The following data is calculated for the alert Average propensity to bankruptcy year X in the sector Average propensity to bankruptcy year X 1 in the sector Evolution of the propensity to bankruptcy from year X 1 to year X Evolution of the average propensity to bankruptcy from year X 1 to year
98. Total amount The following detailed information is available in the values tab Number of expenses with an invoice date after the end date of the project Total number of expenses linked to the project Total amount of expenses with an invoice date after the end date of the project Total amount of all expenses linked to the project No detailed information is available in the tables tab Links to further details Expenses The following links to further details are available Link to the expenses with an invoice date after the end date of the project 134 ARACHNE User manual 14 3 5 3 Difference average per project between invoice date and payment date Description The alert identifies projects for which the average delay between e etme date on pamen dete forepenoes sgh Input data The following data is used to calculate the alert Invoice date of expenses Payment date of expense Calculated data The following data is calculated for the alert Difference between invoice date and payment date for each expense in days Average difference for each project Average difference within the peer group Deviation of the average difference for the project from the average difference in the peer group Alert value The alert gets a value from O to 10 depending on the deviation of the average difference for the project from the average difference in the peer group Additionally a score of 10 is generated if the av
99. U NG POTE tm 34 5 6 5 VIC WWI GCE CUI S ossa ras trccrsssa se E E E E 36 5 6 6 Expanding and collapsing related entities ssec 37 5 6 7 WP 38 Search and navigate uos ssiexcd aem svi ecu iurium sU sen d Ubeen Dip qu Su ev NU CUM RDUM II FU NgPUI EU RE 40 6 1 SIC Ie RBS c TT UU Tr 40 6 1 1 Mesum 40 6 1 2 SOO OIG m 44 6 1 3 SCOT EMINO ON GOKU 7161 OS RR m MET 50 6 2 GVIS ACO OD gaso sc cessessinov E toe hineanors tieasmea ean reenna E eearacere ones 51 6 2 1 System FUNCTIONS oirr ir i E E E E E E E T A E N 51 6 2 2 Navigation BEP mue D serirriersserderi tritri i E EEE EEO EEEE TEE EEEE 51 6 2 3 Naviga lon TOSI S erry A E A O EAE 53 GAD NS tae Sees E EEE E sevens AEA A E AAE A E 54 7 1 PUVA NCA VIEW EE A E N E E T ness 54 7 1 1 Nodes OGOl COOTION e 55 7 1 2 SDECITIE ODLLIODS teens ceste tutded c ETE Der ERA E EOE AEO ETA EE 55 7 2 OUI anr es cos ap ater cate aoe 55 7 2 1 ISCO ZOOM D 56 7 2 2 SBECITCODIONS essence M case sa en DE N EIE SE rep DU TOETA 56 7 3 ATRIDES DI cede menicepmev ie ipte ie Pn istnd meo te FUN Ore 57 7 3 1 CSTO sro PME M 58 7 3 2 SDECIICODHODS sini moa eU Dee UND tor em NN CM NU o E UD 59 7 4 LOC Al VIEW MEM UE mmm 59 7 4 1 Socio teases 59 7 4 2 erase eC T 60 7 5 SUTIN CVSS
100. ULTING NF Mesghborhood Project Information Projectident FDVC 017 Name FAKE Project ExtProv Memberstate Faux pays Mansgng Ministere 11 Authorty Operstng FAKE TEST program OversiiScore 38 CM Revised Start date 2011 1201 End dst 2013 04 30 Ststus Closed Cost 50 00 Othercontnb 0 E C Fin assistance Personnel Futuresdd 39 personnel Actusisdd 7 Benef 100 00 personnel tumover Additions Actusisdd 101 807 00 tumover tumover Beneficiary Add 37 type personnelas agreed Interactive reports are available on different entities and in different formats Each report will be described later in this chapter 8 1 Interactive report The interactive report cannot be printed but contains interactive features and graphs concerning a selected project contract or company Each report is divided into multiple information zones that can be collapsed or expanded As each interactive report contains the same section each section will be described for the project report only and the other reports will just have a brief description of their content 8 1 1 Project interactive report Each report is constituted by different sections that can be expanded or collapsed using the small arrow on the top right of the section title ES The project interactive report contains the following sections Case management and general information 69 ARACHNE User manual Interactive report FAKE Project link subContractor FA
101. X in the sector Alert value The alert gets a value from O to 5 depending on i the value of the propensity to bankruptcy indicator value in Orbis compared to the average propensity to bankruptcy in the sector and ii the evolution of the propensity compared to the average evolution of the propensity to bankruptcy in the sector ARACHNE User manual E Applicable project types Pop up information High or deteriorating rating compared to sector benchmark Z High or deteriorating rating compared to sector benchmark Company involved Role in project P2B Bankruptcy score yearX P2B Bankruptcy score year X 1 Average P2B bancruptcy X score of the sector Average P2B bancruptcy X 1 score of the sector 0 DRAPANTEX Beneficiary 1 18 12 59 12 46 1 TRAXXION Contractor 20 19 11 89 12 00 The following detailed information is available in the tables tab for all involved companies for which predictive indicators are available Company name Role in the project Propensity to bankruptcy score year X Propensity to bankruptcy score year X 1 Average propensity to bankruptcy score year X in the sector Average propensity to bankruptcy score year X 1 in the sector No detailed information is available in the values tab Links to further details X DRAPANTEX X TRAXXION The following links to further details are available Links to the interactive reports of the companies mentioned in the tables tab with a bad propensit
102. XA999XX0 FAKE Project 023 08 e oO Q 10 10 of s 17ESF Fake country Ministerie 2 3999XA999XXC FAKE Project 044 08 Surroundings graph cf 10 09 09 10 009 O 2 13 ESF Fake country Ministerie 2 9999XA999XXC FAKE Project 231 10 o9 0 o8 0Q 100 Q9 Q0 O oQ 3 ESF Fake country Ministerie 3 9999XA999XXC FAKE Project 017 09 oQ ssQ 328 10 100 10 off oO o 16 ESF Fake country Ministerie 3 9993XA999XXC FAKE ProjecHink subConracto 25 10 of O O O O O O O O O O Q soQ s Road Fake country Ministerie 3 9999XA999XXC FAKE Project link subContractor 0 0 2 i10 oQ Q 1 090 1009 oQ Q Q 1 09 o o o 21 Road Fake country Ministerie 3 9999XA999XXC FAKE Project sanction01 o0 e od oQ 0 o o 0 0 0 i10 od o oQ 8 Road Fake country Ministerie 4 9999XA999XXC 7 Benef Contr for FAKE Project SME1 Ix Benef Contr for FAKE Project SME1 Benef Contr Benef Contr Unique Benef Contr Benef Contr Benef Contr Benef Contr Benef Contr Benef Contr Benef Contr Benef Contr Benef Contr Benef Contr Benef Contr Benef Con E Company identification BvD Size Country C E Flag Company city Group name s ur dg e Number bsidi of Number of VPI P25 ae wi Mi The main difference resides in the displayed properties 5 6 7 Filtering Filtering options give the ability to
103. a Just click Next to continue Data export wizard The application will now request the data needed for exporting Please click on the Next button when the progress bar has reached its maximum Data loaded Cn mina 10 2 2 4 Selecting export format At this stage it is time to select in which export format you want to obtain the information The application provides three different export formats Separated Fields Text exports in CSV TSV format Simple Text Export exports in simple text file XML Formatted file exports as a structured XML file The first format is used if you want to load the results in other software such as Excel or database systems It provides a simple delimited text file The simple text export can be used to get tables or lists that can be either printed or re imported into word processors The XML format will generate a structured XML file that can be used in various applications or even transformed using XSLT to generate HTML exports 90 k i ARACHNE User manual Available formats Separated Fields Text CSV TSV Export v Report type Exported file location Misc Separator character Separator Field names as headers v Line feed mode CrLf Use system localization settings Decimals C3 Enable enum translations FI Depending on the chosen export format the following elements on the screen will adapt their content The report type can be u
104. a supplier contractor that appears in multiple projects as supplier contractor within the same Member State Level of calculation The check is performed for each project Peer group Not applicable Input data The following data is used to calculate the alert Projects Related contracts and their contractor Calculated data Alert value The alert gets a value of 10 when there is a supplier contractor that is involved as supplier contractor in other projects within the same Member State Project score Alert value Applicable project types All project types Pop up information Suppliers Contractors involved in multiple projects Ea Suppliers Contractors involved in multiple projects Contractors number of projects Contractors max number of projects in a same member state Total amount of project costs of related contractors 3 3 6 8 4 35 176 ARACHNE User manual The following detailed information is available in the values tab Number of projects in which the supplier contractor is involved as a supplier contractor Maximum number of projects in which the supplier contractor is involved as a supplier contractor within the same Member State Total accumulated cost of the projects in which the supplier contractor is involved as a supplier contractor Suppliers Contractors involved in multiple projects E3 Contractor name Project name WARENHUIS DE VRIJHEID FAKE Project 004 08 WARENHUIS DE VRIJHE
105. a zv enie kvality poskytovan ch slu ieb Rast konkurencieschopnosti spolo nosti Lund Refund cia v davkov na technick vybavenie Rekon trukcia a moderniz cia Hasi skej stan Rekon trukcia a pr stavba Hasi skej stanice Rekon trukcia Hasi skej stanice Nitra Rekon trukcia Hasi skej stanice Topo any Rekon trukcia roz renie a moderniz cia has Technick infra trukt ra v skumu a v voja pr Zavedenie vysoko produkt vnej z kazkovej E amp no 5iim 9T T 20 element s 10 2 Export wizard steps 10 2 1 Refine confirm selection This screen allows you to validate your initial selection by checking or unchecking items in the list You can use the bottom buttons to select all items no item or to invert the current selection Hements to export CARTA MUNDI INC CARTA MUNDI INC CARTA MUNDI POLSKA SP ZO O CARTA MUNDI NV CARTA MUNDI INC CARTA MUNDI INC CARTA MUNDI DEUTSCHLAND GMBH CARTA MUNDI DEUTSCHLAND GMBH CARTA MUNDI ASIA PACIFIC PTE LTD CARTA MUNDI AG CARTA MUNDI CARTA MUNDI SSS Click the Next button when your selection is correct 10 2 2 Property selection Once the items have been selected the second phase is to select which properties fields you want into your final export This mechanism avoids exporting useless properties You can only select properties applicable for the entity selected It is not possible to select properties belonging to other entities
106. ail the error report if automatic reporting is not available or doesn t succeed You can copy the report content and paste it in an email or another document using the clipboard LJ button In order to help developers to identify and fix the issue you may also send the application log files Note that the last log file is automatically attached to the report email when using the Report button To locate and send the log files please follow these simple steps Open the windows file explorer n the address bar type the following line APPDATA Vadis s a GET Client application VArachneM ogs This should place you in the application logs folder Logs are created on a daily basis and are named using the current day date To locate the last log simply locate the file named Log lt yyyy gt lt mm gt lt dd gt log where y is the year m is the month and d is the day corresponding to today s date 105 14 Appendices 14 1 Glossary Affinity Affinity diagram Aggregate companies Basket Beneficiary Business card BvD ID BvD size Case management CE flag Cluster group A business relationship between two managers owners of a same company direct affinity or of two different legally linked companies indirect affinity A graph representing all direct and indirect affinities for a given person Companies held by only one shareholder They are called aggregated since they are represented together with the
107. ailable in the tables tab Name of the supplier contractor Projects in which the supplier contractor is involved as a supplier contractor limited to 30 as a preview Name of the contracts through the supplier contractor is linked with the projects Name of the beneficiary of the project Alert value for the contractor Links to further details H Contract requests The following links to further details are available Link to contract related to the current project that generated the alert value Starting from that point the user can navigate to the supplier contractor and subsequently the related contracts 14 3 7 7 Suppliers contractors linked to multiple operational programs Description The objective of this check is to identify projects for which a supplier contractor is linked to multiple operational programs as a supplier contractor within the same Member State Level of calculation The check is performed for each project Peer group Not applicable Input data The following data is used to calculate the alert Projects Related operational programs Related suppliers contractors Calculated data Alert value The alert gets a value 10 when there is a supplier contractor that is linked to multiple operational programs as a supplier contractor within the same Member State Project score Alert value Applicable project types All project types Pop up information Suppliers Contractors involved in multip
108. ailed information is available in the tables tab Name of the sub contractors limited to 30 as a preview VAT number of the sub contractors Country code of the sub contractors VIES result of the VAT check No detailed information is available in the values tab Links to further details Es Related companies The following links to further details are available Link to the list of related sub contractors 14 3 5 14 Expenditure paid for the purchase of the Land per Project Project total cost Description This check will return the percentage of total amounts used to pay for the purchase of land versus the total project cost Level of calculation The check is performed for each project Peer group Not applicable Input data The following data is used to calculate the alert Expenditure paid for the purchase of land Project cost Calculated data The following data is calculated for the alert Percentage of expenditure paid for the purchase of land compared to the total project cost Alert value The alert gets a value of 10 when the percentage of expenditure paid for the purchase of land compared to the project cost exceeds 1096 Project score Alert value Applicable project types DG Regio Infrastructure Pop up information 146 ARACHNE User manual Alert Project cost Land purchase cost Ratio land purchase cost and project cost The following detailed information is available in the values tab Projec
109. al i 14 3 7 4 Project partners involved in multiple operational programs Description The objective of this check is to identify projects for which the project partner appears in multiple operational programs within the same Member State as a project partner Level of calculation The check is performed for each project Peer group Not applicable Input data The following data is used to calculate the alert Projects Project partners of the project Operation program to which the project belongs Calculated data Alert value The alert gets a value of 10 when the project partner of the project is also involved as project partner in projects belonging to multiple operational programs within the same Member State Project score Alert value Applicable project types All project types Pop up information Partners involved in multiple OPs E3 Partners involved in multiple OPs Project partners max number of operational programs in a same member state Project partners number of operational programs Total amount of project costs of related project partners 245 700 136 68 The following detailed information is available in the values tab Number of operational programs in which the project partners is involved through projects as a project partner Maximum number of operational programs in which the project partners is involved through projects as a project partner within the same Member State Total cost
110. al Ea 14 3 6 11 Quantity of Solid Waste treated in tons after the Project is finished latest available information Quantity of Solid Waste to be treated in tons when the project was approved Description This check returns a ratio that compares the quantity of solid waste treated when the project is finished to the quantity to be treated when the project was approved and defines this as the realization rate The objective of the alert is to identify projects for which the realization rate is lower than the average realization rate in the peer group or low in general Level of calculation The check is performed for each project Input data The following data is used to calculate the alert Quantity of solid waste treated after the project is finished based on the latest available information in tons Quantity of solid waste to be treated as agreed in the project application in tons Calculated data The following data is calculated for the alert Realization rate quantity of solid waste treated quantity of solid waste to be treated Average realization rate in the peer group Deviation of the realization rate of the project from the average realization rate in the peer group Alert value The alert gets a value from O0 to 10 depending on the deviation of the realization rate quantity of solid waste treated vs quantity of solid waste to be treated from the average realization rate in the peer group Additionally w
111. ance 4 000 140 621 02 Tumover af the beneficiary 4 111 059 02 Ratio EC overall financial assistance and benefici 573 02 Average of the ratio in the peer group 75 70 The following detailed information is available in the values tab Overall EC financial assistance Beneficiary turnover Ratio of overall EC financial assistance compared to beneficiary turnover Average ratio in the peer group No detailed information is available in the tables tab Links to further details No links to further details are available 204 ARACHNE User manual i 14 3 8 16 Project cost beneficiary turnover Project level only on SME projects Description The objective of this check is to identify projects for with the ratio of project cost relative to the beneficiary turnover is larger than the average ratio in the peer group Level of calculation The check is performed for each project Operational Program Input data The following data is used to calculate the alert Project cost Beneficiary turnover as sourced by the Member State in table Project Calculated data The following data is calculated for the alert Ratio project cost beneficiary turnover Average ratio in the peer group Deviation of the ratio project cost beneficiary for the project from the average ratio in the peer group Alert value The alert gets a value from 0 to 10 depending on the deviation of the ratio project cost beneficiary tu
112. ankrupt within the next 18 months 20 The company belongs to the top 596 of companies in its country having the highest probability to become bankrupt within the next 18 months 113 14 3 ARACHNE Alerts reference 14 3 1 Alert types We can define three main types of alerts present in the Arachne tool Absolute value based checks The alerts in this category are calculated by comparing a value for a certain variable with absolute values as defined in the design phase of Arachne E g a project with more than 3 consortium partners will be assigned a lower score for that alert than a project with more than 10 consortium partners Ratio checks The alerts in this category are obtained by calculation a ratio of project related values and comparing the results of this calculation with other entities in its peer group The peer group can be different for different checks E g we calculate the relation of travel expenses versus total project cost and compare this across all projects in the operational program A A score is attributed in accordance with the statistical deviation from the mean value of all calculated ratios in this peer group The higher the deviation from the mean the higher the resulting score will be A Flag or no flag checks The alerts in this category will generate a score of O or a score of 10 depending on the absence or presence of a certain variable E g a contract with the contract modificat
113. are available Link to the interactive report of the beneficiary 14 3 9 2 Relationship 14 3 9 2 1 Links between beneficiaries project partners Description The objective of this check is to identify projects for which there exists path between the beneficiaries project partner s A path is a link between several entities in the Orbis database It can be comprised of legal links between companies and private links between companies and related people A distance of 4 or less steps between two entities will be considered as a link Level of calculation The check is performed for project Peer group Not applicable Input data The following data is used to calculate the alert Orbis ID of Beneficiary Orbis ID of Project partners Legal links ownership in Orbis Private links directors in Orbis Calculated data The following data is calculated for the alert Path finding between entities Alert value The alert gets a value of 10 when a path is identified Project score Alert value Applicable project types Pop up information Links between beneficiaries project partners E3 Links between beneficiaries praject partners Alert Number of paths between beneficiaries project partners The following detailed information is available in the values tab Number of paths that have been found between the beneficiary project partner s No detailed information is available in the tables tab Links to fur
114. aste water or supply 164 E ARACHNE User manual Pop up information Cost of sewage renovation vs km to be renovated E3 Cost of sewage renovation vs km to be renovated Alert Value Length of sewage network to be renovated 2 06 Cost relating to the sewage network component 1 752 630 00 Ratio Sewage renovation cost and km renovated 850 731 26 Average ratio in the peer group 292 141 21 The following detailed information is available in the values tab Length of sewage network to be renovated constructed in km Cost relating to the sewage network component Cost per km cost relating to the sewage network component length of sewage network to be renovated constructed in km Average cost per km in the peer group No detailed information is available in the tables tab Links to further details No links to further details are available 165 ARACHNE User manual E 14 3 6 15 Cost relating to the Water supply plant component of the Project Population to benefit from the water supply network as agreed when the project was approved Description This check will return the cost of the water supply plant component per population equivalent to benefit from the water supply network The objective of the alert is to identify projects for which the cost per population equivalent is higher than the average cost in the peer group Level of calculation The check is performed for each project Input data The f
115. ate in the peer group Deviation of the realization rate of the project from the average realization rate Alert value The alert gets a value from O to 10 depending on the deviation of the realization rate of the project from the average realization rate in the peer group Additionally an alert is generated if the realization rate of the project is less than 5096 Alert value Applicable project types 151 ARACHNE User manual E Pop up information Number of additional personnel after project end ws as agreed Number of additional personnel actual Number of additional personnel as agreed Ratio number of additional personnel at project end vs agreed Average of the ratio in the peer group The following detailed information is available in the values tab Number of additional personnel actual after the project is finished Number of additional personnel as agreed Realization rate number of additional personnel actual number of additional personnel as agreed Average realization rate in the peer group No detailed information is available in the tables tab Links to further details No links to further details are available 152 ARACHNE User manual Ea 14 3 6 5 Number of additional personnel as agreed in the Project Number of personnel of the beneficiary when the application was approved Description This check will check the number of staff that will be employed as mentioned in the contra
116. ated for the alert Total amount of expenses with an invoice date dated within 14 days before the project end date Total amount of all expenses related to the project Percentage of expenses dated within 14 days before the project end date compared to the total expense amount Alert value The alert gets a value from O to 10 depending on the percentage of expenses that have an invoice date within 14 days before the project end date Project score Alert value Applicable project types ESF and SME Pop up information High percentage of cost allocations within the last 14 days E3 High percentage of cost allocations within the last 14 days Alert Value Amount of expenses within last 14 last days 8 736 12 Total amount 17 118 18 Percentage of amounts within 14 last days 51 03 The following detailed information is available in the values tab Total amount of the expenses with an invoice date within 14 days before the project end date Total amount of expenses related to the project Percentage of the expenses with an invoice date within 14 days before the project end date compared to the total amount of expenses related to the project No detailed information is available in the tables tab 136 ARACHNE User manual Links to further details bs Expenses The following links to further details are available Link to the expenses with an invoice date within 14 days before the project end date 14 3 5 5 Expenses
117. ation The check is performed for each project Input data The following data is used to calculate the alert Cost relating to the waste water treatment component of the project Population equivalent to benefit from the waste water treatment as agreed in the project application Calculated data The following data is calculated for the alert Cost per population equivalent cost relating to the waste water treatment component of the project Population equivalent to benefit from the waste water treatment Average cost per population equivalent in the peer group Deviation of the average cost per population equivalent for the project from the average cost in the peer group Alert value The alert gets a value from O to 10 depending on the deviation of the average cost per population equivalent cost relating to the waste water treatment component of the project Population equivalent to benefit from the waste water treatment for the project from the average cost per population equivalent in the peer group Alert value Applicable project types Waste water or supply Pop up information 161 E ARACHNE User manual WW cost vs population to benefit E3 WW cost vs population to benefit Alert Population benefiting ta the treatment at approval Waste water treatment component cost Ratio Water Waste cost and population benefiting to the treatment at approval Average ratio in the peer group The following detailed in
118. before start date Alert Value Number of invoices before start date 1 Number of invoices 13 Amount of invoices before start date 3 027 41 Total amount 2 6587 02 The following detailed information is available in the values tab Number of expenses with an invoice date before the start date of the project Total number of expenses linked to the project Total amount of expenses with an invoice date before the start date of the project Total amount of all expenses linked to the project No detailed information is available in the tables tab Links to further details A Expenses The following links to further details are available Link to the expenses with an invoice date before the start date of the project 133 ARACHNE User manual i 14 3 5 2 Project costs outside eligibility period after end date This check will look for costs dated after the project end date Level of calculation The check is performed for each project Not applicable Input data The following data is used to calculate the alert Project end date Expense invoice date Alert value The alert gets a value 10 if there are any expenses for which the e aa 5 on Applicable project types Pop up information Project costs outside eligibility period after end date E3 Project costs outside eligibility period after end date Alert Number of invoices after project end Number of invoices Amount of invoices after project end
119. ct versus the number of staff when the application was approved The objective of the alert is to identify projects for which this performance metric is lower than the average value in the peer group Level of calculation The check is performed for each project Sector Operational Program Project type Input data The following data is used to calculate the alert Number of additional personnel as agreed in the project Number of personnel when the application was approved Calculated data The following data is calculated for the alert Percentage of additional personnel as agreed compared to the number of personnel when the application was approved Average percentage in the peer group Deviation of the percentage for the project from the average percentage in the peer group Alert value The alert gets a value from O0 to 10 depending on the deviation of the percentage additional personnel as agreed versus personnel when the application was approved of the project from the average percentage in the peer group Additionally an alert is generated if the percentage is larger than 50 Alert value Applicable project types Pop up information Number of additional personnel as agreed vs as submitted E3 Number of additional personnel as agreed vs as submitted Alert Number of additional personnel as agreed Number of personnel when submitted Average of the ratio in the peer group Ratio of number of additionnel personnel a
120. ct costs during the last 60 days before the project end date compared to the total project costs Alert value The alert gets a value from O to 10 depending on percentages of costs that are dated less than 60 days before the project end date The higher the percentage the higher the alert value Project score Score of the alert Applicable project types DG Regio Infrastructural projects Pop up information High percentage of cost allocations within the last 60 days Ea High percentage of cost allocation within the last amp days Alert Amount 60 days before end date Total amount Percentage amounts 60 days before end date X Expenses The following detailed information is available in the values tab Total amount of costs dated maximum 60 days before the project end date 129 ARACHNE User manual E Total project costs based on individual expenses Percentage of costs dated maximum 60 days before the project end date compared to the total project costs No detailed information is available in the tables tab Links to further details berg Expenses The following links to further details are available Alink to the list with expenses dated maximum 60 days before the project end date 14 3 4 9 Contracted amount annual turnover of the contractor retrieved via data enrichment Description This check will compare the contracted amount to the annual turnover of the contractor as mentioned in the financial
121. ct end date Calculated data The following data is calculated for the alert Difference between both dates in days Average difference in the peer group Deviation of the difference in days for the contract from the average difference in the peer group Alert value The alert gets a value from O0 to 10 depending on the deviation of the difference for the contract from the average difference in the peer group An alert is generated if the difference for the contract is larger than 270 days Project score Highest score of the contracts that belong to the project Applicable project types DG Regio Infrastructural projects Pop up information Difference final contract end date and initial contract end date Ea Diference final contract end date and initial contract end date Alert Value Initial contract end date 31 08 2010 Final contract end date 29 12 2010 Difference final and initial end dates 120 Average value in the peer group 36 00 The following detailed information is available in the values tab Initial contract end date Final contract end date Difference between de initial contract end date and the final contract end date in days Average difference in the peer group No detailed information is available in the tables tab Links to further details No links to further details are available 124 ARACHNE User manual 14 3 4 4 Number of consortium partners Level of calculation The check is p
122. ct mentioned in the tables tab Clicking on the link opens a selection window with the names of the companies registered on the same address as the company with a role in the project For all selected names the interactive report will be opened Multiple elements found Multiple elements are available Please chose the elements you want to display PORT REAL ESTATE GUSE BELGIUM WILMARSDONK MAGAZIJN 14 3 9 3 Reputational 44 3 9 3 1 Involvement of directors shareholders with bankruptcies Description The objective of this check is to identify projects for which there is related company beneficiary project partner contractor or consortium member with a director shareholder that has been involved in a bankruptcy in the past Level of calculation The check is performed for each beneficiary project partner contractor and consortium member Peer group Input data The following data is used to calculate the alert Orbis ID of Beneficiary Orbis ID of Project partners Orbis ID of Contractors Orbis ID of Consortium members Private links directors shareholders from Orbis Involvements in previous bankruptcies for directors shareholders Orbis Calculated data Alert value The alert gets a value from 5 to 10 depending on date of the bankruptcy a recent bankruptcy results in a higher alert value Project score Highest alert value of any company linked to the project beneficiary project partner contractor or consortium
123. ctivated the introduction web page is shown when the application starts cannot be changed cannot be changed cannot be changed cannot be changed cannot be changed cannot be changed cannot be changed cannot be changed When activated company names will be displayed on company nodes in the affinity graphs instead of the company count Export options Open results after exporting When activated the application will try to open automatically the exported file after a successful export Automatic update Enable auto update process When activated enables auto updating This function is not available in the European Commission version 11 2 Colors The user can choose his preferred colors or those allowing a better visibility when coloring graphs see e g the coloring option 95 ARACHNE User manual Configuration E General options User colors Connection Gradient colors Color palette m L Lower color Automatic palette Em Medium color User palette Document Templates L Higher color User colors Default columns lll Color 1 I Color 5 Color 2 F Color 6 E H Color 3 i Color 7 E Hil Color 4 Hl Color 8 Colorize labels Quick4ind colors __ Found in a node Found in a node s aggregates Colors can be changed by double clicking on color pickers It opens the standard Windows color picker S Bi iii u 11 2 1 Gradient colors The color gradient
124. culated for the alert Year of the latest available financial statements Availability of any published financial statements Alert value The alert gets a value from O to 10 depending on the availability and age of published financial statements The less information available the higher the alert value Project score Highest alert value of any company linked to the project beneficiary project partner contractor or consortium member Applicable project types Pop up information Mon incomplete filing of annual accounts Company involved Year of the last balance sheet used PARKLAND KERESKEDELMI ES SZAKTANACSADO BET TI T RSAS G unknown MELISA EMIN CHAMDERE ET 20011231 Contractor17 unknown VINATHAO KERESKEDELMI BET TI T RSAS G 20051231 The following detailed information is available in the tables tab Name of the company Role in the project Year of the lasted available financial statements No detailed information is available in the values tab 210 ARACHNE User manual Links to further details X PARKLAND KERESKEDELMI ES SZAKTANACSADO BET TI T RSAS G n Contractor 7 The following links to further details are available Link to the interactive reports of the companies mentioned in the tables tab for which there are no financial statements available 44 3 9 1 5 Project cost annual turnover Description The objective of this check is to identify projects for with the ratio of the project co
125. curity reasons it is better expert mode to change it as soon as possible You can also change your e Graphical navigation password at any time You can navigate through different graph representations to discover the network structure behind people companies and groups How to start e Data export Search into the database m i p o various formats such as The GET Client lets you search fogco A h l Ca OF id ce legal links or any other kind of entity or reMation rough the Entities A set of Vadis tailor made potential indicators may be used to add or Relations menu information to the different graph representations or queries For advanced users checking the Expert mode option in the Entities menu will activate the free form search mode Automatic updates en ae The GET Client is able to update itself automatically when connecting By using context menus on the entities or relations you may open to a server providing updates You can also check manually for various graph representations and navigate into them updates Help and support If you need more information about how to work with the application please read the user manual You may also go to our dedicated web site Status bar The main application screen contains different functional blocks e The main application menu e The task pane on the left of the screen e The status bar on the bottom of the screen e The application space In addition ex
126. d 116 14 34 Contract GINO CIC esssesuumcdeennaEubE mtd dum More NEETER NE EEE EEE 122 Hoo ID DI 133 A2 MEE I 0 OE E Tc 148 y E albo aide me 171 14 3 8 Other checks related to ESF projects ccccccseesecccseseccccsececceeseceseusecsssesseseeeesecessuseeeees 190 14 39 Repb tational amp Fraud OIeFES rierien etus UE ERI e ERA Supe MEER QUERER Ore HOUR Fa GM ED VERRE 206 ecc 2 About Arachne Arachne is a client server application based on Vadis GET Groups Exploration Tool application built as a data super browser with advanced functionalities like dashboards and graphical representation of data interconnections Project ARACHNE aims at establishing a comprehensive and complete database of projects implemented under the Structural Funds in Europe and to enrich the data with publicly available information in order to identify based on a set of risk indicators the most risky projects 2 1 Groups Exploration Tool The Arachne project is built on top of the Groups Exploration Tool application from Vadis s a This tool was originally created to provide data exploration tools for the business built on Bureau Van Dijk worldwide data service Orbis database It includes a wide range of publicly available data plus additional data mining options developed by Vadis for the Arachne project Vadis Predictive Indicators
127. d on user s context 17 ARACHNE User manual E This module is visible only for user having access to the case management and lists quick links to important case management functions Please refer to chapter 9 for more details about case management functions The details panel module This panel also called business card will give you instant information about the currently selected entity Heyrovskeho namesti 1888 2 This works for all application screens when an entity is PRAHA 616 selected and displays a default set of properties for the 16200 selected entity CZECH REPUBLIC 420 296 809 111 These properties are customizable using the Parameters 4420 296 809 410 Columns menu then selecting For details panel option office imc cas cz See chapter 11 for more details www imc cas cz STAV MAKROMOLE 3 2 5 3 Application space E Welcome window E Beneficiaries global UNUM Beneficiaries global Project count as beneficiary gt 0 Contract Management Eligibility Overall Score Fraud Alerts Overall Alert Reputational Overall Score Procurement Overall Score Overall Score Performance Overall Score Concentration Overall Score Other Overall e ei VADIS CONSULTING DRAPANTEX Przemyslowy Instytut Automatyki 1 Pomiarow PIAP ILOMAR AGENCIES T MOBILE MAGYARORSZ G TAVKOZLESI RESZVENYTARSASAG HEALTH STUDIO ET SERVICE CENTRE MOLENBERGNATIE LIDEL INTERNATIONAL Pow
128. d to calculate the alert Orbis ID of Beneficiary Orbis ID of Project partners Orbis ID of Contractors Orbis ID of Consortium members Ownership links Orbis Calculated data Alert value The alert gets a value from 3 to 10 depending on the risk level of the country in which the company has group involvements Project score Highest alert value of any company linked to the project beneficiary project partner contractor or consortium member Applicable project types Pop up information Group involvement in sensitive regions Ea Group involvement in sensitive regions Tables Company involved i j Country related to the maximal risk level country Company name related to the maximal risk level Maximal risk level in the group MOLENBERGNATIE j VIET NAM MOLENBERGNATIE GMD VIETNAM 2 3 1 MOLENBERGNATIE ciay VIET NAM MOLENBERGNATIE GMD VIETNAM 3 PORT REAL ESTATE VIET NAM MOLENBERGNATIE GMD VIETNAM 2 3 3 PORT REAL ESTATE vontr VIET NAM MOLENBERGNATIE GMD VIETNAM 3 225 ARACHNE User manual E The following detailed information is available in the tables tab Company name Role in the project Country of the related company within the group of the company Name of the related company within the group of the company limited to 30 as a preview Risk level of the country of the related company within the group of the company No detailed information is available in the values tab Links to further details Gl
129. d to turnover of the contractor in the peer group Contracted amount vs annual tumover of the contractor Contracted amount vs annual tumover Contract name Contractor name Contracted amount Tumover of the contractor 0 Fake Wrong VAT Wrong VAT 295 124 06 2 000 00 Ratio contracted amounts and tumover Alert level 127 565 10 The following detailed information is available in the tables tab for each contract that has an alert value Value of the alert Name of the contract related to that alert value Contract amount Turnover of the contractor retrieved from Orbis Percentage of the contract amount compared to the turnover of the contractor Links to further details X Contract requests The following links to further details are available Link to the contracts that have an alert value 131 ARACHNE User manual 14 3 4 10 External service provider Description This check will check to see if an external service provider is mentioned in the contract to back up financial or technical risks An alert is generated if the is an external service provider Level of calculation The check is performed for each contract Peer group Not applicable Input data The following data is used to calculate the alert External service provider name sourced by the Member States Calculated data The following data is calculated for the alert Number of external service providers sourced by the Member State for
130. data is calculated for the alert Cost per km project cost length or rail in km Average cost in the peer group Deviation of the cost per km for the project from the average cost per km in the peer group Alert value The alert gets a value from O0 to 10 depending on the deviation of costs per km for the project from the average cost per km in the peer group Project score Alert value Applicable projecttypes Rail Pop up information ARACHNE User manual i Project cost vs km rail constructed E3 Alert Value Length of rail constructed in km 578 00 Project cost 64 959 590 00 Ratio project cost and length of the rail constructed in km 112 386 83 Average of the ratio in the peer group 25 077 26 The following detailed information is available in the values tab Length of rail in km Project cost Cost per km project cost length of rail in km Average cost per km in the peer group No detailed information is available in the tables tab Links to further details No links to further details are available 14 3 6 10 Project total cost declared to the EC Quantity of Solid Waste to be treated in tons when the project was approved Description This check will return the project cost per ton of solid waste to be treated The objective is to identify projects for which the cost per ton is larger than the average cost in the peer group Level of calculation The check is performed for each projec
131. dentify projects for with the ratio of personnel cost relative to the total project cost is larger than the average ratio in the peer group Level of calculation The check is performed for each project Peer group Operational Program Input data The following data is used to calculate the alert Personnel cost Project cost Calculated data The following data is calculated for the alert Ratio personnel cost project cost Average ratio in the peer group Deviation of the ratio personnel cost project cost for the project from the average ratio in the peer group Alert value The alert gets a value from O0 to 10 depending on the deviation of the ratio personnel cost project cost for the project from the average ratio in the peer group Project score Alert value Applicable project types Pop up information Personnel cost vs project cost E3 Personnel cost vs project cost Alert Personnel cost Project cost Ratio personnel and project costs Average of the ratio in the peer group The following detailed information is available in the values tab Ratio of personnel cost compared to project cost Average ratio in the peer group Personnel cost Project cost No detailed information is available in the tables tab Links to further details E Expenses The following links to further details are available Link to the personnel costs line items in the expenses 193 ARACHNE User manual 1
132. details are available 14 3 6 3 Training hour cost actually incurred Training hour cost on the basis of the approved budget Description This check will compare the actual cost per training hour provided versus the agreed hourly costs as mentioned in the project budget The objective of the alert is to identify projects for which the actual cost per training hour is higher than the agreed cost per training hour Level of calculation The check is performed for each project Not applicable Input data The following data is used to calculate the alert Hours of training provided Hours of training to be provided as agreed in the contract Project expenses Project cost as mentioned in the contract Calculated data The following data is calculated for the alert Actual cost per training hour sum of project expenses hours of training provided Agreed cost per training hour project cost hours of training to be provided Alert value The alert gets a value of 5 or 10 depending on the deviation of the actual cost per training hour from the agreed cost per training hour An alert is generated if the actual cost per training hour is at least 1096 higher than the agreed cost per training hour Alert value Applicable project types Pop up information 150 ARACHNE User manual g i Training hour cost incurred vs approved E3 Training hour cost incumed vs approved Alert Number of hours of training to be pr
133. e Average ratio in the peer group Deviation of the ratio EC financial assistance project income for the project from the average ratio in the peer group Alert value The alert gets a value from O to 10 depending on the deviation of the ratio EC financial assistance project income for the project from the average ratio in the peer group Project score Alert value Applicable project types Pop up information Ratio of EC financial assistance vs project income E3 Ratio of EC financial assistance vs project income Alert Value EC financial assistance 4 000 140 621 02 Project income 17 00 Ratio EC financial assistance and project income 235 302 389 4 Average of the ratio in the peer group 5 050 3595 73 The following detailed information is available in the values tab EC financial assistance amount Project income Ratio of EC financial assistance compared to project income Average ratio in the peer group No detailed information is available in the tables tab Links to further details No links to further details are available 191 ARACHNE User manual i 14 3 8 3 EC financial assistance other contributions Description The objective of this check is to identify projects for with the ratio of EC financial assistance relative to other contributions is larger than the average ratio in the peer group Level of calculation The check is performed for each project Peer group Operational Progra
134. e and quality of the match No detailed information is available in the values tab Links to further details POWSZECHNA KASA OSZCZEDNOSCI BANK POLSKI SA PKO BP SA 3 Word Compliance article 1701101 HA Mr Peter Leyman The following links to further details are available Link to the interactive report for the related people mentioned in the tables tab Link to the interactive report for each company mentioned in the tables tab Link to WorldCompliance details and articles Word Compliance entry 1701101 E3 Name PKO Bank Polski Source Website Category GovemmentLinkedCom Sub category NA Position s StateJinked enterprise Date 2008 12 23 Remarks empty article A 230 ARACHNE User manual 14 3 9 4 2 Involvement of individuals entities included in sanction lists Description The objective of this check is to identify projects for which there is related company beneficiary project partner contractor or consortium member for which either the company or its management is listed in sanction lists in the WorldCompliance database This will include people that are in a political function or that have close contacts family member close colleague to a politician Level of calculation The check is performed for each beneficiary project partner and consortium member Notapplicable o Input data The following data is used to calculate the alert Orbis ID of Beneficiaries Orbis ID of Pr
135. e a standard document preview window From this window the user can print or export the result to different file formats Using the button switches the presentation to the page view mode Using the zoom combo box gus allows to see multiple pages on screen B FAKE Project ExtProv TUO oe Banaficlary Profectidient FLA COT hier shee ran pays Drell aca 2 Shadi dake 2014 1201 She Cine Pesca 15 es cone VADIS CON SULTING Project information Ade CIO Fieve zcoe End cam ori 20 20 Ec Am 10000 essiz Foteeadd 23 105 0o Acta 101 20700 zT Add personne m agreed Alerts 8 2 1 1 Printing results The report can be printed using the print button 8 2 1 2 Exporting results Using the disk icon gives the user the ability to export in various formats FAKE Project ExtProv Alert Value CH Rewieed tome Overall Teos Overall soo 1 Dremi sowe r2 Chena scone rz Procursment Cara Boone Ferentage disquaitied tender offers vs mecelied Normniber of valid tendere Cuonihmeched amounts vie chosed tendens vs pecleck cost Kemia of contract addenda compared bo sector average Financial comection Contract bungee Overall Contract addenda cost vs project cost Contract addenda cost vs contracted amount Dienne inal conieci end date end Initial contaci end debe 10 Cuonirsct modidicaons Eey experts linked bo msltipie projects High pescentege of cost allocations within Gee es
136. e average ratio in the peer group Level of calculation The check is performed for each project Operational Program Input data The following data is used to calculate the alert EC financial assistance Beneficiary turnover as sourced by the Member State in the Project table Calculated data The following data is calculated for the alert Ratio EC financial assistance beneficiary turnover Average ratio in the peer group Deviation of the ratio EC financial assistance beneficiary turnover for the project from the average ratio in the peer group Alert value The alert gets a value from O to 10 depending on the deviation of the ratio EC financial assistance beneficiary turnover for the project from the average ratio in the peer group Alert value Applicable project types Pop up information Ratio of EC financial assistance vs turnover of the beneficiary E3 Ratio of EC financial assistance vs tumover of the beneficiary Values Alert Value EC financial assistance 4 000 140 621 02 Tumover of the beneficiary 4 111 059 02 Ratio EC financial assistance and beneficiary tumover Average of the ratio in the peer group The following detailed information is available in the values tab EC financial assistance Beneficiary turnover Ratio of EC financial assistance compared to beneficiary turnover Average ratio in the peer group No detailed information is available in the tables tab Links to further de
137. e between 3 and 15 depending on the number and timing of the changes in name during the last 3 years Project score Highest alert value of any company linked to the project beneficiary project partner contractor or consortium member Applicable project types Pop up information Name changes Company involved Role in project Previous name New name BISNODE BELGIUM HOLDING Sub contractor WOM BELGIUM HOLDING BISNODE BELGIUM HOLDING PORT REAL ESTATE Contractor PORT REAL ESTATE ASTOX VADIS COMSULTING Beneficiary No change of name 242 E ARACHNE User manual Name changes Number of diferent names last year Number of different names in the last 3years Change date of names Related company 1 20130320 1 20131024 The following detailed information is available in the tables tab Company name Role in the project Previous name limited to 30 as a preview New name limited to 30 as a preview Number of different names during the last year Number of different names during the last 3 years Date of the change VAT number of the company No detailed information is available in the values tab Links to further details BISNODE BELGIUM HOLDING PORT REAL ESTATE The following links to further details are available Link to the interactive reports of the companies mentioned in the tables tab with name change 243
138. e filter expression the highlight filter dialog will re open with the currently defined criteria To reset a highlight filter click on the filter expression then follow these steps FTA ME Medium SM Country v Within Inthe highlight filter dialog click on the Reset button to reinitialize the filters Click on the Apply button to confirm the operation The highlighting will disappear from the graph 62 ARACHNE User manual Es 7 5 Surroundings graph The surroundings graph is based on the same principle as the local view but uses a path definition instead of one relation type and a depth The path definition consists in a list of connected relations which define which items will be shown in the graph Odkanalizovanie podunajskej asti bratislavsk ho regi nu b Odkanalizovanie podunajskej asti bratislavsk reginu e Bratis buska vodatenska spolo nos as n 53 5 e a n HLAVNA MESTO Hol amp rekonstrukda Centrum v skumu SRBRATIStAVA aintenzifik cia OV riz k z sobovaria vodou ve k ho ur HLAVNE MESTO SR BRATISLAVA lre vr Ej A W Hi 182996 v Ev j v Search amp 6 nodes 6 links 1 5 1 Path definitions Path definitions explain how the relations are bound together to produce the corresponding graph Entity type Surroundings path Project Beneficiary gt Beneficiary Legal lin
139. e progress is at least 10 less than the project progress Alert value Applicable project types Pop up information Number of people trained vs to be trained EJ Number of people trained vs to be trained Alert Number of people trained Number of people to be trained Percentage people trained Project progress Difference between project progress and number of people trained The following detailed information is available in the values tab Number of people trained Number of people to be trained Performance progress percentage of people trained Project progress Difference between the project progress and the performance progress 148 ARACHNE User manual i No detailed information is available in the tables tab Links to further details No links to further details are available 14 3 6 2 Hours of training provided Hours of training to be provided agreed in the Contract Description This check will compare the total number of training hours that have been provided versus the total number of hours of training that needed to be provided as mentioned in the contract and defines this as the performance progress Project progress has been defined as the actual project expenses compared to the project cost as agreed on in the project application The objective is to identify projects for which the performance progress is lower than the project progress Level of calculation The check is perform
140. e the alert Fixed assets cost Personnel cost Calculated data The following data is calculated for the alert Ratio fixed assets cost personnel cost Average ratio in the peer group Deviation of the ratio fixed assets cost personnel cost for the project from the average ratio in the peer group Alert value The alert gets a value from O to 10 depending on the deviation of the ratio fixed assets cost personnel cost for the project from the average ratio in the peer group Project score Alert value Applicable project types Pop up information Fixed assets vs personnel cost x Fixed assets cost over personnel cost ratio Values Alert Fixed assets cost Personnel cost Ratio fixed assets and personnel costs Average of the ratio in the peer group The following detailed information is available in the values tab Fixed assets cost Personnel cost Ratio of fixed assets cost compared to personnel cost Average ratio in the peer group No detailed information is available in the tables tab Links to further details a Expenses The following links to further details are available Link to the expenses all line items 202 ARACHNE User manual i 14 3 8 14 EC financial assistance beneficiary turnover Project level Description The objective of this check is to identify projects for with the ratio of EC financial assistance relative to the beneficiary turnover is larger than th
141. ect cost Average ratio in the peer group No detailed information is available in the tables tab Links to further details E Expenses The following links to further details are available Link to the administrative costs line items in the expenses 195 ARACHNE User manual 14 3 8 7 Representation and travel costs project cost Description The objective of this check is to identify projects for with the ratio of representation and travel cost relative to the total project cost is larger than the average ratio in the peer group Level of calculation The check is performed for each project Peer group Operational Program Input data The following data is used to calculate the alert Representation and travel cost Project cost Calculated data The following data is calculated for the alert Ratio representation and travel cost project cost Average ratio in the peer group Deviation of the ratio representation and travel cost project cost for the project from the average ratio in the peer group Alert value The alert gets a value from O to 10 depending on the deviation of the ratio representation and travel cost project cost for the project from the average ratio in the peer group Project score Alert value Applicable project types Pop up information lepresentation and travel cost vs project cost E3 Representation and travel cost vs project cost Representation and travel costs Project cost Rat
142. ect the entity or relation for which you want to change the columns configuration in the Columns for combo box The left list represents the currently selected columns the right list contains all columns available for the selected entity or relation 2 To add a new column select it on the right list then click on the arrow 3 To remove a column from the selection select it in the left list then click on the delete X button 4 To change the selection order select a field in the left list and use the up down arrow buttons to change its position 97 ARACHNE User manual 12 Advanced functions 12 1 Expert search As all the standard searches are limited to certain predefined criteria it is also possible to turn on the expert mode The expert mode allows to completely customizing search forms based on the whole set of available properties in the system The expert mode is enabled from the Entities main menu or the application configuration Search for Companies Search for Persons Search for Groups Expert mode Pe Navigator Once the expert mode is enabled subsequent calls to entity or relation search forms will display a fully customizable search form instead of the predefined forms To go back to the standard mode simply uncheck the option from the menu 12 1 1 Building your search form In its initial state the expert search form is completely empty Search for Projects d x For each
143. ed balance sheets The legal links also come from this source and represent the entire shareholder to subsidiary relationships These data constitute a network containing about 110 million companies and 12 million legal links Note that smaller companies do not have any shareholder or subsidiary Only medium or big companies are owned by or own other ones 4 6 2 Groups memberships and group legal links The network composed of companies and legal links is processed by a clustering algorithm developed by Vadis to discover sets of strongly linked companies The idea behind this clustering is 24 to try to match the reality of big international or national groups such as Texaco oil LVMH luxury products Carrefour supermarkets and others Once this clustering is done it gives the definition of the various groups in the system From there companies belonging to these groups are linked to them through the membership relation These memberships give the ability to detect common shareholders or subsidiaries main shareholder of a group as well as various group indicators Finally groups are linked together using the group legal links These links are aggregations of legal links existing between companies of two given groups GROUP A GROUP B Company 1 Company 4 Company 2 Company 5 Company 3 Company 6 In this example companies 1 and 3 from group A own shares in company 4 of group B but these shares are not high enough to make t
144. ed cases directly the first step for supervisors will be to assign a case follower The follower will be responsible of the case investigation and will report comments on it Assigned to Assign Vadis Test Creation date PWC Recovery e Created by Fake Test Last update Adriaan ROOT Follo Test User Arachne Only user accounts of the same user group with the follower role are listed in the combo box To assign a case select a follower and click the Assign button When a case has already been assigned there is a possibility for supervisors to reassign it to another follower if needed The mechanism is identical to the assign process 85 ARACHNE User manual Case status c Assigned to Vadis Test Reassign Once a case is assigned its status becomes opened For ongoing cases supervisors are allowed to change the case status and sub status but the case cannot be re assigned to another user Case status Closed v Ei Blacklisted Sa Assigned to Finally for closing cases the supervisor has the responsibility to approve or decline the follower proposed status Approve Decline Case status Closing ZiNoacdion Sla Approving a case will confirm the decision and set the case status to closed Closing the case will assign a value to the revised score of the target entity This revised score is visible in the dashboards and reports Sub status Action Whitelisted Revised score is set to its minimal
145. ed for each project Not applicable Input data The following data is used to calculate the alert Hours of training provided actual Hours of training to be provided as agreed in the contract Project cost Project expenses Calculated data The following data is calculated for the alert Performance progress hours of training provided hours of training to be provided Project progress sum of project expenses project cost Alert value The alert gets a value of 5 or 10 depending on the deviation of the performance progress from project progress An alert is generated if the performance progress is at least 10 less than the project progress Alert value Applicable project types Pop up information Hours of training provided vs to be provided K Hours of training provided vs to be provided Alert Number of hours of training to be provided Number of hours of training provided Percentage hours of training provided Difference between project progress and hours of 149 ARACHNE User manual g i The following detailed information is available in the values tab Hours of training to be provided Hours of training provided Performance progress percentage of hours of training provided vs to be provided Project progress Difference between the project progress and the performance progress No detailed information is available in the tables tab Links to further details No links to further
146. ed in multiple projects Project partner s max number of projects in a same member state Total amount of project costs of related project partners 225 780 136 68 The following detailed information is available in the values tab Number of projects in which the project partner is involved as project partner Maximum number of projects in which the project partner is involved within the same Member State as project partner Total amount sum of the project costs of the projects in which the project partner is involved as project partner Partners involved in multiple projects E3 Partners involved in multiple projects Project partner name Project name Project cost MOLENBERGNHATIE FAKE Project 01 1 08 1 110 004 00 MOLENBERGNATIE FAKE Praject 012 08 187 000 000 00 MOLENBERGNATIE F j 261 241 84 MOLENBERGNATIE j 255 853 84 Rael CRIM Mie KI ATI 1 AC Pe i eh The following detailed information is available in the tables tab Name of the project partner Name of the project in which the project partner is involved as project partner limited to 30 as a preview Cost of the project in which the project partner is involved as project partner Links to further details H Related companies The following links to further details are available Link to the project partner Starting from this link the user can further navigate to the projects in which the project partner is involved 174 ARACHNE User manu
147. ed words contained in the text fields to be able to process to word search This means that when typing word1 word2 in a text box using the Contains operator the application will try to use the full text index to locate occurrences of the field containing both words word1 AND word There is also a possibility for the user to use wildcard expression for some words Only trailing wildcards are supported in full text indexing e g when typing word in a search field the operation really processed is return all records where the property contains a word beginning with word Name generic Reabilitare teatru de vara din Parcul Nicolae Romanescu Campanie de promovare si consolidare a brandului de turism al Campanie de promovare a 3 destinatie turistica si a Bucurestiului c Realizarea brandului turistic a Member state zr E 50 ARACHNE User manual 6 2 Navigation The navigation into the global network built on entities and relations always uses the same behavior 4 i e context menus available on the various entities and relations These context menus are available on the following items Any entity or relation displayed in a table or dashboard Any entity or relation displayed in a graph Case status Project FAKE Project SME5 v 2 EN e y MsrpaxnaHe Ha MHTerpupaHa Y Add to basket a 0404147 Y Add to basket P 085491 2012 41 Bolsas de Fc Create new case
148. eee The following data is used to calculate the alert Orbis ID of Beneficiaries Orbis ID of Project partners Orbis ID of Contractors Orbis ID of Consortium members Private links of the companies management Orbis The following data is calculated for the alert Links between Orbis data and World Compliance Quality of the link The alert gets a value from O to 10 depending on the quality of the match between the Orbis entity and the entity in World Compliance The quality of the match depends on the number of elements Quality of the name match exactly the same or similar Additional match on address or not Additional match on birthdate or not Frequency of appearance of the name in the database Highest alert value of any company linked to the project beneficiary project partner contractor or consortium member PAM 229 E ARACHNE User manual Involvement in PEP lists t3 Involvement in PEP lists Role in project Person ID ls a Political Exposed Person 0 POWSZECHNA KASA OSZCZEDNOSCI BANK POLSKI SA PKO BP SA Contractor Mr Peter Leyman Entity matched as PEP listed with a quality score of 0 5 1 VADIS CONSULTING Beneficiary Entity matched as PEP listed with a quality score of 0 5 The following detailed information is available in the tables tab Name of the company Role of the company in the project Name of the related individual when applicable Type of match between Orbis and World Complianc
149. ember stz s 88 55E oir oi HH 2 6 c o a6 66 cu g FAKE Project supervision1 Q 30 18e 50 Q 30 soQ 22 Solid waste Fake count FAKE Project ExtProv 34 i18 5o 0 35 50 20 Solid waste Fake count FAKE Project 003 08 E Unassigned 3 0 so so so o 15 Energy eff Urban Fake count DRE HEFER FE F OTE a cid cd E B aft lsiti8st8s 608 S35 LIDEL INTERNATIONAL isQ oQ 9 4 FAKE Project link subContractor soQ D 0 QO 25 s0 15 Road Fake count FAKE Project sanction03 D soQ Q Q Q 25 so i1s Fake count FAKE Project 407 08 E Unassigned Q 2 QO 250 O 25 so 1s ESF Fake count FAKE Project 003 08 210 Q Q so OQ 15 Energy eff Urban Fake count FAKE Project 045 09 am 210 250 330 o so 30 o 15 Rail Fake count FAKE Project 197 09 220 4 380 000 250 40 o 3 Water waste supply Fake count FAKE Project SME4 Q 2 0 Q o 38 250 25Q 14 SME Fake count FAKE Project 136 09 Q 20Q Q Q Q so o 10 Fake countr FAKE Project 158 09 200 Q Q so o 1i0 Fake countr FAKE Project 173 09 D 220 Q Q D so o 10 Fake countr FAKE Project 175 09 D 0 20Q Q Q Q so o 10 Fake countr FAKE Project 178 09 20 Q Q Q so o 10 Fake countr M amp nbi t 20 element s Each pr
150. enda compared to sector average Alert Total number of contract addenda for all contracts of the project Highest number of contract addenda on project related contracts Average number of contract addenda in the peer group The following detailed information is available in the values tab Total number of contract addenda for all contracts of the project Highest number of contract addenda on project related contracts Average number of contract addenda per contract in the peer group No detailed information is available in the tables tab Links to further details No links to further details are available 120 ARACHNE User manual 14 3 3 6 Financial correction to procurement procedure applied in the past in relation to the beneficiary Description This check will check to see if any financial corrections have been preter maleimtepetferebenefda i Input data The following data is used to calculate the alert Flag whether there has been a financial correction to a procurement procedure applied in the past in relation to the beneficiary Calculated data Not applicable Alert value If a financial correction has been applied to the beneficiary in the eee a o o o Applicable project types Pop up information Hnancial correction Ea Financial comection Values Alert Value Financial comection Yes The following detailed information is available in the values tab Indication whether a financial c
151. entities will be considered as a link Level of calculation The check is performed for each contractor supplier including consortium members Peer group Not applicable Input data The following data is used to calculate the alert Orbis ID of Contractors suppliers Legal links ownership in Orbis Private links directors in Orbis Path finding between entities identified depending on the number of paths Project score Highest alert value of the values for the contractors suppliers linked to the project Applicable project types Pop up information Links between contractors suppliers Ea Alert Number of paths between contractors suppliers 216 ARACHNE User manual EI The following detailed information is available in the values tab Number of paths that have been found between the contractors suppliers including consortium members No detailed information is available in the tables tab Links to further details E Path The following links to further details are available Link to the visualization of the path s that have been found In the visualisation additional information can be added roles on the project legal links private links affinities 44 3 9 2 5 Links between contractors consortium members and sub contractors Description The objective of this check is to identify projects for which there exists path between the contractors consortium members and sub contractors
152. er of the beneficiary as agreed in the Project when the project was approved Turnover of the beneficiary when the application was approved when the Project starts given in the data Description This check will compare the additional turnover of the beneficiary as agreed in the project application versus the actual turnover amount of the beneficiary when the application was approved The objective of the alert is to identify projects for which this performance metric is lower than the average value in the peer group Level of calculation The check is performed for each project Sector Operational Program Project type Input data The following data is used to calculate the alert Additional turnover beneficiary as agreed in the project application Turnover beneficiary when the application was approved Calculated data The following data is calculated for the alert Percentage of additional turnover as agreed compared to the turnover when the application was approved Average percentage in the peer group Deviation of the percentage for the project from the average percentage in the peer group Alert value The alert gets a value from O to 10 depending on the deviation of the percentage additional turnover as agreed vs turnover when the application was approve of the project from the average percentage in the peer group Additionally an alert is generated if the percentage is larger than 5096 Alert value Applicable pro
153. erage difference for the project exceeds 40 days for ESF projects or 90 days for ERDF projects Applicable project types All projects Pop up information Difference between invoice and payment dates E3 Difference between invoice and payment dates Alert Average of difference between invoice and payment dates project Average of difference between invoice and payment dates peer group Standard deviation of difference between invoice and payment dates peer group The following detailed information is available in the values tab Average difference between invoice date and payment date for all expenses linked to the project Average difference between invoice date and payment date for all expenses within the peer group Standard deviation of difference between invoice date and payment date in the peer group No detailed information is available in the tables tab Links to further details 135 ARACHNE User manual i P Expenses The following links to further details are available Link to all expenses related to the project 14 3 5 4 High percentage of cost allocations during the last 14 days before Project end date Description This check identifies projects for which a high percentage of the Level of calculation Peer group Input data The following data is used to calculate the alert Expense amount Expense invoice date Project end date Calculated data The following data is calcul
154. erent types of entities It aims at having a complete overview of the relationships around a specific entity C3 Groups Exploration Toolset GET TPM Server Test File QQ Entities Relations Dashboards Parameters Windows Help ud GET Client introduction d Q Search for Companies 6 Navigator vx m d Vadis Test01 co Groups z ff Connect ET SENEREREN NT Pinna R Your current profile DD Gp country dst companies countries gt Change your password gt gt T gP Disconnect 3 2 BREPOLS GROUP Std Normal BELGIUM 27 Manufacturing Printing publishing and allied industries 1 BREPOLS GROUP Begijnhof 67 TURNHOUT 2300 BELGIUM Companies 32 14 44 80 20 Unique i NACE 32 14 42 83 13 Company identification Size BvD Country Company Group name Code NACE Na 0 city v2 sub 2 number primary E ETEX BE0400454404 VL Very large BELGIUM BRUXELLES ETEX 7415 4673 gt WB l IMMOBILIENMAATSCHAPPIJ DE VALK BE0406696551 SM Small BELGIUM ARENDONK 7020 6832 El HET PAVILJOEN BE0418357040 ME Medium BELGIUM ARENDONK 5153 0210 El DE KRUISBERG BE0418360307 ME Medium BELGIUM ARENDONK 0111 0210 E ENS Persons UPI 1 Ao Birth Number of Number of Number of E date affinities Companies linked groups R LINE MANAGEMENT C002077765 0 8 1 R ASSAPP C002162188 0 3 1 R Mr Jean Louis Marie Ghislain De Cartier De Marchienne P044177189 260 13 6 S Mr Emile De Cartier De Marchienne P044195145 101 3 3 a Mr Paul De Jon
155. erformed for each contract Not applicable Description The objective of this alert is to identify contracts for which there are a high number of consortium partners Input data The following data is used to calculate the alert Number of consortium partners Calculated data Not applicable Alert value The alert gets a value from O to 10 depending on the number of consortium partners for the contract A higher number of consortium partners results in a higher alert value Highest score of the contracts that belong to the project Applicable project types DG Regio Infrastructural projects Pop up information Number of consortium partners Ea Number of consortium partners The following detailed information is available in the values tab Number of consortium partners Number of consortium partners E3 Number of consortium partners Consortium member name THE BELGIAN CHOCOLATE GROUP FIRMA SWINKELS WARENHUIS DE VRIJHEID Wrong VAT The following detailed information is available in the tables tab The names of the consortium partners Links to further details 125 ARACHNE User manual i Contract reguests Related companies The following links to further details are available Contract requests link to the related contract Related companies link to the consortium partners 14 3 4 5 Contract modifications Description This check will check to see if any contract modifications have bee
156. ernal data Sub contract Requestor Contract Requestor E Project Contract Contract Executor 7 Legal link Company Expense c Beneficiary ep E D 2 gt Membership Private f Person j Group Affinity Group legal link 22 4 5 1 Entities Project The Project entity represents a single E C project A project is linked to one beneficiary and multiple contractors via the Beneficiary relation It is also linked to contracts via the Contract requestor relation and to persons via the Involvement relation Contract The Contract entity represents a contract passed by a company beneficiary contractor or sub contractor for a given project The contract is linked to the project via the Contract requestor relation and to the company via the Contract executor relation Company The Company entity contains mixed information coming from E C data beneficiary contractor and sub contractor information and public data financial and scores Companies are linked to projects via the Beneficiary relation They are linked to contracts via the Contract executor relation In addition companies are linked together via the Legal link relation to groups via the Membership relation and to persons via the Private relation These three relations come from the public data Person The Person entity represents either individuals or corporations The persons are linked to projects through the nvolvement relation Persons are also lin
157. ers with invalid VAT number Supplier name VAT Number of the supplier DAINIPPON SCREEN NEDERLAND BV 33163141 CORNEA EXPERT CONTA SRL 2348 852 lalpress SRL 16981739 PUNCT ADVERTISING SRL 15560545 FUNDATIA RO 2000 11186392 The following detailed information is available in the tables tab Name of the suppliers limited to 30 as a preview VAT number of the suppliers Country code of the suppliers VIES result of the VAT check No detailed information is available in the values tab 141 B i ARACHNE User manual Links to further details ig Contract requests The following links to further details are available Link to the list of related contracts through with the suppliers are linked to the project Starting from this list the user can navigate to the concerned suppliers right mouse click contractor 14 3 5 10 Project total cost declared to the EC Turnover of the beneficiary when the application was approved retrieved via data enrichment Description This check will look at the total project cost versus the turnover of the beneficiary at the moment that the project application was approved as mentioned in the financial statements of the project year data from Orbis The objective of the alert is to identify projects for which the project cost compared to the beneficiary turnover is high Level of calculation The check is performed for each project Sector Operational Program Project
158. es the report in MIME HTML format also called Web Archive format This format is compatible with most common web browsers ut Generates the report in Microsoft s Electronic Paper Format XPS which is very similar to the PDF format but designed by Microsoft ARACHNE User manual 9 Case management The case management was designed to assist the user of the Arachne tool in managing the proper follow up of projects or contracts that require additional review 9 1 1 Case management user roles Each Arachne user account will be assigned one of the following user roles with regards to the case management module Guest he can see cases but cannot change anything except comments Follower he can add additional information to the cases that are assigned to him he can propose a case status change He cannot assign cases to specific users nor approve other case status changes Supervisor he must re assign the cases to specific users user with a Follower role and he can accept or decline case status change proposals Roles are assigned by local administrators on user account creation Some users may not access the case management module depending on how their account has been created The following table explains which user role has which access to the case management functions Follower Supervisor Create new cases Assign cases Change case status Close cases Add comments Display case information 9 1 2 Case
159. eterme Contract29 TRUVO BELGIUM The following detailed information is available in the tables tab Name of the actual key expert Name of the related contract Name of the related contractor No detailed information is available in the values tab Links to further details eI Contract requests The following links to further details are available Link to the related contract ARACHNE User manual 14 3 4 7 Key experts linked to multiple projects Description The objective of the check is to identify contract in which key experts are involved that are also involved in other contracts related to other projects Level of calculation The check is performed for each contract Peer group Operational Program Input data The following data is used to calculate the alert Name of the key expert Calculated data The following data is calculated for the alert Identification of the other contracts in which the key expert is involved and verification whether those contracts are linked to different projects Alert value The alert gets a value from O to 10 depending on the number of different projects in which a key expert is involved via contracts Project score Highest score of the contracts that belong to the project Applicable project types DG Regio Infrastructural projects Pop up information Key experts linked to multiple projects E3 Key experts linked to multiple projects Alert Number of projects Number
160. ffers received Average percentage in the peer group Deviation for each contract from the average percentage in the peer group Alert value The alert gets a value from O to 10 depending on the deviation from the average value in the peer group Project score Highest score of the contracts that belong to the project Applicable project types DG Regio Infrastructural projects Pop up information Percentage disqualified tender offers vs received E3 Percentage disqualified tender offers vs received Alert Number of valid tender offers Number of disqualified tender offers Ratio number of disqualified and total tender offers Average of the ratio in the peer group The following detailed information is available in the values tab Number of valid tender offers Number of disqualified tender offers Percentage of disqualified tender offers Average percentage in the peer group No detailed information is available in the tables tab ARACHNE User manual Links to further details No links to further details are available 14 3 3 3 Number of valid tenderers Description This check will look at the total number of valid tenders The objective of the alert is to identify contracts for which the number of received valid tender offers is lower than the average number of valid tender offers received in the peer group Level of calculation The check is performed for each contract Peer group Sector Operational Program
161. ficial lists of tax havens and regions sensitive to corruption Level of calculation The check is performed for each beneficiary project partner contractor and consortium member Peer group Input data The following data is used to calculate the alert Orbis ID of Beneficiary Orbis ID of Project partners Orbis ID of Contractors Orbis ID of Consortium members Private links directors shareholders from Orbis Countries companies linked to directors shareholders Orbis Calculated data Not applicable Alert value The alert gets a value from 3 to 10 depending on the risk level of the country in which the director shareholder has involvements Project score Highest alert value of any company linked to the project beneficiary project partner contractor or consortium member Applicable project types Pop up information Involvement of directors shareholders from sensitive regions 3 Involvement of directors shareholders from sensitive regions Tes Company involved Role in project Person Related company Country 0 Moller Guttenbrunn Hullad kanyag Keresked s Feldolgoz Kit Beneficiary Mr Danny Vincenzo Steriti METFER TRADING LIMITED LIECHTENSTEIN The following detailed information is available in the tables tab Name of the company Role in the project Director shareholder linked to the company Name of the company in which the director shareholder has an involvement Country of the c
162. for model building Scoring is made available for companies in around 60 countries where companies information is available Sufficient historical financial data from the company and the companies in its peer group has to be available in order to be able to calculate the score A risk ranking within each country across all size segments is produced This ranking values from 1 to 20 with 20 being the highest 596 most exposed companies in the country A local risk rating also defined as 6 classes A B C D E and F with F being the class having the highest propensity of bankruptcy within the next 12 to 18 months The following table lists the different categories with their matching scores Category Score Explanation A 1 5 The company belongs to the bottom 2596 of companies in its country having the lowest risk to become bankrupt within the next 18 month B 6 11 The company belongs to the second bottom band companies in its country representing low risk of bankruptcy within the next 18 months C 12 14 The company belongs to the third bottom band of companies in its country representing relatively low risk of bankruptcy within the next 18 months but with a higher risk probability than those in rating B 15 17 The company belongs to a band of companies in its country having a medium risk to become bankrupt within the next 18 month 18 19 The company belongs to a band of unstable companies in its country having a high risk to become b
163. formation is available in the values tab Population equivalent to benefit from the waste water treatment as agreed in the project application Cost relating to the waste water treatment component of the project Cost per population equivalent cost relating to the waste water treatment component of the project Population equivalent to benefit from the waste water treatment Average cost per population equivalent in the peer group No detailed information is available in the tables tab Links to further details No links to further details are available 162 ARACHNE User manual Ea 14 3 6 13 Cost relating to the Waste Water Treatment Component of the Project Population Equivalent benefiting from the waste water treatment latest available information Description This check will return the cost of the water waste component per population equivalent benefiting from the water waste treatment The objective of the alert is to identify projects for which the cost per population equivalent is higher than the average cost in the peer group Level of calculation The check is performed for each project Input data The following data is used to calculate the alert Cost relating to the waste water treatment component of the project Population equivalent benefiting from the waste water treatment actual latest available information Calculated data The following data is calculated for the alert Cost per populati
164. from O to 10 depending on the deviation of the ratio EC financial assistance project cost for the project from the average ratio in the peer group Project score Alert value Applicable project types Pop up information Ratio of EC financial assistance vs total project cost Ea Ratio of EC financial assistance vs total project cost Alert Value EC financial assistance 591 615 18 Project cost 4563 00 Ratio EC financial assistance and project cost 217 32 Average of the ratio in the peer group 24 83 The following detailed information is available in the values tab EC financial assistance amount Project cost Ratio of EC financial assistance compared to project cost Average ratio in the peer group No detailed information is available in the tables tab Links to further details No links to further details are available 190 ARACHNE User manual i 14 3 8 2 EC financial assistance Project income Description The objective of this check is to identify projects for with the ratio of EC financial assistance relative to the project income is larger than the average ratio in the peer group Level of calculation The check is performed for each project Peer group Operational Program Input data The following data is used to calculate the alert EC financial assistance Project income Calculated data The following data is calculated for the alert Ratio EC financial assistance project incom
165. g point if it is only composed of weak links i e no skeleton exists The dashboard function summarizes the critical information for projects beneficiaries contracts and contractors in a compact visual and interactive way Its target is to focus the user s attention on high risk indicators Company s earnings before interest taxes depreciation and amortization which give an indication of its current operational profitability i e how much profit it makes with its present assets and its operations on the products it produces and sells As this application is based on client server architecture it requires user authentication to connect to the server The default user authentication is done through the standard ECAS authentication service in place at the European Commission Entity Project Contract company person or group Entity BvD missing Missing indicators A Any company with known recorded shareholders none of which having more than 25 of direct or total ownership Companies with 6 or more identified shareholders of any type whose ownership percentage is known Also attributed to A companies in which the summation of direct ownership links all categories of shareholders included all of which being under 25 is higher than 75 As above but includes companies with 4 or 5 identified shareholders As above but includes companies with 1 to 3 identified shareholders Also attributed for a company that is menti
166. generic Case status 5 5 E 8 Project type Member state Managing Authority Op Name generic S Total grants amount EC Type VAT Number E C Country g Of o FAKE Project supervision Q 34 Solidwaste Fake country Ministerie 10 9994 ee a Rn 24 ni Ti a FAKE Project ExtProv Q 34 Solid waste Fake country Ministerie 11 999 E eed NUN SS BELGIUN FAKE Project 003 08 Unassigned 33 Energy eff Urban Fake country Ministerie 1 9994 a ee 22 933 088 96 Unknown 5250008815 POLAND FAKE Project 024 09 z 32 ESF Fake country Ministerie 3 3991 ILOMAR AGENCIES 20 4 043 770 510 30 Public 0444190813 BELGIU FAKE Project link subContractor Q 30 Road Fake country Ministerie 3 999 T MOBILE MAGYARORSZ G T VK ZL SI FAKE Project sanction03 z e 30 Fake country Ministerie 6 999 ARSASAG akksi ii Acn FAKE Project 407 08 Unassigned 28 ESF Fake country Ministerie 58 999 HEALTH STUDIO ET SERVICE CENTRE Q 18 497 085 749 06 Public 0412656212 BELGIUM FAKE Project 003 08 E e 21 Energy eff Urban Fake country Ministerie 1 999 MOLENBERGNATIE 17 79 227 509 50 Public 0404785354 BELGIUM ES A Aa Del rae eee ann ad cena jm 16 A1 Q62 270 93 Private 0412640472 RELGIUN 4 Ill b 4 IIl b Display complete dashboard Display complete dashboard Contracts global Contractors global xit ss imd LM Name generic Case status 5 8 Hi Contract ident
167. gh De Jong P123401651 53 19590000 93 4 3 gm UD Cm S nmtm emet adi mes 4 gt BREPOLS GROUP To put elements in the navigator window you have to drag and drop them in the correct area i e drag a company and drop it into the Companies table Once a first element has been added to the navigator a double click on it will populate the other tables with related elements Double click can occur in any of the tables 12 5 Licensing system Arachne users have unlimited access to their own data i e the information they have provided themselves through SFC2007 utilizing a predefined XML schema The external data corporate data sanction lists adverse media is subject to a licensing fee with a concurrent users structure In case there is a license available the user will get it automatically when either starting up the application or performing an action in the application which requires access to the external data 103 ARACHNE User manual Es When an action is performed which requires a license and there is no license available then a pop up message is shown The license is automatically released when the user is inactive during a period of 5 minutes In the restricted access mode without license the user has access to the internal data all alert scores based on internal as well as external data the detailed information drill down pop up of alerts based on internal data visualization based on inte
168. gories entity search and relation search These search forms are available through the main application menu Once items have been found the application offers a quick navigation into the entity relationship diagram through context menus right click menus 6 1 Search forms Search forms provide a quick and efficient search based on predefined criteria Different search forms are provided by default with the application and they apply to various entities and relations As stated in the overview the application provides both entity search and relation search through its main menu laratian Toolset GET CE Server Test Dashboards X Case management Parameters Windows Lj Groups Exi 6 1 1 Search on entities Entity search provides forms for projects contracts companies persons and group C Relations Dashboards 4 Search for Projects Search for Contracts Search for companies BvD ID E Search for Companies A Search for Persons Search for Groups Expert mode LI Navigator A typical search window contains two main components the search form itself and the results table Search for Companies Company name Contains Company name E C Contains Status code in v Mn i Search form NACE Code primary Begins with ar VPI P2B Bankruptcy ea VPI P2B Sold Top 20 gt 1 G NACE Code NACE 2 0 2 roup name primary digits Results table ARACHNE User manual
169. greed vs at approval The following detailed information is available in the values tab Number of additional personnel as agreed Number of personnel of the beneficiary when the application was approved Average percentage in the peer group additional personnel versus personnel when the application was approved Percentage for the project No detailed information is available in the tables tab 153 ARACHNE User manual gi i Links to further details No links to further details are available 14 3 6 6 Additional Turnover of the beneficiary after the Project is finished latest available information Additional Turnover of the beneficiary as agreed in the Project when the project was approved Description This check will compare the additional turnover of the beneficiary when the project has finished versus the additional turnover that was foreseen in the project application and defines this as the realization rate The objective of the alert is to identify projects for which the realization rate is lower than the average realization rate in the peer group Level of calculation The check is performed for each project Sector Operational Program Project type Input data The following data is used to calculate the alert Additional turnover beneficiary when the project is finished Additional turnover beneficiary as agreed in the project application Calculated data The following data i
170. he company 4 belong to group A participation rates are commonly between 0 01 and 10 In the same way company 5 owns shares of company 3 Once aggregated these so called weak links give a global relation between group A and group B GROUP A pe GROUP B The group legal link direction and weight depend on the number weights and directions of all aggregated legal links 25 ARACHNE User manual E 4 6 3 Affinities Affinities are relationships between people that are computed based on private relations and legal links The idea is to create an affinity between two individuals when these individuals have a function in the same company or have a function in directly related companies We distinguish direct affinities and indirect affinities Direct affinity Indirect affinity Person Person Person Person Company Company Company 4 6 4 Vadis Predictive Indicators In addition to the external data the application provides two indicators built on predictive modeling techniques These indicators called Vadis Predictive Indicators or VPI are only available for companies The two indicators are VPI P2B Bankruptcy predicts the risk for a company to go bankrupt VPI P2B Sold predicts the risk for a company to be sold bought by another More information about the scores can be found in chapter 14 2 of this manual 26 5 Dashboards The dashboard function summarizes the critical information for projects beneficiar
171. he ratio seminars publishing cost project cost for the project from the average ratio in the peer group Project score Alert value Applicable project types Pop up information Alert Value Seminars publishing costs 134 421 60 Project cost 877 286 50 Ratio seminars publishing and project costs 0 15 Average of the ratio in the peer group 0 06 The following detailed information is available in the values tab Seminars publishing cost Project cost Ratio of seminars publishing cost compared to project cost Average ratio in the peer group No detailed information is available in the tables tab Links to further details E Expenses The following links to further details are available Link to the seminars publishing costs line items in the expenses 198 ARACHNE User manual i 14 3 8 10 Research costs project cost Description The objective of this check is to identify projects for with the ratio of research cost relative to the total project cost is larger than the average ratio in the peer group Level of calculation The check is performed for each project Peer group Operational Program Input data The following data is used to calculate the alert Research cost Project cost Calculated data The following data is calculated for the alert Ratio research cost project cost Average ratio in the peer group Deviation of the ratio research cost project cost for the project f
172. hen the realization rate is less than 7096 5096 or 3096 an alert is generated Alert value Applicable project types Solid Waste Pop up information Quantity of solid waste treated vs to be treated Eg Quantity of solid waste treated vs to be treated Alert Quantity of solid waste to be treated Quantity of solid waste treated Ratio quantity Solid Waste treated and to be treated Average ratio in the peer group The following detailed information is available in the values tab Quantity of solid waste to be treated as agreed in project application in tons Quantity of solid waste treated when the project is finished in tons Realization rate quantity of solid waste treated vs quantity of solid waste to be treated Average realization rate in the peer group 160 ARACHNE User manual g i No detailed information is available in the tables tab Links to further details No links to further details are available 14 3 6 12 Cost relating to the Waste Water Treatment Component of the Project Population Equivalent to benefit from the waste water treatment as agreed when the project was approved Description This check will return the cost of the water waste component per population equivalent to benefit from the water waste treatment The objective of the alert is to identify projects for which the cost per population equivalent is higher than the average cost in the peer group Level of calcul
173. his case The case management module can be accessed directly using the Case management link on the bottom right of the table or via the menu bar option Case management Please read the case management chapter 9 for more information 3 2 3 2 Alert statistics section Depending on your user level this part of the application displays average global alert value and average revised alert values See chapter 5 1 for more details about alerts amp x Alert statistics Op program ident Average of CM Revised Occurences of Overall Occurences of CM Op program ident Average of Overall Score ae 38 20075K16UPO001 13 00 3 9999X A999XX001 Q 15 00 Q Global average Overall Score 10 00 CM Revised score The user s context corresponds to the group it belongs and the access rights related to it operational program management authority The user level depends on your current user group and how it is located into the group hierarchy It can be operational program managing authority audit authority certification authority Member State or DG 11 ARACHNE User manual The statistics contain the following elements First column contains the aggregation criteria it may be the operational program as selected in the current example the managing authority or the member state depending on your user level Second column contains the projects overall score average value inside the selec
174. idiary 109 Map of groups Membership NACE code Navigator Orbis database Path graph Participation rate Person Prim main country Prim main sector Prim nof companies Prim nof countries Private link A map of groups is a network map of interconnected cluster groups of companies The Membership relation links companies to their group s One company may be linked to no group one group or two groups In this last case one group is qualified as the standard group and the second one as the investment group The Statistical Classification of Economic Activities in the European Community in French Nomenclature des Activit s conomiques dans la Communaut Europ enne commonly referred to as NACE is a European industry standard classification system consisting of a 6 digit code The navigator allows the user to visualize the different relations between different types of entities company person and group in one single screen separated into three parts because of the three different types of entities It aims at having a complete overview of the relationships around a specific entity Database containing publicly available information about companies and their board members o General information address phone web site o Financial information coming from published balance sheets o Ownership information between companies o Ownership and functional relationships between companies and i
175. ies contracts and contractors in a compact visual and interactive way Its target is to focus the user s attention on high risk indicators The dashboards can be accessed either by the application main menu or the welcome window s mini dashboards A dashboard displays a given top number of elements ordered by highest alert value for a given focus An alert is a property whose value is defined between 0 and a maximum The maximum value represents the highest risk or propensity for the alert A focus is a set of selection criteria used to limit the scope of the displayed dashboard 5 1 Understanding alerts The alerts also called risk indicator scores give an evaluation value for different audit criteria applied on projects contracts beneficiaries and contractors These alerts vary between O and a predefined maximum value which represents the highest risk level The risk score of a beneficiary is the weighted average of the risk scores of its projects The risk score of a contractor is the weighted average of its contracts 5 1 1 Alerts organization For a better understandability alerts are grouped in categories represented by one categorical alert which aggregates its individual alert values On top of them the overall alert aggregates all categorical alerts into a single value Overall alert Categorical alert Categorical alert Individual alert Individual alert Individual alert Individual alert
176. ifferent addresses last year Number of different addresses in the last 3years Change date of addresses Related company 1 1 20130220 BG106588682 The following detailed information is available in the tables tab Company name Role in the project Previous address limited to 30 as a preview New address limited to 30 as a preview Number of different addresses in the last year Number of different addresses in the last 3 years 241 ARACHNE User manual Date of the change in address VAT number of the company No detailed information is available in the values tab Links to further details 4a VRATSA INVEST GRUP OOD The following links to further details are available Link to the interactive reports of the companies mentioned in the tables tab with address change 14 3 9 5 6 Name changes Description The objective of this check is to identify projects for which there is related company beneficiary project partner contractor or consortium member for which the name has changed in the past three years Level of calculation The check is performed for each beneficiary project partner contractor and consortium member Peer group Input data The following data is used to calculate the alert Orbis ID of Beneficiary Orbis ID of Project partners Orbis ID of Contractors Orbis ID of Consortium members Name of the companies Orbis Calculated data Alert value The alert gets a valu
177. ils bs Expenses The following links to further details are available Link to the expenses with a round amount 14 3 5 6 Duplicate amounts within expenses Description This check will identify expenses with duplicate amounts The objective of the alert is to identify projects for which a high amount of the total expenses is claimed via duplicate amount expenses Level of calculation The check is performed for each project Peer group Not applicable Input data The following data is used to calculate the alert Expense amount Calculated data The following data is calculated for the alert Total amount for expenses with a duplicate amount Total amount of expenses Percentage of duplicate amount expenses compared to the total amount of expenses Alert value The alert gets a value from O to 10 depending on percentage of expense amounts that are duplicate amounts compared to the total expense amounts Project score Alert value Applicable project types ESF and SME Pop up information Duplicate amounts within expenses E3 Duplicate amounts within expenses Alert Number of expenses with duplicate amounts Number of expenses 300 Amount of expenses with duplicate amount 12 801 76 Amount of total expenses 115 044 74 Percentage of expenses with duplicate amounts 11 05 The following detailed information is available in the values tab Number of expenses with duplicate mounts Total number of expenses Total amo
178. in our example the dashboard presents the top 20 highest overall scores Two kinds of columns are visible in the dashboard standard columns and alert columns You can easily identify alert columns by the fact they have vertical text in the header and the cells contain colorized LED style indicators Only when corresponding entities are used in the case management a dedicated column called case status is displayed On case managed entities an additional revised case status appears Header zone The header element contains the dashboard selection criteria i e which are the conditions used to select items to display B7 d o 0 0 o oo co o o Ex x DU E o Es 2 ea bu Name generic xs s 93 on u og 235 Project type Member state Managing Authority C 5 OSS uB 85 g3 5 ses o c 6 26 O o cuo FAKE Project supervisionl Q 30 i8Q so Q Q 30 soQ 22 Solidwaste Fakecountry Ministerie 10 9 FAKE Project SME4 e 208 0 oQ 3230 250 25 14 SME Fake country Ministerie 10 9t The table headers columns represent different entity properties which can be standard properties text amount flag and so called alert properties numerical properties within a well defined range of values 31 ARACHNE User manual E Fr y 3 3 o Zo o o 5 2 ane 2 6 60 559 28 265 25 22 5 Ze a ED Eg a EI Eo 29 2235 Name generic Casestatus
179. in the dashboard by re querying the information based on the selected alert There are two different sorting behaviors depending on the kind of column you click Sorting on alerts By clicking on a particular alert header the selection indicator red triangle will appear on the selected alert This action changes the selected alert for the whole dashboard This re executes the current selection using the selected alert for the top selection it is always sorted on descending order as it is the dashboard behavior Sorting on standard columns By clicking on the header of a standard column the sort occurs locally on the displayed record This sort operation is applied on currently displayed data no re query operation is performed in this case ai Ll Project type Projecttype Project type n n Subsequent clicks will change the ascending descending option When used a small arrow on the top of the cell indicates the current option Grouping When the grouping bar is activated using the button in the tool bar a simple column drag and drop allows the user grouping rows by the selected column Grouping can also be done on multiple columns The grouping option applies only on currently displayed data No re query operation is performed in this case 34 ARACHNE User manual Group by Overall Score X E amp E amp E B 3 eof 4 of poll seh m Blas ERI BB sbB gt g 28 28 5
180. information Use of PO box address E3 Use of PO box address Company involved Role in project Address 0 Contractor18 Contractor PO BOX 2 1 Powszechna Kasa Oszczednosci Bank Polski 54 Beneficiary Pulawska 15 00 375 WARSAW The following detailed information is available in the tables tab Name ofthe company Role in the project Address Orbis No detailed information is available in the values tab Links to further details Contractor1 a Powszechna Kasa Oszczednosci Bank Polski SA 228 ARACHNE User manual ermi The following links to further details are available Links to the interactive reports of the companies mentioned in the tables tab that have a PO Box address 14 3 9 4 Sanction 14 3 9 4 1 Involvement of individuals included in PEP lists Level of calculation Input data Calculated data Alert value Project score Applicable project types Pop up information The objective of this check is to identify projects for which there is related company beneficiary project partner contractor or consortium member for which either the company or its management is listed as PEP Politically Exposed Person in the WorldCompliance database This will include people that are in a political function or that have close contacts family member close colleague to a politician The check is performed for each beneficiary project partner a ee and consortium member Not L Not applicable
181. io representation and travel costs and project cost Average of the ratio in the peer group The following detailed information is available in the values tab Representation and travel cost Project cost Ratio of representation and travel cost compared to project cost Average ratio in the peer group No detailed information is available in the tables tab Links to further details bg Expenses The following links to further details are available Link to the representation and travel costs line items in the expenses 196 ARACHNE User manual 14 3 8 8 Supplier costs project cost Description The objective of this check is to identify projects for with the ratio of supplier cost relative to the total project cost is larger than the average ratio in the peer group Level of calculation The check is performed for each project Peer group Operational Program Input data The following data is used to calculate the alert Supplier cost Project cost Calculated data The following data is calculated for the alert Ratio supplier cost project cost Average ratio in the peer group Deviation of the ratio supplier cost project cost for the project from the average ratio in the peer group Alert value The alert gets a value from O to 10 depending on the deviation of the ratio supplier cost project cost for the project from the average ratio in the peer group Project score Alert value Applicable project ty
182. ion variable as true will have a score of 10 a contract without this variable as false will have a score of O Note that combinations between these different types of alerts are possible For example a combination of a ratio check with an absolute value check occurs frequently 114 A WIN Y nar P a at AN i Se J 14 3 2 Alert aggregations The table below provides an overview of how individual alerts are aggregated into categorical alerts and how the categorical alerts are aggregated into the overall risk alert with the highest scores with the highest scores Eligibility A score on 50 is calculated based on the average of all individual alerts A score on 50 is calculated based on the average of all individual alerts A score on 50 is calculated based on the average of all individual alerts A score on 50 is calculated based on the average of the 3 individual alerts with the highest scores Reputational amp Fraud A score on 50 is calculated based on the average of all individual alerts The overall score is the average of the scores of the categorical alerts mentioned above The risk score of a beneficiary is the weighted average of the risk scores of its projects The risk score of a contractor is the weighted average of the risk scores of its contracts 115 ARACHNE User manual 14 3 3 Procurement 14 3 3 1 Lead time between publication of the tender notice and contract signa
183. ject cost versus energy decrease in kWh year The objective of this alert is to identify projects for which the cost per kWh year is higher than the average cost in the peer group Level of calculation The check is performed for each project Peer group Input data The following data is used to calculate the alert Project cost Energy decrease KWh year Calculated data The following data is calculated for the alert Cost per kWh year project cost energy decrease Average cost per kWh year in the peer group Deviation of the cost per kWh year for project from the average cost in the peer group Alert value The alert gets a value from O to 10 depending on the deviation of the cost per kWh year project cost energy decrease for the project from the average cost in the peer group Project score Alert value Applicable project types Energy Efficiency Urban Pop up information 169 ARACHNE User manual Es Project cost Energy decrease kWh year Average of the ratio in the peer group The following detailed information is available in the values tab Energy decrease in kWh year Project cost Cost per kWh year project cost energy decrease Average cost per kWh year in the peer group No detailed information is available in the tables tab Links to further details No links to further details are available e 170 ARACHNE User manual i 14 3 7 Concentration 14 3 7 1 Beneficiarie
184. ject types Pop up information 155 i ARACHNE User manual Additional tumover as ws as submitted Ea Additional agreed tumover over submitted tumover ratio Alert Additional tumover as agreed Tumover at approval Difference additional tumover as agreed vs beneficiary s tumover at approval Average of the ratio in the peer group The following detailed information is available in the values tab Additional turnover beneficiary as agreed in the project application Turnover beneficiary when the application was approved Percentage additional turnover as agreed versus turnover when the application was approved Average percentage in the peer group No detailed information is available in the tables tab Links to further details No links to further details are available 14 3 6 8 Project total cost declared to the EC Length in km per Project Per Type of Road Description This check will return the total project cost per km for road projects The objective is to identify projects for which the cost per km is larger than the average cost in the peer group Level of calculation The check is performed for each project Peer group Same road type in the same Member State Input data The following data is used to calculate the alert Project cost Length of road in km Calculated data The following data is calculated for the alert Cost per km project cost length of road in km Average cost
185. k gt Private Company Beneficiary gt Beneficiary gt Private For projects here s the way the definition works Starting from a project the graph takes first all related companies from the Beneficiary relation From these companies the graph then takes all their related projects using the Beneficiary relation and all related companies using the Legal link relation Finally based on this result the graph takes all related persons through the Private relation thus all persons linked to companies 7 5 2 Customization In order to extend the view customization parameters allow adding multiple additional relations as a fourth path element 63 ARACHNE User manual Parameters Append neighbors Membership Private link Contract request Contract execution Related compan The parameters dialog lists available relation types that can be selected to enrich the graph You can select one or more additional relations based on the initial graph content Items can be selected using SHIFT click or CTRL click The operation is validated by clicking on the button Warning this operation can take a lot of process time or even hang the application particularly when adding affinity links on graphs containing already a lot of persons Odkanalizovanie podunajskej asti bratislavsk ho regi nu e c c gt e e e c e Odkanahizovarie JUDr Staris Paed Dh hien Ing Frantisek Mgr Restis Ing Stanislav Beno Ing
186. ked to companies through the Private relation and between each other via the Affinity relation The Group entity represents a set of companies strongly linked together via the Legal link relation see cluster groups 4 6 2 for more details Groups are linked to companies via the Membership relation and between each other via the Group legal link relation 4 5 2 Relations Relation Description Beneficiary The Beneficiary relation links projects and companies together At least one relationship must exist between a project and its beneficiary company In fact this link is not only about beneficiary but about any kind of link occurring between projects and companies Beneficiary 1 per project Contractors and subcontractors Partners Consortium members Involvement The nvolvement relation links persons to projects The link is qualified by an involvement role which can be e Contact person Financial manager Official representative Project manager Representative Expense The Expense relation is only linked to projects Each relation matches a single expense row for the related project The link is mainly qualified by the expense type and amount Contract executor The Contract executor relation links contracts to the companies executing them At least one relationship must exist between a contract and its main contractor The link is qualified by a role which can be e Beneficiary Consortium member Contractor Sub contracto
187. l links ownership in Orbis Private links directors in Orbis Calculated data The following data is calculated for the alert Path finding between entities Alert value The alert gets a value of 10 when a path is identified Project score Alert value Applicable project types Pop up information Links between beneficiaries project partners and sub contractors E3 Alert Number of paths between beneficiaries project partners and sub contractors The following detailed information is available in the values tab Number of paths that have been found between the beneficiary project partner s and sub contractor s 215 ARACHNE User manual No detailed information is available in the tables tab Links to further details Path The following links to further details are available Link to the visualization of the path s that have been found In the visualisation additional information can be added roles on the project legal links private links affinities 44 3 9 2 4 Links between contractors suppliers including consortium members Description The objective of this check is to identify projects for which there exists a path between contractors suppliers including consortium members A path is a link between several entities in the Orbis database It can be comprised of legal links between companies and private links between companies and related people A distance of 4 or less steps between two
188. le OPs Suppliers Contractors involved in multiple OPs Values Suppliers number of operational programs Suppliers max number of operational programs in a same member state Total amount of project costs of related suppliers 179 ARACHNE User manual The following detailed information is available in the values tab Number of operational programs in which the supplier contractor is involved as a supplier contractor Maximum number of operational programs in which the supplier contractor is involved as a supplier contractor within the same Member State Total accumulated cost of the projects in which the supplier contractor is involved as a supplier contractor Suppliers Contractors involved in multiple OPs E3 Suppliers Contractors involved in multiple OPs Contractor name Project name Contract name Member state PORT REAL ESTATE FAKE ProjectJink subContractor Fake links Benef sub contractor FC PORT REAL ESTATE FAKE Project 001 08 FC PORT REALESTATE FAKE Project 015 08 FC FC FC FC FC FC FC Operational program ID Alert level 5 PORT REAL ESTATE FAKE Froject 045 09 PORT REAL ESTATE FAKE Project 002 08 PORT REAL ESTATE FAKE Project 002 08 PORT REAL ESTATE FAKE Praject DU02 08 PORT REAL ESTATE FAKE Project 102 08 PORT REAL ESTATE FAKE Proiect 102 08 The following detailed information is available in the tables tab Name of the supplier contractor Projects in which the
189. le cases list screen A Filter cases enables filtering options when the cases list is displayed ARACHNE User manual Es The welcome screen of the case management is the starting point to navigate the case management There are two main functionalities in this screen e General overview This part of the welcome screen lists general information regarding the number of projects or contracts that have been assigned to a user for review and their status e Reports Using the report buttons the user is able to create open several types of reports o Number of cases by status Average throughput time Cases assignments Closing cases Open cases Cases age O O O O 9 1 6 Cases list screen The cases list screen consists of two main parts the overview pane and the filtering pane This screen is displayed when clicking on either Unassigned cases or Cases list buttons on the left Id Case title Target ty Target name Amount OverallAlertSc Status Sub sta Creati Followe E pm mann T2 T m Y A y gt yz M gt a Entity type a Case 546716 Project Ce3gaBaHe Ha YCIOBMA 3a 500 179 00 10 C3 Ongoing None 4 10 any Stat Case 546712 Project Cbz34aBaHe Ha YCIOBMHA 3a 500 179 00 10 I Opened None 4 10 us Closed Investigation Project Szkolenie dla stra ak w oc 49982 50 4 Ca Closing Revised 5 10 Revised Case 546744 Project Uen Ha npoexra Noetann 5611 77
190. light matching elements and position itself on the first match If the match is unique the focus will be set on the first matching element E Quantity of solid waste treated vs to be treated ia m Training hour cost incurred vs approved m WW cost vs population benefiting m LE WW cost vs population to benefit E Procurement O Contracted amounts via closed tenders vs project cost m Financial correction ial Lead time between publication and contract signature TT 89 A AALIAIC RAK a8 miii Es AKACGHNE User manual z 10 2 2 2 Property templates In the properties selection panel it is possible to create user defined templates which can be reused later The templates are saved into a dedicated file stored in the windows user profile The dropdown lists the different available templates To create a new template you must first click on the create template button L and enter a template name Then select the different properties you want to assign to this template and finally click on the save template button ua Templates can be changed if needed by selecting them in the list change their selected properties and click on the save template button again Templates can be deleted by selecting them then clicking on the eraser button 10 2 2 3 Property loading At this stage the user has nothing to configure This step will load the corresponding dat
191. link to sub contractor Starting from that point all related information for the sub contractor can be accessed including the interactive report contractor in which the list of related contracts and projects can be consulted 14 3 7 12 Sub contractors linked to multiple Projects of the same beneficiary Description The objective of this check is to identify projects for which there is a sub contractor that appears as a sub contractor in multiple projects but always with the same beneficiary within the same Member State Level of calculation The check is performed for each project Peer group Not applicable Input data The following data is used to calculate the alert Projects Related beneficiaries Related sub contractors Calculated data Alert value The alert gets a value of 10 when there is a sub contractor that appears as a sub contractor in multiple projects but always with the same beneficiary within the same Member State Project score Alert value Applicable project types DG Regio Infrastructure Pop up information SubContractors linked to multiple projects of the same beneficiary E3 SubContractors linked to multiple projects of the same beneficiary SubContractor s number of projects SubContractars max number of projects in a same beneficiary The following detailed information is available in the values tab Maximum number of projects in which the sub contractor is involved as a sub contractor
192. m Input data The following data is used to calculate the alert EC financial assistance Other contributions Calculated data The following data is calculated for the alert Ratio EC financial assistance other contributions Average ratio in the peer group Deviation of the ratio EC financial assistance other contribution for the project from the average ratio in the peer group Alert value The alert gets a value from O to 10 depending on the deviation of the ratio EC financial assistance other contributions for the project from the average ratio in the peer group Project score Alert value Applicable project types Pop up information Ratio of EC financial assistance vs other contributions E3 Ratio of EC financial assistance vs other contributions Alert Value EC financial assistance 4 000 140 621 02 Other contributions 5 000 00 Ratio EC financial assistance and other contributions 600 028 12 Average of the ratio in the peer group 60 079 68 The following detailed information is available in the values tab EC financial assistance amount Other contributions Ratio of EC financial assistance compared to other contributions Average ratio in the peer group No detailed information is available in the tables tab Links to further details No links to further details are available 192 ARACHNE User manual 14 3 8 4 Personnel cost project cost Description The objective of this check is to i
193. mad Hammad Zafar 35 19780805 a ohammad Mohammadi i 1 e Mr Mohammad Mohammadi Vakil Seyed 29 19840502 E CHARLES KE amp a Mr Menasche Glecer 29 19831205 a Mr Emmanuel Cuisinier 31 19820610 n j ARACHNE User manual 6 1 2 1 Search basics The element picker lists the different elements on which you can define search criteria Legal links Private links Membership links Affinity links El Overview Overview c Overview Shareholders Managers i Members Contacts Subsidiaries Companies Groups Z Contacts i Legal links Private links Memberships i Affinity links The overview item displays an overview of the selected criteria in the form criteria part as the other elements in the tree will show search criteria for the relation and the source and target entities Note searching on relations can be a long process requiring minutes to find the results depending on which criteria were used in the form 45 ARACHNE User manual ES 6 1 2 1 1 Search on legal links Criteria on shareholder and subsidiary companies are the same as the search for company form In addition direct participation and total participation can be used to search for specific links Field name Op Value Shareholders Country Within BELGIUM Subsidiaries VPI P2B Bankruptcy gt 18 Legal links Direct participation gt B Company name Company name E C Status code Country NACE Code primary
194. man H KBC GROEP KBC GROUPES KBC GROUP 4KBC GRUPPE KBC VERZEKERINGEN a CO O 3 a BC e NV gt Mr Philippe Mane Therese Gh 1 Vienck gt Mr Amaury Pelgrims De Bigard gt Mr Georges Simonard gt Mr Willem Dambre gt Mrs Liliane Caris x gt de heer Marcellinus Andreas c Mafia Baalhuis gt Dr Teodoro Gabriele Sgalmani Mr Thomas Andre Ley sem od N i NS l 1 d a e j 5 Mr B Straub i j L gt MrD Staquet Pa 7 gt Mrs Marleen Van Elewyck i ETERGYP 7 j gt Mrs Martine Focant m 229 4 History 1 elements v Search eS 50 visible nodes 30 companies 39 people 4 Sg Su x5 E E T T 3 1 Customization Customization options are available by clicking on the tools 4 button on the bottom toolbar Two links v One link v Activate legal links v Show only active functions 40 Max people nodes KJA T Q454 t Graph depth The depth can be changed between one link depth 1 or two links depth 2 The default value is one link Activate legal links Activating legal links means the indirect affinities are taken into account in the selection phase When disabled only direct affinities are used By default legal links are activated Direct affinities correspond to person gt company gt person path as indirect affinities correspond to perso
195. n gt company gt company gt person path Show active functions When this option is enabled the graph won t include the links with previous functions Only current functions will be used This option is enabled by default Max people nodes ARACHNE User manual Es In order to limit the graph size only a top strongest affinities are used in the selection process This option makes the top selection vary to include more or less people in the graph The value can vary from 10 to 100 The default value is 40 7 3 2 Specific options 7 3 2 1 Hiding elements Hiding elements works identically as in the group map 7 4 Local view The local view displays centered graph on a given company using the legal links network The view depth can be adapted using the graph customization parameters However the application provides a closed and a deep local view with different presets Local view NEFIBOUW B V 1000 100 0 ETEX NEFIBOLW B V ENGINEERING IS CAFCO INTERNATIONAL PROMAT GESELLSCHAFT i M B H 100 0 500 500 5009s 100 3 N REDCO MANASCO bw ETERGYP S And 38 other elements MAIDEN CREEK FADEMAC ETERNIT DURLOCK S A ETERNIT INC FABRICA ARGENTINA S A MANAGEMENT ARGENTINA DE HOLDING GMBH MATERIALES DE CONSTRUCCION S 4 n p a x 3h Quo E y Search a lt g 51 nodes 50 links Closed and deep local views differ by their initial parameters
196. n appear when clicking on the search button with no data entered for the selected fields in expert mode 6 1 1 5 Search results Once the search has been processed the results are displayed in the lower table Unique CE EM Company identification BvD Size Country Flag Company city number b EI ETS MARCEL LAMBERT BE0401657402 SM Small BELGIUM GOSSELIES Ki ETABLISSEMENT ALBERT ET CIE BE0401575644 BELGIUM AISEAU PRESLE Ell MARBRONIX BE0401548029 BELGIUM MONTIGNIES S I DANIELS FRANS CENTRALE VERWARMING EN SANITAIR BE0400936533 BELGIUM DONK Il ECOLE D EQUITATION LE GROENENDAEL RUITERSCHOOL BE0400652560 BELGIUM HOEILAART E EURODIA BE0400631180 BELGIUM OVERIJSE Il ALUMINIUM EN GLAZAL PRODUKTEN EN KEUKENS BE0400615938 BELGIUM RAMSDONK Eli INBOUW BELGIE BE0401896437 BELGIUM BRUSSEL EH CAISSE D ASSURANCES DE LA SOCIETE COOPERATIVE FEDERALE DE BELGIQUE BE0402197533 BELGIUM BRUXELLES a Gl ana un nere nrnansarcnen meine SRR ET m he T T 1860 element s e 43 ARACHNE User manual At that stage the following operations can be performed on the results 6 1 2 The user can navigate to other entities or relation by right clicking on items Results can be sorted by clicking on column headers Columns can be re ordered by a drag and drop operation Columns can be customized according to the user s needs refer to chapter 11 3 Items can be selected single or multiple selection for export see chapter 10
197. n done Level of calculation The check is performed for each contract Not applicable Input data The following data is used to calculate the alert Number of contract modifications Calculated data Not applicable Alert value If a contract modification has been applied then the contract gets an alert value of 10 Highest score of the contracts that belong to the project Applicable project types DG Regio Infrastructural projects Pop up information Contract modifications E3 Contract modifications Values The following detailed information is available in the values tab Number of contract modifications Contract requests The following detailed information is available in the tables tab 126 ARACHNE User manual E Name of the contractor related to the contract for which there has been a contract modification Links to further details Lu Contract requests The following links to further details are available Link to the related contract 14 3 4 6 Key experts change Level of calculation The check is performed for each contract Operational Program Description This check will check to see if key experts related to a contract have changed during the implementation of the project Input data The following data is used to calculate the alert Key expert change flag Pop up information Key experts change E3 Key experts change Key expert name Contract name Contractor name Yves L
198. n is available in the values tab Links to further details dl GET Kereskedelmi s Szolgaltat Korl tolt Felel ss g T rsas g The following links to further details are available Link to the interactive reports of the companies mentioned in the tables tab with activity change 240 ARACHNE User manual 14 3 9 5 5 Address changes Description The objective of this check is to identify projects for which there is related company beneficiary project partner contractor or consortium member for which the address has changed in the past three years Level of calculation The check is performed for each beneficiary project partner contractor and consortium member Peer group Input data The following data is used to calculate the alert Orbis ID of Beneficiary Orbis ID of Project partners Orbis ID of Contractors Orbis ID of Consortium members Address Orbis Calculated data Not applicable Alert value The alert gets a value between 3 and 5 depending on the number and timing of the changes in address during the last 3 years Project score Highest alert value of any company linked to the project beneficiary project partner contractor or consortium member Applicable project types Pop up information Company involved Role in project Previous address New address 0 VRATSA INVEST GRUP OOD Beneficiary IZTOCHNA PROM ZONA BAZA KZU P K 293 3000 VRATSA UL LUKASHOV 13 B 3000 VRATSA Number of d
199. n provides data isolation mechanisms based on user management and authentication system This isolation prevents users to see information to which they have no access i e users from one operational program cannot see information from another operational program This isolation is based on how the user groups are defined in the user management system Groups can be represented as a tree like structure OP A Data OP B Data OP C Data 21 The internal data are always related to a given operational program which is represented by a corresponding user group in the user management system This prevents users from one operational program to access data from another one As the groups represent the European Commission structure data access rights are inherited from the children to the parents in our graphical example this means that users of MA 1 can access data from OP A and OP B but won t be able to access data from OP C 4 5 Entity relationship diagram The application is based on an entity relationship diagram reflecting the real world organization between the different kinds of data available in the system This diagram is built from multiple data sources For a clear comprehension the following color code will be used mE Entities or relations containing E C Member state data also called internal data z Entities or relations containing a mix of internal and external data Entities or relations containing only ext
200. ndividuals Shortest path information between two given entities and can be enriched with extra entities and relations manually Percentage held by a shareholder in a subsidiary There are two types of participations rates direct that describes the directly linked participation and total that is the summation of direct and indirectly owned participations of a shareholder towards a subsidiary The Person entity represents either individuals or corporations The persons are linked to projects through the nvolvement relation Persons are also linked to companies through the Private relation and between each other via the Affinity relation Country the most represented in the group Activity sector the most represented in the group Number of companies in the group Number of countries in the group The Private relation links persons to companies the link is qualified by the role or position of the person into the company 110 PR Ratio Relations Related companies Related groups Shareholder Skeleton group Strong group Subsidiary Summary window Task pane Ultimate Owner VPI predictive indicators Weight The average participation rates that a group A may have as shareholder group towards another group B This is the sum of all participation rates from all shareholders of group A to subsidiaries of group B divided by the number of companies in group B Beneficiary involvement expense
201. ndow HH Shows or hides the aggregated companies table TF Shows or hides the graph overview Shows or hides company names on icons in the graph This option changes the way links are displayed in the graph Ti All links All s m WE TUENTIENE Only s il AONUI AREE Barsepsnon IX Hl Participati k Only links with participation over a given kj articipation over E threshold EXP T m OO 703 v Default weight n 270 Search This option switches the participation rates to appear on all links Display all k 7 2 Group map The group map with the hierarchical graph is the two views related to the group clustering system As the hierarchical was the inside cluster view the group map is the outside cluster view i e the relations between the clusters Please refer to the chapter 4 6 2 for more information about the cluster groups and how they work 55 ARACHNE User manual Group Group view ETEX Std SA FINANCIER ETERNIT kw EURONATEACHADAS Y USIERTAS SL Sid NGS GESELLSCHAFT KG Sid SCOTTISH WIDOWS FUND AND LIFE ASSURANCE SOCIETY Sid LICHTENSTEINER BRAND SCHUTZGLAS VERWALTUNGS GMBH Sx UNE wan Rar S S ui TEGRAL HOWDINGS LIMITED Sud porx N ETEXORYC SA Std 750 MAE e EN get x C N SINIAT S e _ M uen MINERALES Y PROQUETOS DERIVADOS Sh esf 063 a MERILUX SARL Sid EH a p UU S000 amp a P
202. net connection that allows application to connect through HTTPS protocol A screen resolution of at least 1680 x 1050 use higher resolution for better user experience Note that the application is expected to be compatible with Windows 8 Windows 8 1 and all releases of Windows Server versions as from Windows Server 2003 tests will be performed in the next coming weeks This application runs on 32 and 64 bit platforms 3 1 2 Running the client application The application can be started either by the desktop icon ARACHNE Client or the startup menu into Vadis s a gt GET Client application ARACHNE Client oe ARACHNE User manual L EP 5 File 1 Entities n Relations Dashboards lt gt Case management Parameters Windows Help Welcome window X jb fakeusest Current cases n 9 Connect Id numeric Case title Casetype Casetarget name Amount Case status Casesub status Creation date Follower SX Your current profile 247 Case 2 FAKE project 3 8 Project FAKE Project 003 08 35 900 080 00 Unassigned None 30 12 2013 11 32 14 Case management Alert statistics Op program ident a Op program ident Average of Overall Score Average of CM Revised Occurences of Overall Occurences of CM Score 38 Revised score 38 9999XA999XX001 13 00 0 0 no element click on any eleme
203. new criterion you will have to Select a property Select an operator Optionally type in a value for the selected property Picking a property is done on the first drop down control Note that for the first line the drop down will only show a limited set of properties called indexed properties Queries on indexed properties perform better than queries on non indexed properties Search for Projects gs Once the property has been picked you must select an operator Operators differ depending on the property type 98 Search for Projects v Select oper Operators on numerical values are equality and order operators lt lt gt gt as well as the undefined operator Operators on text values are The equality operator which defines an exact match The content Contains operator which searches given words into the property Undefined operator Operators on enumerated values are The equality operator The multiple equality operator Within list This second option is more interesting as multiple choices can be done directly After the operator has been selected an extra field to enter the value will appear except for the undefined operator which requires no value Search for Projects w gt 0 0015 EY L The value field will differ depending on the property type Text values will use text box numerical values will use a numeric value box and enumerated values
204. ng links to further details are available Link to the visualization of the path s that have been found In the visualisation additional information can be added roles on the project legal links private links affinities 14 3 9 2 6 Directors shareholders with high number of mandates Description The objective of this check is to identify projects for which there is related company beneficiary project partner contractor or consortium member that has a director shareholder with a high number of mandates Level of calculation The check is performed for each beneficiary project partner contractor or consortium member Peer group Input data The following data is used to calculate the alert Orbis ID of Beneficiary Orbis ID of Project partners Orbis ID of Contractors Orbis ID of Consortium members Private links directors in Orbis Number of private links per director shareholder of mandates of the directors shareholder Project score Highest alert value of any company linked to the project beneficiary project partner contractor or consortium member Applicable project types 218 ARACHNE User manual E Pop up information Directors shareholders with high number of mandates EJ Directors shareholders with high number of mandates Company involved Role in project Mame of the director shareholder with high number of mandates Number of mandates per UPI 0 BISNODE BELGIUM HOLDING Contrac
205. nges nba of a Grouping shows or hides the grouping panel on the top of the dashboard table see chapter 5 6 4 5 6 2 Varying the number of visible records on the dashboard By using the dedicated toolbar button the number of items present in the dashboard can be changed according to the user s needs 32 ARACHNE User manual l 3j E E ff den y dn TE 88 By default this value is set to 20 It can be set up to 200 items Warning incrementing this value will impact the performance of the system 5 6 3 Expanding and collapsing categorical alerts When you left click on an alert category column which is not active the alert category becomes active and the dashboard is refreshed according to the new alert E Alert selection Expand Collapse indicator indicator Concentration Overall Score Alert category name The symbol on the top right corner of the cell defines which categorized alert is expanded or collapsed Expanding or collapsing categorical alerts can be done with a Shift Click on the header cell The same option can be achieved via the context menu on the alert category cells by clicking the right mouse button in the header of the column a E E ae ieee B3 SEE 202 2295 82 jm 28 ufi 28 zu cmi E R ETES aeae SES 8 582 52 ES Blegfess r alege SaS EZE gt JE 5B a rct om F OF jEZ nsossHEgz amp RjEvuP Eo9guru i2UmsE LB
206. nkruptcy gt 1 VPI P2B Sold Top 20 gt 1 VPI EDV Min k gt VPI EDV Max k lt Top 10 by v E Top 10 by v EH Gear Search Cear When in advanced mode additional criteria are available They are displayed in bold to identify them easily Advanced criteria are predefined and cannot be changed For fully customizable selections please refer to the chapter 12 1 about expert search mode Forms contain a Clear button which resets all fields with an empty or default value 6 1 1 3 Top selection In addition to the search criteria the search forms offer the possibility to use a single property as sort criteria and then use it to limit the amount of records returned This is called the top selection 41 ARACHNE User manual ki i Bw ogr das This option can be really useful when the search criteria are vague enough to return a wide range of elements By using the top selection you can reduce the amount of returned records thus the speed of the response and perform a more accurate search if the top property is well chosen When enabling the top selection you will have to provide the number of returned records the property used for sorting results and the sort direction The top selection is done based on selected criteria Top 10 by Type Ti ur E Unique identification number S VAT Number E C en VPI Scored Ed Financial data
207. nt activities Company involved Hole in project List of activities Number of sector activities PORT REAL ESTATE Contractor 52 MOLENBERGNATIE Beneficiary 52 The following detailed information is available in the tables tab Company name Role in the project Sector code of activities Number of activities No detailed information is available in the values tab Links to further details P MOLENBERGNATIE X PORT REAL ESTATE The following links to further details are available ARACHNE User manual E Link to the interactive report of the companies mentioned in the tables tab with an elevated risk level 14 3 9 3 6 Use of PO box address Description The objective of this check is to identify projects for which there is related company beneficiary project partner contractor or consortium member that has a PO Box address Level of calculation The check is performed for each beneficiary project partner contractor and consortium member Peer group Input data The following data is used to calculate the alert Orbis ID of Beneficiary Orbis ID of Project partners Orbis ID of Contractors Orbis ID of Consortium members Address Orbis Calculated data Not applicable Alert value The alert gets a value of 5 when the address is a PO Box Project score Highest alert value of any company linked to the project beneficiary project partner contractor or consortium member Applicable project types Pop up
208. nt to see details Global average Overall Score 14 00 CM Revised score Dashboard summaries Projects global Beneficiaries global ER Fr e a N d 3 z a Name generic Casestatus E 8 Project type Member state Managing Authority Op Name generic EE Total grants amount E C Type VAT Number E C Country E on i FAKE Project supervision1 Q 34 Solid waste Fake country Ministerie 10 VADIS CONSULTING 24 50 041 00 Private 0475080462 BELGIU FAKE Project ExtProv RE Qo Q 34 Solid waste Fake country Ministerie 11 DRAPANTEX Q 22 241 014 678 00 Private 0412035016 BELGIU FAKE Project 003 08 Unassigned 33 Energy eff Urban Fake country Ministerie 1 a en 22 933 088 96 Unknown 5250008815 POLAND FAKE Project 024 09 s e e 32 EE Fake country ius 3 ILOMAR AGENCIES 20 4 043 770 510 30 Public 0444190813 BELGIU FAKE Project link subContractor 30 R Fake country Ministerie 3 T MOBILE MAGYARORSZAG TAVKOZLESI FAKE Project sanction03 Z Q le so Fake Ministerio 6 RESZVENYTARSASAG 20 4 567 00 Private 110042361 HUNG FAKE Project 407 08 3 Unassigned OD 28 ESF Fake country Ministerie 58 999 HEALTH STUDIO ET SERVICE CENTRE 18 497 085 749 06 Public 0412656212 BELGIUN FAKE Project 003 08 D Q 21 Energy eff Urban Fake country Ministerie 1 999 MOLENBERGNATIE Q 17 79 227 509 50 Public 0404785354 BELGIUN EAMT Deis ca DAEINN sna Dan Pt R Pee a noni LIDELL INTERNATIONAL i 16 41 QAS 270 92 Private 417640472
209. of key experts in multiple projects The following detailed information is available in the values tab Number of projects in which the key expert is involved Number of key experts that are involved in multiple projects Key experts linked to multiple projects E3 Key experts linked to multiple projects Project name FAKE Project 031 10 FAKE Praject D45 08 FAKE Praject 045 08 The following detailed information is available in the tables tab Names of the different projects 128 i ARACHNE User manual Name of the key expert that is involved in the different projects Links to further details Contract requests E Details The following links to further details are available Link to the contract related to the current project in which the key expert generating the alert value is involved Details link leads to the project s in which the key expert is involved 14 3 4 8 High percentage of cost allocations during the last 60 days before Project end date Description This check will look for a high percentage of costs being booked Level of calculation Peer group Input data The following data is used to calculate the alert Project costs based on individual expenses sourced Date of the project cost Project end date Calculated data The following data is calculated for the alert Total project cost Project costs during the last 60 days before the project end date Percentage of proje
210. of the projects in which the project partner is involved as project partner and that belong to different operational programs within the same Member State Partners involved in multiple OPs E3 Partners involved in multiple OPs Project partner name Project name Member state Operational program ID Project cost MOLENBERGNATIE FAKE Project 011 08 53959XA399X X001 1 110 004 00 MOLENBERGNMATIE FAKE Praject 012 08 39839XA939X X001 187 000 000 00 MOLENBERGNMATIE FAKE Praject 02 7 08 3899XA399x X001 261 241 84 t 3939XA399XXD01 255 053 84 PLL FA rr a erie Sr An nsn Peri 175 ARACHNE User manual The following detailed information is available in the tables tab Name of project partner Project names of the projects belonging to different operational programs in the same Member State and in which the project partner is involved as project partner limited to 30 as a preview Member State of the projects mentioned above Operational program of the projects mentioned above Project cost of the projects mentioned above Links to further details A Related companies The following links to further details are available Link to the project partner Starting from this link the user can further navigate to the projects in which the project partner is involved 14 3 7 5 Suppliers contractors involved in multiple Projects Description The objective of this check is to identify projects for which there is
211. of the ratio other cost project cost for the project from the average ratio in the peer group Alert value The alert gets a value from O to 10 depending on the deviation of the ratio other cost project cost for the project from the average ratio in the peer group Project score Alert value Applicable project types Pop up information Other costs vs project cost E3 Other costs vs project cost Values Alert Value Other costs 107 899 05 Project cost 877 286 50 Ratio other and project costs Average of the ratio in the peer group The following detailed information is available in the values tab Other cost Project cost Ratio of other cost compared to project cost Average ratio in the peer group No detailed information is available in the tables tab Links to further details n Expenses The following links to further details are available Link to the other costs line items in the expenses 200 ARACHNE User manual 14 3 8 12 Exceptional costs project cost Description The objective of this check is to identify projects for with the ratio of exceptional cost relative to the total project cost is larger than the average ratio in the peer group Level of calculation The check is performed for each project Peer group Operational Program Input data The following data is used to calculate the alert Exceptional cost Project cost Calculated data The following data is calculated for the ale
212. oject partners Orbis ID of Contractors Orbis ID of Consortium members Private links of the companies management Orbis Calculated data The following data is calculated for the alert Links between Orbis data and World Compliance Quality of the link Alert value The alert gets a value from O to 10 depending on the quality of the match between the Orbis entity and the entity in World Compliance The quality of the match depends on the number of elements Quality of the name match exactly the same or similar Additional match on address or not Additional match on birthdate or not Frequency of appearance of the name in the database Highest alert value of any company linked to the project beneficiary project partner contractor or consortium member Applicable project types PAN Pop up information Involvement in sanction lists Ea Involvement in sanction lists Company involved Role in project Person ID Is included in sanction lists NORDIK LIMITED EOOD Beneficiary Entity matched as sanction listed with a quality score of 0 5 ROKMAN EOD Contractor Entity matched as sanction listed with a quality score of 0 5 KONSTANTIN VELYOV KIS 99 ET Sub contractor Entity not matched as sanction listed The following detailed information is available in the tables tab Name of the company Role in the project 231 ARACHNE User manual Ed Name of the related individual when applicable Type of match between Orbi
213. oject row can be expanded to explore the alert values relative to its beneficiary and contractors In the sub table only categorical alerts are visible 28 ARACHNE User manual 5 3 Contracts dashboard The contracts dashboard focuses on contracts and the linked contractors 2008 03 01 5 13 Contractl21 3249 17 Contract 2005 01 01 Contracts global CM Revised score Overall Alert Procurement Overall Score Contract Management Overall Score Eligibility Overall Score Concentration Overall Score Reputation al Fraud Alerts Overall Score 5 4 Beneficiaries dashboard The beneficiaries dashboard focuses on the project beneficiaries and their respective projects By expanding the row you can directly see beneficiaries involved in multiple projects Beneficiaries global Project count as beneficiary gt 0 Con Fact Management Eligibility Overall Score Other Overall Fraud Alerts Overall Score Overall Alert Procurement Overall Score Overall Score Performance Overall Score Concentration Overall Score Reputational VADIS CONSULTING a z Q 30 ssQ DRAPANTEX sop 31 10090 241 014 78 00 Private Przemyslowy Instytut Automatyki i Pomiarow PIAP D D u D 50 333 088 96 Unkne 50 041 00 Private Name generic CM Revised score y Overall Overall Eligibilit FAKE Project 004 08 FAKE Project 005 08 FAKE Project 005 10 FAKE Project 006 08 FAK
214. ollowing data is used to calculate the alert Cost relating to the water supply plant component of the project Population equivalent to benefit from the water supply network as agreed in the project application Calculated data The following data is calculated for the alert Cost per population equivalent cost relating to the water supply plant component of the project population equivalent to benefit from the water supply network Average cost per population equivalent in the peer group Deviation of the average cost per population equivalent for the project from the average cost in the peer group Alert value The alert gets a value from O to 10 depending on the deviation of the average cost per population equivalent cost relating to the water supply plant component of the project population equivalent to benefit from the water supply network for the project from the average cost per population equivalent in the peer group Pop up information Water supply cost vs population to benefit Ea Water supply cost vs population to benefit Alert Value Population to be served by water supply network 50 00 Cost relating to the water supply component 9 861 78 Ratio Water supply cost and population benefiting at approval 197 24 Average ratio in the peer group 103 29 The following detailed information is available in the values tab Population equivalent to benefit from the water supply network as agreed in the
215. ompany in which the director shareholder has an involvement Risk level of the country No detailed information is available in the values tab Links to further details 223 ARACHNE User manual d Mullertauttenbrunn Hullad kanyag Keresked s Feldolgoz Kit i Mr Danny Vincenzo Steriti The following links to further details are available Link to the interactive report of the company that has a role in the project Link to the interactive report of the related director shareholder where his involvements are mentioned 44 3 9 3 3 Incorporation in sensitive regions Description The objective of this check is to identify projects for which there is related company beneficiary project partner contractor or consortium member that is registered in a sensitive region The list of sensitive regions is based on official lists of tax havens and regions sensitive to corruption Level of calculation The check is performed for each beneficiary project partner contractor and consortium member Not applicable Input data The following data is used to calculate the alert Orbis ID of Beneficiary Orbis ID of Project partners Orbis ID of Contractors Orbis ID of Consortium members Countries of companies Calculated data Not applicable the country in which the related company is registered Project score Highest alert value of any company linked to the project beneficiary project partner contractor or cons
216. on see chapter 5 for detailed information about dashboards Columns cannot be customized in the mini dashboards Dashboard summaries Projects global Beneficiaries global Tm e a Em SS Name generic Case status 8 8 Project type Member state Managing Authority Op Name generic EE Total grants amount E C Type VAT Number E C Country 7 TIL 59 E FAKE Project supervision1 34 Solid waste Fake country Ministerie 10 VADIS CONSULTING As 50 041 00 Poe 0475080462 BELGIU FAKE Project ExtProv Q 34 Solid waste Fake country Ministerie 11 DRAPANTEX E Qe 22 241 014 678 00 Private 0412035016 BELGIU FAKE Project 003 08 Unassigned 33 Energy eff Urban Fake country Ministerie 1 7 owe ne i Eoma 22 933 088 96 Unknown 5250008815 POLAND FAKE Project 024 09 s Q 32 ESF Fake country Ministerie 3 ILOMAR AGENCIES 20 4 043 770 510 30 Public 0444190813 BELGIU FAKE Project link subContractor Q 30 Road Fake country Ministerie 3 T MOBILE MAGYARORSZ G T VK ZL SI pm i z FAKE Project sanction03 e e sj Fake country Ministerie 6 T R SZV NYT RSAS G wen paad hana re FAKE Project 407 08 33 Unassigned 28 ESF Fake country Ministerie 58 999 HEALTH STUDIO ET SERVICE CENTRE 18 497 085 749 06 Public 0412656212 BELGIUN FAKE Project 003 08 Q 21 Energy eff Urban Fake country Ministerie 1 999 MOLENBERGNATIE 17 79 227 5
217. on equivalent cost relating to the waste water treatment component of the project population equivalent benefiting from the waste water treatment Average cost per population equivalent in the peer group Deviation of the average cost per population equivalent for the project from the average cost in the peer group Alert value The alert gets a value from O to 10 depending on the deviation of the average cost per population equivalent cost relating to the waste water treatment component of the project population equivalent benefiting from the waste water treatment for the project from the average cost per population equivalent in the peer group Alert value Applicable project types Waste water or supply Pop up information WW cost vs population benefiting Ea Values Value Population benefiting to the treatment actual 400 00 Waste water treatment component cost 970 654 00 Ratio Water Waste cost and population benefiting to the treatment actual 2 301 64 Average ratio in the peer group 550 46 The following detailed information is available in the values tab Population equivalent benefiting from the waste water treatment actual latest available information Costrelating to the waste water treatment component of the project 163 ARACHNE User manual Ea Cost per population equivalent cost relating to the waste water treatment component of the project population equivalent benefiting from
218. on is based on client server architecture it requires user authentication to connect to the server The default user authentication is done through the standard ECAS authentication service in place at the European Commission When the application starts the ECAS login screen will ask you your ECAS user and password Contact Privacy Statement English en v EUROPEAN COMMISSION AUTHENTICATION SERVICE ECAS E a European Commission IntraComm gt Authentication Service gt Login 4 Logout Change password Account information Help European Commission Log i N Not registered yet CREME AM Be OO authenticates your identity on European Username or e mail address Commission websites Password p More options Nee Lost your password Required fields Last update 17 10 2013 3 5 2 m 28 ms 4 Top Remark Check if the selected domain for which you have an account is correct e f you work with an EC account the European Commission domain should be active e f you work with an external account the External domain should be active N 6 A A fr NIE E E ARACHNE User manual AINA TINGE VOC HIGhHuUdti T You can change the domain by clicking the Change it option Login Not registered yet Username or e mail address Password Where you can select the correct domain EUROPEAN COMMISSION AUTHENTICATION SERVICE ECAS Commission European Commission
219. on predictive modeling These indicators are considered to be external data as well See chapter 14 2 about Vadis Predictive Indicators All these sources are bound and processed together in a single database to allow the application to browse search and perform advanced operations 4 2 Data refresh 4 2 1 Weekly schedule and data refresh cycle The following weekly schedule for data refreshes has been decided The Member States are able to upload new data on SFC 2007 until each Monday 2pm for a release run the current week After that time files will not be lost but used for the release of the following week The data validation enrichment and risk calculation processes are running as of Monday 2pm and the results will be available in Arachne as of Friday morning The refresh of the Orbis database will be done quarterly every three months The refresh is planned in the third week of January April July and October In exceptional cases this refresh might be delayed by a few weeks As WorldCompliance data is related to Orbis the refresh cycle of WorldCompliance is synchronized with the refresh cycle of Orbis PEP Politically exposed persons 20 ARACHNE User manual Es All amounts in Arachne are expressed in Euro Amounts provided by the Managing Authorities in local currency will be converted to EUR when the data is uploaded in Arachne Monday 2PM The currency rate which will be used is the currency rate which is
220. oned by a source Annual Report Private Communication or Information Provider as being the Ultimate Owner of another company even when its shareholders are not mentioned Any company with a known recorded shareholder none of which with an ownership percentage direct total or calculated total over 5096 but having one or more shareholders with an ownership percentage above 25 Companies with 6 or more identified shareholders Also attributed to B companies in which the summation of direct ownership percentages all categories of shareholders included is higher than 5096 As above but includes companies with 4 or 5 identified shareholders As above but includes companies with 1 to 3 identified shareholders Any company with a recorded shareholder excluding the 3 collective types mentioned above with a total or a calculated total ownership over 50 Also given to a company when a source indicates that the company has an ultimate owner even though its percentage of ownership is unknown Attributed to C companies in which the summation of direct ownership percentage all categories of shareholders included is higher than 50 Any company with a recorded shareholder with a direct ownership of over 50 Unknown degree of independence GET Groups Tool originally created to provide data exploration tools for the business built on Exploration Bureau Van Dijk worldwide data service Orbis database It includes a wide range
221. ontractor VAT number through a structure check The objective is to identify projects for which the VAT number of any of the contractors does not comply with the VAT structure requirements as mentioned on the VIES website of the European Commission Level of calculation The check is performed for each project Not applicable Input data The following data is used to calculate the alert VAT number of the contractor Calculated data Not applicable Alert value The alert gets a value of 10 when the VAT number of one of the contractors related to the project does not meet the structural requirements as mentioned on the VIES website of the European Commission Project score Alert value Applicable project types DG Regio Infrastructure Pop up information 144 ARACHNE User manual Contractors with invalid VAT number Infrastructural E3 Contractors with invalid VAT number Infrastructural Tables Contractor name VAT Number of the contractor Country code of the contractor SADE Magyarorsz g M ly pit Kft 11097875 2 43 SADE Magyarorsz g M ly pit Kit 1 Kultur lis Or amp ks gv delmi Szakszolg lat 15327868 2 41 SADE Magyarorsz g M ly pit Kit 1097875 2 43 Pali Gabor 65012057 2 41 Cs ffai Janos 71434463 3 24 The following detailed information is available in the tables tab Name of the contractors limited to 30 as a preview VAT number of the contractors Country code of the cont
222. ore Alert value Applicable project types DG Regio Infrastructure Pop up information SubContractors linked to multiple projects E3 SubContractors linked to multiple projects Values Alert SubContractors max number of projects in a same member state SubContractor s number of projects The following detailed information is available in the values tab Maximum number of projects in which the sub contractor is involved as a sub contractor within the same Member State Number of projects in which the sub contractor is involved as a sub contractor SubContractors linked to multiple projects E3 SubContractors linked to multiple projects SubContractor name Project name Contract name Alert level Project cost Contract cost 0 BISNODE BELGIUM HOLDING FAKE Project4ink subContractor Fake links Benef sub contractor 10 453 8400 1 256 405 53 1 BISNODE BELGIUM HOLDING FAKE Project 102 08 Contract 202 10 1 921 933 81 568 036 78 The following detailed information is available in the tables tab Name of the sub contractor Projects in which the sub contractor is involved as a sub contractor limited to 30 as a preview 185 ARACHNE User manual Name of the contracts through the sub contractor is linked with the projects Alert value for the sub contractor Project amount Contract amount Links to further details a Related companies The following links to further details are available A
223. orrection has been applied to the beneficiary in the past No detailed information is available in the tables tab Links to further details No links to further details are available 121 ARACHNE User manual 14 3 4 Contract management 14 3 4 1 Contract Addenda Cost total for the Project Project Cost Description This check will compares the contract addenda costs for a project with the total project cost The objective is to identify projects for which the contract addenda cost part exceeds the average percentage in the peer group Level of calculation The check is performed for each project Sector Operational Program Project type Input data The following data is used to calculate the alert Contract addenda cost for all contracts related to the project Project cost Calculated data The following data is calculated for the alert Percentage of contract addenda cost compared to the total project cost Average percentage in the peer group Deviation of the percentage of contract addenda costs for the project from the average percentage in the peer group Alert value The alert gets a value from O to 10 depending on the deviation of the percentage for the project form the percentage in the peer group Pop up information Contract addenda cost vs project cost Ea Contract addenda cost vs project cost Alert Value Addenda costs 87 658 31 Project cost 886 132 00 Ratio addenda and project costs 0 10 A
224. ortium member but always for the same beneficiary within the same Member State Alert value Applicable project types DG Regio Infrastructure 183 ARACHNE User manual E Pop up information Consortium partners involved in multiple projects of the same beneficiary E3 Consortium partners involved in multiple projects of the same beneficiary Consortium partners number of projects max of the same beneficiary Consortium partner s number of projects Total amount of praject costs of the related consortium partner 2 752 183 12 The following detailed information is available in the values tab Maximum number of projects in which the consortium member is involved as a consortium member within the same Member State and with the same beneficiary Number of projects in which the consortium member is involved as a consortium member Total accumulated cost of the projects in which the consortium member is involved as a consortium member Consortium partners involved in multiple projects of the same beneficiary Consortium partners involved in multiple projects of the same beneficiary Consortium member name Project name Contract name Beneficiary name THE BELGIAM CHOCOLATE GROUP FAKE Project 031 10 Contract31 HEALTH STUDIO ET SERVICE CENTRE THE BELGIAN CHOCOLATE GROUP FAKE Project 045 08 Contract18 HEALTH STUDIO ET SERVICE CENTRE THE BELGIAN CHOCOLATE GROUP FAKE Project 045 08 Fake Wrong VAT HEALTH STUDIO ET SERV
225. ortium member Applicable project types Pop up information Incorporation in sensitive regions E ERE RA Company involved Role in project Country Risk level of the country SANS SOUCI sro Beneficiary CZECH REPUBLIC EVD PECE spol s r o Contractor CZECH REPUBLIC CS PLUS LUC Contractor UNITED ARAB EMIRATES The following detailed information is available in the tables tab Company name Role in the project Country of the company 224 ARACHNE User manual Risk level of the country of the company No detailed information is available in the values tab Links to further details El cs PLUS LLC The following links to further details are available Link to the interactive report of the companies mentioned in the tables tab with an elevated risk level 44 3 9 3 4 Group involvement in sensitive regions Description The objective of this check is to identify projects for which there is related company beneficiary project partner contractor or consortium member that has companies in its group that are registered in a sensitive region The list of sensitive regions is based on official lists of tax havens and regions sensitive to corruption The group are companies that are linked to the company through direct or indirect ownership links Level of calculation The check is performed for each beneficiary project partner contractor and consortium member Peer group Input data The following data is use
226. ovided as agreed Number of hours of training provided Project costs actual Project costs as agreed The following detailed information is available in the values tab Hours of training to be provided Hours of training provided Actual project costs sum of expenses Project cost No detailed information is available in the tables tab Links to further details No links to further details are available 14 3 6 4 Number of additional personnel after the Project is finished latest available information Number of additional personnel of the beneficiary to be employed as agreed in the Project Description This check will compare the number of staff when the project is finished and the number of staff to be employed as agreed in the contract and defines this as the realization rate The objective of the alert is to identify projects for which the realization rate is lower than the average realization rate in the peer group Level of calculation The check is performed for each project Sector Operational Program Project type Input data The following data is used to calculate the alert Additional personnel after the project is finished latest available information Additional personnel target as agreed in the project Calculated data The following data is calculated for the alert Realization rate additional personnel after the project is finished additional personnel as agreed Average realization r
227. partner contractor and consortium member Peer group Input data The following data is used to calculate the alert Orbis ID of Beneficiary Orbis ID of Project partners Orbis ID of Contractors Orbis ID of Consortium members Private links Orbis Change date of private links Orbis Calculated data Alert value The alert gets a value between 3 and 10 depending on the number and timing of the changes in directors during the last 3 years Project score Highest alert value of any company linked to the project beneficiary project partner contractor or consortium member Applicable project types Pop up information High rotation of directors 3 High rotation of directors Tables Company involved Role in project Changed directors names Nb changes of director last year Nb changes of director last 3years Change dates of directors Change status Related company 0 OPUS Ingatlanszolg ltat s Kivitelez Kit Beneficiary Mrs Gyula Babus 2 4 20130717 New HU10712740 1 OPUS Ingatlanszolg ltat s Kivitelez Kit Beneficiary Mrs Jacint Kendli 2 4 20130220 New HU10712740 2 OPUS Ingatlanszolg ltat s Kivitelez Kit Beneficiary Mrs Bela Misnyovszki 2 4 20121011 Previous HU10712740 3 OPUS Ingatlanszolg ltat s Kivitelez Kft Beneficiary Mr Ervin Klem 2 4 20120316 New HU10712740 The following detailed information is available in the tables tab Name of the company Role in the project 238
228. pboard Interactive report Printable report Beneficiaries Partners Contracts Involvements Expenses Payments Pe y Imm Surroundings graph From a detailed screen relating to a project or contract by selecting the New case button 83 ARACHNE User manual Case management Status 2 Sub status Regardless of the starting point the following case creation screen is displayed Case FAKE Project 011 08 Case title Title field is required Case type Project oasis tant eee FAKE Project D1 1 08 Supervisor Roottest2 Roottest2 Follower Case status a Description x Description field is required gt Remaining characters 3000 Add case Cancel The case name project or contract name the case type Project and Contract and the supervisor the user that creates the case are entered automatically The user can provide a title for the case assign a specific user only available when the current user is a supervisor that is responsible for the follow up and change the case status only available when the current user is a supervisor A description text box is foreseen to provide specific instructions for the reviewer Once the case creation is complete the case will appear in the case overview screen 9 1 9 Updating a case Reviewing cases can be done only by followers or supervisors When opening the case details screen case status and sub status can be changed Case title Test case demo Vadis Description Ca
229. pes Pop up information Supplier cost vs project cost E3 Supplier costs vs project cost Alert Value Supplier costs 13 832 31 Project cost 318 781 00 Ratio supplier and project costs 0 04 Average of the ratio in the peer group 0 02 The following detailed information is available in the values tab Supplier cost Project cost Ratio of supplier cost compared to project cost Average ratio in the peer group No detailed information is available in the tables tab Links to further details n Expenses The following links to further details are available Link to the supplier costs line items in the expenses ARACHNE User manual 14 3 8 9 Seminars publishing costs project cost Description The objective of this check is to identify projects for with the ratio of seminars publishing cost relative to the total project cost is larger than the average ratio in the peer group Level of calculation The check is performed for each project Peer group Operational Program Input data The following data is used to calculate the alert Seminars publishing cost Project cost Calculated data The following data is calculated for the alert Ratio seminars publishing cost project cost Average ratio in the peer group Deviation of the ratio seminars publishing cost project cost for the project from the average ratio in the peer group Alert value The alert gets a value from O to 10 depending on the deviation of t
230. point to another without leaving the window In parallel to this navigation the graph keeps a history of the different entry points 56 ARACHNE User manual 0 ETEA Std 1 HBRECEM HOLDIMG AG Std v 2 SWISSPOR HOLDING A Inv History 3 elements Search Using the back forward arrows or the history list allows you to quickly go back to a previous view 7 2 2 2 Hiding elements To facilitate the user s work this graph gives the possibility to remove groups from the view by selecting them and pressing the delete Del key Before After Group Group view SWISSPOR HOLDING AG Inv Group Group view SWISSPOR HOLDING AG Inv Si Sor DING AG FIBREC EMFOLDING AG Std FIBRECEM HOLDING AG Std Once some groups have been hidden the eye icon on the toolbar becomes enabled indicating some hidden nodes can be shown on the graph By clicking on this button hidden groups will reappear in the window T 3 Affinity graph The affinity graph displays the relationships between people through companies This graph is based on a first node selection through the Affinity relation to select all related people for a given person Once this selection is done it includes all common related companies For more explanation about affinities please refer to chapter 4 6 3 In the end the graph displays persons companies and the links between them 57 ARACHNE User manual Affinity graph Mr Jean Prosper Pierre Beeck
231. project application Cost relating to the water supply plant component of the project 166 ARACHNE User manual E Cost per population equivalent cost relating to the water supply plant component of the project population equivalent to benefit from the water supply network Average cost per population equivalent in the peer group No detailed information is available in the tables tab Links to further details No links to further details are available 14 3 6 16 Cost relating to the Water supply network component of the Project Length of water supply network to be renovated constructed in kms Description This check will return the cost related to the water supply network component per km of renovated or constructed water supply network The objective of the alert is to identify projects for which the cost per km is higher than the average cost in the peer group Level of calculation The check is performed for each project Input data The following data is used to calculate the alert Cost relating to the water supply network component Length of water supply network to be renovated constructed in km Calculated data The following data is calculated for the alert Cost per km cost relating to the water supply network component length of water supply network to be renovated constructed in km Average cost per km in the peer group Deviation of the cost per km for the project from the average cost per km in
232. published by DG BUDG in the beginning of each month see http ec europa eu budget contracts grants info contracts inforeuro inforeuro en cfm 4 2 2 New data deliveries impact Alerts are computed on different levels For instance many of them depend on ratio deviation related to peer groups Hence it is possible to see that alert values differ from one data delivery to another due to the following reasons Another Operational Program or Member State has provided new data and peer group thresholds have changed peer groups are not always based on Operational Programs but also on sector project type or country Currency rates updates can have an impact on thresholds or values The matching between the given company Beneficiary Contractor or SubContractor and an Orbis company has changed because of updated info Orbis or WorldCompliance refresh and thresholds or values may have change 4 3 Data licensing All external data is subject to a limited usage license Because of this license which works with a maximum number of concurrent users seats it may happen that the licensing system doesn t allow the current user to see external data This lack of visibility doesn t prevent the application from running correctly but all external data won t be visible until a seat becomes available Please refer to chapter 12 5 for more information about the licensing system 4 4 Authentication and data isolation The Arachne applicatio
233. r Project partner Contract requestor The Contract requestor relation links contracts to the projects requesting them This is an unqualified link Sub contract requestor The Sub contract requestor relation links contracts together in a directed manner This is an unqualified link Legal link The Legal link relation links companies together in a directed manner symbolizing the ownership of one company by another This link is qualified by the participation rate percentage Private The Private relation links persons to companies the link is qualified by the role or position of the person into the company Membership The Membership relation links companies to their group s One company may be linked to no group one group or two groups In this latest case one group is qualified as the standard group and the second one as the investment group Affinity The Affinity relation links person together See more details in the dedicated chapter 4 6 3 Group legal link The Group legal link relation links groups together by aggregating legal links between companies of those groups 4 6 External data The goal of this chapter is to present the different concepts found in the external data 4 6 1 Companies and legal links Companies and legal links are provided by an external data provider which collects public data about them on a worldwide scale The information related to companies is mostly financial and based on officially publish
234. r details a Expenses The following links to further details are available Link to the fixed assets costs line items in the expenses 194 ARACHNE User manual 14 3 8 6 Administrative costs project cost Description The objective of this check is to identify projects for with the ratio of administrative cost relative to the total project cost is larger than the average ratio in the peer group Level of calculation The check is performed for each project Peer group Operational Program Input data The following data is used to calculate the alert Administrative cost Project cost Calculated data The following data is calculated for the alert Ratio administrative cost project cost Average ratio in the peer group Deviation of the ratio administrative cost project cost for the project from the average ratio in the peer group Alert value The alert gets a value from O to 10 depending on the deviation of the ratio administrative cost project cost for the project from the average ratio in the peer group Project score Alert value Applicable project types Pop up information Administration cost vs project cost E3 Administration cost over project cost ratio Alert Ratio administrative and project costs Average of the ratio in the peer group The following detailed information is available in the values tab Administrative cost Project cost Ratio of administrative cost compared to proj
235. r that appears together with the same works contractor in other contracts within the same Member State Level of calculation The check is performed for each project Peer group Not applicable Input data The following data is used to calculate the alert Projects Related contracts Related contract types Related contractors Calculated data Alert value The alert gets a value of 10 when there is a supervision contractor that appears together with the same contractor in other contracts within the same Member State Project score Alert value Applicable project types DG Regio Infrastructure Pop up information Supervision contractor multiple times in same constellation with work contractor E3 Supervision contractor multiple times in same constellation with work contractors Nb contracts of involvement The following detailed information is available in the values tab Number of contracts in the same Member State in which the supervision contractor appears with the same works contractor Supervision contractor multiple times in same constellation with work contractors E3 Supervision contractor multiple times in same constellation with work contractors Supervision contractor name Work contractor name Project name Contract name 0 Contractor18 Contractor19 FAKE Project supervision Fake supervision 1 1 Contractor18 Contractor19 FAKE Project supervision 1 Fake supervisionz The following detailed information
236. ractors VIES result of the VAT check No detailed information is available in the values tab Links to further details Related companies The following links to further details are available Link to the list of related contractors 14 3 5 13 Sub contractors with invalid VAT number Description This check will validate the sub contractor VAT number through a structure check The objective is to identify projects for which the VAT number of any of the sub contractors does not comply with the VAT structure requirements as mentioned on the VIES website of the European Commission Level of calculation The check is performed for each project Peer group Not applicable Input data The following data is used to calculate the alert VAT number of the sub contractor Calculated data Alert value The alert gets a value of 10 when the VAT number of one of the sub contractors related to the project does not meet the structural requirements as mentioned on the VIES website of the European Commission Project score Alert value Applicable project types DG Regio Infrastructure Pop up information 145 i ARACHNE User manual SubContractors with invalid VAT number Infrastructural Ea SubContractors with invalid VAT number Infrastructural SubContractor name VAT Number of the subcontractor Country code of the subcontractor WIES result 0 BISNODE BELGIUM HOLDING 0418693510 BE Valid The following det
237. radients Templates not used in Arachne application present for backward compatibility Columns defines default columns for search navigation result tables and the business card Languages choice between two versions of the application French and English These user preferences are persisted in a user settings file Once the settings are modified they will be used of any newly opened window The previously opened windows won t be updated This is valid for all changes except the language change which requires an application restart 11 1 Windows The user can determine different options such as the main window s position and size the visibility of the basket window when application starts and a confirmation message before exit Other options are also available concerning hierarchical graph and affinity diagram But the main advantage of these settings is at the level of the option Enable expert mode see 12 1 By choosing this option the user will be able to use the Expert mode as default mode Configuration General options General Options Connection Preserve main window position and size 4 Use extemal web browser Colors 4 Show confirmation before exit Show detailed reports on crash Languages Basket is visible when application starts V Show task pane at startup Document Templates Default columns v Show introduction screen at startup Hierarchical Graph Enable node aggregation Number of passes Use aggrega
238. rnal data surroundings graph and the case management system However the user has no access to information from the Orbis database the detailed information drill down pop up of alerts based on the external data reports containing external data visualizations based on external data functionalities to add external data to the surroundings graph and functionalities to navigate to the external data from the dashboards The chart below provides an overview of the behavior of the concurrent user mechanism when there is a request operation in the application Result ls Error Operation Meeds License Return Result Client Has License License Available f 104 ki i ARACHNE User manual 13 Troubleshooting the application The application has built in error logging and error reporting facilities When critical errors appear the application displays a complete error report e Application Error Exception happened An exception of type System NullReferenceException happened in GETClient Object reference not set to an instance of an object Inner exceptions Stack trace Com Vadis GET ClientApp Controls PropertylemplateEditorControl btnNe Object sender EventArgs e in H Projects GETVWGET Controls PropertyTemplateEditorControl cs line 205 Svstem Windows Forms Control OnClickiEventAras el m Close application If such errors occur please report them using the Report button or em
239. rnover for the project from the average ratio in the peer group Alert value Applicable project types Pop up information Project cost vs turnover E3 Alert Value Project cost 793 645 378 00 Tumover of the beneficiary 78 673 00 Ratio project cost and beneficiary tumover at approval 95 947 Average of the ratio in the peer group 1 939 13 The following detailed information is available in the values tab Project cost Beneficiary turnover Ratio of project cost compared to beneficiary turnover Average ratio in the peer group No detailed information is available in the tables tab Links to further details No links to further details are available 205 ARACHNE User manual 14 3 9 Reputational amp Fraud alerts 14 3 9 1 Financial 14 3 9 1 1 High or deteriorating propensity to bankruptcy Description The objective of this check is to determine a financial risk score for a company based on its propensity to bankruptcy and the evolution of its propensity to bankruptcy over 2 years The propensity to bankruptcy is a score from 1 to 20 which indicates the probability that a company will go bankrupt in the coming 18 months Further information on the propensity to bankruptcy indicator is included in 15 2 The objective of the alert is to identify projects to which a company with high financial risk score is linked Level of calculation The check is performed for each beneficiary project partner
240. rojects Value 3 111 984 22 The following detailed information is available in the values tab Total number of projects in which the personnel member is involved Total accumulated cost of those projects linked to multiple projects Ea Personnel linked to multiple projects Personnels names Related project 0 Komaromi R bert L pj Egyet El re pol si dijasok k pz si t mogat sa 1 Kom romi R bert A k pz s min s g nek s tartalm nak fejleszt se 2 Kom romi Robert A p lyaarient ci rendszer nek tartalmi s m dszertani fejleszt se Representative The following detailed information is available in the tables tab Personnel member s name Function of the personnel member Project in which the personnel member is involved limited to 30 as a preview Alert value of the personnel member Links to further details X Involvements X Details The following links to further details are available 181 ARACHNE User manual Involvements link to the personnel member Starting from that point related information from the Orbis database can be consulted Details link leads to the project s in which the personnel member is involved 14 3 7 9 Consortium members linked to multiple Projects Description The objective of this check is to identify projects for which there is a consortium member that appears as a consortium member in multiple projects within the same Member State Level of
241. rom the average ratio in the peer group Alert value The alert gets a value from 0 to 10 depending on the deviation of the ratio research cost project cost for the project from the average ratio in the peer group Project score Alert value Applicable project types Pop up information Hesearch cost vs project cost E3 Research costs vs project cost Alert Research costs Project cost Ratio research and project costs Average of the ratio in the peer group The following detailed information is available in the values tab Research cost Project cost Ratio of research cost compared to project cost Average ratio in the peer group No detailed information is available in the tables tab Links to further details a Expenses The following links to further details are available Link to the research costs line items in the expenses 199 ARACHNE User manual 14 3 8 11 Other costs project cost Description The objective of this check is to identify projects for with the ratio of other cost relative to the total project cost is larger than the average ratio in the peer group Level of calculation The check is performed for each project Peer group Operational Program Input data The following data is used to calculate the alert Other cost Project cost Calculated data The following data is calculated for the alert Ratio other cost project cost Average ratio in the peer group Deviation
242. rs E3 Links between beneficiaries project partners and contractors suppliers Alert Number of paths between beneficianes project partners and contractors suppliers The following detailed information is available in the values tab Number of paths that have been found between the beneficiary project partner s and contractor s supplier s 214 ARACHNE User manual No detailed information is available in the tables tab Links to further details Path The following links to further details are available Link to the visualization of the path s that have been found In the visualisation additional information can be added roles on the project legal links private links affinities 14 3 9 2 3 Links between beneficiaries project partners and sub contractors Description The objective of this check is to identify projects for which there exists a path between the beneficiary project partner s and sub contractor s A path is a link between several entities in the Orbis database It can be comprised of legal links between companies and private links between companies and related people A distance of 4 or less steps between two entities will be considered as a link Level of calculation The check is performed for project Peer group Not applicable Input data The following data is used to calculate the alert Orbis ID of Beneficiary Orbis ID of Project partners Orbis ID of Sub contractors Lega
243. rt Ratio exceptional cost project cost Average ratio in the peer group Deviation of the ratio exceptional cost project cost for the project from the average ratio in the peer group Alert value The alert gets a value from O to 10 depending on the deviation of the ratio exceptional cost project cost for the project from the average ratio in the peer group Project score Alert value Applicable project types Pop up information Exceptional costs vs project cost E3 Exceptional costs vs project cost Alert Exceptional costs Project cost Ratio exceptional and project costs Average af the ratio in the peer group The following detailed information is available in the values tab Exceptional cost Project cost Ratio of exceptional cost compared to project cost Average ratio in the peer group No detailed information is available in the tables tab Links to further details n Expenses The following links to further details are available Link to the exceptional costs line items in the expenses 201 ARACHNE User manual 14 3 8 13 Fixed assets cost personnel cost Description The objective of this check is to identify projects for with the ratio of fixed assets cost relative to the personnel cost is larger than the average ratio in the peer group Level of calculation The check is performed for each project Peer group Operational Program Input data The following data is used to calculat
244. rt Orbis Interactive report Beneficiary Printable report Beneficiary Interactive report Contractor Printable report Contractor Related projects Shareholders list Subsidiaries list Related groups Hierarchy view Closed local view Deep local view Groups map Surroundings graph Related people Current Related people all 52 ARACHNE User manual 6 2 2 4 Person entity Addto basket Interactive report ERU Related companies all Affinities Affinity diagram Copy name to clipboard Interactive report h E Related companies all S Affinities Affinity diagram 6 2 2 5 Group entity Add to basket Related groups Hierarchy view Groups map Related companies all Copy name to clipboard Related groups Hierarchy view Groups map Related companies all 6 2 3 Navigation results When using neighborhood navigation e g project beneficiaries company related people contract sub contracts the application will open a new window with a list of matching elements Note that these elements are not entities but relations even if they are not shown completely This means that sometimes the same entity may appear on multiple rows This simply means that there are multiple relations between the original entity and this entity This happens mostly in beneficiaries and partners as one company may be beneficiary and contractor at the same time or company related people as a
245. s gt eens ren z lundi 1 janvier 2007 gv Cos 2200008 i x 4 TT H Once applied the results in the search window are post filtered according to the selected criteria 100 ARACHNE User manual situs Project dtc de ot 000027402008 Confer ncia Nacional Portugal mais Acessivel SEFSE POAT 2008 04 01 2008 12 31 191 548 00 000401402011 Surdocegueira um modelo de interven o SEFSE POAT 2012 01 02 2013 12 30 97 712 29 000342402011 FORUM CREATIVE LEARNING BUSINESS INNOVATION SEFSE POAT 2011 06 09 2012 02 28 114 649 52 000351402011 Iniciativa de divulga o de informa o t cnica sobre emprego SEFSE POAT 2011 11 16 2011 12 31 40 000 00 000363402011 Avalia o do Programa Mais Sucesso Escolar SEFSE POAT 2011 06 21 2012 06 20 79 217 60 000388402011 Mostra de Forma o Profissional Espa o de Informa o Profiss SEFSE POAT 2011 11 01 2012 0531 96 000 00 000389402011 NetFORCE Portal de Forma o e Certifica o SEFSE POAT 2011 06 20 2013 12 31 100 000 00 000396402011 Estrat gia para a promo o do emprego e a dinamiza o do desen SEFSE POAT 2011 11 25 2012 12 31 114 059 87 000405402011 Portal da Inova o Social SEFSE POAT 2011 12 12 2013 12 31 180 786 33 000060 2008 12 Cursos Profissionais e Cursos de Forma o Profissional de Du SEFSE POPH 2008 01 03 2008 07 31 64 704 28 nnn271 2007 13 Curene de Fdurar n Farmacdn de lavene SE FSF POPH 2nng n1 n3 _9NNR
246. s 1 Company s activity code in 65 Financial intermediation except insurance and pension funding 66 Insurance and pension funding except compulsive social security 67 Activity auxiliary to financial intermediation 2 Classified as with company type in Banks Financials Mutual amp Pension funds Nominees Trusts Trustees Public authorities States Governments A top invest company is an investment company that has either no company as shareholder or only has top investment companies as shareholders The investment network is constituted of all legal links whose shareholder is a top investment company An investment group is constructed from this investment network For connectivity reasons an investment group may have all companies as top investment companies except the bottom level subsidiaries as non investment companies It is therefore possible that a company belongs to an investment group and a normal group this is a direct subsidiary to a top investment company The Legal link relation links companies together symbolizing the ownership of one company by another This link is qualified by the participation rate percentage Define the level or the importance of a company inside a group starting from the ultimate owner level 0 companies minority shareholders above the ultimate owner have level above 0 and subsidiaries below O Any deal where a shareholder acquires some participation into a subs
247. s Pop up information High financial ratings of associated companies 3 High financial ratings of associated companies Tables Company involved Role in project Financial rating associated companies Number of associated companies Number of associated companies with a bankrupty score 0 OGwwHa 3narorpan Beneficiary 19 00 18 1 The following detailed information is available in the tables tab for all involved companies for which predictive indicators are available for associated companies Company name Role in the project Average propensity to bankruptcy of associated companies Number of associated companies Number of associated companies with a bankruptcy score 209 ARACHNE User manual No detailed information is available in the values tab Links to further details E Oura 3narorpaa The following links to further details are available Link to the interactive report of the companies mentioned in the tables tab 44 3 9 1 4 Non incomplete filing of annual accounts Description The objective of this alert is to identify companies for which no or limited financial data is available Level of calculation The check is performed for each beneficiary project partner contractor and consortium member Peer group Not applicable Input data The following data is used to calculate the alert Publication dates of the financial statements Calculated data The following data is cal
248. s and World Compliance and quality of the match No detailed information is available in the values tab Links to further details X NORDIK LIMITED EOOD 4 Word Compliance article 1173675 u Wadd Pamnlisnens arnica 15E4Gn3F5 The following links to further details are available Link to the interactive report for the related people that resulted in the info in the tables tab Link to the interactive report for each company mentioned in the tables tab Link to WorldCompliance details and articles 232 ARACHNE User manual 14 3 9 4 3 Involvement of individuals entities included in enforcement lists Description The objective of this check is to identify projects for which there is related company beneficiary project partner contractor or consortium member for which either the company or its management is listed in enforcement lists in the WorldCompliance database This will include people that are in a political function or that have close contacts family member close colleague to a politician Level of calculation The check is performed for each beneficiary project partner Lo and consortium member Notapplicable o Input data The following data is used to calculate the alert Orbis ID of Beneficiaries Orbis ID of Project partners Orbis ID of Contractors Orbis ID of Consortium members Private links of the companies management Orbis Calculated data The following data is calculated for
249. s calculated for the alert Realization rate additional turnover when the project is finished additional turnover as agreed Average realization rate in the peer group Deviation of the realization rate of the project from the average realization rate in the peer group Alert value The alert gets a value from O to 10 depending on the deviation of the realization rate for the project from the average realization rate in the peer group Additionally an alert is generated if the realization rate is less than 5096 Alert value Applicable project types Pop up information Additional turnover at the project end vs as agreed Ea Additional tumover at project end over additional tumover as agreed ratio Alert Value Additional tumover actual 110 186 00 Additional tumover as agreed Difference number of additional tumover at project end vs as agreed Average of the ratio in the peer group The following detailed information is available in the values tab Additional turnover beneficiary when the project is finished 154 ARACHNE User manual E Additional turnover beneficiary as agreed in the project application Realization rate difference number of additional turnover at project end vs as agreed Average realization rate in the peer group No detailed information is available in the tables tab Links to further details No links to further details are available 14 3 6 7 Additional Turnov
250. s involved in multiple Projects Description The objective of this check is to identify projects for which the beneficiary appears in multiple projects within the same Member State Level of calculation The check is performed for each project Peer group Not applicable Input data The following data is used to calculate the alert Project Beneficiary Calculated data Alert value The alert gets a value of 10 when the beneficiary of the project is also involved as beneficiary in other projects in the same Member State Project score Alert value Applicable project types All project types Pop up information Beneficiaries involved in multiple projects Ea Beneficiary s number of projects Beneficiary s max number of projects in a same member state The following detailed information is available in the values tab Number of projects in which the beneficiary is involved as beneficiary Maximum number of projects in which the beneficiary is involved within the same Member State as beneficiary Beneficiaries involved in multiple projects Ea Beneficiaries in multiple projects Tables Beneficiary s projects list FAKE ProjectJink subContractor FAKE ProjectJink subContractor FAKE Project supervision 1 FAKE Project Ext Prov The following detailed information is available in the tables tab The list of projects in which the beneficiary is involved as beneficiary limited to 30 as a preview 171 ARACHNE U
251. s similar to the project report but with contract alerts Note that by definition there are less alert categories computed on the contract level Here also the alert details can be displayed by right clicking on individual alerts 72 ARACHNE User manual Alerts summary E CM Revised score EH Procurement Overall Score EH Contract Management Overall Score EH Eligibility Overall Score oeoooo0 EH Concentration Overall Score EH Reputational Fraud Alerts Overall Score ki si Eligibility Overall Score Concentration Overall Scone r 33 Contract Management Overall Score 10 20 30 40 50 Procurement Overall Score Reputational Fraud Alerts Overall Score Value Description Revised overall scare as set in the case management system 26 ProcurementOverall Score 25 Contract Management Overall Score 0 Eligibility Overall Score 33 Concentration Overall Score amp Reputational Fraud Alerts Overall Score 8 1 3 Beneficiary and contractor interactive reports General information This section differs from project and contract reports t doesn t contain any case management references as companies are not part of the case management system The general information section is followed by two additional sections o The Orbis address gives the address as present in the external data o The financial information gives the last balance sheet information available in the external database of
252. se type Project 5ome description about my case Case target name FAKE Project 003 08 Amount involved Supervisor Administrator Administrator Creation date 05 11 2013 16 42 Created by Administrator Administrator Last update 25 01 2014 16 08 84 ARACHNE User manual 9 1 9 1 Follower options For case followers the case status can be changed to ongoing or closing Case status a Ongoing z fa The follower must change the case status from opened to ongoing when he starts working on the case Cases may be left opened as nobody works on them When changing the case status to closing a sub status must be set The sub status can have the following values No action the case doesn t need specific operation anymore Whitelisted the revised score must be set to O no risk for the corresponding entity Blacklisted the revised score must be set to 50 highest risk for the corresponding entity Case status C3 Closing EiNoadion Sta When the status has been changed the operation must be confirmed by clicking on the disk icon Note that changing a case status to closing will require you to add a closing comment Cases cannot be put in closing status without it a4 Comment on Case Closure ENTIA No more action required on this case it has been investigated and the situation is normal OK 9 1 9 2 Supervisor options As cases are created unassigned by default only supervisors can create assign
253. sed as a sub format selector in export formats The Parameters part will display specific parameters according to the selected export formats Example for separated fields only one report type available format Available formats Separated Fields Text CSW TSW Export Report type Example for the simple text export continuous list or table is available Export format Exported file loc Continuous list 1 file Remark the CSV TSV format is a simple structured text file format As the format specification is very basic please use it with caution Changing separator character may have an impact on how the file will be loaded by different applications 91 ARACHNE User manual You can select the exported file location by clicking on the folder icon and selecting a file Exported file location 3 Simple Text Export KH C5 Libraries Documen ts gt gt Search Documents r3 Organize v New folder Eas e Some library features are unavailable due to unsupported library locations Click here to learn more A Favorites 3 Documents library me re BE Desktop Includes 1 location li D Downloads Name p Date modified Type bcnc J InstallResources 3 08 2012 16 04 File folder E Libraries My Corel Shows 4 10 2012 14 14 File folder DD My Data Sources 18 06 2013 15 34 File folder d Music d My DXSkins 13 07 2012 14 14 File folder E Pict di My PSP Files 8 07 2013 09 24 File folder Y
254. see information about your user account and profile using the My profile option in the task pane or via the menu File Profile information User profile E3 User group Root User profile MASTER Case management role Follower Password age 1 Days User Rights o Junctions access rights Generic functions Expert mode search Search on relations Exploring entities 3 Exploring relations cross fertilization Entity summary display Basket functionnalities Graphical visualizations Data printing Data export Customization options E The user profile dialog contains the following information Your user group operational program managing or other authority etc Your user profile the application may hold multiple user profiles with associated user rights These rights apply to the software functionalities only as your user group will fix the rights on the data Your case management role in the case management system see chapter 9 of this manual Your password age passwords expire after 90 days Note that this information is not relevant for users using the ECAS authentication The rights lists associated to your user profile this list contains all functional modules and the indication about your access rights on them we ARACHNE User manual Es 3 2 2 Disconnection from the system You can disconnect from the system either by closing the
255. ser manual i Links to further details A Related companies The following links to further details are available Link to the beneficiary Starting from this link the user can further navigate to the projects in which the beneficiary is involved 14 3 7 2 Beneficiaries involved in multiple operational programs Description The objective of this check is to identify projects for which the beneficiaries appear in multiple operational programs within the same Member State as beneficiary Level of calculation The check is performed for each project Peer group Not applicable Input data The following data is used to calculate the alert Projects Operational Programs to which the projects belong Beneficiaries of the projects Calculated data Alert value The alert gets a value of 10 when the beneficiary of the project is also involved in a project that belongs to another operational program within the same Member State as beneficiary Project score Alert value Applicable project types All project types Pop up information Beneficiaries involved in multiple OPs E3 Beneficiaries in multiple OPs Beneficiary s number of operational programs Beneficiary s max number of operational programs in a same member state The following detailed information is available in the values tab Number of operational programs in which the beneficiary is involved as beneficiary Maximum of operational programs in which
256. ses on top However cases can be sorted on each column Cases can be displayed using the paging buttons on the bottom toolbar attached to the list Double clicking on a single case will open the corresponding case details screen 9 1 6 2 Filtering pane This part of the screen allows the user to filter on various parameters It s only visible by clicking on the Filter cases button on the left 80 ARACHNE User manual ee Following criteria may be used 7 My cases assigned to me e Case identifier m e Cases assigned to the current user Case status e Case type any not closed e Case status Creation date e Case creation date in a date time interval from to 1 be ES e Case assignment date in a date time interval from to E e User group No date selected hd T Assignment date e Fo ower er d z e Target name name of the entity concerned by the case To No date selected Group MS MA OP any Follower any M Case target name 9 1 Casesdetails screen The case details screen displays the complete information about one single case It is accessed by double clicking on a case or in the case list or asking the case details on a project or contract using the context menus Case 001 Description Project Please investigate this project in detail FAKE Project 013 08 21 392 050 00 a Case information lt Not assigned yet gt Roottest2 Roottest2 01 10 2013 18 05 Test User Arachne
257. ssseeeccccecsaeeeseeeccecessueesseeececeesseaeaeeeeeeeesaaas 21 4 5 Entity relationshIpD diagram sscsiesasacssscancGacewdadsanracdessdenssnaenresnsdecesbbseeneaedanndesainassewanedeesebiceserteant 22 4 5 1 dud me 23 4 5 2 cde d E 8 23 4 6 EXPT We Mo zc BENE ETE OTT TE 24 4 6 1 Companies and legal links sse annes 24 4 6 2 Groups memberships and group legal links eese 24 4 6 3 PIPER NR UN TT 26 4 6 4 Vadis Predictive Indicators ccssssscccccnsssscccccsscssceccnsaussesccnsaussessensaussesecsuauseesenssassesensan 26 DAS MOG OS es sence IE E EO E OT TOT DT 27 5 1 Understanding alerts sosisini arree EENE AE EENES 27 5 1 1 Alerts organiza ON seca E A T E 27 5 2 POO S AO NR m 28 5 3 Contr icedi HDO ea tous seuneuosennoncnaauneionnuenionnndyntes sounnnanaeatiessoustauetes 29 5 4 Beneficiaries dashboard ccccccccccccsssessesecccceeesaeesseeececeessaeeseeeeeeeeesauaesseeeeesessauauseeeeeeeeenaaas 29 5 5 Contractors CaS MD ONG MNT TTE 30 5 6 Dashboards options and features sssinccssssendescivtecssavrendseaswndv enrteeduncheSedaeusdacdsoet veeasecevenkanedstedane 30 5 6 1 Dashboard GOS CHD nol E 31 5 6 2 Varying the number of visible records on the dashboard eese 32 5 6 3 Expanding and collapsing categorical alerts ecce 33 5 6 4 SOIT na O
258. st Number of employees Description The objective of this check is to identify projects for with the ratio of project cost relative to the number of employees of the beneficiary is large Level of calculation The check is performed for each project Not applicable Input data The following data is used to calculate the alert Project cost Number of employees of the beneficiary as mentioned in the annual accounts of the project end year data from Orbis Calculated data The following data is calculated for the alert Ratio project cost number of employees of the beneficiary Alert value The alert gets a value from O to 10 depending on the value of the ratio project cost number of employees of the beneficiary for the project A larger ratio value results in a larger alert value Alert value Applicable project types Pop up information Project cost vs number of employee E3 Project cost vs number of employee Alert Value Project cost 1 110 004 00 Number of employee 2 Ratio project cost and number of employees of the beneficiary 555 G0 00 The following detailed information is available in the values tab Project cost Number of employees of the beneficiary Ratio of project cost compared to number of employees of the beneficiary No detailed information is available in the tables tab 212 ARACHNE User manual Links to further details X MOLENBERGNATIE The following links to further details
259. st relative to the annual turnover of the beneficiary is large as it is mentioned in the financial statements of the project year data from Orbis Level of calculation The check is performed for each project Peer group Not applicable Input data The following data is used to calculate the alert Project cost Annual turnover of the beneficiary as it is mentioned in the financial statements of the project year data from Orbis Calculated data The following data is calculated for the alert Ratio project cost annual turnover of the beneficiary Alert value The alert gets a value from O to 10 depending on the value of the ratio A larger ratio value results in a larger alert value Project score Alert value Applicable project types Pop up information Diff betw project cost and annual turnover E3 Project cost vs annual tumover Project cost 4 000 140 621 02 Tumover of the beneficiary 1 930 000 00 Ratio project cost and tumover of the beneficiary 2 072 61 The following detailed information is available in the values tab Project cost Annual turnover of the beneficiary Ratio of project cost compared to annual turnover of the beneficiary No detailed information is available in the tables tab 211 ARACHNE User manual Links to further details X MOLENBERGNATIE The following links to further details are available Link to the interactive report of the beneficiary 14 3 9 1 6 Project co
260. statements of the contract year data from Orbis The objective of the alert is to identify contracts for which the amount is high compared to the turnover of the contractor Level of calculation The check is performed for each contract Sector Operational Program Project type Input data The following data is used to calculate the alert Contract amount Turnover of the contractor based on the financial statements of the year of the contract information retrieved from Orbis Calculated data The following data is calculated for the alert Percentage of contract amount compared to turnover of the contractor Average percentage in the peer group Deviation of the percentage for the contract from the average percentage in the peer group Alert value The alert gets a value from O to 10 depending on the deviation of the percentage contract amount compared to turnover of the contractor for the contract from the average percentage in the peer group Additionally an alert is generated if the percentage is larger than 8096 value 8 or 10096 value 10 Highest score of the contracts that belong to the project Applicable project types DG Regio Infrastructural projects Pop up information 130 ARACHNE User manual Contracted amount vs annual tumover of the contractor Contracted amount vs annual tumover The following detailed information is available in the values tab Average percentage contract amount compare
261. subContractor D OQ s 15 Pm country l Ministe FAKE Project sanction03 Q e D s Fake country Ministe FAKE Project 407 08 Unassigned O FAKE Project 003 08 e FAKE Project 045 09 e FAKE Project 197 09 e FAKE Project SME4 FAKE Project 136 09 e e FAKE Project 158 09 Q9 FAKE Project 173 09 o 6 FAKE Project 175 09 e e FAKE Project 178 09 e FAKE Project 181 09 FAKE Project 211 10 FAKE Project 226 10 FAKE Project 232 10 60 E mE amp Ej HP C 15 Fake country Ministe v 15 Energy eff Urban Fake country Ministe f 2 339 o9 Q s Rail Fake country Ministe 41 38 00 s Water waste supply Fake country Ministe Q oQ 14 Fake country Ministe Q Q Q 9 10 Fake country Ministe E amp e e i E e C E e C EJ e C e 10 Fake country Ministe E 10 Fake country Ministe 10 ida cani Ministe EJ e EJ e C 10 Fake country Ministe E e C 10 Fake country Ministe E o 10 Fake country Ministe EJ e C 10 Fake country Minist 10 Fake country Ministe b amp amp m vT T 20 element s 5 2 3 z 3 z 2 3 2 gt 2 5 2 20 3 2 3 2 3 z o3 2 5 2 3 z EJ oe 7 The table element displays the first N entities corresponding to the selection ordered by the overall score property by default in descending order so
262. szechna Kasa szczednosci Bank Polski SA llecorexumecka npodpecpionangsa ruimgasyn bepkogsrua ETABLISSEMENTS JOSEPH ROYEN VRATSA INVEST GRUP OOD NORDIK LIMITED EOOD KENDERESI ViZIKOZMU TARSULAT PARKLAND KERESKEDELMI ES SZAKTANACSADO BET TI T RSAS G KOMOJIO CTMII EDON B D c Ae eu j 16 element s The application space can hold multiple opened windows By default these windows appear as tabbed windows but they can also be positioned manually at user s will by a simple drag and drop operation 18 ARACHNE User manual m T E L IEEE No condition Group in sensitive regions involvement in Sensitve E EH EG Jj Incorporation Ei El FAKE Project 5ME2 FAKE Praject SMEA FAKE Project 01 7 09 FAKE iibri E EH El E J GET Client introduction Welcome window F Search for Projects De oO coo0o000 E 5 amp J Corporate Services s r o Search for Projects Advanced TRIOSTRAND spol s r o STAV MAKROMOLEKULARNI CHEMIE AV CR vvi Name Contains E Datcon th Elektronikai dilea ii Kit Project ident 3 E T Industry s r o Tof by Desc GM TECHNOLOGY SK s r o Ekologick domy EVO s r o Games Distillery s r o SELMANI s r o Management Solutions s r o E E H E Managing Start date E oococcowpoocdca E k 0 element s E m T 20 element s 3 2 5 4 Status bar The status bar on the bot
263. t Input data The following data is used to calculate the alert Project cost Quantity of solid waste to be treated in tons as agreed in the project application Calculated data The following data is calculated for the alert Project cost per ton of solid waste to be treated Average project cost per ton in the peer group Deviation of the project cost per ton for the project from the average project cost per ton in the peer group Alert value The alert gets a value from O to 10 depending on the deviation of costs per ton of solid waste to be treated for the project from the average cost per km in the peer group Alert value Applicable project types Solid waste Pop up information 158 ARACHNE User manual E Project cost vs quantity of solid waste to be treated E3 Project cost vs quantity of solid waste to be treated Alert Quantity of solid waste to be treated Project cost Ratio project cost and quantity of solid waste to be treated at approval Average of the ratio in the peer group The following detailed information is available in the values tab Quantity of solid waste to be treated in tons as agreed in the project application Project cost Project cost per ton for the project Average project cost per ton in the peer group No detailed information is available in the tables tab Links to further details No links to further details are available 159 ARACHNE User manu
264. t ED deys Extemial serice provider EBgib y Overall Sonne Project costs catis Ide eligibility period bedore stet dile Project cont outside eligibility period afer end dae Dileme between Invoice and payment dates High percentage of cost alloceons within Gee lest 14 days 76 ARACHNE User manual Supported formats Acrobat PDF file Excel 97 2003 Rich Text Format TIFF File Web Archive XPS Document senerates the report in Adobe Acrobat format Lem dee Deem Mem Tum dum 1 12 f 5 a 1m gi Eoo ai zue aiao o o Im T7 Qo Smee nto s aasa 4 e a Q an ma wee A EA ssy as 888 4 z 4 m 4 ee 4 VEGYes k pz sek a k pzett VEGYeseke rt EGYSZE LH Derat oc OF e maininnat e missi s mule we RP nay O IU Peete O 7777 ma n6 PL Parent P a X wm z e Mmmpuidosum cs de re Bbi 9548 TT v BH B H eir t LI Generates the report as an Excel document c z a rA Generates the report in RTF Rich Text Format a multiple word processors compatibility format wm ABC AA S Generates the report in multi image TIFF format tif Tol Projecfilapl ight iN 14 Windows Photo Viewer E pe gt be fpr mt Qe v B amp pe a 3 GLX Generat
265. t award compared to the total project cost Average percentage in the peer group No detailed information is available in the tables tab Links to further details No links to further details are available 119 ARACHNE User manual 14 3 3 5 Number of Contract addenda gt 5 or high compared to the average per Sector Description This check will verify the number of contract addenda in absolute values as well as compared to the average within the sector The objective is to identify contracts with a high number of contract addenda i e i high compared to the average number of addenda per contract in the peer group or ii more than 5 contract addenda Level of calculation Peer group Number of contract addenda Calculated data The following data is calculated for the alert Average number of contract addenda per contract in the peer group Deviation of the number of contract addenda from the average number of contract addenda in the peer group Alert value The alert gets a value from O to 10 depending on the deviation of the number of contract addenda from the average number of contract addenda in the peer group An alert is generated if the number of contract addenda is larger than 5 Project score Highest score of the contracts that belong to the project Applicable project types DG Regio Infrastructural projects Pop up information Number of contract addenda compared to sector average EJ Number of contract add
266. t cost Costfor the purchase of land Percentage cost for the purchase of land project cost No detailed information is available in the tables tab Links to further details No links to further details are available E i ARACHNE User manual 14 3 6 Performance 14 3 6 1 Number of people trained Number of people to be trained agreed in the Contract Description This check will compare the number of people that were actually trained versus the people that needed to be trained as agreed in the contract and defines this as the performance progress Project progress has been defined as the actual project expenses compared to the project cost as agreed on in the project application The objective is to identify projects for which the performance progress is lower than the project progress Level of calculation The check is performed for each project Not applicable Input data The following data is used to calculate the alert Number of people trained actual Number of people to be trained as agreed in the contract Project cost Project expenses Calculated data The following data is calculated for the alert Performance progress number of people trained number of people to be trained Project progress sum of project expenses project cost Alert value The alert gets a value of 5 or 10 depending on the deviation of the performance progress from project progress An alert is generated if the performanc
267. tails No links to further details are available 203 ARACHNE User manual 14 3 8 15 EC financial assistance beneficiary turnover overall Description The objective of this check is to identify projects for with the ratio of overall EC financial assistance relative to the beneficiary turnover is larger than the average ratio in the peer group Level of calculation The check is performed for each project Operational Program Input data The following data is used to calculate the alert EC financial assistance Beneficiary turnover as sourced by the Member State in the Project table Calculated data The following data is calculated for the alert Overall EC financial assistance sum of EC financial assistance for all projects of the beneficiary Ratio overall EC financial assistance beneficiary turnover Average ratio in the peer group Deviation of the ratio overall EC financial assistance beneficiary turnover for the project from the average ratio in the peer group Alert value The alert gets a value from O to 10 depending on the deviation of the ratio overall EC financial assistance beneficiary turnover for the project from the average ratio in the peer group Alert value Applicable project types Pop up information Ratio of overall EC financial assistance vs tumover of the beneficiary E3 Ratio of overall EC financial assistance vs tumover of the beneficiary Alert Value EC overall financial assist
268. tch exactly the same or similar Additional match on address or not Additional match on birthdate or not Frequency of appearance of the name in the database Project score Highest alert value of any company linked to the project beneficiary project partner contractor or consortium member Applicable project types Pop up information 234 ARACHNE User manual Li Involvement in adverse media 3 Involvement in adverse media Company involved ls included in adverse media lists HEALTH STUDIO ET SERVICE CENTRE Entity not matched as adverse media listed VADIS CONSULTING Entity not matched as adverse media listed UNILEVER Entity not matched as adverse media listed MELISA EMIN CHAMDERE ET Entity matched as adverse media listed with a quality score of 0 8 Menu Bera OOQ Entity not matched as adverse media listed ALBOUWMAT Entity not matched as adverse media listed PORT REAL ESTATE Entity not matched as adverse media listed The following detailed information is available in the tables tab Name of the company Role in the project Name of the related individual when applicable Type of match between Orbis and World Compliance and quality of the match No detailed information is available in the values tab Links to further details Mr Emin Sali Chamdere HA MELISA EMIN CHAMDERE ET 4 Word Compliance article 2439409 The following links to further details are available Link to the interactive report for
269. te around method Aggregation skipped 50 nodes under Affinity diagram Affinity jumps 1 Max people nodes 40 Legal jumps 1 Max company nodes 80 Search options 4 Enable expert mode Export options v Open results after exporting Automatic update Enable auto update process Last update revision 000 94 General options Preserve main window position and size Use external web browser When activated latest application position and size is saved in the user configuration file so it will be restarted at the same location When activated the application will open web links into an external browser instead of opening it with the embedded browser When activated a confirmation dialog is displayed when closing the application cannot be changed Show confirmation before exit Show detailed reports on crash Basket is visible when the application starts Show task pane at startup Show introduction screen at startup Hierarchical graph Enable aggregation Number of passes Use aggregate around method Aggregation skipped under Affinity diagram Affinity jumps Legal jumps Max people nodes Max company nodes Show company names by default Search options Enable expert mode This option has the same role as the Expert mode option on the entity search menu When activated the basket window will be displayed when the application starts When activated the task pane is shown when the application starts When a
270. te dashboard Click on the link to open the full dashboard window Each mini dashboard displays the top 10 of highest overall score value It only contains a reduced column set that cannot be customized the overall score the revised score for case managed entities and some specific columns for each kind of entity For projects Project type Member state Managing authority Project status Project cost For contracts Contract identifier Signature date Key expert change For beneficiaries and contractors Total grants amount Type VAT number Country 13 ARACHNE User manual Es Each mini dashboard has similar functionalities as the complete dashboard except for drilldown and expanding collapsing alert details Please refer to chapter 5 for more specific information about dashboards D ARACHNE User manual 3 2 4 Arachne interface Menu bar Administrator G Your current profile gt Change your password This application allows you to deeply analyse the B2B universe through analytical methodoligues that are built by Vadis in strong collaboration with Bureau Van Dijk Electronic Publishing Case management GET User Core functions Don t forget to change your password e Search and browse If you registered online a random password was assigned You can perform search either on entities or relations in default or automatically for your user account For se
271. ted aggregation criteria Third column contains the revised projects score average value inside the selected aggregation criteria The revised score is the score assigned to closed project cases This gives an idea about how the cases were resolved Lower values mean cases were mostly resolved in a positive way as higher values demonstrate cases were flagged as more risky A Fourth and fifth columns contain respectively for the overall score and for the revised score the number of items having a score over 38 Changing the aggregation criteria can be done by using the combo box on the top right of the table LA J DM OLI GITE POI IL 7 lh Member state CM CM Managing Authority a Figure 1 Selecting aggregation criteria The statistics can also be refreshed for the current selection using the 3 icon On the bottom left of the table you also have the global project average values for the population corresponding to the user s context Faux pays Global average Overall Score 10 00 CM Revised score Double clicking on a row in the table opens the dashboard window with its selection set to the selected aggregation criteria i e double clicking on a row with an operational program will show you the dashboard for this operational program ARACHNE User manual Ed 3 2 3 3 Dashboard summaries section Mini dashboards are reduced versions of full dashboards available in the applicati
272. the related people mentioned in the tables tab Link to the interactive report for each company mentioned in the tables tab Link to WorldCompliance details and articles 235 ARACHNE User manual 14 3 9 5 Change 14 3 9 5 1 Newly created company Description The objective of this check is to identify projects for which there is related company beneficiary project partner contractor or consortium member that has been recently created Level of calculation The check is performed for each beneficiary project partner contractor and consortium member Peer group Input data The following data is used to calculate the alert Orbis ID of Beneficiary Orbis ID of Project partners Orbis ID of Contractors Orbis ID of Consortium members Company incorporation year Orbis Calculated data Alert value The alert gets a value between 0 and 20 depending on the age of the company Project score Highest alert value of any company linked to the project beneficiary project partner contractor or consortium member Applicable project types Pop up information Company invalved Role in project Incorporated year of the company MOB EXPRES SRL Contractor 2001 ARHI PLAN 5 R L Contractor 2008 PROD COM SERV GHIOANA S R L Contractor 1992 EREDAS SRL Contractor 2006 BOROS IOSIF INTREPRINDERE INDIVIDUALA Contractor 2013 The following detailed information is available in the tables tab Name of the company Role in the
273. the waste water treatment Average cost per population equivalent in the peer group No detailed information is available in the tables tab Links to further details No links to further details are available 14 3 6 14 Cost relating to the Sewage Network Component of the Project Length of sewage network to be renovated constructed in km Description This check will return the cost of the sewage network component per km of renovated or constructed sewage The objective of the alert is to identify projects for which the cost per km is higher than the average cost in the peer group Level of calculation The check is performed for each project Input data The following data is used to calculate the alert Cost relating to the sewage network component Length of sewage network to be renovated constructed in km Calculated data The following data is calculated for the alert Cost per km cost relating to the sewage network component length of sewage network to be renovated constructed in km Average cost per km in the peer group Deviation of the cost per km for the project from the average cost per km in the peer group Alert value The alert gets a value from O to 10 depending on the deviation of the cost per km cost relating to the sewage network component length of sewage network to be renovated constructed in km for the project from the average cost per km in the peer group Alert value Applicable project types W
274. ther details 213 ARACHNE User manual I Path The following links to further details are available Link to the visualization of the path s that have been found In the visualisation additional information can be added roles on the project legal links private links affinities 14 3 9 2 2 Links between beneficiaries project partners and contractors suppliers including consortium partners Description The objective of this check is to identify projects for which there exists a path between the beneficiary project partner s and contractor s supplier s A path is a link between several entities in the Orbis database It can be comprised of legal links between companies and private links between companies and related people A distance of 4 or less steps between two entities will be considered as a link Level of calculation The check is performed for project Peer group Not applicable Input data The following data is used to calculate the alert Orbis ID of Beneficiary Orbis ID of Project partners Orbis ID of Contractors suppliers Legal links ownership in Orbis Private links directors in Orbis Calculated data The following data is calculated for the alert Path finding between entities Alert value The alert gets a value of 10 when a path is identified Project score Alert value Applicable project types Pop up information Links between beneficianes project partners and contractors supplie
275. this or another application 6 2 2 Navigation functions The following navigation options are available for the different entities in the system Context menus are available by right clicking on items 51 ARACHNE User manual 6 2 2 1 Project entity Add to basket Ch Create new case Copy name to clipboard Interactive report E Printable report 4 Beneficiaries Partners 4 Contracts 4 Involvements 4 Expenses Surroundings graph 6 2 2 2 Contract entity Add to basket Ch Create new case J Copy name to clipboard Interactive report Printable report 4 Contractor 4 Requesting project 4 Sub contracts 6 2 2 3 Company entity Add to basket Copy name to clipboard Detailed report Printable report Interactive report Beneficiary Printable report Beneficiary Interactive report Contractor Printable report Contracto Related projects Shareholders list Subsidiaries list Related groups Hierarchy view Pee uz DILE DID D D E m Closed local view rd Deep local view Groups map Surroundings graph Related people current Related people all pa po rip Copy name to clipboard Interactive report Printable report Beneficiaries Partners Contracts Involvements Expenses Surroundings graph Copy name to clipboard Interactive report Printable report Contractor Requesting project Sub contracts Detailed report Orbis Printable repo
276. time between publication and contract signature Alert Publication of the tender notice Signature date Lead time between publication and signature dates Average lead time in the peer group The following detailed information is available in the values tab Date on which the tender notice was published Date on which the contract was signed Number of days between both above mentioned dates Average number of days between both dates in the peer group No detailed information is available in the tables tab 116 ARACHNE User manual i Links to further details No links to further details are available 14 3 3 2 Number of disqualified tender offers Number of tender offers received disqualified and valid Description This check will look at the percentage of tenders that have been disqualified The objective of the alert is to identify contracts for which the percentage of disqualified tender offers compared to the total number of tender offers differs from the average percentage in the peer group Level of calculation The check is performed for each contract Peer group Sector Operational Program Project type Input data The following data is used to calculate the alert Number of disqualified tender offers Number of tender offers received disqualified and valid Calculated data The following data is calculated for the alert Percentage of disqualified tender offers compared to total number of tender o
277. tom of the application will give various information about tasks and processes running in the background 32324 F Orhi Version 11322774 Orbis version 20130918 It also shows the current application version and data version The data version references the Orbis external data publication date using yyyymmdd date format year month day The application version and Orbis version should always be mentioned when reporting problems or issues 19 4 Understanding the concepts 4 1 Arachne data The data available in the application come from multiple sources that are aggregated in order to give the user a complete and accurate view of what s happening in its universe These data sources are Member States data about projects contracts beneficiaries and contractors These are called internal data Publicly available information about companies and their board members o General information address phone web site Financial information coming from published balance sheets Ownership information between companies Ownership and functional relationships between companies and individuals Global PEP lists Global sanction lists O O O O O Global enforcement lists o Global adverse media lists These are called external data There are also referenced as Orbis and or WorldCompliance data in the manual or the application Orbis and WorldCompliance are the original data source names Vadis specific indicators based
278. tor de heer Frederik Gustaf Akerman 1 FIRMA SWIMKELS Contractor Mrs Martine Swinkels The following detailed information is available in the tables tab Name of the company Role in the project Name of the director shareholder of the company limited to 30 as a preview Number of mandates of the director shareholder No detailed information is available in the values tab Links to further details amp BISNODE BELGIUM HOLDING T FIRMA SWINKELS The following links to further details are available Link for each company with a role in the project mentioned in the tables tab Clicking on the link opens a selection window with the names of the individuals linked to the company For all selected names the interactive report will be opened Multiple elements are available Please chose the elements you want to display 219 ARACHNE User manual 14 3 9 2 Registration of multiple companies on the same address Description The objective of this check is to identify projects for which there is related company beneficiary project partner contractor or consortium member with an address on which multiple other companies are registered Level of calculation The check is performed for each beneficiary project partner contractor or consortium member Peer group Input data The following data is used to calculate the alert Orbis ID of Beneficiary Orbis ID of Project partners Orbis ID of Contractors Orbis
279. tors Company involved Change dates of shareholders directors OPUS Ingatlanszolgaltat s Kivitelez Kft i 20130717 HU10712740 OPUS Ingatlanszolg ltat s Kivitelez Kft i 20121011 HU10712740 OPUS Ingatlanszolg ltat s Kivitelez Kft i 20120316 HU10712740 OPUS Ingatlanszolg ltat s Kivitelez Kit i 20120316 HU10712740 The following detailed information is available in the tables tab Name of the company Role in the project Name of the new shareholder director limited to 30 as a preview Date for change in new shareholder director VAT number of the company No detailed information is available in the values tab ARACHNE User manual Links to further details b Persons in the company OPUS Ingatlanszolgaltat s Kivitelez Kit The following links to further details are available A link for each company mentioned in the tables tab Clicking on the link opens a new window in which the names of the related shareholders directors from the tables tab can be selected The interactive reports of the selected shareholders directors are subsequently opened 14 3 9 5 3 High rotation of directors Description The objective of this check is to identify projects for which there is related company beneficiary project partner contractor or consortium member that had a lot of changes in directors in the past three years Level of calculation The check is performed for each beneficiary project
280. tra windows such as basket 12 3 3 and graph legend 7 may be displayed on the right of the application The user has the possibility to change the different elements location by a simple drag and drop operation This gives the users the ability to customize their work experience 15 ARACHNE User manual ui Bf 3 2 5 Menus and toolbars 3 2 5 1 Application main menu Groups Exploration Toolset GET CE Server Test e t ES File CQ Entities Relations Dashboards X Case management Parameters Windows Help Menu descriptions Screenshot Description CiEnties Relations Dashboa The File menu contains the connection disconnection options Disconnection Administrator the export and print functions and the password change option Change your password only when logged with the internal authentication system ECAS ees password change is not supported through the application Cy Relations Dashboards The Entities menu contains the different search forms available Search for Projects on entities projects contracts companies persons and groups Search for Contracts Some entities may have multiple forms available Please refer to Search for companies BvD ID chapter 6 1 for more information about searches The menu contains also the expert mode activation and the Search for Persons navigator which will be described in the advanced features Search for Groups section Expert mode Navigator
281. ts as a supplier contractor but with the same beneficiary within the same Member State Project score Alert value Applicable project types All project types Pop up information Suppliers Contractors involved in multiple projects of the same beneficiary Ea Suppliers Contractors involved in multiple projects of the same beneficiary Suppliers max number of projects of the same beneficiary Total amount of project costs of related suppliers 3 376 874 35 The following detailed information is available in the values tab Number of projects in which the supplier contractor is involved as a supplier contractor Maximum number of projects in which the supplier contractor is involved as a supplier contractor within the same Member State and with the same beneficiary Total accumulated cost of the projects in which the supplier contractor is involved as a supplier contractor Suppliers Contractors involved in multiple projects of the same beneficiary E3 Suppliers Contractors involved in multiple projects of the same beneficiary Tables Contractor name Project name am Beneficiary name WARENHUIS DE VRIJHEID FAKE Praject 004 08 ILOMAR AGENCIES WARENHUIS DE VRIHEID FAKE Praject 011 08 i DRAPANTEX WARENHUIS DE VRIHEID FAKE Praject 023 08 HEALTH STUDIO ET SERVICE CENTRE WARENHUIS DE VRIJHEID FAKE Praoject 045 08 HEALTH STUDIO ET SERVICE CENTRE 178 ARACHNE User manual The following detailed information is av
282. ture date Description This check looks at the lead time between the publication of the tender notice and the contract signature date in days The objective of the check is to identify contracts for which there is either i a large delay between the publication date of a tender notice and the contract signature date or ii a significant difference between the delay for the contract and the average delay in the peer group Level of calculation The check is performed for each contract Peer group Operational Program Input data The following data is used to calculate the alert Publication date of the tender notice Contract signature date Calculated data The following data is calculated for the alert Difference between both dates Average difference within the peer group Deviation of the difference for each contract from the average difference in the peer group Alert value The alert gets a value from O to 10 depending on the deviation of the difference between both dates in days for the contract compared to the average difference between both dates in the peer group If the difference between the publication of the tender notice and the contract signature date exceeds 180 days then the alert value is also 10 Project score Highest score of the contracts that belong to the project Applicable project types DG Regio Infrastructural projects Pop up information Lead time between publication and contract signature E3 Lead
283. unt of expenses with duplicate amounts Total amount of expenses Percentage of expenses with duplicate amounts compared to the total project amounts 138 ARACHNE User manual No detailed information is available in the tables tab Links to further details a Expenses The following links to further details are available Link to the expenses with duplicate amounts 14 3 5 7 Negative expenses Description Level of calculation Peer group Input data This check will identify expenses with negative amounts The objective of the alert is to identify projects for which a high amount of the total expenses is claimed via negative amount expenses The check is performed for each project Operational Program Calculated data Alert value Project score Applicable project types The following data is used to calculate the alert Expense amount The following data is calculated for the alert Total amount for expenses with a negative amount Total amount of expenses Percentage of negative amount expenses compared to the total amount of expenses The alert gets a value from O to 10 depending on percentage of expense amounts that are negative amounts compared to the total expense amounts Alert value Pop up information Number of expenses Amount of total expenses 102 613 41 Number of expenses with negative amounts 1 Amount of expenses with negative amount 16 992 00 Fercentage of expenses with
284. urrent Previous Work country 47 ARACHNE User manual E 6 1 2 1 3 Search on membership links Criteria on companies are the same as in the company search form Criteria on groups are the same as in the group search form The only criterion on the membership link is the ultimate owner flag This flag is a technical value indicating which method is used to determine the group s ultimate owner It can take UO ultimate owner or LTC largest top company Field name Ip Value Members Status code i Active Country i BELGIUM Groups Investment Gp Investment Prim UO country i BELGIUM Memberships Prim UO Flag Company name Company name E C Status code Country NACE Code primary Company age letween in Or 15004 E VPI P2B Bankruptcy E Overview VPI P2B Sold Top 20 VPI Estimated Deal Value Min VP Estimated Deal Value Max Group name Group ID Investment Gp Prim UO country Prim main sector Within Primary countries Contains Prim nof companies Between inc 50000 H E 48 ARACHNE User manual Ed 6 1 2 1 4 Search on affinity links The criteria on persons on both sides of the affinity link are the same as in the person search form The only criterion on the affinity link is the direct link flag A direct affinity link corresponds to a person company gt person path as an indirect affinity link corresponds to a person gt company company person path Field name Contacts
285. used when representing continuous values is built on three colors lower color medium color and higher color representing lower medium and higher values 11 2 2 Color palette The color palette is used to represent enumerated values or distinct literals It can be automatic or user based In user palette mode the user can define eight base colors In automatic mode these colors are automatically generated by the application using an hsl optimal dispersion algorithm ensuring an optimal color difference between two consecutive colors 11 3 Default columns For each entity company group person and each type of link legal link membership private link the user can select the columns he wants to display in the list of results details panel on the task pane on the left of the application and the graph indicators available in graph windows 96 ARACHNE User manual ka Configuration General options Default properties configuration Connection For graph indicators aca For graph indicators Columns for Disables columns Lanquages Document Templates Company Default columns Enabled columns Active company Country ma s Address E C Type e Bankrupt company Legal form t El Benefciciary overall score Q 1 Company age m Benefciciary overall score Q 2 BvD Size E Benefciciary overall score 3 3 TT LE BvD Size C E Flag C W C E Rag Overall Alert reall i City
286. verage of the ratio in the peer group 0 03 The following detailed information is available in the values tab Total contract addenda costs for all contracts related to the project Total project cost Percentage of total contract addenda costs compared to the total project cost Average percentage in the peer group No detailed information is available in the tables tab Links to further details 122 ARACHNE User manual i No links to further details are available 14 3 4 2 Contract Addenda Cost total per Contract Contracted Amount Per Contract Description This check will result in the percentage of amounts that were solicited through a contract addendum within one contract The objective of the alert is to identify contracts where the percentage of contract addenda costs compared to the contract amount is higher than the average percentage in the peer group Level of calculation The check is performed for each contract Peer group Sector Operational Program Project type Input data The following data is used to calculate the alert Contract addenda cost Total contract amount Calculated data The following data is calculated for the alert Percentage of contract addenda costs compared to the total contract amount Average percentage in the peer group Deviation of the percentage for the contract from the average percentage in the peer group Alert value The alert gets a value from O to 1
287. will use a drop down list This creates your first search criterion Note that you can roll back your modifications using the eraser button Each click will go one step backwards going back to the operator picker then the property picker If you want to add more criteria just use the button It will create an extra line and then restart the same process Search for Projects w gt Sann X iv i x To remove a complete line use the red cross button Note when you create advanced forms always remember that all criteria must be validated in order to have some results AND operation 12 2 Post filtering options Post filtering option is a specific action that can be performed on entity search results and the basket This post filtering process acts only on the result set and will only use available information i e visible columns 99 ARACHNE User manual E i DE me w m joe h gt x 000003402007 Auditoria SE POAT 2007 12 01 2008 12 31 1 709 680 00 a 000004402007 Estudo de Avalia o do Impacte de Ac es Financiadas pelo FSE SE POAT 2007 12 01 2007 12 31 70 000 00 Ei 000010402008 Certifica o de entidades formadoras SE POAT 2008 02 01 2010 12 31 1 307 480 00 3 000027402008 Confer ncia Nacional Portugal mais Acessivel SE POAT 2008 04 01 2008 12 31 191 548 00 a 000021402008 Assist ncia T cnica no mbito do QREN FSE SE POAT 2008
288. within the same Member State and with the same beneficiary 186 ARACHNE User manual E Number of projects in which the sub contractor is involved as a sub contractor SubContractors linked to multiple projects of the same beneficiary SubContractors linked to multiple projects of the same beneficiary SubContractorname Project name Contract name Alert level Project cost Contract cost 0 Memi Bera 000 FAKE Project 046 08 Fake Wrong VAT 10 06 132 00 255 124 06 1 Mena Bera 000 FAKE Project 102 08 Contracta 10 192193381 125640453 The following detailed information is available in the tables tab Name of the sub contractor Projects in which the sub contractor is involved as a sub contractor limited to 30 as a preview Name of the contracts through the sub contractor is linked with the projects Alert value for the sub contractor Project amount Contract amount Links to further details a Related companies The following links to further details are available A link to sub contractor Starting from that point all related information for the sub contractor can be accessed including the interactive report contractor in which the list of related contracts and projects can be consulted ARACHNE User manual ES 14 3 7 13 Supervision contractor multiple times in same constellation with works contractor Description The objective of this check it to identify projects for which there is a supervision contracto
289. xl Concentration Overall Score Overall Score 32 CM Revised score Procurement Overall Score Elements can also be re Contract Management Overall Score Eligibili uere ll E Performance Overall Score Reputational Fraud Alerts Other Overall Score Concentration Overall Score 50 FAKE Project 024 09 Overall Score 30 Concentration Overall Score 25 FAKE Project link subContractor FAKE Project sanction03 Overall Score 17 Overall Score 16 Concentration Overall Score 50 FAKE Project 234 10 Concentration Overall Score 30 FAKE Project 017 09 Overall Score 13 Concentration Overall Score 50 FAKE Project 242 10 f A IITBM CILIII 40 a o 2 E E o e o o uv Procurement Overall Score Contract Management Overall Score Eligibility Overall Score 19 Q Q Performance Overall Score e soQ soQ oQ 16 35 o8 soQ oQ Concentration Overall Score Other Overall Reputational a Concentration Overall Score 50 Overall Score 10 FAKE Project 355 11 Overall Score 12 FAKE Project 240 10 FAKE Project 241 10 FAKE Project 246 10 FAKE Project 370 11 Overall Score 13 FAKE Project 242 10 Overall Score 16 FAKE Project 234 10 Overall Score 32 oo od 120 12 120 i20 o9 o9 o o o 0 s so o o so o o so o o so
290. xt menu and use the Add to basket option Simply drag and drop elements from tables to the basket Warning you must pick the row header to perform the drag and drop operation Note that the drag and drop operation is not possible from the dashboards or mini dashboards C Groups Exploration Toolset GET TPM Server Test mem CE x File Q Entities Relations Dashboards Parameters Windows amp 3 GET Client introduction Search for Companies V Managers for VERHAEGHE Search for Companies Advanc de VadisTesi0i Id numeric 2 Connect SX Your current profile Company name a Grenon vo acer Status code Within v Disconnect Entity IB VIRIDAXIS 1786033 BREMBERGHOEVE 1561642 IB moonen 1318817 E E VERHAEGHE H 1304495 AR Mr Hans Verhae 1096656380 Country Within BELGIUM E DEDWERSEHAGEN NACE Code primary Begins with 012 VPI P2B Bankruptcy gt Uu Ha SINT KATELIJNE WAVER 2860 BELGIUM 32 15 31 1053 32 15 31 41 89 VPI P2B Sold Top 20 gt 1 Size BvD 0 County C F E BOTERHOEK BE0419110076 ME Medium BELGIUM F E PAESEN STOETERIJ LINDENHOF BE0425177328 ME Medium BELGIUM PE F E EUROPE HUNTING BE0425013814 SM Small BELGIUM BC F E SENTOBIN BE0426786538 ME Medium BELGIUM HC F re HANAVI BE08611
291. y 208 ARACHNE User manual 14 3 9 1 3 High financial ratings of associated companies Description The objective of this check is to determine a financial risk score for a company based on the propensity to bankruptcy for its associated companies shareholders subsidiaries The propensity to bankruptcy is a score from 1 to 20 which indicates the probability that a company will go bankrupt in the coming 18 months Further information on the propensity to bankruptcy indicator is included in 15 2 The objective of the alert is to identify projects to which a company with a high financial risk score is linked Level of calculation The check is performed for each beneficiary project partner contractor and consortium member Not applicable Input data The following data is used to calculate the alert Associated companies shareholders subsidiaries this information is retrieved from Orbis Propensity to bankruptcy year X latest available indicator from Orbis for the associated companies Calculated data The following data is calculated for the alert Average propensity to bankruptcy for all associated companies of a company Alert value The alert gets a value from O to 5 depending on the average propensity to bankruptcy of the associated companies of a company Project score Highest alert value of any company linked to the project beneficiary project partner contractor or consortium member Applicable project type
292. y its shareholders The cluster group construction takes into account investment and non investment groups The CG algorithm is applied to these two populations The intersection of the two populations contains the non investment companies that are owned by one or several investment companies 106 Companies Company city Contract Controlling point Dashboard EBITDA ECAS The Company entity contains mixed information coming from data from the European Commission beneficiary contractor and sub contractor information and from public data financial and scores Companies are linked to projects via the Beneficiary relation They are linked to contracts via the Contract executor relation In addition companies are linked together via the Legal link relation to groups via the Membership relation and to persons via the Private relation These three relations come from the public data Local plant city The Contract entity represents a contract signed by a company beneficiary contractor or sub contractor for a given project The contract is related to the project via the Contract requestor and to the company via the Contract executor A controlling point is on top of a skeleton group and has at least one participation rate higher than 50 to another company of the same skeleton group Several controlling points can be identified in the same skeleton group On the other hand a group may not have a controllin

Download Pdf Manuals

image

Related Search

ARACHNE arachne myth arachne ai arachne soul eater arachne fragment arachne hypixel skyblock arachne spider arachne greek mythology arachne skyblock arachne cash machine arachne story arachne crane arachne pronunciation arachne web arachne and athena arachne wall generator arachne\u0027s keeper arachne money machine arachne vs classic wall arachne eu arachne fragment hypixel skyblock arachne login arachne hero wars arachne automatic cash machine arachne build arachne demonic

Related Contents

USER`S MANUAL - GTI-IA  Sektkorken-Fallschirm  "取扱説明書"  incidents critiques  BECK-O-TRONIC 4 - Becker Antriebe  CRT-D - Boston Scientific  Service - Terry`s Jaguar Parts  HRSD4 DVR User GHuide (GER)  mesœstetic`  LG WD-10587BD User's Manual  

Copyright © All rights reserved.
Failed to retrieve file