Name

rebuild_supergroup — rebuild the Supergroup and Delayed_Supergroup columns of the MEMBERS table for an individual

Synopsis

int rebuild_supergroup ( sname);  
char(3) sname ;
 

Input

sname

A Sname.

Description

This procedure rebuilds the Supergroup and Delayed_Supergroup columns of the MEMBERS table for a specific individual. The GROUPS, CENSUS (by way of MEMBERS), and BIOGRAPH tables provide the necessary data.

If this individual has any MEMBERS rows with non-NULL Residency, LowFrequency, or GrpOfResidency, those values depended on an earlier version of the supergroup data, so this function automatically sets them all to NULL and removes any of the individual's rows in the RESIDENCIES table.

Note

The MEMBERS.Supergroup and Delayed_Supergroup columns are not automatically maintained by the system at this time.

Example

SELECT rebuild_supergroup('FOO');


Page generated: 2024-02-22T15:09:14-05:00.