1 / 21

Overview of European Works Council Database Forms and Structure

This document provides a comprehensive overview of the European Works Council (EWC) database, detailing its structure and the main forms for user input and updates. The MySQL database consists of 105 different tables, with the four primary tables containing extensive records: Tgroupco (4342 records), Tbody (1293 records), Tagreement (1826 records), and Tanalysis (1748 records with 16 subtables). Screenshots illustrate various forms, including subsidiary links, agreement specifics, and contact information crucial for efficient data management within the EWC framework.

feo
Télécharger la présentation

Overview of European Works Council Database Forms and Structure

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. European Works Council database somescreenshots of the main forms for input/updating ipas@etui.org, 2014.03.18

  2. General information • the MySQL database contains105 different tables, of which the four main ones are • Tgroupco  containing 26 columns and 4342 records • Tbody containing 15 columns and 1293 records • Tagreement containing 15 columns and  more than 1826 records • Tanalysis containing 70 columns (+ at least 16 subtables) and 1748 records titleofthepresentation

  3. Parent companiesform Ewcdb – screenshots MsAccess

  4. Parent companiesform – subforms (1) titleofthepresentation

  5. Parent companiesform – subforms (2) titleofthepresentation

  6. Parent companiesform – Contacts linked to Group titleofthepresentation

  7. Parent companiesform – Subsidiarieslinked to Groupco titleofthepresentation

  8. EWC body form titleofthepresentation

  9. EWC Body form – Contacts linked to the body titleofthepresentation

  10. Agreement form – general tab

  11. Agreement form – signatures and registration tab

  12. Agreement form – exceptional provisions tab

  13. Agreement form – SE specific tab

  14. Agreement analysisform – Constitution/legal issues tab

  15. Agreement analysisform – Seats tab

  16. Agreement analysisform – Information & consultation tab

  17. Agreement analysisform – Plenary meetings tab

  18. Agreement analysisform – Select committee… tab

  19. Agreement analysisform – Support available to EWC tab

  20. Contacts form titleofthepresentation

  21. Organisations form titleofthepresentation

More Related