Name

rebuild_all_residency — rebuild the residency related columns of the MEMBERS table and repopulate the entire RESIDENCIES table for all individuals

Synopsis

int rebuild_all_residency ( );  
 

Description

This procedure rebuilds the residency related columns of the MEMBERS table for all individuals. All data in the RESIDENCIES table is also updated appropriately. 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[318] if residency is to be correctly computed.

Note

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

Example

SELECT rebuild_all_residency();




Page generated: 2023-11-28T17:36:10-05:00.