WBW2 ZStoWGS Export - Revision history

Reneschneider: /* Related Articles */

2024-07-18T10:19:26Z

← Older revision		Revision as of 10:19, 18 July 2024
Line 117:		Line 117:
	\|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.		\|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.
	\|}		\|}

			== WGS Export ==
			The WGS export can be exported over the [[App:SBB-WBW-Import-Export\|SBB-WBW-Import-Export]] / SBB WG WGS Export

	==Related Articles==		==Related Articles==

Reneschneider: /* Related Articles */

2024-07-18T08:18:49Z

← Older revision		Revision as of 08:18, 18 July 2024
Line 119:		Line 119:

	==Related Articles==		==Related Articles==
	[[SBB:WBW Parallelinstanz & Customizing]]		[[SBB:WBW Parallelinstanz & Customizing\|WBW Parallelinstanz & Customizing]]

			[[App:SBB-WBW-Import-Export\|SBB-WBW-Import-Export]]

Reneschneider at 09:02, 17 June 2024

2024-06-17T09:02:07Z

← Older revision		Revision as of 09:02, 17 June 2024
Line 87:		Line 87:
	\|Ebene 3 Verantwortlicher		\|Ebene 3 Verantwortlicher
	\|U231901		\|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. If ~~no assignment exist~~ this ~~field stays empty~~.[[File:~~Strategic officer~~.png\|none\|thumb]]		\|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.[[File:Cat2mgtres.png\|none\|thumb]]
	\|-		\|-
	\|P		\|P
	\|Ebene 3 Stellvertreter		\|Ebene 3 Stellvertreter
	\|U222029		\|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. If ~~no assignment exist~~ this ~~field stays empty~~.[[File:~~Deputy officer~~.png\|none\|thumb]]		\|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.[[File:Cat2mgtdep.png\|none\|thumb]]

	\|-		\|-

Reneschneider: /* WGS-Tool_WBW-Export.csv */

2024-06-17T08:59:37Z

WGS-Tool_WBW-Export.csv

← Older revision		Revision as of 08:59, 17 June 2024
Line 55:		Line 55:
	\|Ebene 2 Verantwortlicher		\|Ebene 2 Verantwortlicher
	\|U222029		\|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. If ~~no assignment exist~~ this ~~field stays empty~~.[[File:~~Strategic officer~~.png\|none\|thumb]]		\|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.[[File:Cat2mgtres.png\|none\|thumb]]
	\|-		\|-
	\|J		\|J
	\|Ebene 2 Stellvertreter		\|Ebene 2 Stellvertreter
	\|U231901		\|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. If ~~no assignment exist~~ this ~~field stays empty~~.[[File:~~Strategic officer~~.png\|none\|thumb]]		\|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.[[File:Cat2mgtdep.png\|none\|thumb]]
	\|-		\|-
	\|K		\|K

Reneschneider: /* Related Articles */

2024-06-14T06:49:04Z

← Older revision		Revision as of 06:49, 14 June 2024
Line 55:		Line 55:
	\|Ebene 2 Verantwortlicher		\|Ebene 2 Verantwortlicher
	\|U222029		\|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[[File:Strategic officer.png\|none\|thumb]]		\|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. If no assignment exist this field stays empty.[[File:Strategic officer.png\|none\|thumb]]
	\|-		\|-
	\|J		\|J
	\|Ebene 2 Stellvertreter		\|Ebene 2 Stellvertreter
	\|U231901		\|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[[File:Strategic officer.png\|none\|thumb]]		\|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. If no assignment exist this field stays empty.[[File:Strategic officer.png\|none\|thumb]]
	\|-		\|-
	\|K		\|K
Line 85:		Line 85:
	\|Ebene 3 Verantwortlicher		\|Ebene 3 Verantwortlicher
	\|U231901		\|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[[File:Strategic officer.png\|none\|thumb]]		\|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. If no assignment exist this field stays empty.[[File:Strategic officer.png\|none\|thumb]]
	\|-		\|-
	\|P		\|P
	\|Ebene 3 Stellvertreter		\|Ebene 3 Stellvertreter
	\|U222029		\|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[[File:Deputy officer.png\|none\|thumb]]		\|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. If no assignment exist this field stays empty.[[File:Deputy officer.png\|none\|thumb]]


