Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Current »

The 3-3-2 method is strategy for assigning ID values to master file records that contain longer names with no particular pattern (e.g., like Customer and Vendor Names). It builds IDs by taking the first 3 characters of the first word, the first 3 characters of the second word, and the first 2 characters of the third word. For example, "Charles Schwab Retirement" would be assigned an ID of "CHASCHRE", and "Greenway Foods" would be assigned an ID of "GREFOO". If this method results in a duplicate ID, the just add an additional digit to a segment(s).

This is an easy method and ensures that all your IDs will be close to the same length and follow a consistent pattern.

  • No labels