| pid_id | int(11) | NO | | PRI | auto_increment | |
| pid_cus_id | int(11) | NO | 0 | | | Customer ID# |
| pid_cli_id | int(11) | NO | 0 | | | Client ID# |
| pid_pat_id | int(11) | NO | 0 | MUL | | Patient ID# |
| pid_udi | varchar(256) | NO | 0 | | | Unique Device Identifier |
| pid_location_code | bigint(20) | NO | 0 | | | SNOMED Code for location of device |
| pid_location_desc | varchar(40) | NO | | | | Description of location |
| pid_implant_date | date | YES | | | | Date of implant |
| pid_device_id | varchar(40) | NO | | | | Description ID |
| pid_lot | varchar(40) | NO | | | | Lot # |
| pid_serial | varchar(40) | NO | | | | Serial # |
| pid_expiration_date | date | YES | | | | Date of expiration |
| pid_manufacture_date | date | YES | | | | Date of manufacturing |
| pid_hct_p | tinyint(1) | NO | 0 | | | HCT/P |
| pid_hct_p_id_code | varchar(40) | NO | | | | HCT/P Code |
| pid_device_description | varchar(256) | NO | | | | Device description |
| pid_brand_name | varchar(256) | NO | | | | Brand name |
| pid_version | varchar(256) | NO | | | | Version or Model # |
| pid_company | varchar(256) | NO | | | | Company name |
| pid_mri_safety_label | varchar(256) | NO | | | | MRI Safety warnings |
| pid_rubber_latex | tinyint(1) | NO | 0 | | | Contains rubber or latex |
| pid_inactive | tinyint(1) | NO | 0 | | | Is inactive |
| pid_inactive_reason | text | NO | | | | Reason for inactive |
| pid_modified | timestamp | YES | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |
| pid_created | timestamp | YES | CURRENT_TIMESTAMP | | | |
| pid_cp_id | int(11) | YES | | MUL | | Linked procedure event when device was implanted |