WBW2 ZStoDAS Export - Revision history

Reneschneider: /* Related Articles */

2024-07-18T10:21:57Z

← Older revision		Revision as of 10:21, 18 July 2024
Line 125:		Line 125:
	\|This column hold the value "Ja" or "Nein" depening on the classification item flag.[[File:DAS ist veraltet.png\|none\|thumb]]		\|This column hold the value "Ja" or "Nein" depening on the classification item flag.[[File:DAS ist veraltet.png\|none\|thumb]]
	\|}		\|}

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

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

Reneschneider: /* Related Articles */

2024-07-18T08:18:29Z

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

	==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: /* Material_Group_Attributes.csv */

2024-06-20T14:10:20Z

Material_Group_Attributes.csv

← Older revision		Revision as of 14:10, 20 June 2024
Line 110:		Line 110:
	\|L		\|L
	\|MAIN_OPE		\|MAIN_OPE
	\|Is the operative buyer is of the classification item with procurement path rule and procurement path idetifier "OPE". It is then the responsible buyer person. Exported must be the staff number, like: ~~UE51083~~		\|Is the operative buyer is of the classification item with procurement path rule and procurement path idetifier "OPE". It is then the responsible buyer person. Exported must be the staff number, like: Melanie Maric
	'''Important''': It can be that the operative manager is maitained on classification level 2 and inherited to level 3. If this is the case then this employee must be taken from the second level.[[File:Main ope.png\|none\|thumb]]		'''Important''': It can be that the operative manager is maitained on classification level 2 and inherited to level 3. If this is the case then this employee must be taken from the second level.[[File:Main ope.png\|none\|thumb]]
	\|-		\|-

Reneschneider: /* Material_Group_Attributes.csv */

2024-06-20T13:15:45Z

Material_Group_Attributes.csv

← Older revision		Revision as of 13:15, 20 June 2024
Line 73:		Line 73:
	\|It is alwas the 9 digits long classification number but only the level 3		\|It is alwas the 9 digits long classification number but only the level 3
	\|-		\|-
	\|C		\|D
	\|Category Manager 2		\|Category Manager 2
	\|Is the strategical buyer is of the classification item with procurement path rule and procurement path idetifier "CM_2". It is then the responsible buyer person. Exported must be the staff number, like: UE51083		\|Is the strategical buyer is of the classification item with procurement path rule and procurement path idetifier "CM_2". It is then the responsible buyer person. Exported must be the staff number, like: UE51083
	'''Important''': Normaly case will 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:Category2 mgt.png\|none\|thumb]]		'''Important''': Normaly case will 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:Category2 mgt.png\|none\|thumb]]
	\|-		\|-
	\|D		\|E
	\|Category Manager 3		\|Category Manager 3
	\|Is the strategical buyer is of the classification item with procurement path rule and procurement path idetifier "CM_3". It is then the responsible buyer person. Exported must be the staff number, like: UE51083		\|Is the strategical buyer is of the classification item with procurement path rule and procurement path idetifier "CM_3". It is then the responsible buyer person. Exported must be the staff number, like: UE51083
Line 84:		Line 84:

	\|-		\|-
	\|E		\|F
	\|Risk Class		\|Risk Class
	\|This column hold the risk assessment "value identifier" from risk assessment with identifier "RK_K800.60".		\|This column hold the risk assessment "value identifier" from risk assessment with identifier "RK_K800.60".
	\|-		\|-
	\|F		\|G
	\|Sustainable Class		\|Sustainable Class
	\|This column hold the risk assessment "value identifier" from risk assessment with identifier "RK_NH".		\|This column hold the risk assessment "value identifier" from risk assessment with identifier "RK_NH".
	\|-		\|-
	\|G		\|H
	\|Cybersecurity Class		\|Cybersecurity Class
	\|This column hold the risk assessment "value identifier" from risk assessment with identifier "RK_CS".		\|This column hold the risk assessment "value identifier" from risk assessment with identifier "RK_CS".
	\|-		\|-
	\|H		\|I
	\|Division_BP		\|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.		\|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.
	\|-		\|-
	\|I		\|J
	\|Team_OPE		\|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]]		\|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]]
	\|-		\|-
	\|J		\|K
	\|Teamlead_OPE		\|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]]		\|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]]
	\|-		\|-
	\|K		\|L
	\|MAIN_OPE		\|MAIN_OPE
	\|Is the operative buyer is of the classification item with procurement path rule and procurement path idetifier "OPE". It is then the responsible buyer person. Exported must be the staff number, like: UE51083		\|Is the operative buyer is of the classification item with procurement path rule and procurement path idetifier "OPE". It is then the responsible buyer person. Exported must be the staff number, like: UE51083
	'''Important''': It can be that the operative manager is maitained on classification level 2 and inherited to level 3. If this is the case then this employee must be taken from the second level.[[File:Main ope.png\|none\|thumb]]		'''Important''': It can be that the operative manager is maitained on classification level 2 and inherited to level 3. If this is the case then this employee must be taken from the second level.[[File:Main ope.png\|none\|thumb]]
	\|-		\|-
	\|L		\|M
	\|EKG_R3		\|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]]		\|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]]
	\|-		\|-
	\|M		\|N
	\|EKG_S4		\|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]]		\|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]]
	\|-		\|-
	\|N		\|O
	\|Ist veraltet		\|Ist veraltet
	\|This column hold the value "Ja" or "Nein" depening on the classification item flag.[[File:DAS ist veraltet.png\|none\|thumb]]		\|This column hold the value "Ja" or "Nein" depening on the classification item flag.[[File:DAS ist veraltet.png\|none\|thumb]]

Reneschneider: /* Material_Group_Attributes.csv */

2024-06-20T13:15:02Z

Material_Group_Attributes.csv

