Name

rebuild_residency — rebuild the residency related columns of the MEMBERS table and repopulate the RESIDENCIES table for an individual

Synopsis

int rebuild_residency ( sname);  
char(3) sname ;
 

Input

sname

A Sname.

Description

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.

Caution

The MEMBERS.Supergroup and Delayed_Supergroup columns must be updated[317] if residency is to be correctly computed.

Note

The residency information is not automatically maintained by the system at this time.

Example

SELECT rebuild_residency('FOO');



[316] Technically, MEMBERS.LowFrequency is an independent computation from the residency information. However it is convenient to compute it along with the residency columns.


Page generated: 2024-10-29T13:29:03-04:00.