# Vtype in Pre-processing historical data

**URL:** <https://forum.inductiveautomation.com/t/vtype-in-pre-processing-historical-data/26377>\
**Category:** Ignition\
**Created:** [July 9, 2019, 8:42am UTC](https://forum.inductiveautomation.com/t/vtype-in-pre-processing-historical-data/26377 "2019-07-09T08:42:33Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Apisit\_Chuencharoen](https://avatars.discourse-cdn.com/v4/letter/a/9d8465/32.png) [@Apisit\_Chuencharoen](https://forum.inductiveautomation.com/u/Apisit_Chuencharoen)\
**Post date:** [July 9, 2019, 8:42am UTC](https://forum.inductiveautomation.com/t/vtype-in-pre-processing-historical-data/26377/1 "2019-07-09T08:42:33Z")

</div>

I can’t find information about Vtype column in my database table after I enabled Pre-processed Partitions in tag history.

Does anyone know about it? Please let me know more details.

Vtype  
0  
1  
2  
4  
5  
6  
34  
38  
64  
97  
98  
101  
102

Thanks

---

<div class="post-metadata">

**Author:** ![jonathan.taylor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jonathan.taylor/32/4048_2.png) [@jonathan.taylor](https://forum.inductiveautomation.com/u/jonathan.taylor)\
**Post date:** [July 9, 2019, 1:51pm UTC](https://forum.inductiveautomation.com/t/vtype-in-pre-processing-historical-data/26377/2 "2019-07-09T13:51:54Z")

</div>

I found this from an old thread from Colby:

> The vtype is used to indicate the role of the value, as well as the order for pre-processed windows. It is a bit flag value, so values can have multiple roles.
> 
> First off, 0 means that the value is the only value for the window. 1=min, 2=max, 4=last value in window, 32=“first” value (to order min and max), and 64=first value of window.

---

<div class="post-metadata">

**Author:** ![Apisit\_Chuencharoen](https://avatars.discourse-cdn.com/v4/letter/a/9d8465/32.png) [@Apisit\_Chuencharoen](https://forum.inductiveautomation.com/u/Apisit_Chuencharoen)\
**Post date:** [July 9, 2019, 4:27pm UTC](https://forum.inductiveautomation.com/t/vtype-in-pre-processing-historical-data/26377/3 "2019-07-09T16:27:11Z")

</div>

Thank you for your information jonathan.taylor.

I investigated my database and I found many values of vtype (0,1,2,4,5,6,34,38,64,97,98,101,102). Could you please give us more details about other numbers that aren’t mentioned in the Colby forum?

Thanks,

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [July 9, 2019, 5:01pm UTC](https://forum.inductiveautomation.com/t/vtype-in-pre-processing-historical-data/26377/4 "2019-07-09T17:01:50Z")

</div>

There are only those six values. The integer column represents a binary AND of the different values; for example, 102 means that the bits in position 64, 32, 4, and 2 are “on” - meaning that the flag for max, exit, first value, and entry are all set.

---

<div class="post-metadata">

**Author:** ![Apisit\_Chuencharoen](https://avatars.discourse-cdn.com/v4/letter/a/9d8465/32.png) [@Apisit\_Chuencharoen](https://forum.inductiveautomation.com/u/Apisit_Chuencharoen)\
**Post date:** [July 10, 2019, 1:19am UTC](https://forum.inductiveautomation.com/t/vtype-in-pre-processing-historical-data/26377/5 "2019-07-10T01:19:14Z")

</div>

That’s clear, thank you PGriffith and Jonathan.taylor