WBW2 ZStoWGS Export
WGS-Tool_WBW-Export.csv
The fields for export were agreed on 16 June 2024 together with Peter Staufer (SBB).
This export takes the information permanently from the classification schema "SBB Warengruppen" with the internal number "custom".
The export format must be a csv-file in UTF8, comma separated.
| Excel view column | Column Name | Example value | Description how to pull data from ZUGSEIL |
|---|---|---|---|
| A | Ebene 1 - de | Anlagen | German name of the classification item 1st level from "SBB Warengruppen" schema |
| B | Ebene 1 - fr | Installations | French name of the classification item 1st level from "SBB Warengruppen" schema |
| C | Ebene 1 - it | Strutture | Italien name of the classification item 1st level from "SBB Warengruppen" schema |
| D | Ebene 1 (#) | 300000000 | Classification item number 1st level, full 9 digits long number |
| E | Ebene 2 - de | Energieanlagen | German name of the classification item 2nd level from "SBB Warengruppen" schema |
| F | Ebene 2 - fr | Installations énergétiques | French name of the classification item 2nd level from "SBB Warengruppen" schema |
| G | Ebene 2 - it | Sistemi energetici | Italien name of the classification item 2nd level from "SBB Warengruppen" schema |
| H | Ebene 2 (#) | 301300000 | Classification item number 2nd level, full 9 digits long number |
| I | Ebene 2 Verantwortlicher | U222029 | This is the strategical buyer of the classification item 2nd level. This is the responsible buyer person and rule type default.. Exported must be the staff number, like: UE51083 |
| J | Ebene 2 Stellvertreter | U231901 | This is the strategical deputy buyer of the classification item 2nd level. This is the deputy buyer person and rule type default.. Exported must be the staff number, like: UE51083 |
| K | Ebene 3 - de | Freileitungstechnik (Instandhaltung) | German name of the classification item 3rd level from "SBB Warengruppen" schema |
| L | Ebene 3 - fr | Technique des lignes aériennes (maintenance) | French name of the classification item 3rd level from "SBB Warengruppen" schema |
| M | Ebene 3 - it | Tecnologia delle linee aeree (manutenzione) | Italien name of the classification item 3rd level from "SBB Warengruppen" schema |
| N | Ebene 3 (#) | 301305000 | Classification item number 3rd level, full 9 digits long number |
| O | Ebene 3 Verantwortlicher | U231901 | This is the strategical buyer of the classification item 3rd level. This is the responsible buyer person and rule type default.. Exported must be the staff number, like: UE51083 |
| P | Ebene 3 Stellvertreter | U222029 | This is the strategical deputy buyer of the classification item 3rd level. This is the deputy buyer person and rule type default.. Exported must be the staff number, like: UE51083
|
| Q | Bereich | EIT | This column holds the value from the classification mapping rule "WG SBB - EK-Bereiche". Output is always the target classification item element number like G or PP or EIB etc. from classification item 3rd level. |
| R | Risikoklassifizierung Produktsicherheit | Hoch | This column hold the risk assessment "value identifier" from risk assessment type with identifier "RK_K800.60" from classification item 3rd level. |
| S | Risikoklassifizierung Nachhaltigkeit | Mittel | This column hold the risk assessment "value identifier" from risk assessment type with identifier "RK_NH" from classification item 3rd level. |
| T | Risikoklassifizierung Cyber Security | Gering | This column hold the risk assessment "value identifier" from risk assessment type with identifier "RK_CS" from classification item 3rd level. |
