---
title: Windows Phone and Surface Device fields: MI_DEVICE_WINDOWS_PHONE table
slug: rdb/essentials-guide/windows-phone-and-surface-device-fields-midevicewindowsphone-table
createdAt: 2026-11-05T09:24:42.009Z
---

The set of Windows Phone and Surface-only device fields in the MI\_DEVICE\_WINDOWS\_PHONE table comprises Windows Phone and Surface-specific device details. It has a one-or-zero to one relationship with the MI\_DEVICE table. If a device is not a Windows Phone or Surface device, the record will not be here.

| Name                       | Data type                   | Not Null? | Primary key? | Description                                                                                                  |
| -------------------------- | --------------------------- | --------- | ------------ | ------------------------------------------------------------------------------------------------------------ |
| etl\_run\_ts               | timestamp without time zone | Yes       | No           | The time the snapshot is taken on VSP.                                                                       |
| vsp\_id                    | integer                     | No        | No           |                                                                                                              |
| device\_id                 | bigint                      | No        | No           | VSP device\_id. The combination of etl\_run\_ts + vsp\_id + device\_id makes the primary key for this table. |
| device\_uuid               | character varying(64)       | No        | No           |                                                                                                              |
| dm\_client\_version        | double precision            | No        | No           |                                                                                                              |
| wp\_cert\_renew\_timestamp | timestamp without time zone | No        | No           |                                                                                                              |
| wp\_ent\_dm\_id            | bigint                      | No        | No           |                                                                                                              |
| wp\_exchange\_id           | character varying(255)      | No        | No           |                                                                                                              |
| wp\_firmware\_version      | character varying(255)      | No        | No           |                                                                                                              |
| wp\_hardware\_version      | character varying(255)      | No        | No           |                                                                                                              |
| wp\_local\_time            | timestamp without time zone | No        | No           |                                                                                                              |
| wp\_processor\_type        | bigint                      | No        | No           |                                                                                                              |
| wp\_signed\_ent\_dm\_id    | bigint                      | No        | No           |                                                                                                              |

