Last Update: August 12, 2015

Absreqm Table

This is a key table for voting by mail. It summarizes the state of each vote-by-mail request in the system. It also contains data on early voting, including check-ins processed on EViDs.

The state of a request is controlled by the date columns. To test for a date being "on" make a selection like this:

{absreqm.Date_Abs_Ballot_Mailed} > Date (2015,01 ,01 )

If the ballot has been mailed to the voter, this will test true.

Because most of these dates are stored with the time as well as the date, testing for things on a particular day can be tricky. If you need to do this in Crystal Reports, the easiest way is to go to the File > Report Options menu and set the column Convert Date-Time Field to the value To Date.

When creating SQL queries and reports, remember to specify the election number.

Certificate	Voter registration ID.
Election_Number	Election number.
Abs_How_Requested	Method by which voter requested ballot: 1—In person 2—Mail 3—Phone 4—In-office absentee (includes EViD check-ins) 5—Pickup absentee (by voter) 6—Fax 7—Pickup absentee (by voter's representative) 8—Email 9—Web 10—Federal Write-in Absentee Ballot (FWAB) 11—Federal Post Card Application (FPCA) 12—Online ballot 13—All-elections request
Counter_Voted	Y indicates ballot was early-voted. This is the only correct way of establishing whether a ballot is an early vote.
Precinct	Voter's precinct at the time the ballot was sent to them.
Party	Voter's party at the time the ballot was sent to them.
Abs_Mil_Civ	Military/civilian indicator associated with the request: M—Military or military dependent C or a space—Civilian
Overseas_Address	Y indicates ballot address is out of the country.
Date_Abs_Requested	Date ballot was requested.
Date_Abs_Ballot_Mailed	Date ballot was sent to voter.
Date_Abs_Ballot_Returned	Date ballot returned by voter was return-processed.
Signature_Difference_Flag	Contains the referral reason code if a returned ballot was referred to the canvassing board. Referral reason codes are in the Absrsnl table. Note The referral reason could be a signature-difference reason but not necessarily. This column was not named as well as it might have been.
Ballot_Style	Ballot style of the vote-by-mail ballot (not the Advance ballot).
Abs_Ballot_Number	Number of the vote-by-mail ballot.
Number_Ballots_Sent	Number of vote-by-mail ballots sent to the voter (does not include Advance ballots).
Date_Abs_Ballot_Cancelled	Date a vote-by-mail request was cancelled.
Date_Adv_Ballot_Mailed	Date an Advance ballot was sent to voter.
Date_Adv_Ballot_Returned	Date an Advance ballot returned by voter was return-processed.
Adv_Ballot_Number	Number of Advance ballot.
Operator_Number	User making the last change to this request.
Date_Record_Added	Date request was added.
Date_Last_Record_Change	Date of the last change to this record for any reason.
Requestor_Name	First and middle names of individual requesting ballot.
Requestor_Addr1	Address of individual requesting ballot.
Requestor_Addr2
Requestor_Addr3
Requestor_Addr4
Requestor_Relationship	Relationship between voter and individual requesting ballot.
Ballot_Mailing_Flag	Unused.
Label_Code	Y indicates a replacement ballot is requested for next Deliver Ballots run.
Phone_Number	Unused.
Requestor_LastName	Last name of individual requesting ballot.
Abs_How_Delivered	Method by which ballot was delivered: 1—Mail 2—Unused 3—Unused 4—Early voted (including in-office absentees and EViD check ins) 5—Pickup absentee (by voter) 6—Faxed 7—Pickup absentee (by voter's representative) 8—Email 9—Electronic ballot (online) 10—Mailed to first-time voter (MARG voter)
Returned_undeliverable_Flag	Y indicates the last ballot received from the voter in this election was returned by USPS as undeliverable. If the voter subsequently votes by mail or during early voting, this flag is reset.
Date_Early_Voted	For an early vote, the date of the early vote.
Reinstated_Flag	Unused.
Adv_Ballot_Style	The ballot style used for advance ballots in this election
AbsenteeReturnBlocked	Return of the voter's ballot was blocked on Mail-Ballot Adjustments dialog.
AbsenteeComments	Comments field on Mail-Ballot Adjustments dialog
FaxOrEmailDeliveryRequested	Flag to indicate that the ballot will be emailed (E) or faxed (F) to prevent production of a mailing label/envelope. N indicates the ballot will neither be emailed nor faxed.
Date_Abs_Return_Review	Date the return was reviewed.
Ballot_Return_Method	Method voter used to return or vote the ballot: C—Counter (in-office absentee or handed in) E—Email F—Fax M—Mail P—Election day vote W—Web (experimental online systems) Z—Early vote
UOCAVA_Flag	Y indicates the ballot qualifies as UOCAVA.
Email_Free_Access_Sent	Date the Free Access Notification was emailed to voter.
Notice_Free_Access_Sent	Date of the Free Access Notification postcard run that included this voter.
Email_Request_Ack_Sent	Date of the UOCAVA Absentee Request Acknowledgment run that included this voter.
Email_Ballot_Receipt_Ack_Sent	Date of the UOCAVA Absentee Ballot Returned Acknowledgment run that included this voter.
Absent_Domestic_Military	Y indicates the voter's military status and mail-ballot address categorize them as absent domestic military for this election.
MilitaryDependent	Y indicates voter is a military dependent.