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

VTHIST : VOTER HISTORY FILE

VTSYST : Voter System File

VTVOTE : VOTER 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

© NEMRC 2010-2022 | Privacy Policy