Voter Checklist Support Document
Open as: PDF or Word Document
Data Dictionary
Table of Contents
VTCODE : ELECTION CODE AND DESCRIPTION FILE
VTELEC : ELECTION PARTICIPATION FILE
VTCODE : ELECTION CODE AND DESCRIPTION FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 C_CODE C 4 0 ELECTION CODE 2 C_DATE D 8 0 ELECTION DATE 3 C_DESC C 60 0 ELECTION DESCRIPTION 4 C_STATUS C 1 0 PARTICIPATION CALC'D: YES, NO, RECALCED 5 C_CLHEAD01 C 70 0 CHECKLIST HEADER 1 6 C_CLHEAD02 C 70 0 CHECKLIST HEADER 2 7 C_CLHEAD03 C 70 0 CHECKLIST HEADER 3 8 C_CLHEAD04 C 70 0 CHECKLIST HEADER 4 9 C_CLHEAD05 C 70 0 CHECKLIST HEADER 5 10 C_CLHEAD06 C 70 0 CHECKLIST HEADER 6 11 C_CLHEAD07 C 70 0 CHECKLIST HEADER 7 12 C_CLHEAD08 C 70 0 CHECKLIST HEADER 8 13 C_CLHEAD09 C 70 0 CHECKLIST HEADER 9 14 C_CLHEAD10 C 70 0 CHECKLIST HEADER 10 15 C_CLHEAD11 C 70 0 CHECKLIST HEADER 11 16 C_CLHEAD12 C 70 0 CHECKLIST HEADER 12 17 C_CLHEAD13 C 70 0 CHECKLIST HEADER 13 18 C_CLHEAD14 C 70 0 CHECKLIST HEADER 14 19 C_CLHEAD15 C 70 0 CHECKLIST HEADER 15 20 C_DELFLAG C 1 0 DELETION FLAG (* = REUSEABLE) ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 20 FIELDS = 1124 Related Indexes VTCODE : C_DELFLAG+C_CODE VTELEC : ELECTION PARTICIPATION FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 E_VOTERNO C 6 0 VOTER NUMBER 2 E_CODE C 4 0 ELECTION CODE 3 E_STATUS C 1 0 APPROVED? Y/N 4 E_ABS_ASK C 1 0 ABSENTEE BALLOT ASKED FOR? Y/N 5 E_DABSENT D 8 0 DATE ABSENTEE BALLOT SENT TO VOTER 6 E_DABRECD D 8 0 DATE ABSENTEE BALLOT REC'D FROM VOTER 7 E_HOWVOTED C 1 0 HOW VOTED YES, NO, ABSENTEE 8 E_CHALLENG C 1 0 CHALLENGED? Y/N 9 E_MAILTAG C 1 0 MAIL TAG? Y/N 10 E_DISTRICT C 1 0 DISTRICT CODE AT TIME OF VOTING 11 E_WARD C 1 0 WARD CODE AT TIME OF VOTING 12 E_DELFLAG C 1 0 DELETION FLAG (* = REUSEABLE) ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 12 FIELDS = 34 Related Indexes VTELEC : E_DELFLAG+E_VOTERNO VTELCD : E_DELFLAG+E_CODE+E_VOTERNO VTHIST : VOTER HISTORY FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 LASTNAME C 25 0 LAST NAME 2 FIRSTNAME C 25 0 FIRST NAME 3 EXTNAME C 4 0 EXTENSION NAME (JR, III) 4 V_VOTERNO C 6 0 SYSTEM-ASSIGNED VOTER NUMBER 5 MADDRESS1 C 30 0 MAILING ADDRESS 1 6 MADDRESS2 C 30 0 MAILING ADDRESS 2 7 MCITY C 25 0 MAILING CITY 8 MSTATE C 10 0 MAILING STATE 9 MZIP C 10 0 MAILING ZIP 10 MAIL_TAG C 1 0 MAIL TAG (YN) IF "N" NO LABELS 11 LOCATION C 30 0 STREET OF PRINCIPAL DWELLING 12 LOCA_STRE C 25 0 STREET NUMBER OF PRINCIPAL DWELLING 13 LOCA_CITY C 25 0 CITY OF PRINCIPAL DWELLING 14 LOCA_STATE C 10 0 STATE OF PRINCIPAL DWELLING 15 TELEPHONE C 12 0 TELEPHONE NUMBER 16 APP_DATE D 8 0 DATE OF APPLICATION 17 APP_SOURCE C 1 0 APPLICATION SOURCE 18 CITYOF C 25 0 CITY OF CHECKLIST 19 DISTRICT C 1 0 VOTING DISTRICT 20 WARD C 10 0 VOTING WARD 21 CITIZEN C 1 0 CITIZEN? (YN) 22 OATH C 1 0 TAKEN FREEMAN'S OATH? (YN) 23 BORN D 8 0 BIRTH DATE 24 BORN_CITY C 25 0 CITY OF BIRTH 25 BORN_STATE C 10 0 STATE OF BIRTH 26 NATURALIZ D 8 0 NATURALIZED CITIZEN? (YN) 27 NAT_CITY C 25 0 CITY OF NATURALIZATION 28 NAT_STATE C 10 0 STATE OF NATURALIZATION 29 LREG_ADDR C 30 0 LAST REGISTERED TO VOTE ADDRESS 30 LREG_CITY C 25 0 LAST REGISTERED TO VOTE CITY 31 LREG_STATE C 10 0 LAST REGISTERED TO VOTE STATE 32 LREG_NAME C 25 0 LAST REGISTERED TO VOTE NAME 33 MISC1 C 4 0 MISC FIELD A 34 MISC2 C 4 0 MISC FIELD B 35 MISC3 C 4 0 MISC FIELD C 36 CHALLENGE C 1 0 VOTER STATUS (ACTIVE, INACTIVE) 37 CHALLDATE D 8 0 DATE CHALLENGE WAS MADE 38 CHALLLTTR D 8 0 DATE CHALLENGE LETTER SENT 39 CHALLRECV D 8 0 DATE VOTER RESPONDED CHALLENGE (IF ANY) 40 VOTE_RECO C 30 0 VOTING RECORD 1 CHAR PER ELECTION 41 DATE_OFF D 8 0 DATE VOTER REMOVE FROM VTVOTE## 42 REASON C 30 0 REASON FOR REMOVAL 43 LAST_VOTE D 8 0 DATE LAST VOTED 44 APPROVED C 1 0 APPROVED VOTER 45 PROVE_DATE D 8 0 APPROVAL DATE 46 V_LUPDATE D 8 0 LAST UPDATED 47 H_NETSTAMP N 2 0 NETWORK SIGNATURE 48 DELFLAG C 1 0 "*" REUSEABLE RECORD ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 48 FIELDS = 624 Related Indexes VTHIST : DELFLAG+UPPER(LASTNAME+FIRSTNAME+EXTNAME) VTHNMB : DELFLAG+V_VOTERNO VTSYST : Voter System File No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 S_VTFORM C 2 0 CHECKLIST FORM SELECT 2 S_WARDUSE C 1 0 USE WARDS FOR THESE VOTERS? 3 S_CITYOF C 25 0 DEFAULT CITY 4 S_ZIP C 10 0 DEFAULT ZIP CODE 5 S_NEXTVOTE C 6 0 NEXT SYSTEM-ASSIGNED VOTER NUMBER TO USE 6 S_ELECT01 C 20 0 ELECTION 1 DESCRIPTION 7 S_ELECT02 C 20 0 ELECTION 2 DESCRIPTION 8 S_ELECT03 C 20 0 ELECTION 3 DESCRIPTION 9 S_ELECT04 C 20 0 ELECTION 4 DESCRIPTION 10 S_ELECT05 C 20 0 ELECTION 5 DESCRIPTION 11 S_ELECT06 C 20 0 ELECTION 6 DESCRIPTION 12 S_ELECT07 C 20 0 ELECTION 7 DESCRIPTION 13 S_ELECT08 C 20 0 ELECTION 8 DESCRIPTION 14 S_ELECT09 C 20 0 ELECTION 9 DESCRIPTION 15 S_ELECT10 C 20 0 ELECTION 10 DESCRIPTION 16 S_ELECT11 C 20 0 ELECTION 11 DESCRIPTION 17 S_ELECT12 C 20 0 ELECTION 12 DESCRIPTION 18 S_ELECT13 C 20 0 ELECTION 13 DESCRIPTION 19 S_ELECT14 C 20 0 ELECTION 14 DESCRIPTION 20 S_ELECT15 C 20 0 ELECTION 15 DESCRIPTION 21 S_ELECT16 C 20 0 ELECTION 16 DESCRIPTION 22 S_ELECT17 C 20 0 ELECTION 17 DESCRIPTION 23 S_ELECT18 C 20 0 ELECTION 18 DESCRIPTION 24 S_ELECT19 C 20 0 ELECTION 19 DESCRIPTION 25 S_ELECT20 C 20 0 ELECTION 20 DESCRIPTION 26 S_CLHEAD01 C 70 0 HEADING 1 FOR CHECKLIST REPORT 27 S_CLHEAD02 C 70 0 HEADING 2 FOR CHECKLIST REPORT 28 S_CLHEAD03 C 70 0 HEADING 3 FOR CHECKLIST REPORT 29 S_CLHEAD04 C 70 0 HEADING 4 FOR CHECKLIST REPORT 30 S_CLHEAD05 C 70 0 HEADING 5 FOR CHECKLIST REPORT 31 S_CLHEAD06 C 70 0 HEADING 6 FOR CHECKLIST REPORT 32 S_CLHEAD07 C 70 0 HEADING 7 FOR CHECKLIST REPORT 33 S_CLHEAD08 C 70 0 HEADING 8 FOR CHECKLIST REPORT 34 S_CLHEAD09 C 70 0 HEADING 9 FOR CHECKLIST REPORT 35 S_CLHEAD10 C 70 0 HEADING 10 FOR CHECKLIST REPORT 36 S_CLHEAD11 C 70 0 HEADING 11 FOR CHECKLIST REPORT 37 S_CLHEAD12 C 70 0 HEADING 12 FOR CHECKLIST REPORT 38 S_CLHEAD13 C 70 0 HEADING 13 FOR CHECKLIST REPORT 39 S_CLHEAD14 C 70 0 HEADING 14 FOR CHECKLIST REPORT 40 S_CLHEAD15 C 70 0 HEADING 15 FOR CHECKLIST REPORT 41 S_F05 C 30 0 FUNCTION KEY F5 42 S_F06 C 30 0 FUNCTION KEY F6 43 S_F07 C 30 0 FUNCTION KEY F7 44 S_F08 C 30 0 FUNCTION KEY F8 45 S_F09 C 30 0 FUNCTION KEY F9 46 S_F10 C 30 0 FUNCTION KEY F10 47 S_F11 C 30 0 FUNCTION KEY F11 48 S_F12 C 30 0 FUNCTION KEY F12 49 S_DCODE C 6 0 DISTRICT CODE PER POSITION 50 S_DNAME C 180 0 DISTRICT TITLES RELATED TO S_DCODE 51 S_WCODE C 10 0 WARD CODE PER POSITION 52 S_WNAME C 100 0 WARD TITLES RELATED TO S_WCODE 53 S_VIEW C 1 0 SHORT OR LONG EDIT MODE DEFAULTS SHORT Y 54 S_DEFA_APP C 1 0 DEFAULT FOR APPROVED. 55 S_COPY_ADD C 1 0 COPY STREET AND LOCATION OPTIONS (Y,N,A) 56 S_BAKDATE D 8 0 LAST TEMPORARY BACKUP DATE 57 S_BAKTIME C 8 0 LAST TEMPORARY BACKUP TIME 58 S_VERSION C 4 0 NEMRC EXECUTABLE THAT MATCHES THIS DATA 59 S_OLDVER C 4 0 PREVIOUS INSTALLED VERSION OF THE MODULE 60 S_UPVER D 8 0 DATE THE NEW VERSION WAS INSTALLED 61 S_NETSTAMP N 2 0 NETWORK STAMP 62 S_ELECT21 C 20 0 ELECTION 21 63 S_ELECT22 C 20 0 ELECTION 22 64 S_ELECT23 C 20 0 ELECTION 23 65 S_ELECT24 C 20 0 ELECTION 24 66 S_ELECT25 C 20 0 ELECTION 25 67 S_ELECT26 C 20 0 ELECTION 26 68 S_ELECT27 C 20 0 ELECTION 27 69 S_ELECT28 C 20 0 ELECTION 28 70 S_ELECT29 C 20 0 ELECTION 29 71 S_ELECT30 C 20 0 ELECTION 30 72 S_HAVAD N 2 0 HAVA DISTRICT FIELD 73 S_HAVAW N 2 0 HAVA WARD FIELD ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 73 FIELDS = 2271 VTVOTE : VOTER FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 LASTNAME C 25 0 LAST NAME 2 HAVALASTNA C 35 0 HAVA LAST NAME (IF > 25) 3 FIRSTNAME C 25 0 FIRST NAME 4 HAVAFIRSTN C 35 0 HAVA FIRST NAME IF > 25 5 HAVAMIDDLE C 35 0 HAVA MIDDLE NAME 6 EXTNAME C 4 0 EXTENSION NAME (JR, III) 7 HAVAEXTNAM C 10 0 HAVA EXTENSION NAME IF > 4 8 V_VOTERNO C 6 0 SYSTEM-ASSIGNED VOTER NUMBER 9 MADDRESS1 C 25 0 MAILING ADDRESS 1 10 HAVAMADDRE C 30 0 HAVA ADDRESS IF > 25 11 HAVAMADDR1 C 30 0 HAVA ADDRESS IF > 25 12 MADDRESS2 C 25 0 MAILING ADDRESS 2 13 HAVAMADDR2 C 30 0 HAVA MAILING ADDRESS 2 IF > 25 14 HAVACAREOF C 35 0 HAVA CARE OF IF NOT IMPORTED IN ADDRESS 15 MCITY C 25 0 MAILING CITY 16 MSTATE C 10 0 MAILING STATE 17 MZIP C 10 0 MAILING ZIP 18 HAVAMZIP C 20 0 MAILING ZIP IF > 10 19 MAIL_TAG C 1 0 MAIL TAG (YN) IF "N" NO LABELS 20 LOCATION C 25 0 STREET NUMBER OF PRINCIPAL DWELLING 21 LOCA_STRE C 25 0 STREET OF PRINCIPAL DWELLING 22 HAVALOCA_S C 30 0 HAVA STREET NAME IF > 25 23 LOCA_CITY C 25 0 CITY OF PRINCIPAL DWELLING 24 LOCA_STATE C 10 0 STATE OF PRINCIPAL DWELLING 25 STATELOCA C 50 0 LOCATION ON STATE RECORD 26 TELEPHONE C 12 0 TELEPHONE NUMBER 27 APP_DATE D 8 0 DATE OF APPLICATION 28 APP_SOURCE C 1 0 APPLICATION SOURCE 29 CITYOF C 25 0 CITY OF CHECKLIST 30 DISTRICT C 1 0 VOTING DISTRICT CODE 31 WARD C 1 0 VOTING WARD CODE 32 CITIZEN C 1 0 CITIZEN? (YN) 33 OATH C 1 0 TAKEN FREEMAN'S OATH? (YN) 34 BORN D 8 0 BIRTH DATE 35 BORN_CITY C 25 0 CITY OF BIRTH 36 BORN_STATE C 10 0 STATE OF BIRTH 37 NATURALIZ D 8 0 NATURALIZED CITIZEN? (YN) 38 NAT_CITY C 25 0 CITY OF NATURALIZATION 39 NAT_STATE C 10 0 STATE OF NATURALIZATION 40 LREG_ADDR C 25 0 LAST REGISTERED TO VOTE ADDRESS 41 LREG_CITY C 25 0 LAST REGISTERED TO VOTE CITY 42 LREG_STATE C 10 0 LAST REGISTERED TO VOTE STATE 43 LREG_NAME C 25 0 LAST REGISTERED TO VOTE NAME 44 MISC1 C 4 0 MISC FIELD A 45 MISC2 C 4 0 MISC FIELD B 46 MISC3 C 4 0 MISC FIELD C 47 CHALLENGE C 1 0 VOTER STATUS (Y/N/BLANK) 48 CHALLDATE D 8 0 DATE VOTER CAN BE REMOVED 49 CHALLLTTR D 8 0 DATE CHALLENGE LETTER SENT 50 CHALLRECV D 8 0 DATE OF CHALLENGE RESPONSE (IF ANY) 51 VOTE_RECO C 30 0 VOTING RECORD 1 CHAR PER ELECTION 52 MULTICOL C 3 0 53 LAST_VOTE D 8 0 DATE LAST VOTED 54 APPROVED C 1 0 APPROVED VOTER 55 PROVE_DATE D 8 0 APPROVAL DATE 56 STATEID N 10 0 STATE NUMBER 57 STATETEMP C 1 0 STATE TEMP FIELD 58 V_LUPDATE D 8 0 LAST UPDATED 59 V_NETSTAMP N 2 0 NETWORK SIGNATURE 60 DELFLAG C 1 0 "*" = REUSABLE ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 60 FIELDS = 911 Related Indexes VTVOTE : DELFLAG+UPPER(LASTNAME+FIRSTNAME+EXTNAME) VTNUMB : DELFLAG+V_VOTERNO VTSTAT : DELFLAG+ STRTRAN(STR(Stateid,10,0),' ','0')+UPPER(PADR(ALLT(LASTNAME),2