Line 97:		Line 97:
	\|Bereich		\|Bereich
	\|EIT		\|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.		\|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		\|R
	\|Risikoklassifizierung Produktsicherheit		\|Risikoklassifizierung Produktsicherheit
	\|Hoch		\|Hoch
	\|This column hold the risk assessment "value identifier" from risk assessment type with identifier "RK_K800.60" from classification item 3rd level.		\|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		\|S
	\|Risikoklassifizierung Nachhaltigkeit		\|Risikoklassifizierung Nachhaltigkeit
	\|Mittel		\|Mittel
	\|This column hold the risk assessment "value identifier" from risk assessment type with identifier "RK_NH" from classification item 3rd level.		\|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		\|T
	\|Risikoklassifizierung Cyber Security		\|Risikoklassifizierung Cyber Security
	\|Gering		\|Gering
	\|This column hold the risk assessment "value identifier" from risk assessment type with identifier "RK_CS" from classification item 3rd level.		\|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.
	\|}		\|}

	==Related Articles==		==Related Articles==
	[[SBB:WBW Parallelinstanz & Customizing]]		[[SBB:WBW Parallelinstanz & Customizing]]

Reneschneider: /* WGS-Tool_WBW-Vorlage.csv */

2024-06-13T12:50:50Z

WGS-Tool_WBW-Vorlage.csv

← Older revision		Revision as of 12:50, 13 June 2024
Line 1:		Line 1:
	==WGS-Tool_WBW-~~Vorlage~~.csv==		==WGS-Tool_WBW-Export.csv==
	The fields for export were agreed on 16 June 2024 together with Peter Staufer (SBB).		The fields for export were agreed on 16 June 2024 together with Peter Staufer (SBB).

Reneschneider at 12:50, 13 June 2024

2024-06-13T12:50:06Z

