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 charactersCode 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.