Changes

79 bytes removed ,  16:12, 4 May 2022
no edit summary
Line 68: Line 68:  
|no decode available in system
 
|no decode available in system
 
|}
 
|}
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.
    
=== DEVICE_ID ===
 
=== DEVICE_ID ===