Death
The Death table is used to record information concerning the place and time of death for an individual constituent, or information concerning the dissolution/disbanding of a corporation or foundation.
When a constituent's Death row is created, several automatic features are activated. These include the following:
- All Address Locators fields belonging to that constituent are changed to Deceased.
- All Address rows linked to the constituent's Addresses will be unlinked.
- Whenever the constituent name is displayed, it will be followed by the word DECEASED or DISBANDED (if a corporation or foundation). This includes the name as hyperlink text, title bar text, or reporting.
- If the Marital Status in Basic Data was Married or Surviving Spouse, it will be changed to Deceased Spouse. If the partner's status was Married, it will be changed to Surviving Spouse.
- If the Is a/Whose fields in a Relationship row had been spouse/spouse, they will be changed to deceased spouse/surviving spouse.
- For the Combined Name and Combined Salutation Name fields in a Name row, and the Name row does not have a type of Combined Mailing Name or Combined Salutation, then the standard, singular form of the Name will be constructed for both spouses; if there is an override on the Combined Name or Combined Salutation Name, the override will be unchecked.
- If the Is a/Whose fields in a Relationship row had been Employee/Employer (emp/boss) they will be changed to Former Employee/Former Employer (femp/fbos). This change occurs when the Death row is created for either the Employer (Disbanded) or the Employee (Deceased).
- The Job Status of any Employment row with a Job Status of Active will be set to No Longer at this Position.
- Any active Membership rows will be set to inactive.
- If a Tracking row exists, its Current Prospect flag will be set to N.
Refer to the Trigger Behaviors, Death topic for more a more technical discussion of these automatic features.
- Millennium system administrators or the database administrator can configure audit logging for the Death data table. For more information, see Audit Log.
- The Death table can be removed from the Millennium Explorer and all other system components (such as reporting) if it is not used. See Table Options for more information.
Display Death with Basic Data
If the Display Death with Basic Data system option is activated at your organization, then the Death item will be removed from Millennium Explorer and users must access the Basic Data display for a constituent in order to view a Death record. Note that if a constituent does not have a Death record, the section header for Death will not display. See the System Options topic for information on how to activate this option.
If the Display Death with Basic Data system option is activated at your organization, complete the following steps to create a Death record for a constituent.
- Access the constituent's Basic Data display by using Millennium Explorer,
- Point to the Edit button
located to the left of the constituent's Basic Data row, and click Link > Death or Link > Death via Default. - Complete the Death insert form, and click Insert.
Death Field Descriptions
The following fields are included in the death data table. Note that the field labels and non-displaying designations that are listed are those that the system uses by default. If your institution wants to override these default settings, you must customize your display definition.
Note: Custom fields are included in the data table, and are available for any purpose that you want to define. These fields are not shown on the standard Display or standard Data Maintenance forms. If you want to make use of one or more of the custom fields, use the Custom Display Designer to edit the standard Display and Data Maintenance forms.
|
Field Name Field Label |
Lookup Table |
Type Length [Default] {Check} |
Description |
|---|---|---|---|
|
deathkey non-displaying |
none |
numeric/number 13,0
|
The primary key field for all rows in all tables. This field holds a permanent "time stamp" of the precise time and date the row was created. This uniquely identifies a row within the table. (system field) |
|
deathid non-displaying |
none |
char 10
|
This field holds the ID number of the constituent who owns this row, providing a link between this row and all others in all other tables which also belong to the same constituent. (system field)
|
|
deathdoc non-displaying |
none |
char 1 ['N']
|
This field holds a Y/N flag to indicate the existence of a linked document for this row. (system field) |
|
deathdate no label |
none |
datetime/date
[getdate()]
|
The date that this Death row was last updated. This field is automatically entered by the system. (system field) |
|
deathuid no label |
none |
varchar/varchar2 30 [suser_sname]
|
The User ID of the operator that last edited this Death row. It is automatically entered by the system. (system field) |
|
deathugrp non-displaying |
none |
char 1 ['Z']
|
This field holds the Group letter that was associated with the User ID of the operator who last edited this row. (system field) |
|
deathdecdt Date |
none |
datetime/date
|
The date of the death of this constituent. |
|
deathcity no label |
none |
char 30
|
The city in which the death occurred. |
|
deathplace Place |
|
char 6 [' ']
|
The place (state, province, territory, etc.) in which the death occurred. |
|
deathcause Cause |
none |
char 50
|
The cause of death. |
|
deathnotif Notified by: |
none |
char 40
|
The initial source of this death information. |
|
deathcorr Corroborated by: |
none |
char 40
|
The corroborating source of this death information. |
|
deathcntry Country |
Countries |
char 6 [' ']
|
The country in which the death occurred. |
|
deathpoint non-displaying |
none |
numeric/number 10,0
|
This system-assigned field is no longer used or supported. (system field). |
|
deathfnum non-displaying |
none |
char 2 ['17'] {'17'} |
The file (table) number for the Death table. (system field). |
|
deathcrdat non-displaying |
none |
datetime/date
[getdate()]
|
The date that the row was created. (system field). |
|
deathcomm no label |
none |
varchar/varchar2 4000
|
The free text comments associated with this row. This text is displayed in the user's accent text color. |
|
deathdate1
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
deathdate2
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
deathmny1
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
deathmny2
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
deathnum1
|
none |
numeric/number 13, 0
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
deathnum2
|
none |
numeric/number 13, 0
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
deathyesno
|
none |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. |
|
deathlook1
|
Death Lookup1 |
char 6
|
This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row. |
|
deathlook2
|
Death Lookup2 |
char 6
|
This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row. |
|
deathlook3
|
Death Lookup3 |
char 6
|
This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row. |
|
deathtext
|
none |
varchar/varchar2 255
|
This custom field may be defined and used by your institution to track any free text information you want to associate with this data row. |
|
deathnotdt On |
none |
datetime/date
|
This field is used to hold the date on which the institution was notified of the death. |
|
deathcordt On |
none |
datetime/date
|
This field is used to hold the date on which the death was corroborated. |
|
deathsrce Source |
none |
char 6 [' ']
|
This field may be used to hold the Source for this information (or the office within the institution responsible for it.) |
|
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
deathdate4
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
deathdate5
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
deathdate6
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
deathdate7
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
deathdate8
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
deathdate9
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
deathdte10
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
deathdte11
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
deathdte12
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
deathmny3
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. |
|
deathmny4
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. |
|
deathmny5
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. |
|
deathmny6
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. |
|
deathmny7
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. |
|
deathmny8
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. |
|
deathmny9
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. |
|
deathmny10
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. |
|
deathmny11
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. |
|
deathmny12
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. |
|
deathnum3
|
none |
numeric/number 10, 0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. |
|
deathnum4
|
none |
numeric/number 10, 0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. |
|
deathnum5
|
none |
numeric/number 10, 0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. |
|
deathnum6
|
none |
numeric/number 10, 0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. |
|
deathnum7
|
none |
numeric/number 10, 0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. |
|
deathnum8
|
none |
numeric/number 10, 0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. |
|
deathnum9
|
none |
numeric/number 10, 0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. |
|
deathnum10
|
none |
numeric/number 10, 0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. |
|
deathnum11
|
none |
numeric/number 10, 0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. |
|
deathnum12
|
none |
numeric/number 10, 0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. |
|
deathchk1
|
none |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. |
|
deathchk2
|
none |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. |
|
deathchk3
|
none |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. |
|
deathchk4
|
none |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. |
|
deathchk5
|
none |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. |
|
deathchk6
|
none |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. |
|
deathchk7
|
none |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. |
|
deathchk8
|
none |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. |
|
deathchk9
|
none |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. |
|
deathchk10
|
none |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. |
|
deathtxt1
|
none |
varchar/varchar2 255
|
This custom field may be defined and used by your institution to track any free text information you want to associate with this data row. |
|
deathtxt2
|
none |
varchar/varchar2 255
|
This custom field may be defined and used by your institution to track any free text information you want to associate with this data row. |
|
deathtxt3
|
none |
varchar/varchar2 255
|
This custom field may be defined and used by your institution to track any free text information you want to associate with this data row. |
|
deathtxt4
|
none |
varchar/varchar2 255
|
This custom field may be defined and used by your institution to track any free text information you want to associate with this data row. |
|
deathtxt5
|
none |
varchar/varchar2 255
|
This custom field may be defined and used by your institution to track any free text information you want to associate with this data row. |
Indices - Death
|
Index |
Primary |
Foreign |
Unique |
Fields |
Sort |
|---|---|---|---|---|---|
|
pk_death |
Y |
|
Y |
deathkey |
ASC |
|
uq_deathid |
|
Y |
Y |
deathid |
ASC |
|
death03 |
|
|
|
deathdate |
ASC |