− | Of these, the DEVICE_ID is the most important, being a consistent and unique identifier used across the system to refer to a device. We also often use the TRADE_NAME, as it is more understandable to humans than DEVICE_IDs are. USAGE_CODE, PREF_NAME_CODE (PNC), and GMDN_CODE are various ways to group devices together, in increasingly precise ways, and RISK_CLASSIFICATION is used as a loose “risk level” of devices. The remaining fields are a pair of dates that we seldom use, a flag for whether the device is under the “new” regulations, and an “obsolete” flag, none of which we tend to use in our queries (but we could). | + | Of these, the DEVICE_ID is the most important, being a consistent and unique identifier used across the system to refer to a device. We also often use the TRADE_NAME, as it is more understandable to humans than DEVICE_IDs are. USAGE_CODE, PREF_NAME_CODE (PNC), and GMDN_CODE are various ways to group devices together, in increasingly precise ways, and RISK_CLASSIFICATION is used as a loose “risk level” of devices. The remaining fields are a pair of dates, a flag for whether the device is under the “new” regulations, and an “obsolete” flag. |