Last Update: August 07, 2015

Pwm Table

This is the master table holding information on election workers.

Certificate

Voter registration ID of election worker.

PW_Active

Y indicates the worker status is Y, Active Election Worker.

PW_Phone_Work

Number designated as worker's Work phone number on Worker Maintenance General tab.

Payroll_ID

Payroll ID assigned to worker.

PW_Certification_Flag

User-defined certification flag.

Normal_Position

Position worker normally works.

Normal_Precinct

Precinct where worker normally works.

Works_outside_normal_prct

Y indicates worker will accept assignments outside their normal precinct.

Date_Last_Worked

Date worker last worked an election.

Election_Last_Worked

Election last worked by worker.

Position_Last_Worked

Position last worked by worker.

Date_Last_Contacted

Date worker was last sent a letter or email from the Voter Focus system.

Note  This column is not updated by emails sent directly from the worker's record, only by emails sent by the Election Worker Bulk Runs under EW Utilities.

Times_Contacted

Unused.

Date_Record_Added

Timestamp when the election-worker record added to the system.

Training_Hours_YTD

Hours of training class worker has attended in this calendar year.

Training_Hours_After_June

Hours of training class worker has attended since June 30 of this year.

Date_Last_Record_Change

Unused.

Operator_Number

Unused.

PW_Comments

Comments field on Worker Maintenance General tab.

PW_YTD_Pay

Amount of pay issued to worker in this calendar year.

PW_YTD_Pay_Year

Year being reported in PW_YTD_Pay column.

PW_Last_Year_Pay

Amount of pay issued to worker in previous calendar year.

Misc_Payment

An outstanding miscellaneous payment owed the worker.

Unavailable_Until

Date when worker is available to work again after being marked as unavailable.

Terminated_Date

Date worker status was changed to T, Terminated Election Worker.

Contact_Flag

Y indicates a response has been received from the worker. (The Response Status fields on the Worker Maintenance General tab is Response Received.)

PW_Soc_Sec_Num

The worker's full Social Security Number.

Note  Social Security Numbers entered in this column are not copied to the worker's voter registration record.

PW_email_address

The worker's email address.

PW_Telephone_Number

Number designated as worker's Home phone number on Worker Maintenance General tab.

Languages

Comma-delimited list of languages spoken by worker.

PW_Mobile_Phone

Number designated as worker's Mobile phone number on Worker Maintenance General tab.

PW_Drivers_License

Worker's driver license number.

Note  Driver License Numbers entered in this column are not copied to the worker's voter registration record.

LocationType

The work types this worker is available for (can be more than one type):

V—Precinct poll work

E—Early voting work

C—Election center work

CountyEmployee

Y indicates County Employee check box is selected on worker's Worker Maintenance General tab. Used with County Employees NOT Paid option.

Election_Day_Cell_Phone

Unused.

Notes_Alert

Y indicates the See Comments/Notes check box is selected on worker's Worker Maintenance General tab.

PW_Phone_Priority

Indicates the order in which worker's three phone numbers—Home, Work, and Mobile—are displayed on their record, denoting which number to call first. For example:

MHW—Mobile, Home, Work

PW_Picture

The hexadecimal data for the worker's photo image.

ELM_update

Y indicates a column on the Pwm row pertaining to ELM has changed, so the next time the ELMUpdates program runs ELM will be updated with the new information.

Department

Department code from VOTER FOCUS ADMIN > System Codes > County Worker Departments.

Worker_Alias

Name from Preferred Name field on Worker Maintenance dialog.

Portal_Account_Created

Y indicates an election-worker portal account has been created for this person by the ELM software.