-
Implement a RCDSTAT Code field in the Fam_Member.dbf table
- values ranging from 00 to 15
-
the higher the RCDSTAT value, the more Fam_Member data we are missing.
If person is dead there is more to miss - RIP date and Obituary column.
- See score discussion below.
FAM_MEMBER Table RCDSTAT Code Values
| Condition |
Assumed Alive |
Assumed Dead |
|---|
| incomplete Given Name with no DOB or Photo |
11 |
15 |
| valid Given name with no DOB or Photo |
6 |
10 |
| valid Given name with DOB (Year) no Photo |
3 |
7 |
| valid Given name with DOB no Photo |
2 |
6 |
| valid Given name with DOB and Photo |
0 |
4 |
If the family member accounted for is assumed to be alive
then the worst score for that record would be
for incomplete Given Name with no DOB or Photo
5 + 4 + 2 = 11
With valid Given name the score would be 6
If the family member accounted for is assumed to be dead
then points would also accrue for
no RIP date and no Obit
3 + 1 bringing total to 15
A record with all of these conditions but has valid Given Name
earns 5 points back dropping the score to 10
This is draft but it could be a promising concept