Migrating to current TRBC industry codes

As I mentioned in an earlier post, TRBC codes changed over time. This article lists the older codes and how to replace them with the current ones, known as TRBC 2012.

The earliest version of Thomson Reuters Business Classification was called Reuters Business Sector Scheme (RBSS). All RBSS codes were 5 digits long. In 2008 the classification was renamed to TRBC and codes were changed to their current form, where top-level codes have 2 digits, and each consecutive level adds 2 more digits.
In order to change a RBSS code to TRBC, apply these changes:

• Add 0 after every digit, starting with the 3rd one
• Remove all pairs of consecutive zeroes

Examples:

• code 50000 becomes 50000000 after first step, then 50 after second
• code 50131 becomes 50103010 after first step, no change in second

T-SQL code snippet to change the codes:
REPLACE(STUFF(STUFF(STUFF(RBSS_Code,6,0,'0'),5,0,'0'),4,0,'0'),'00','')


Also, some codes were changed during the migration to TRBC. After that these was another revision of TRBC codes in 2012, when 5th level of classification was added and more codes were changed. Summary of all changes (after changing codes from RBSS to TRBC using method outlined above):

• RBSS codes starting with 9 (90000 / Governmental services, 90010 / Non-profit organizations, 90099 / Subject to further review) were removed from the classification
• 50104010 Renewable Energy Equipment & Services was changed to 50201010 / Renewable Energy Equipment & Services
• 50104020 Renewable Fuels was changed to 50201020 / Renewable Fuels
• 52201010 / Construction - Supplies and Fixtures changed to 53203020 / Construction Supplies & Fixtures
• 52203050 / Commercial Services and Supplies was discontinued
• 52401010 / Air Freight & Courier Services (4) changed to 52405010 / Air Freight & Courier Services
• 52402010 / Airlines changed to 52406010 / Airlines
• 52402020 / Airport Services changed to 52407010 / Airport Services
• 52403010 / Marine Transportation changed to 52405020 / Marine Freight & Logistics
• 52403020 / Marine Port Services changed to 52407020 / Marine Port Services
• 52404010 / Rails & Roads - Passengers changed to 52406020 / Passenger Transportation, Ground & Sea
  
• 52404020 / Rails & Roads - Freights changed to 52405030 / Ground Freight & Logistics
  
• 52404030 / Highways & Railtracks changed to 52407030 / Highways & Rail Tracks
  
• 53201010 / Homebuilding changed to 53203010 / Homebuilding
  
• 53201020 / Consumer Electronics was discontinued
• 53201030 / Appliances, Tools & Housewares changed to 53204030 / Appliances, Tools & Housewares
  
• 53201040 / Home Furnishing changed to 53204040 / Home Furnishings
  
• 53201050 / Leisure Products was split to 53205010 / Toys & Juvenile Products and 53205020 / Recreational Products
• 53204020 / Consumer Electronics was discontinued
• 53302090 / Media Diversified was discontinued
• 53401010 / Retail - Department Stores changed to 53402010 / Department Stores
  
• 53401020 / Retail - Discount Stores changed to 53402020 / Discount Stores
  
• 53401030 / Retail - Catalog & Internet Order was discontinued
• 53401040 / Retail - Apparel & Accessories changed to 53403040 / Apparel & Accessories Retailers
  
• 53401050 / Retail - Computers & Electronics changed to 53403050 / Computer & Electronics Retailers
  
• 53401060 / Retail - Specialty changed to 53403090 / Miscellaneous Specialty Retailers
  
• 55101040 / Investment Services was split under 551020 / Investment Banking & Investment Services
• 55102040 / Specialty Investment Services was discontinued
• 55103010 / Diversified Financial Services was discontinued
• 55201020 / Financial Services - Diversified (4) was discontinued
• 55301060 / Insurance Brokers was discontinued
• 55401010 / Real Estate Operations changed to 554020 / Real Estate Operations
  
• 55401020 / REIT - Residential & Commercial was split under 554030 / Residential & Commercial REITs
  
• 56201010 / Pharmaceuticals - Diversified was merged to 56201040 / Pharmaceuticals (4)
  
• 56201020 / Biotechnology changed to 56202010 / Biotechnology & Medical Research (4)
  
• 56201030 / Pharmaceuticals - Generic & Specialty was merged to 56201040 / Pharmaceuticals (4)
  
• 57103010 / Computer Hardware changed to 57106010 / Computer Hardware
  
• 57103020 / Office Equipment changed to 57105010 / Office Equipment (4)