---
title: Policy-related fields: MI_POLICY table
slug: rdb/essentials-guide/policy-related-fields-mipolicy-table
createdAt: 2026-11-05T09:24:42.029Z
---

The MI\_POLICY table contains the exported details for all Ivanti EPMM policies, regardless of whether they are currently applied to devices.

| Name               | Data type    | Not Null? | Primary key? | Description                                                                                                                                                                            |
| ------------------ | ------------ | --------- | ------------ | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| etl\_run\_ts       | timestamp    | Yes       | No           | Timestamp at which the ETL process has run                                                                                                                                             |
| vsp\_id            | integer      | No        | No           | The identifier of VSP from which this policy got exported                                                                                                                              |
| policy\_id         | integer      | No        | No           | Identifier of the policy                                                                                                                                                               |
| policy\_uuid       | varchar(64)  | No        | No           | UUID of the policy                                                                                                                                                                     |
| policy\_name       | varchar(64)  | No        | No           | Name of the policy                                                                                                                                                                     |
| priority           | integer      | No        | No           | Priority of the policy over other similar type of policies applied to the device                                                                                                       |
| active             | varchar(1)   | No        | No           | Whether the policy is active                                                                                                                                                           |
| user\_override     | varchar(1)   | No        | No           | Always 'f', not used                                                                                                                                                                   |
| policy\_type       | varchar(64)  | No        | No           | Whether it is a DEFAULT policy or ENTERPRISE(Admin created) policy or DEVICE policy                                                                                                    |
| profile\_type      | varchar(64)  | No        | No           | Type of policy profile, LOCKDOWN, PRIVACY, SECURITY, SYNC, ACTIVESYNC, USER, DOCS, GLOBALHTTPPROXY, SINGLEAPPMODE, KIOSK, APPCONNECT, SAMSUNG\_GENERAL, ANDROIDQUICKSETUP              |
| description        | varchar(255) | No        | No           | Policy description that admin configured                                                                                                                                               |
| hash               | varchar(64)  | No        | No           | Fingerprint of all the associated rules of this policy                                                                                                                                 |
| created\_at        | timestamp    | No        | No           | Date and time at which this policy is created                                                                                                                                          |
| version            | integer      | No        | No           | Version policy, number of times the policy got modified                                                                                                                                |
| last\_modified\_at | timestamp    | No        | No           | Last modified date and time                                                                                                                                                            |
| created\_by        | integer      | No        | No           | The id of the user who created this policy, maps to user\_id in mi\_user table, if a device is registered to this user. 9000 is the default id for the system created default policies |
| last\_modified\_by | integer      | No        | No           | Id of the user who modified the policy                                                                                                                                                 |

