01Relates to the patient
ACCOUNT is the patient's ACCOUNT
Single-patient export: the patient's rows.
02References
ACCOUNT→PATIENTS.ACCOUNTBODY_SITE_SNOMED→V_IMPLANTABLE_DEVICE_BODY_SITES_SNOMED.SNOMED_CODEBODY_SITE_SELF_RPT→V_IMPLANTABLE_DEVICE_BODY_SITES_UDI.BODY_SITE_IDDEVICE_ID→IMPLANTABLE_DEVICES.DEVICE_IDENTRY_USER_ID→USERS.USER_ID
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | DEVICE_ID | string | varchar(25) | no | |
| 2 | ACCOUNT PK | string | varchar(12) | no | |
| 3 | BATCH_NUMBER | string | varchar(10) | yes | |
| 4 | SERIAL_NUMBER | string | varchar(10) | yes | |
| 5 | EXPIRATION_DATE | datetime | datetime | yes | |
| 6 | MANUFACTURED_DATE | datetime | datetime | yes | |
| 7 | UNIQUE_DEVICE_ID | string | varchar(10) | yes | |
| 8 | LOT_NUMBER | string | varchar(20) | yes | |
| 9 | MANUFACTURING_DATE | datetime | datetime | yes | |
| 10 | HCT_P_ID | string | varchar(25) | yes | |
| 11 | SEQUENCE_NO PK | integer | int | no | |
| 12 | ENTRY_DATE | datetime | datetime | yes | |
| 13 | ENTRY_USER_ID | string | varchar(20) | yes | |
| 14 | COMMENTS | string | varchar(350) | yes | |
| 15 | IS_DELETED | boolean | bit | yes | |
| 16 | SNOMED_CODE | string | varchar(40) | yes | |
| 17 | BODY_SITE_SNOMED | string | varchar(20) | yes | |
| 18 | BODY_SITE_SELF_RPT | integer | int | yes | |
| 19 | IMPLANT_DATE | datetime | datetime | yes | |
| 20 | DONATION_ID | string | varchar(15) | yes | |
| 21 | BAG_DEVICE_ID | string | varchar(10) | yes | |
| 22 | BAG_LOT_NUMBER | string | varchar(15) | yes |