rebuild_new_residency — rebuild the residency-related columns of the MEMBERS table and repopulate the entire RESIDENCIES table, but only for the individuals with MEMBERS rows that haven't already been analyzed
int
rebuild_new_residency
(
|
); |
This procedure queries MEMBERS
to determine which individuals have any rows with NULL
Residency, and then
re-analyzes the residency related
columns for all of the MEMBERS rows for those individuals. Those
individuals' data in the RESIDENCIES
table will also be updated appropriately. The interpolated
and Supergroup information
stored in MEMBERS, and BIOGRAPH, provide the data necessary to
rebuild residency.
The MEMBERS.Supergroup and Delayed_Supergroup columns must be updated[318] if residency is to be correctly computed.
The residency information is not automatically maintained by the system at this time.