---
title: Device policy fields: MI_DEVICE_POLICY table
slug: rdb/essentials-guide/device-policy-fields-midevicepolicy-table
createdAt: 2026-11-05T09:24:41.970Z
---

The MI\_DEVICE\_POLICY table contains a record for each device or policy association in Ivanti EPMM.

| Name              | Data type   | Not Null? | Primary key? | Description                                                                                                                                                                                                          |
| ----------------- | ----------- | --------- | ------------ | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| device\_uuid      | varchar(64) | No        | No           | UUID of the device, maps to device\_uuid in mi\_device table                                                                                                                                                         |
| etl\_run\_ts      | timestamp   | Yes       | No           | Timestamp at which the ETL process has run                                                                                                                                                                           |
| last\_updated\_at | timestamp   | No        | No           | Last change in status or created timestamp                                                                                                                                                                           |
| policy\_id        | integer     | No        | No           | Identifier of the policy, maps to policy\_id in mi\_policy table                                                                                                                                                     |
| status            | varchar(1)  | No        | No           | Status of the policy:<br />'P' - Pending<br />'S' - Sent<br />'A' - Applied<br />'F' - Failed<br />'R' - Revoked<br />'Q' - Quarantine Revoked<br />'U' - Update Pending<br />'V' - Update Failed<br />'X' - Unknown |
| vsp\_id           | integer     | No        | No           | The identifier of VSP from which this policy got exported                                                                                                                                                            |