← Older revision		Revision as of 12:50, 13 June 2024
Line 30:		Line 30:
	\|Ebene 1 (#)		\|Ebene 1 (#)
	\|300000000		\|300000000
	\|		\|Classification item number 1st level, full 9 digits long number
	\|-		\|-
	\|E		\|E
	\|Ebene 2 - de		\|Ebene 2 - de
	\|Energieanlagen		\|Energieanlagen
	\|		\|German name of the classification item 2nd level from "SBB Warengruppen" schema
	\|-		\|-
	\|F		\|F
	\|Ebene 2 - fr		\|Ebene 2 - fr
	\|Installations énergétiques		\|Installations énergétiques
	\|		\|French name of the classification item 2nd level from "SBB Warengruppen" schema
	\|-		\|-
	\|G		\|G
	\|Ebene 2 - it		\|Ebene 2 - it
	\|Sistemi energetici		\|Sistemi energetici
	\|		\|Italien name of the classification item 2nd level from "SBB Warengruppen" schema
	\|-		\|-
	\|H		\|H
	\|Ebene 2 (#)		\|Ebene 2 (#)
	\|301300000		\|301300000
	\|		\|Classification item number 2nd level, full 9 digits long number
	\|-		\|-
	\|I		\|I
	\|Ebene 2 Verantwortlicher		\|Ebene 2 Verantwortlicher
	\|U222029		\|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[[File:Strategic officer.png\|none\|thumb]]
	\|-		\|-
	\|J		\|J
	\|Ebene 2 Stellvertreter		\|Ebene 2 Stellvertreter
	\|U231901		\|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[[File:Strategic officer.png\|none\|thumb]]
	\|-		\|-
	\|K		\|K
	\|Ebene 3 - de		\|Ebene 3 - de
	\|Freileitungstechnik (Instandhaltung)		\|Freileitungstechnik (Instandhaltung)
	\|		\|German name of the classification item 3rd level from "SBB Warengruppen" schema
	\|-		\|-
	\|L		\|L
	\|Ebene 3 - fr		\|Ebene 3 - fr
	\|Technique des lignes aériennes (maintenance)		\|Technique des lignes aériennes (maintenance)
	\|		\|French name of the classification item 3rd level from "SBB Warengruppen" schema
	\|-		\|-
	\|M		\|M
	\|Ebene 3 - it		\|Ebene 3 - it
	\|Tecnologia delle linee aeree (manutenzione)		\|Tecnologia delle linee aeree (manutenzione)
	\|		\|Italien name of the classification item 3rd level from "SBB Warengruppen" schema
	\|-		\|-
	\|N		\|N
	\|Ebene 3 (#)		\|Ebene 3 (#)
	\|301305000		\|301305000
	\|		\|Classification item number 3rd level, full 9 digits long number
	\|-		\|-
	\|O		\|O
	\|Ebene 3 Verantwortlicher		\|Ebene 3 Verantwortlicher
	\|U231901		\|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[[File:Strategic officer.png\|none\|thumb]]
	\|-		\|-
	\|P		\|P
	\|Ebene 3 Stellvertreter		\|Ebene 3 Stellvertreter
	\|U222029		\|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[[File:Deputy officer.png\|none\|thumb]]


	\|-		\|-
	\|Q		\|Q
	\|Bereich		\|Bereich
	\|EIT		\|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		\|R
	\|Risikoklassifizierung Produktsicherheit		\|Risikoklassifizierung Produktsicherheit
	\|Hoch		\|Hoch
	\|		\|This column hold the risk assessment "value identifier" from risk assessment type with identifier "RK_K800.60" from classification item 3rd level.
	\|-		\|-
	\|S		\|S
	\|Risikoklassifizierung Nachhaltigkeit		\|Risikoklassifizierung Nachhaltigkeit
	\|Mittel		\|Mittel
	\|		\|This column hold the risk assessment "value identifier" from risk assessment type with identifier "RK_NH" from classification item 3rd level.
	\|-		\|-
	\|T		\|T
	\|Risikoklassifizierung Cyber Security		\|Risikoklassifizierung Cyber Security
	\|Gering		\|Gering
	\|		\|This column hold the risk assessment "value identifier" from risk assessment type with identifier "RK_CS" from classification item 3rd level.
	\|}		\|}

	==Related Articles==		==Related Articles==
	[[SBB:WBW Parallelinstanz & Customizing]]		[[SBB:WBW Parallelinstanz & Customizing]]

Reneschneider: /* ???.csv */

2024-06-13T12:26:21Z

???.csv

@@ Line 1: / Line 1: @@
-==???.csv==
+==WGS-Tool_WBW-Vorlage.csv==
-The fields for export were agreed on 5 June 2024 together with Peter Staufer (SBB).
+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".
@@ Line 9: / Line 9: @@
 !Excel view column
 !Column Name
 !Description how to pull data from ZUGSEIL
 |-
 |A
-|???
+|Ebene 1 - de
-|???
+|Anlagen
 |-
 |B
-|???
+|Ebene 1 - fr
-|???
+|Installations
 |-
 |C
-|???
+|Ebene 1 - it
-|???
+|Strutture
 |}
 ==Related Articles==
 [[SBB:WBW Parallelinstanz & Customizing]]

Reneschneider: /* Material_Level.csv */

2024-06-05T14:52:19Z

Material_Level.csv

@@ Line 1: / Line 1: @@
-==Material_Level.csv==
+==???.csv==
 The fields for export were agreed on 5 June 2024 together with Peter Staufer (SBB).
@@ Line 12: / Line 12: @@
 |-
 |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
+|???
 |}
 ==Related Articles==
 [[SBB:WBW Parallelinstanz & Customizing]]

Reneschneider: Created page with "==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. {| class="wikitable" |+ !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..."

2024-06-05T14:51:19Z

Created page with "==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. {| class="wikitable" |+ !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..."

New page

==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.
{| class="wikitable"
|+
!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.

{| class="wikitable"
!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.

{| class="wikitable"
!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[[File:DAS Lead Buyer.png|none|thumb]]
|-
|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[[File:DAS strategical buyer.png|none|thumb]]
|-
|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"[[File:DAS operative buyer devision description.png|none|thumb]]
|-
|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"[[File:DAS Teamlead OPE.png|none|thumb]]
|-
|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".[[File:DAS MAIN OPE.png|none|thumb]]
|-
|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"[[File:DAS EKG R3.png|none|thumb]]
|-
|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"[[File:DAS EKG S4.png|none|thumb]]
|-
|M
|Ist veraltet
|This column hold the value "Ja" or "Nein" depening on the classification item flag.[[File:DAS ist veraltet.png|none|thumb]]
|}

==Related Articles==
[[SBB:WBW Parallelinstanz & Customizing]]