_999.patients_implantable_devices
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| pid_id | int(11) | NO | PRI | auto_increment | ||
| pid_cp_id | int(11) | YES | MUL | Linked procedure event when device was implanted | ||
| 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 | datetime | YES | CURRENT_TIMESTAMP | |||
| pid_created | datetime | YES | CURRENT_TIMESTAMP |
References
| Local Column | References | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| pid_id |
|