← Older revision		Revision as of 13:15, 20 June 2024
Line 62:		Line 62:
	\|-		\|-
	\|A		\|A
			\|WG Level 1
			\|It is alwas the 9 digits long classification number but only the level 1
			\|-
			\|B
			\|WG Level 2
			\|It is alwas the 9 digits long classification number but only the level 2
			\|-
			\|C
	\|Warengruppe		\|Warengruppe
	\|It is alwas the 9 digits long classification number but only the level 3		\|It is alwas the 9 digits long classification number but only the level 3
	\|-		\|-
	\|B		\|C
	\|Category Manager 2		\|Category Manager 2
	\|Is the strategical buyer is of the classification item with procurement path rule and procurement path idetifier "CM_2". It is then the responsible buyer person. Exported must be the staff number, like: UE51083		\|Is the strategical buyer is of the classification item with procurement path rule and procurement path idetifier "CM_2". It is then the responsible buyer person. Exported must be the staff number, like: UE51083
	'''Important''': Normaly case will 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:Category2 mgt.png\|none\|thumb]]		'''Important''': Normaly case will 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:Category2 mgt.png\|none\|thumb]]
	\|-		\|-
	\|C		\|D
	\|Category Manager 3		\|Category Manager 3
	\|Is the strategical buyer is of the classification item with procurement path rule and procurement path idetifier "CM_3". It is then the responsible buyer person. Exported must be the staff number, like: UE51083		\|Is the strategical buyer is of the classification item with procurement path rule and procurement path idetifier "CM_3". It is then the responsible buyer person. Exported must be the staff number, like: UE51083
Line 76:		Line 84:

	\|-		\|-
	\|D		\|E
	\|Risk Class		\|Risk Class
	\|This column hold the risk assessment "value identifier" from risk assessment with identifier "RK_K800.60".		\|This column hold the risk assessment "value identifier" from risk assessment with identifier "RK_K800.60".
	\|-		\|-
	\|E		\|F
	\|Sustainable Class		\|Sustainable Class
	\|This column hold the risk assessment "value identifier" from risk assessment with identifier "RK_NH".		\|This column hold the risk assessment "value identifier" from risk assessment with identifier "RK_NH".
	\|-		\|-
	\|F		\|G
	\|Cybersecurity Class		\|Cybersecurity Class
	\|This column hold the risk assessment "value identifier" from risk assessment with identifier "RK_CS".		\|This column hold the risk assessment "value identifier" from risk assessment with identifier "RK_CS".
	\|-		\|-
	\|G		\|H
	\|Division_BP		\|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.		\|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		\|I
	\|Team_OPE		\|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]]		\|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		\|J
	\|Teamlead_OPE		\|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]]		\|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		\|K
	\|MAIN_OPE		\|MAIN_OPE
	\|Is the operative buyer is of the classification item with procurement path rule and procurement path idetifier "OPE". It is then the responsible buyer person. Exported must be the staff number, like: UE51083		\|Is the operative buyer is of the classification item with procurement path rule and procurement path idetifier "OPE". It is then the responsible buyer person. Exported must be the staff number, like: UE51083
	'''Important''': It can be that the operative manager is maitained on classification level 2 and inherited to level 3. If this is the case then this employee must be taken from the second level.[[File:Main ope.png\|none\|thumb]]		'''Important''': It can be that the operative manager is maitained on classification level 2 and inherited to level 3. If this is the case then this employee must be taken from the second level.[[File:Main ope.png\|none\|thumb]]
	\|-		\|-
	\|K		\|L
	\|EKG_R3		\|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]]		\|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		\|M
	\|EKG_S4		\|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]]		\|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		\|N
	\|Ist veraltet		\|Ist veraltet
	\|This column hold the value "Ja" or "Nein" depening on the classification item flag.[[File:DAS ist veraltet.png\|none\|thumb]]		\|This column hold the value "Ja" or "Nein" depening on the classification item flag.[[File:DAS ist veraltet.png\|none\|thumb]]

Reneschneider: /* Material_Group_Attributes.csv */

2024-06-17T08:45:15Z

Material_Group_Attributes.csv

← Older revision		Revision as of 08:45, 17 June 2024
Line 102:		Line 102:
	\|J		\|J
	\|MAIN_OPE		\|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]]		\|Is the operative buyer is of the classification item with procurement path rule and procurement path idetifier "OPE". It is then the responsible buyer person. Exported must be the staff number, like: UE51083
			'''Important''': It can be that the operative manager is maitained on classification level 2 and inherited to level 3. If this is the case then this employee must be taken from the second level.[[File:Main ope.png\|none\|thumb]]
	\|-		\|-
	\|K		\|K

Reneschneider: /* Material_Group_Attributes.csv */

2024-06-17T08:36:23Z

Material_Group_Attributes.csv

← Older revision		Revision as of 08:36, 17 June 2024
Line 66:		Line 66:
	\|-		\|-
	\|B		\|B
	\|~~Lead Buyer~~		\|Category Manager 2
	\|~~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]]		\|Is the strategical buyer is of the classification item with procurement path rule and procurement path idetifier "CM_2". It is then the responsible buyer person. Exported must be the staff number, like: UE51083
			'''Important''': Normaly case will 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:Category2 mgt.png\|none\|thumb]]
	\|-		\|-
	\|C		\|C
	\|Category Manager		\|Category Manager 3
	\|~~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]]		\|Is the strategical buyer is of the classification item with procurement path rule and procurement path idetifier "CM_3". It is then the responsible buyer person. Exported must be the staff number, like: UE51083
			'''Important''': Normaly case will 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:Category-mgt.png\|none\|thumb]]Important: Normaly case will 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.

	\|-		\|-
	\|D		\|D

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:04:54Z

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]]