PART COMMODITY CODES - DRAFT PACKAGE Hexagon EAM (formerly Infor EAM) - Part Master commodity assignment Prepared 16 November 2026 ------------------------------------------------------------------ WHAT IS IN THIS PACKAGE ------------------------------------------------------------------ Part_Commodity_Codes_Draft.xlsx The main deliverable. Five sheets: README - conventions, assumptions, QA notes Part Commodity Codes - full list with group and typical contents (review sheet) EAM Import - two columns only, same layout as the supplier draft Legacy EAM Mapping - all 233 canned EAM commodities crosswalked Prefix Legend - what each prefix covers, plus per-group counts part_commodity_codes_webpage.html Standalone searchable version of the same content. Open it in any browser - no internet connection needed except for web fonts. Three tabs: code list, legacy crosswalk, conventions and notes. Search box filters live across code, description and contents. csv/ 01_part_commodity_codes_full.csv Group, code, description, typical contents 02_eam_import.csv Code + description only - the load file 03_legacy_eam_crosswalk.csv Legacy code -> new code, with action per row 04_prefix_legend.csv Prefix meanings 05_group_counts.csv Code count per group source_files/ The two files this was built from, kept for traceability: Part_Commodity_Codes_in_Gen_Bridge_PRD_EAM_25Aug26.xlsx (canned EAM list) Supplier_Commodity_Codes_-_Draft_04Nov25.xlsx (style reference) ------------------------------------------------------------------ THE NUMBERS ------------------------------------------------------------------ 557 part commodity codes across 45 groups 233 legacy EAM commodities crosswalked 144 direct equivalent 68 recoded to a catch-all, to be refined with a part export 21 flagged for retirement Longest code: 18 characters (field allows ~50) Longest description: 64 characters ------------------------------------------------------------------ CODE CONVENTIONS ------------------------------------------------------------------ Character set Uppercase A-Z, digits, space, hyphen, ampersand. No leading or trailing spaces. Style Mnemonic alpha, matching the existing Supplier Commodity Codes draft (VLV GATE, GT BLADE, SAFE FALL PROTECT). Structure Flat code list with a readable prefix. The Group column gives a one-level rollup for spend and inventory reporting without needing a second EAM field. Catch-alls Every family ends in a "... PARTS OTHER" code so no part record has to be left blank. Track these - a family whose catch-all keeps growing has earned a new code. MISC UNCLASSIFIED Temporary landing spot for parts that cannot be classified on first pass. Should trend to zero; do not let it become permanent. ------------------------------------------------------------------ SCOPE AND ASSUMPTIONS ------------------------------------------------------------------ Perspective Owner/operator. Codes describe what the stations BUY and STOCK, not what an OEM builds. In scope Gas turbine, steam turbine, HRSG, diesel and recip gensets, dual-fuel backup, balance of plant, T&D and substation, plus all general workplace and indirect purchases made at the stations. Out of scope Hydro, wind, solar, nuclear. PS97 (Nuclear) is flagged for retirement. Services Excluded - those belong in the Supplier Commodity Codes list. The one exception is MISC SERVICE ITEM, for non-stock expense lines that sit on part records today (for example the canned "Electricity" commodity). Gas utility PS48, PS49 and PS73 look like legacy gas-distribution buckets and are flagged for retirement. Confirm before deleting. Standards No UNSPSC / NAICS / eCl@ss mapping was requested, so none is applied. A column can be added later. Part data No part master export was available, so the list is built from the two source files plus standard power station storeroom categories. ------------------------------------------------------------------ ISSUES FOUND IN THE SUPPLIER COMMODITY DRAFT ------------------------------------------------------------------ Worth fixing in Supplier_Commodity_Codes_-_Draft_04Nov25.xlsx while this work is open: 1. Duplicate code. CATERING SVCS appears twice. Row 33 is described as "Cabling - Communications" - the wrong code was pasted. Suggest CABLE COMM SVCS. 2. Duplicate code. VIBRA CTRL BAL appears twice, for "Vibration Control - Monitoring" and "Vibration Control - Balancing". Suggest VIBRA CTRL MON and VIBRA CTRL BAL. 3. Truncated code. "COMP " (Computer Field Device Maintenance) has no suffix. Suggest COMP FIELD MNT. 4. Typo. FILERS REPAIR is described as "Filers - Repair Maintenance". Should read FILTERS REPAIR / Filters. 5. Length outliers. PIPING INSTALL REP and a few others run 17-18 characters while the rest cap at 16. Harmless if the field allows it, but worth standardizing. ------------------------------------------------------------------ NEXT STEPS ------------------------------------------------------------------ 1. Review the Part Commodity Codes sheet and mark anything to add, merge or rename. 2. Confirm the 21 retirements on the Legacy EAM Mapping sheet. 3. Send a part master export (part number, description, UOM, vendor) for bulk auto-assignment by keyword. That is where the 68 catch-all mappings get resolved into real codes. 4. Name the governance owner - who approves new codes, and how requests are submitted.