Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
PatImplantableDevice
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| PatImplantableDeviceSID | INTEGER | ? | MANDATORY | System generated unique id using the PatImplantableDevice sequence. |
| PracticeID | INTEGER | ? | MANDATORY | FK |
| PatientID | INTEGER | ? | MANDATORY | FK |
| UniqueDeviceIdentifier | CHAR(250) | MANDATORY | Unique Device Identifier. | |
| DeviceIdentifier | CHAR(250) | OPTIONAL | Device Identifier | |
| LotNumber | CHAR(60) | OPTIONAL | Product Info: Lot Number. | |
| SerialNumber | CHAR(60) | OPTIONAL | Production Info: Device serial number | |
| ExpirationDate | DATE | OPTIONAL | Product Info: Expiration Date | |
| ManufacturedDate | DATE | OPTIONAL | Production Info: Manufacture date | |
| Description | CHAR(200) | OPTIONAL | Device Info: Device description. | |
| BrandName | CHARACTER(60) | OPTIONAL | Device Info: Brand Name. | |
| VersionModel | CHAR(60) | OPTIONAL | Device Info: Version Model | |
| CompanyName | CHARACTER(60) | OPTIONAL | Device Info: Company Name | |
| MRISafetyInfo | CHAR(200) | OPTIONAL | Device Info: Magnetic Resonance Imaging (MRI) Safety information. | |
| ContainsRubber | LOGICAL | OPTIONAL | Device Info: Device required to be labeled as containing natural rubber latex or dry natural rubber. | |
| DeviceStatus | CHAR(2) | OPTIONAL | System defined lookup for ImplantableDeviceStatus Type | |
| TimeStamp | CHARACTER(14) | OPTIONAL | System generated date/time stamp record was last written. | |
| LastUser | INTEGER | ? | OPTIONAL | User ID of user that last wrote the record. |
| CreateStamp | CHARACTER(14) | OPTIONAL | System generated date/time stamp record was created. | |
| CreateUser | INTEGER | ? | OPTIONAL | User ID of user that created the record. |
| ImplantedDate | DATE | OPTIONAL | Date device was implanted into patient. | |
| EncounterSID | INTEGER | ? | MANDATORY | FK from Encounter |
| GMDNDescription | CHAR(200) | OPTIONAL | Global Medical Device Nomenclature Description. | |
| DonationID | CHAR(60) | OPTIONAL | Production Info: Donation Identification Number. | |
| IsHCTP | LOGICAL | OPTIONAL | Defines if the device a Human Cell, Tissue, or Cellular or Tissue-Based Product. | |
| SnomedCode | CHAR(20) | OPTIONAL | Snomed code associated with the implantable device | |
| TimeStampUTC | DATETIME-TZ | OPTIONAL | This is a denormalized field based off the TimeStamp. This field contains the Date, Time and timezone offset. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| Encounter | PatImplantableDevice.EncounterSID = Encounter.EncounterSID | CASCADE if PatImplantableDevice exists |
| Patient | PatImplantableDevice.PracticeID = Patient.PracticeID and PatImplantableDevice.PatientID = Patient.PatientID |
CASCADE if PatImplantableDevice exists |
| Practice | PatImplantableDevice.PracticeID = Practice.PracticeID | CASCADE if PatImplantableDevice exists |
| Child Table | Join Phrase | When deleting PatImplantableDevice record... |
|---|---|---|
| PatImplantableDeviceActivity | PatImplantableDeviceActivity.PatImplantableDeviceSID = PatImplantableDevice.PatImplantableDeviceSID | CASCADE if PatImplantableDeviceActivity exists |