List of PI point columns

Selected(x)

Enter an x to have PI Builder act on the row when you click Publish, Delete, or Retrieve.

This column is required in PI Builder and may be named Select(x) to support PI Tag Configurator worksheets.

n/a

Name

To change the name, enter a new name in the NewName or NewTag column.

This column is required in PI Builder.

n/a

ObjectType

Set to PIPoint.

This column is required in PI Builder.

n/a

Error

If an error occurs during a delete, publish, or retrieve operation for a specific row in the worksheet, PI Builder displays the error message for that row in the Error column cell. The error continues to be displayed until you clear it or perform the next delete, publish, or retrieve operation.

no

NewName

Enter a new name to change the point name in Data Archive.

This column may be named NewTag to support PI Tag Configurator worksheets.

yes

Description

This column may be named Descriptor to support PI Tag Configurator worksheets.

yes

digitalset

yes

displaydigits

yes

engunits

yes

exdesc

yes

future

no1

pointsource

yes

pointtype

Possible values:

• Blob

• Digital

• Float16

• Float32

• Float64

• Int16

• Int32

• Integer

• String

• TimeStamp

yes

ptclassname

no

sourcetag

yes

archiving

yes

compressing

yes

compdev

yes

compmax

yes

compmin

yes

compdevpercent

yes

excdev

yes

excmax

yes

excmin

yes

excdevpercent

yes

scan

yes

shutdown

yes

span

yes

step

yes

typicalvalue

yes

zero

yes

action1

yes

action2

yes

action3

yes

action4

yes

action5

yes

AutoAck

yes

ControlAlg

yes

ControlTag

yes

Deadband

yes

Options

yes

ReferenceTag

yes

srcptid

yes

test1

yes

test2

yes

test3

yes

test4

yes

test5

yes

txt1

yes

txt2

yes

txt3

yes

txt4

yes

txt5

yes

convers

yes

filtercode

yes

instrumenttag

yes

location1

yes

location2

yes

location3

yes

location4

yes

location5

yes

squareroot

yes

totalcode

yes

userint1

yes

userint2

yes

userreal1

yes

userreal2

yes

clamp

yes

displaygroup

yes

eventnumb

yes

expressnumb

yes

filternumb

yes

groupsize

yes

nodenumb

yes

offset

yes

period

yes

schedtype

yes

ChartType

yes

ClearOnLimitChange

yes

ClearOnStart

yes

CLTag

yes

CommentTag

yes

LCLTag

yes

LSLTag

yes

Mixture

yes

OneSideOfCL

yes

OutsideControl

yes

OutsideOneSigma

yes

OutsideTwoSigma

yes

PIProductLimits

yes

ProductTag

yes

ResetTag

yes

SQCAlarmPriority

yes

Stratification

yes

TestStatusTag

yes

Trend

yes

UCLTag

yes

USLTag

yes

WaitOnLimitChange

yes

CalcMode

yes

CompValue

yes

Conversion

yes

EventExpr

yes

FilterExpr

yes

Function

yes

MovingCount

yes

Offset2

yes

PctGood

yes

Period2

yes

RateSampleMode

yes

ReportMode

yes

TotalCloseMode

yes

zerobias

yes

dataaccess

Valid for Data Archive versions earlier than 3.4.380.

yes

datagroup

Valid for Data Archive versions earlier than 3.4.380.

yes

dataowner

Valid for Data Archive versions earlier than 3.4.380.

yes

ptaccess

Valid for Data Archive versions earlier than 3.4.380.

yes

ptgroup

Valid for Data Archiveversions earlier than 3.4.380.

yes

ptowner

Valid for Data Archive versions earlier than 3.4.380.

yes

datasecurity

Valid for Data Archive versions 3.4.380 and later.

yes

ptsecurity

Valid for Data Archive versions 3.4.380 and later.

yes

changedate

no

changer

no

creationdate

no

creator

no

pointid

no

recno

no