rebuild_residency — rebuild the residency related columns of the MEMBERS table and repopulate the RESIDENCIES table for an individual
int
rebuild_residency
(
|
sname) ; |
char(3)
sname
;This procedure rebuilds the residency related columns of the MEMBERS table for a specific individual. These are:
Also, the individual's rows in the RESIDENCIES table (if any) are emptied and replaced.
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[317] if residency is to be correctly computed.
The residency information is not automatically maintained by the system at this time.
[316] Technically, MEMBERS.LowFrequency is an independent computation from the residency information. However it is convenient to compute it along with the residency columns.