Transcript GDS MjR3 – Data migrationPalletTypeCode

GDS MjR3 – Data migration
PalletTypeCode - PlatformTypecode
Session: GDS UG
Time:
14:30 – 17:30
Who May Attend: IP
Speaker: Mark Van Eeghem
YAM (Yet Another Mapping)
© 2014 GS1
What?
PalletTypeCode (codelist) 2.8
now maps to
PlatformTypeCode (codelist) MjR
© 2014 GS1
3
Where is platformTypeCode in MjR?
Not here.
This is gone!
© 2014 GS1
4
Where is platformTypeCode in MjR?
Here.
In
PackagingInformationModule
© 2014 GS1
5
Migration Issue 1
PalletTypeCode (GDS 2.8)
PlatformTypeCode (GDS MjR)
Code Value Code Name
Code Value Code Name
1
Soft Wood
27
Unspecified
2
Aluminium
27
Unspecified
4
Hard Wood
27
Unspecified
5
Metal
27
Unspecified
7
Steel
27
Unspecified
8
Wood
27
Unspecified
These are not pallet types… but packaging material type codes
So: no direct mapping to MjR is possible (apart from “27” –Unspecified).
© 2014 GS1
6
Migration Issue 1
PalletTypeCode (GDS 2.8)
PackagingMaterialTypeCode (GDS MjR)
Code Value Code Name
Code Value
Code Name
1
Soft Wood
WOOD_SOFTWOOD
Softwood
2
Aluminium
METAL_ALUMINIUM
Aluminium
4
Hard Wood
WOOD_HARDWOOD
Hardwood
5
Metal
METAL_OTHER
Metal
7
Steel
METAL_STEEL
Steel
8
Wood
WOOD_OTHER
Wood
Here they are, mapped 1-2-1 to packaging material type codes
© 2014 GS1
7
© 2014 GS1
8
The Real Migration Issue 1.
User intervention is required
User and Datapool should discuss:
• Is there a real platformTypeCode the user wants to
pass on apart from “27 – Unspecified”?
• Is so, which one?
© 2014 GS1
9
Action Items for issue 1
1
Datapools must check whether the codes
1,2,4,5,7,8 are being used, and if so,
check with their userbase to see whether
a better, existing platformType is required.
2
Datapools should report back to UG if these
Codes are being used at all.
© 2014 GS1
10
Migration Issue 2: Deprecated values
PalletTypeCode (GDS 2.8)
3
As Specified by the Department of
Transportation (DOT)
6 Standard
17 Wholesale Pallet
18 Pallet 80x100cm
19 Pallet 60x100cm
PlatformTypeCode (GDS MjR)
Code Value Code Name
27
Unspecified
50
Custom
Platform
So: no direct mapping to MjR is possible (apart from “27” –Unspecified or
“50” – Custom Platform).
© 2014 GS1
11
The Real Migration Issue 2.
User intervention is required
User and Datapool should discuss:
• Is there a real platformTypeCode the user wants to
pass on apart from “27 – Unspecified” or “50 –
Custom Platform”?
• Is so, which one?
© 2014 GS1
12
Action Items for issue 2
1
Datapools must check whether the codes
3,6,17,18,19 are being used, and if so,
check with their userbase to see whether
a better, existing platformType is required.
2
Datapools should report back to UG if these
Codes are being used at all.
© 2014 GS1
13
Contact Details
Mark Van Eeghem
Sr Manager Tech Req And Dev
GS1 Global Office
E: [email protected]
W: www.gs1.org