Part Commodity CodesFor the Hexagon EAM part master Draft ยท not yet loaded into EAM

Conventions, assumptions and QA

The package README, section by section.

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.