Last Update: July 20, 2015

Certificate

Voter registration ID.

Election_Number

Election number.

Date_Last_Record_Change

Date of transaction.

Precinct

Voter's precinct at time of transaction.

Absentee_Activity_Type

Activity type. See the table below for valid values.

New_Code

Used as new value for certain activity types.

Ballot_Number

Ballot number where transaction is issuing a ballot.

Operator_Number

User performing the transaction.

Rerun_Flag

R indicates vote-by-mail label or envelope printing was rerun.

Ballot_Style

Ballot style where ballot is being issued.

Return_Batch

Return batch number for returned ballot.

Reversal_Flag

R indicates this transaction reverses a prior transaction.

Transaction_Date

Official date of the transaction. This might be different from database timestamp.

CountyId

County of residence. Always set to your county.

Temporarily_Away

Y indicates ballot was returned by the USPS as undeliverable with a reason of Temporarily Away. If Absentee_Activity_Type is not BRU, the value in this column will be NULL.

Value

Description

Possible New_Code Values

ADM

Advance ballot mailed

ADR

Advance ballot returned

G, L, S

ARI

Advance ballot reinstated

BLK

Ballot return blocked

N, Y

BRU

Ballot returned undeliverable

Z

CAN

Vote-by-mail request cancelled

ELR

Early vote reversed

ELY

Early vote

FAX

Ballot faxed or emailed

E, F, N

FX-

Ballot faxed or emailed

E, F, N

FX/

Ballot faxed or emailed

F, N

MAI

Ballot mailed

0, I, L, P

MIL

Change military or civilian status

C, M

PID

Photo ID provided

0, 1, 2, 3, 4,

REI

Reinstated ballot returned with errors

REQ

New request

RET

Ballot returned

A, B, E, G, I, J, L, M, N, O, P, S, T, W, X

STA

Change to voter's vote-by-mail status:

C—Cancelled

F—FPCA

P—Permanent

S—

query to Kara

T—Temporary

C, F, P, S, T

UBL

query to Kara

Y

UNB

query to Kara

N