Import CAEN document into the ANNA.ERP database

[Alexander Mihail]

CAEN.doc

CAEN

(1.61 MiB) Downloaded 5 times

The importance of the CAEN classification is in that it maps most of the fundamental activities across the country.
To convert the CAEN document into an SQL structure, the following needs to happen:

1. Changes to ANNA.LawView (Gaius) user interface
   
   
   
   1. LawView compiler must use the root node as template for creating the hierarchy
      
   2. Must add another special character, \t, to the compiler's heading definition. This indicates to the compiler that an "alias" is to be found separated by TAB after the "NAME #" paragraph prefix.
      
   3. Creating XRefs has to use the self-arcs of the root node as template. The template arc decides the type of the subsequently created cross-references. Cross-references would take into account the name of the template arc. In the CAEL classification, the arcs would be labled "Aceasta clasa include" or "Aceasta clasa exclude".
      


2. Changes to the SQL schema of ANNA.ERP
   
   
   
   1. Add a new CAEN table to the schema of ANNA.ERP.DB and to the INDEX table.
      
   2. Add a new CAEN.XRef table to the SQL schema.
      
   3. Get the compiler to work live within the SQL database. This is also a test of endurance and performance.
      
   4. Work on performance issues.