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 :