WBW2 ZStoWGS Export

Material_Level.csv

The fields for export were agreed on 5 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	Description how to pull data from ZUGSEIL
A	Warengruppennummer Level 1 und 2	It is alwas the 9 digits long classification number but only the level 1 and 2
B	Sprache	Language code DE, EN, IT, FR
C	Warengruppenbezeichnung	Name of the classification item in specific language

Material_Group.csv

The fields for export were agreed on 5 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	Description how to pull data from ZUGSEIL
A	Warengruppennummer Level 3	It is alwas the 9 digits long classification number but only the level 3
B	Sprache	Language code DE, EN, IT, FR
C	Warengruppenbezeichnung	Name of the classification item in specific language

Material_Group_Attributes.csv

The fields for export were agreed on 5 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	Description how to pull data from ZUGSEIL
A	Warengruppe	It is alwas the 9 digits long classification number but only the level 3
B	Lead Buyer	The Lead buyer is of the classification item. This is the responsible buyer person and rule type default. Exported must be the staff number, like: UE51083
C	Category Manager	The strategical buyer is of the classification item. This is the responsible buyer person and rule type default.. Exported must be the staff number, like: UE51083
D	Risk Class	This column hold the risk assessment "value identifier" from risk assessment with identifier "RK_K800.60".
E	Sustainable Class	This column hold the risk assessment "value identifier" from risk assessment with identifier "RK_NH".
F	Cybersecurity Class	This column hold the risk assessment "value identifier" from risk assessment with identifier "RK_CS".
G	Division_BP	Thi 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.
H	Team_OPE	The operative buyer is of the classification item. This is the value from field area description. But only in case the rule type is "procurement path rule" and the procurement path with identifier "TL_OPE"
I	Teamlead_OPE	The operative buyer is of the classification item. This is the name (first and last) from the responsible person. But only in case the rule type is "procurement path rule" and the procurement path with identifier "TL_OPE"
J	MAIN_OPE	The operative buyer is of the classification item. This is the name (first and last) from the responsible person. But only in case the rule type is "default".
K	EKG_R3	This is the operative buyer R3 group is of the classification item. Output must be the goup number but only in case the rule type is "procurement path rule" and the procurement path with identifier "EKG_R3"
L	EKG_S4	This is the operative buyer S4 group is of the classification item. Output must be the goup number but only in case the rule type is "procurement path rule" and the procurement path with identifier "EKG_S4"
M	Ist veraltet	This column hold the value "Ja" or "Nein" depening on the classification item flag.