Vitals Death FAQ

Data Dictionary

.
01/07/02                     NEMRC Customer Support                       Page 1
04:31 pm                       Filename: VDDECE                                 
                          File Description: Death File                          

  No   Field Name   Type   Len   Dec    Description of field                
--------------------------------------------------------------------------------
   1    D_REG_NUM      C      5     0   DEATH REGISTER NUMBER                   
   2    D_DATE_REC     D      8     0   DATE RECORDED                           
   3    D_DLNAME       C     25     0   DECEASED: LAST NAME                     
   4    D_DFNAME       C     25     0             FIRST NAME                    
   5    D_DMIDDLE      C     25     0             MIDDLE NAME                   
   6    D_DSEX         C      1     0             SEX                           
   7    D_DTOWN        C     25     0             TOWN OF DEATH                 
   8    D_DOD          D      8     0             DATE OF DEATH                 
   9    D_SSN          C     11     0             SOCIAL SECURITY NUMBER        
  10    D_VET          C      1     0             US VETERAN                    
  11    D_VETDESC      C     20     0             VETERAN DESCRIPTION           
  12    D_RACE         C      1     0             ENTHIC BACKGROUND/RACE        
  13    D_AGED         N      3     0             AGE AT DEATH                  
  14    D_DOB          D      8     0             DATE OF BIRTH                 
  15    D_BIRLOCA      C     25     0             BIRTH LOCATION                
  16    D_MSTAT        C      1     0             MARITAL STATUS                
  17    D_SNAME        C     25     0             SPOUSES NAME                  
  18    D_DOCCUP       C     25     0             OCCUPATION                    
  19    D_ADD1         C     25     0             ADDRESS LINE 1                
  20    D_ADD2         C     25     0             ADDRESS LINE 2                
  21    D_CITY         C     25     0             CITY                          
  22    D_STATE        C      2     0             STATE                         
  23    D_MOTHER       C     25     0             MOTHER'S NAME                 
  24    D_FATHER       C     25     0             FATHER'S NAME                 
  25    D_FDOB         D      8     0             FATHER'S DOB                  
  26    D_MDOB         D      8     0             MOTHER'S DOB                  
  27    D_FBIRLOCA     C     25     0             FATHER'S BIRTH LOCATION       
  28    D_MBIRLOCA     C     25     0             MOTHER'S BIRTH LOCATION       
  29    D_DISP         C     20     0   DESCRIPTION OF DISPOSITION              
  30    D_DISPPL       C     25     0   PLACE OF DISPOSITION                    
  31    D_DISPTOWN     C     25     0   TOWN OF DISPOSITION                     
  32    D_DEATH        C     30     0   CAUSE OF DEATH                          
  33    D_OUTTOWN      C      1     0   OUT OF TOWN DEATH                       
  34    D_BOOK         N      5     0   BOOK                                    
  35    D_PAGE         N      5     0   PAGE                                    
  36    D_NETSTAMP     N      2     0   SYSTEM STAMP                            
  37    D_DELFLAG      C      1     0   DELETE FLAG                             
  38    D_NOTES        M      0     0   NOTES                                   
--------------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL  38 FIELDS =  549

                                Related Indexes                                

VDREGS  : D_DELFLAG + ALLTRIM(STR(YEAR(D_DOD))) + D_REG_NUM                     
VDLNAM  : D_DELFLAG + D_DLNAME + D_DFNAME                                       
VDDATE  : D_DELFLAG + DTOS(D_DOD)                                               .
01/07/02                     NEMRC Customer Support                       Page 1
04:31 pm                       Filename: VDSYST                                 
                      File Description: Death System File                      

  No   Field Name   Type   Len   Dec    Description of field                
--------------------------------------------------------------------------------
   1    S_CLERK        C     25     0   TOWN CLERK NAME                         
   2    S_F05          C     30     0                                           
   3    S_F06          C     30     0                                           
   4    S_F07          C     30     0                                           
   5    S_F08          C     30     0                                           
   6    S_F09          C     30     0                                           
   7    S_F10          C     30     0                                           
   8    S_F11          C     30     0                                           
   9    S_F12          C     30     0                                           
  10    S_MISC0        C     10     0                                           
  11    S_MISC1        C     10     0                                           
  12    S_MISC2        C     10     0                                           
  13    S_MISC3        C     10     0                                           
  14    S_MISC4        C     10     0                                           
  15    S_MISC5        C     10     0                                           
  16    S_MISC6        C     10     0                                           
  17    S_MISC7        C     10     0                                           
  18    S_MISC8        C     10     0                                           
  19    S_MISC9        C     10     0                                           
  20    S_ALLOW0       C      1     0                                           
  21    S_ALLOW1       C      1     0                                           
  22    S_ALLOW2       C      1     0                                           
  23    S_ALLOW3       C      1     0                                           
  24    S_ALLOW4       C      1     0                                           
  25    S_ALLOW5       C      1     0                                           
  26    S_ALLOW6       C      1     0                                           
  27    S_ALLOW7       C      1     0                                           
  28    S_ALLOW8       C      1     0                                           
  29    S_ALLOW9       C      1     0                                           
  30    S_DELFLAG      C      1     0   DELETE FLAG                             
  31    S_NETSTAMP     N      2     0   SYSTEM STAMP                            
  32    S_VERSION      C      4     0   VERSION NUMBER                          
--------------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL  32 FIELDS =  382

        :                                                                                                                                        
							

© NEMRC 2010-2023 | Privacy Policy