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 | Is the strategical buyer is of the classification item with procurement path rule and procurement path idetifier "CM_2". Search the employee always on level 3. It is then the responsible buyer person. Exported must be the staff number, like: UE51083 Important: It can be that the category 2 manager is maitained on classification level 2 and inherited to level 3. If this is the case then this employee must be taken. |
| J | Ebene 2 Stellvertreter | U231901 | Is the strategical buyer is of the classification item with procurement path rule and procurement path idetifier "CM_2". Search the employee always on level 3. It is then the deputy buyer person. Exported must be the staff number, like: UE51083 Important: It can be that the category 2 manager is maitained on classification level 2 and inherited to level 3. If this is the case then this employee must be taken. |
| 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 | Is the strategical buyer is of the classification item with procurement path rule and procurement path idetifier "CM_3". Search the employee always on level 3. It is then the responsible buyer person. Exported must be the staff number, like: UE51083 Important: It can be that the category 2 manager is maitained on classification level 2 and inherited to level 3. If this is the case then this employee must be taken. |
| P | Ebene 3 Stellvertreter | U222029 | Is the strategical buyer is of the classification item with procurement path rule and procurement path idetifier "CM_3". Search the employee always on level 3. It is then the deputy buyer person. Exported must be the staff number, like: UE51083 Important: It can be that the category 2 manager is maitained on classification level 2 and inherited to level 3. If this is the case then this employee must be taken. |
| 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. If no assignment exist this field stays empty. |
| 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. If no assignment exist this field stays empty. |
| 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. If no assignment exist this field stays empty. |
| 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. If no assignment exist this field stays empty. |
