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
:
